Question

In: Math

Prob 1Coffee Beanery in Chicago  is open 365 days a year and sells an average of 120...

Prob 1Coffee Beanery in Chicago  is open 365 days a year and sells an average of 120 pounds of Kona Coffee beans a day (Assume demand is to normally distributed with a standard deviation of 40 pounds/day). Beans are ordered from Hawaii, and will arrive in exactly 4 days with a flat rate shipping and handling charge of $150. Per-pound annual holding costs for the beans are $3. Coffee is highly profitable, so the Beanery would like to have at most a 1% chance of running out of beans. Orders should be placed in whole pounds, but otherwise the Kona suppliers can deal with orders of any size. .

1)Calculate the economic order quantity (EOQ) for Kona coffee beans ________lbs

2)Calculate the total annual holding costs of cycle stock for Kona coffee beans $__________

3) Calculate the total annual fixed ordering costs for Kona coffee beans $__________

4)Calculate the Re-Order Point ________lbs

5)If management specified that a 2% stock-out risk is now okay, would safety stock holding costs decrease, increase, remain unchanged or do we not have enough info to tell? (Circle 1)

Problem 1-contd' Now assume that Kona supplier wants to place the Beanery on a fixed order intervals, where they will only deal with orders every 3 weeks (Hawaiians have better things to do than be waiting by the phone for obnoxious Manhattanites). Assume all other parameters remain the same.

1)If the Beanery has only 350lbs of beans left on the day they are allowed to place an order, calculate the probability they will run out before this next order arrives. ________%

2)Compare the cost of safety stock for the Fixed Order interval to that associated with the reorder point. How does it differ and why?

Solutions

Expert Solution

This is a case of variable demand and constant lead time.

Given : Average demand =120 pounds per day

Standard deviation of demand =40 pounds per day

Lead time =4 days

Ordering cost =150

Holding cost per pound per year =3

Number of working days =365

Service level =100-stockout percentage=100-1=99% =0.99

z=NORMSINV(0.99)=2.33

Annual demand =Average demand*Number of working days=120*365=43800

1)

EOQ=sqrt(2*Annual demand*cost per order/holding cost per unit per year)

=sqrt(2*43800*150/3)

=2092.844

=2093 pounds per order

2)Total annual holding cost=Average inventory *holding cost per pound per year

=EOQ/2* 3

=2093/2 *3

=$ 3139.5

3)Number of orders=Annual demand/EOQ=43800/2093=20.92=21 orders per year

Total annual fixed ordering cost =Number of orders *cost per order =21*150=$ 3150

4)Reorder point =ROP=Lead time demand +Safety stock

=Average demand *lead time +z*sqrt(lead time)*standard deviation of demand

=120*4+2.33*sqrt(4)*40

=480+2.33*2*40

=666.4

=666 (rounding to nearest whole number)

5)When stock-out risk increases ,then service level decreases.So,z value decreases and thus safety stock decreases.

Holding cost remains unchanged as increase in stock out risk has no impact.


Related Solutions

