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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!