Kit Bill of Materials: Items per Kit, Weight, Volume, Cost and Truck Loads
This lesson is part of the course
In this lesson
You build the weight, volume and cost of one invented household kit with SUMPRODUCT and work out how many trucks a shipment of 2,400 kits needs when both weight and volume limit the load.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Needs Estimate: Households per Site, a Fictional Kit Standard and Total Kits Needed Locked
- Kit Bill of Materials: Items per Kit, Weight, Volume, Cost and Truck Loads Locked
- Pipeline Planning: Orders, Lead Times, Arrival Dates with WORKDAY and Gaps Before Arrival Locked
- Warehouse Stock: Receipts, Dispatches, Stock on Hand, Weeks of Cover & Shortage Flags Locked
- Distribution Plan: Round Trips, Trips per Day, Kits per Day and Distribution Days per Site Locked
- Monitoring: Planned vs Distributed Kits, Coverage %, Transit Losses and Stock Left at Sites Locked
- Cost per Beneficiary: Procurement, Transport, Storage, Staff and Cost per Household Reached Locked
- Donor Report & Dashboard: Budget vs Actual by Line, Spend Rates, Overspend Flags and a Chart Locked