Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started