| trailer | 10x10x40 | | | 4000 | | Logistics Plan With Warehouse |
| shipping charge | $1000/full load | | | | | | day1 | day2 | day3 | day4 | day5 | day6 | day7 | day1 |
| raw mat'l shipping charge | .2+.2+.4/unit | | | | | Inbound | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| current fin goods shipping charge | $200 | | | | | On hand | 2000 | 571 | -857 | -2286 | -3714 | -5143 | -6571 | -8000 |
| demand | 10000/week | | | per day? | | Outbound | 1429 | 1429 | 1429 | 1429 | 1429 | 1429 | 1429 | 1429 |
| lot size | 1000 | | | | | balance | 571 | -857 | -2286 | -3714 | -5143 | -6571 | -8000 | -9429 |
| warehouse rental /month | 1.5/sq ft |
| unlimited sq.ft- 12 ft high |
| warehouse variable cost | .15/unit |
| product Vol | 2 cu.ft |
| Travel Time | 4 days |
| Mfg space required sq.ft | 10000 |
| Current shipping charge | 200 |
| Customer work a 7 day work week | | | | | | | | | | | | | Fixed Cost | Var Cost | Total |
| Labor Cost is the same EC vs. WC | | | | | | | | | | | | Opt #1 | 5000 | 1.05 | 5000 |
| | | | | | | | | | | | | Opt#3 | | 1.8 | 0 |
| What do we need to know | | | Opt#1 WCW | Opt#2 WCM | Opt#3 ECD | | | | | | | BE Vol | 0 | | $5,000 |
| Daily Customer Requirements | 1429 |
| one trailer can hold | 2000 | 1000 | | | | | | | 2000 |
| shipment per week | 5 | 10 | | | | | | | $3,000 |
| I can stack 6 high (12ft/2ft) | | | | | | | | | 43333.3333333333 |
| one unit takes up 2sq.ft of space |
| Variable Cost |
| plus the warehouse variable cost | 0.15 | | 0.15 |
| shipping cost | 0.5 | 1 | 0.5 | 1 | 1 |
| shipping cost incurred by supplier | 0.4 | 0.8 | 0.4 | 0.8 | 0.8 |
| sq. ft required |
| Monthly volume | 43333.3333333333 |
| Warehouse cost per unit | 0.0692307692 |
| Fixed Cost |
| Mfg. Facilities Cost | $15,000 | | | $15,000 |
| Warehouse monthly Cost | $3,000 | | $3,000 |
Ladyjee0h6
unit_4_ip_template.xlsx
