The Exotic Plant shop carries a variety of indoor gardening supplies and finds that for these...

Transcribed Image Text:

The Exotic Plant shop carries a variety of indoor gardening supplies and finds that for these supplies that they find on average sell at about the same rate throughout the year. One item they carry is potting soil. Their data shows that a 5 kg bag of potting soil costs them The sales price is $9.50 a bag and average sales are Currently when they order 250 35 The physical holding cost rate for Exotic Plant is The cost of money for the Exotic Plant shop is 85% a What is their current cycle inventory? Icycle=Q/2= H=(h=r)C= F t=Q/R= #N/A EOQ= service level, (z= #N/A What is the current annual cost to hold one unit in inventory for one year? bags #N/A What is the current time to zero (t) for their current order quantity? weeks bags at a time. The delivery lead time for the order is 1.0364 bags What is the economic order quantity (Q*) for a bag of potting soil? Inventory Holding Cost =H(Q/2)= 25% a year. The fixed cost to order the fertilizer is 15% a year. The Exotic Plant shop wants ). The store is open 52 weeks a year. $4.50 to purchase bags a week. The standard deviation of sales is 2 weeks. $12 #N/A #N/A USE the economic order quantity in the question above to calculate the current cost of holding inventory for a year. (H(Q/2) 6.2 bags a week. USE the economic order quantity in the question above to calculate the cost of ordering this inventory for a year (S(R/Q)) Cost of ordering inventory =S*(Rannua/Q)= #N/A USE the economic order quantity rule above, to determine how much to order each time. What is the reorder point for this shop? ROP = LTD + 1 = #N/A 0.00 =ROUNDUP(F55,0) The Exotic Plant shop carries a variety of indoor gardening supplies and finds that for these supplies that they find on average sell at about the same rate throughout the year. One item they carry is potting soil. Their data shows that a 5 kg bag of potting soil costs them The sales price is $9.50 a bag and average sales are Currently when they order 250 35 The physical holding cost rate for Exotic Plant is The cost of money for the Exotic Plant shop is 85% a What is their current cycle inventory? Icycle=Q/2= H=(h=r)C= F t=Q/R= #N/A EOQ= service level, (z= #N/A What is the current annual cost to hold one unit in inventory for one year? bags #N/A What is the current time to zero (t) for their current order quantity? weeks bags at a time. The delivery lead time for the order is 1.0364 bags What is the economic order quantity (Q*) for a bag of potting soil? Inventory Holding Cost =H(Q/2)= 25% a year. The fixed cost to order the fertilizer is 15% a year. The Exotic Plant shop wants ). The store is open 52 weeks a year. $4.50 to purchase bags a week. The standard deviation of sales is 2 weeks. $12 #N/A #N/A USE the economic order quantity in the question above to calculate the current cost of holding inventory for a year. (H(Q/2) 6.2 bags a week. USE the economic order quantity in the question above to calculate the cost of ordering this inventory for a year (S(R/Q)) Cost of ordering inventory =S*(Rannua/Q)= #N/A USE the economic order quantity rule above, to determine how much to order each time. What is the reorder point for this shop? ROP = LTD + 1 = #N/A 0.00 =ROUNDUP(F55,0)

Answer rating: 100% (QA)

This image is showing a spreadsheet with formulas related to inventory management concepts such as Economic Order Quantity EOQ cycle inventory holding costs and reorder point calculations However to p... View the full answer