Calculate the average-standard deviation of monthly demand

Assignment Help Operation Management

Reference no: EM131476762

An electronics manufacturer produces circuit boards in Chicago, IL and distributes its products through two regional warehouses in Newark, NJ and Denver, CO. In the current distribution system, the United States is partitioned into two major regions: Eastern and Western. While the Newark warehouse serves the customers in the Eastern region, the Denver warehouse serves the Western region. Typically it takes four weeks to satisfy an order placed by the two warehouses to the manufacturer.

In recent years the company has experienced significant pressure to reduce costs. Therefore, the company is considering centralizing the distribution function at one of the two existing locations. The company would like to maintain the current service level of 94 percent. To perform an analysis, the company has identified a typical product, Product X. The following table provides historical data that includes monthly demand in the two regions for Product X:

Month 1 2 3 4 5 6

Denver 200 230 180 220 300 250

Newark 280 260 320 350 310 300

The ordering cost is $1000 per order while inventory carrying cost is $8 per unit per month. Also, shipping costs from Chicago to Denver and Newark are $12 and $10 per unit, respectively, and the average transportation costs from Denver and Newark to their corresponding customers are both equal to $15 per unit.

However, if Denver becomes the centralized warehouse, the average transportation cost to the Eastern region customers will be $20, while if Newark becomes the centralized warehouse, the average transportation cost to the Western region customers will be $21. Finally, feel free to round your numbers to the nearest integer and use a continuous review inventory system.

Calculate the average and standard deviation of monthly demand at Newark and Denver warehouses.

Calculate the total inventory carrying costs per month under the current decentralized system.Please show all your work

If the company decides to centralize the distribution function, which regional warehouse should be chosen (i.e., Denver or Newark) to minimize the total cost?Why?Please show all your work.

Reference no: EM131476762

Questions Cloud

Coordination function as performed by primary care physician : What is the Coordination function as performed by a Primary Care Physician or Primary Care Team, and how does it give Patients better care.

Nonconstant growth valuation-estimate of stock current price : A company currently pays a dividend of $3.75 per share (D0 = $3.75). What is your estimate of the stock's current price?

Compare the three different theories of money demand : Compare and contrast the three different theories of money demand. Compare the pros and cons of independent central bank?

Japanese securities before converting to dollars : What is the rate of return you earned on the Japanese securities before converting to dollars?

Calculate the average-standard deviation of monthly demand : Calculate the average and standard deviation of monthly demand at Newark and Denver warehouses.

Supply chain is made up of three levels-bullwhip effect : A supply chain is made up of three levels: a retailer, a manufacturer and a supplier. Quantify the bullwhip effect

Calculate the net present value-the IRR and MIRR : The manager of PPO Inc. plans to manufacture engine blocks for classic cars from the 1960s. Calculate the net present value, IRR, MIRR and Profitability Index.

The usa patriot act : Which of the following did the USA PATRIOT Act do?

Cash futures price of three month zero coupon bond : The cash futures price of a 3 month zero coupon bond with a face value of $100 for delivery in 11.62 months from now is 95.19 dollars.

User Account

All Pages