About this calculator
Cost a wrapping batch from measured original film use and active labor time. Material is allocated by consumption; whole-roll purchase outlay is reported separately to keep inventory purchases distinct from consumed cost.
Inputs
How to use this calculator
Wrapping process group
- Pallets in this process groupPositive whole count; groups are added.
- Original film used per pallet (in)Measured before stretching, including actual tails and waste; 900 in = 75 ft.
- Usable original film length per roll (in)Same film basis as consumption; 18,000 in = 1,500 ft.
- Price per roll (USD)Your actual purchase price.
- Labor minutes per palletMeasured active labor time.
- Other consumed cost per pallet (USD)Only costs not already in film, labor or batch setup.
Shared inputs
- Loaded labor cost per hour (USD)Your actual cost; not a wage benchmark.
- One-time batch setup / other cost (USD)Added once across all groups.
Enter the shipment or scenario values, then select Calculate result.
Method
Formula and variables
Film cost per group = pallet count × original film per pallet ÷ usable original roll length × roll price. Labor = pallets × minutes per pallet ÷ 60 × hourly cost. Add other per-pallet costs and one-time setup. Total ÷ total pallets is the weighted consumed cost per pallet. Whole-roll purchases are separately rounded within each group.
- Pallets in this process group
- Positive whole count; groups are added.
- Original film used per pallet (in)
- Measured before stretching, including actual tails and waste; 900 in = 75 ft.
- Usable original film length per roll (in)
- Same film basis as consumption; 18,000 in = 1,500 ft.
- Price per roll (USD)
- Your actual purchase price.
- Labor minutes per pallet
- Measured active labor time.
- Other consumed cost per pallet (USD)
- Only costs not already in film, labor or batch setup.
- Loaded labor cost per hour (USD)
- Your actual cost; not a wage benchmark.
- One-time batch setup / other cost (USD)
- Added once across all groups.
Interpret the result
Per-pallet cost is the weighted consumed batch cost. Whole-roll outlay may be larger for a small batch and must not be added to consumed film cost a second time.
Outputs: Consumed film, labor and total cost per pallet
Measured-input cost allocation in USD. Consumed film cost differs from buying whole rolls; the separate roll outlay includes unused inventory and is not added again to consumed cost. Groups do not share residual rolls. Tax, financing, depreciation and live material prices are not inferred.
Worked example
Check the arithmetic
This example uses the starting values shown above. The arithmetic below is calculated independently of the interactive result.
Work through the calculation
- Film = 100 × (900 ÷ 18,000) × $30 = $150.
- Labor = 100 × 2 ÷ 60 × $24 = $80; other consumed cost = 100 × $0.20 = $20.
- Total = $250; $250 ÷ 100 = $2.50 per pallet.
Compare the displayed result
Expected displayed result: $2.50 per pallet
FAQs
Why does one pallet consume less than a full roll’s price?
Consumption allocates only the used fraction of a roll. Buying a roll leaves unused inventory, which appears in the separate purchase outlay.
Example inputs and options
Starting values are examples unless a field identifies a dated rule. Unit selectors convert only fields marked for conversion. Rates and model options keep the units and basis shown in their labels.
- Pallets in this process group
- Example: 100
- Original film used per pallet (in)
- Example: 900
- Usable original film length per roll (in)
- Example: 18000
- Price per roll (USD)
- Example: 30
- Labor minutes per pallet
- Example: 2
- Other consumed cost per pallet (USD)
- Example: 0.2
- Loaded labor cost per hour (USD)
- Example: 24
- One-time batch setup / other cost (USD)
- Example: 0
