Collection Storage Occupancy Percent Fill Rate Calculator
Keep occupied/usable/blocked storage slot inventories and unequal store denominators separate; physical empty slots are not all usable conservation capacity.
Description
Usable storage slots and blocked physical slots are different capacities.
Usable storage slots and blocked physical slots are different capacities. Occupancy percentages depend on which denominator is used.
Keep occupied/usable/blocked storage slot inventories and unequal store denominators separate; physical empty slots are not all usable conservation capacity.
When to use Collection Storage Occupancy Percent Fill Rate Calculator
Use this tool to keep occupied/usable/blocked storage slot inventories and unequal store denominators separate; physical empty slots are not all usable conservation capacity.
Prepare the collection, exposure, scheduling or financial records required for this calculation. Keep row order and the declared units consistent.
How to use Collection Storage Occupancy Percent Fill Rate Calculator and understand its results
- Prepare the collection, exposure, scheduling or financial records required for this calculation. Keep row order and the declared units consistent.
- Enter occupiedSlotCountsByStore, usableSlotCountsByStore, blockedUnusableSlotCountsByStore using the field table and calculation rules, then run the tool.
- Read usableSlotOccupancyPercentByStore, pooledUsableSlotOccupancyPercent, occupiedShareOfPhysicalSlotsPercent. The explanation below defines the units, signs, ordering and any flags or placeholder values.
- If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.
| Input field | Meaning | Value type; see rules below | Requirement |
|---|---|---|---|
| occupiedSlotCountsByStore | Occupied slot counts by store | list of number | Required |
| usableSlotCountsByStore | Usable slot counts by store | list of number | Required |
| blockedUnusableSlotCountsByStore | Blocked unusable slot counts by store | list of number | Required |
Align nonnegative integer occupied and blocked counts with positive integer usable counts. Require occupied no greater than usable. Return local usable percentages, pooled usable percentage and occupied share of total physical slots.1
Paired lists must be nonempty and have equal lengths.
usable occupancy = 100 × occupied/usable; physical share includes blocked slots Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.
| Output field | Meaning | Value type |
|---|---|---|
| usableSlotOccupancyPercentByStore | Usable slot occupancy percent by store | list of number |
| pooledUsableSlotOccupancyPercent | Pooled usable slot occupancy percent | number |
| occupiedShareOfPhysicalSlotsPercent | Occupied share of physical slots percent | number |
{
"input": {
"occupiedSlotCountsByStore": [
80,
50
],
"usableSlotCountsByStore": [
100,
100
],
"blockedUnusableSlotCountsByStore": [
20,
0
]
},
"output": {
"usableSlotOccupancyPercentByStore": [
80,
50
],
"pooledUsableSlotOccupancyPercent": 65,
"occupiedShareOfPhysicalSlotsPercent": 59.09090909090909
}
}Limitations and assumptions
Physical empty slots are not automatically usable conservation capacity.
Numbers and computed results must be finite; overflow produces an error. Numeric lists are limited to 100,000 entries; the rules above may require smaller limits. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors.
Alternative or Complementary methods
Use Store Environmental Zone Capacity Utilisation Checker: Audit committed environmental-zone volume deficits without treating surplus in an incompatible zone as a local solution; unlike slot occupancy, incoming reserved volume is explicit. For a complementary task, use Box List Item Count per Linear Metre Estimate Calculator: Expand heterogeneous counted box-list inventory and measured widths to actual item density per linear metre; not a fixed box conversion or universal item density.
References
Similar or alternative tools
- Store Environmental Zone Capacity Utilisation Checker
Audit committed environmental-zone volume deficits without treating surplus in an incompatible zone as a local solution; unlike slot occupancy, incoming reserved volume is explicit.
- Box List Item Count per Linear Metre Estimate Calculator
Expand heterogeneous counted box-list inventory and measured widths to actual item density per linear metre; not a fixed box conversion or universal item density.