• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculate Expected Storage Costs

User26

New Member
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?
 

Attachments

  • Example.xlsx
    9.3 KB · Views: 2
Back
Top