Hi,

I am working in a warehouse inventory department.

I am trying to find the formula or criteria to calculate the warehousing cost for each stored product (SKU), during a period (month).

Objective:
To determine slow moving items warehousing cost.

Question:
What is required to know?and what is the formula?

- Total Square Footage of Warehouse = 72000m2
- Total warehouse cost for June = 6,353,217 USD
- Warehouse total locations number = 32,000
- Warehouse utilization during that period = 73% (Occupied)
- Total number of products(SKUs) = 5100
- Total Shipped Cases during June = 1,316,403
- Total Received Cases during June = 1,948,398

Regards,

Alan