Question: Complete the table. Please show/explain formulas used.. I am having a difficult time understanding the formulas and how to calculate the data to use the
Complete the table. Please show/explain formulas used.. I am having a difficult time understanding the formulas and how to calculate the data to use the formulas. See supporting info below
| Q* | Ddlt | SS | Avg Inv | Inv cost | Ord Cost | Tot Cost | |
| Albany | |||||||
| Buffalo | |||||||
| California | |||||||
| Delaware | |||||||
| Louisiana | |||||||
| Total cost of the distribution system |
Supporting info:
90% service level and 2 week lead time
| Table 4: Ordering Cost and Holding Costs (per unit per week) | |||
| cost at | ordering cost | holding cost | |
| current system | regional warehouse | $ 5,550.00 | $ 1.25 |
| central warehouse | central warehouse | $ 5,550.00 | $ 1.25 |
| mixed model | central warehouse | $ 3,000.00 | $ 1.00 |
| regional warehouse | $ 3,000.00 | $ 1.25 |
| HISTORICAL demand for 12 weeks | ||||||||||||
| Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Albany | 33 | 45 | 37 | 38 | 55 | 30 | 18 | 58 | 47 | 37 | 23 | 55 |
| Buffalo | 26 | 35 | 41 | 40 | 46 | 48 | 55 | 18 | 62 | 44 | 30 | 45 |
| California | 44 | 34 | 22 | 55 | 48 | 72 | 62 | 28 | 27 | 95 | 35 | 45 |
| Delaware | 27 | 42 | 35 | 40 | 51 | 64 | 70 | 65 | 55 | 43 | 38 | 47 |
| Louisiana | 32 | 43 | 54 | 40 | 46 | 74 | 40 | 35 | 45 | 38 | 48 | 56 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
