I'm looking to calculate the expected storage costs based on number of pallets deposited in to store per week and estimated number of weeks taken to build stock up before ready to despatch.
In example attached, we generate 4 pallets per week. Will take 14 weeks to generate enough stock.
So we'll have 4 x 14 weeks, 4 x 13 weeks, 4 x 12 weeks etc.
But if pallets have been in the store for more than 4 weeks, the storage charge increases.
Ideally I'd want to be able to change the avg pallet weight, number of weeks projected etc too so I can use the same model for different products.
Any thoughts?
In example attached, we generate 4 pallets per week. Will take 14 weeks to generate enough stock.
So we'll have 4 x 14 weeks, 4 x 13 weeks, 4 x 12 weeks etc.
But if pallets have been in the store for more than 4 weeks, the storage charge increases.
Ideally I'd want to be able to change the avg pallet weight, number of weeks projected etc too so I can use the same model for different products.
Any thoughts?