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 13:30

The budgeted overhead cost for the year is $1,260,000. the company has estimated that one-third of the budgeted overhead cost is incurred to support the firm's two partners, and two-thirds goes to support the staff accountants. the current audit bid for monoco industries requires $18,000 in direct partner professional labor, $30,000 in direct staff accountant professional labor, $5,000 in direct material. what is the overhead rate based on a single cost driver (rounded to the nearest percentage)?

Answers: 3

Answer

Business, 22.06.2019 09:30

What is the relationship among market segmentation, target markts, and consumer profiles?

Answers: 2

Answer

Business, 22.06.2019 10:30

On july 1, oura corp. made a sale of $ 450,000 to stratus, inc. on account. terms of the sale were 2/10, n/30. stratus makes payment on july 9. oura uses the net method when accounting for sales discounts. ignore cost of goods sold and the reduction of inventory. a. prepare all oura's journal entries. b. what net sales does oura report?

Answers: 2

Answer

Business, 22.06.2019 12:30

Consider a treasury bill with a rate of return of 5% and the following risky securities: security a: e(r) = .15; variance = .0400 security b: e(r) = .10; variance = .0225 security c: e(r) = .12; variance = .1000 security d: e(r) = .13; variance = .0625 the investor must develop a complete portfolio by combining the risk-free asset with one of the securities mentioned above. the security the investor should choose as part of her complete portfolio to achieve the best cal would be a. security a b. security b c. security c d. security d

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