Business, 06.04.2021 04:10 alazayavila123

Assuming a service level of 99% for all parts, what will be the impact on the total inventory investment if the number of warehouses is reduced from 8 warehouses to 2? Reduced to 1? Assume that each of the 8 warehouse has roughly equal demand and, when consolidating the warehouses, the total demand across all 8 warehouses is equally divided between the remaining warehouses. A. Using data from the case, complete the table below. Note that Exhibit gives the standard deviation of the bi-weekly demand for 8, 2, and 1 warehouses respectively. Use these values to calculate the Stdev of weekly demand.
Product Griffin Beaker Erlenmeyer Flask
# of Warehouses 8 2 1 8 2 1
Z-Value 2.33 2.33 2.33 2.33 2.33 2.33
Calculations Average
for 1 warehouse Weekly
Demand
Stdev of
Weekly
Demand
POU (weeks)
Q
Average Pipeline
Inventory
Begin on hand
SS
Average On Hand
Average Inventory
Total Average Inventory
(all warehouses)
Calculate the percentage savings in total average Inventory investment from warehouse consolidation for each product. Assume lead time stays constant at 1 week:
from 8 warehouses to 2 warehouses.
from 8 warehouses to 1 warehouse.
Take a simple average of the percent savings for each part and apply the resulting average percent savings to the entire North American finished goods (NA FG) inventory. Assume 2010 NA FG is $5 million. Calculate the total savings for the NA FG if:
8 warehouses are consolidated to 2 warehouses.
8 warehouses are consolidated to 1 warehouse.
Would savings from consolidation compensate for the expected increase in inventory of $1.5 million if:
8 warehouses are consolidated to 2 warehouses?
8 warehouses are consolidated to 1 warehouse?
Griffin 500ml Beaker Erlenmeyer 500ml Flask
2009 units sold 11,268 3,389
Percent of all units sold 0.1% 0.03%
Annual carrying cost (%) 14% 14%
Unit price $8.80 $9.50
Unit cost $3.96 $4.56
Cost of underage $0.48 $0.49
Cost of overage $0.021 $0.025
Optimal service level 95.8% 95.3%
Average bi-weekly demand
(8 warehouses) 54.2 16.3
Standard deviation of bi-
weekly demand
(8 warehouses) 21.4 10.9
Average bi-weekly demand
(2 warehouses) 216.7 65.2
Standard deviation of bi-
weekly demand
(2 warehouses) 38.3 19.5
Average bi-weekly
demand (1 warehouse) 433.4 130.3
Standard deviation of bi-
weekly demand
(1 warehouse) 51.0 26.0

Answers: 3

Show answers

Another question on Business

Business, 21.06.2019 16:30

You are opening a new store and must project in your business plan the amount of inventory shrinkage. you have forecasted $1,200,000 in sales for the first year. assuming your shrinkage will be 5%, the high end of the national average, calculate the projected annual shrinkage for your business plan. you are opening a new store and must project in your business plan the amount of inventory shrinkage. you have forecasted $1,200,000 in sales for the first year. assuming your shrinkage will be 5%, the high end of the national average, calculate the projected annual shrinkage for your business plan.

Answers: 3

Answer

Business, 21.06.2019 21:00

The market for corn in country a is highly competitive. at the current market price of $5/bushel there is a shortage of 100,000 bushels of corn in this country. media reports claim that the price of corn will rise drastically in the near future. according to these reports, the neighboring country b had witnessed a similar situation recently. at the same price, the shortage in country b was also 100,000 bushels and eventually the equilibrium price in b went up to $10/bushel. both countries are known to have equal number of corn producers and the market supply of corn is identical at all prices. this, combined with the fact that consumers in the two countries also have similar tastes and preferences, led the media to conclude that the price of corn in country a would soon be as high as $10/bushel. the new equilibrium price turns out to be below $10/bushel, what inferences can be drawn?

Answers: 3

Answer

Business, 22.06.2019 01:30

What is an example of a good stock to buy during economic expansion? a) cyclical stock b) defensive stock c) income stock d) bond

Answers: 3

Answer

Business, 22.06.2019 11:20

Mae jong corp. issues $1,000,000 of 10% bonds payable which may be converted into 10,000 shares of $2 par value ordinary shares. the market rate of interest on similar bonds is 12%. interest is payable annually on december 31, and the bonds were issued for total proceeds of $1,000,000. in accounting for these bonds, mae jong corp. will: (a) first assign a value to the equity component, then determine the liability component. (b) assign no value to the equity component since the conversion privilege is not separable from the bond.(c) first assign a value to the liability component based on the face amount of the bond.(d) use the “with-and-without” method to value the compound instrument.

Answers: 3

Answer

You know the right answer?

Assuming a service level of 99% for all parts, what will be the impact on the total inventory invest...

Questions