If the average survival of a red cell in the human body is 120 days with...
If the average survival of a red cell in the human body is 120 days with a standard deviation of 8 days, what is the probability for each of the following events? Assume a normal distribution, a. A red cell surviving more than 134 days? b. A red cell that survives less than 110 days? c. A red cell surviving between 108 and 122 days?
Find the EAR in each of the following cases (Use 365 days a year. Do not...
Find the EAR in each of the following cases (Use 365 days a year. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.): Stated Rate (APR) Number of Times Compounded Effective Rate (EAR) 9.4 % Quarterly % 18.4 Monthly      14.4 Daily      11.4 Infinite     
ind the EAR in each of the following cases: (Use 365 days a year. Do not...
ind the EAR in each of the following cases: (Use 365 days a year. Do not round intermediate calculations. Round the final answers to 2 decimal places.) Stated Rate (APR) Number of Times Compounded Effective Rate (EAR) 10.1 % Quarterly % 19.1 Monthly 15.1 Daily 12.1 Infinite
Find the EAR in each of the following cases (Use 365 days a year. Do not...
Find the EAR in each of the following cases (Use 365 days a year. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.): Stated Rate (APR) Number of Times Compounded Effective Rate (EAR) 9.6 % Quarterly % 18.6 Monthly 14.6 Daily 11.6 Infinite
Compute the cost of not taking the following trade discounts: (Use 365 days in a year....
Compute the cost of not taking the following trade discounts: (Use 365 days in a year. Round the intermediate calculations to 4 decimal places. Round the final answer to 2 decimal places.) a. 2/13, net 50. Cost of lost discount             % b. 2/20, net 50. Cost of lost discount              % c. 3/18, net 65.    Cost of lost discount             % d. 3/18, net 150.    Cost of lost discount             %
Total asset turnover 1.5 times Average collection period​ (assume 365-day​ year) 15 days Fixed asset turnover...
Total asset turnover 1.5 times Average collection period​ (assume 365-day​ year) 15 days Fixed asset turnover 5 times Inventory turnover​ (based on cost of goods​ sold) 3 times Current ratio 2.0 times Sales​ (all on​ credit) ​$4,000,000 Cost of goods sold 75% of sales Debt ratio 40% Fill in the assets section of the pro forma balance sheet.  ​(Round all items to the nearest​ dollar.) Cash ​$ Accounts receivable Inventories Net fixed assets Total assets ​$ Fill in the liabilities...
Given 2016 2015 2014 Days Inventory (365 x Average inventory / Cost of sales) 83 82...
Given 2016 2015 2014 Days Inventory (365 x Average inventory / Cost of sales) 83 82 75 Sales/Store ($ million) 14.0 13.9 13.5 = Transactions/Store (Thousands) 466.5 459.9 446.3 x Sales/Transactions ($) 30.01 30.22 30.25 Sales/Store ($ million) 14.0 13.9 13.5 = Square feet/Store (Thousands) 80.0 77.4 73.7 x Sales/Square foot ($) 175.0 179.59 183.18 Given (Thousands) 2016 2015 2014 2013 Sales 700,000 432,800 256,200 117,600 Gross profit 181,400 114,300 70,000 33,400 Net income 8,200 14,100 10,300 5,300 Working capital...
Red blood cells have an average lifespan of 120 days in the human body. If a...
Red blood cells have an average lifespan of 120 days in the human body. If a given individual produces 200 billion red blood cells per day, what is the average number of red bloods cells in his/her body? (Note: 1 trillion = 1000 billion) SHOW WORK a) 1.6 trillion cells b) 8 trillion cells c) 16 trillion cells d) 24 trillion cells e) 30 trillion cells f) 600 trillion cells g) We do not have enough information to answer this...
How can I respond to this discussion? Days sales = 365/ Inventory Turnover Industry: 365/2.69= 135.69,...
How can I respond to this discussion? Days sales = 365/ Inventory Turnover Industry: 365/2.69= 135.69, so days sales for industry is 135.69. Company: 365/15.82= 23.07, so days sales for company is 23.07. Taking into consideration that a company with a quick ratio greater 1, has a liquidity that allows for meeting short-term obligations. This company has a quick ratio of .91. The reasons for this could be a number of things, from delayed collections of accounts receivable to decreasing...
Demand averages 20,002 units per year and operates 365 days per year. Holding cost= $5 per...
Demand averages 20,002 units per year and operates 365 days per year. Holding cost= $5 per unit per year while the ordering cost is $100 per order. Company is currently using a periodic (P) inventory system, holding 1000 units in safety stock to cover demand uncertainty and placing orders for every 73 days. The company is investigating the possibility of using a continuous review (Q) inventory system with holding 15 units in safety stock to cover demand uncertainty. Use the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT