Calculate the average and standard deviation

Reference no: EM131869878

Question: 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: EM131869878

Questions Cloud

What is the expected annual cost of carrying cycle stock : In an effort to maintain logistics costs low, the CEO of Riding Patriot has hired you as a consultant for their logistics department, and assigned you the task.

Create synergy in culturally or generationally : What are some techniques to create synergy in culturally or generationally diverse workplaces?

Approach to a critical thinking assignment : What would be the best approach to a critical thinking assignment for the below scenario? Please assist.

What is the maximum profit that can be achieved : An electric power plant uses solid waste for fuel in the production of electricity. Total cost in dollars per hour to produce electricity is.

Calculate the average and standard deviation : An electronics manufacturer produces circuit boards in Chicago, IL and distributes its products through two regional warehouses in Newark, NJ and Denver.

What is one event in your life that changed your life : What is one event in your life that changed you/changed your life? Compare/contrast yourself/your life before and after this event

Compute jill annual irr from owning net of renting : Buying expenses are 5% of purchase price and selling expenses are 8% of sale price. Compute Jill’s annual IRR from owning net of renting.

Discuss the leadership development plan : Elaborate on the role and value that your leadership development plan could potentially have in supporting the development and retention of human.

Allow jim to spend on monthly mortgage payment : Apple bank has a maximum back end DTI limit of 28%. what is the most they will allow Jim to spend on a monthly mortgage payment?

User Account

All Pages