Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Retail Management A Strategic Approach

Authors: Barry Berman, Joel Evans, Patrali Chatterjee

13th Edition

0133796841, 9780133796841

More Books

Students also viewed these General Management questions

Question

Identify the four types of layouts and their characteristics.

Answered: 1 week ago