Question

EOQ, reorder point, and safety stock Alexis Company uses 907 units of a product per year on a continuous basis. The product has a fixed cost of $57 per order, and its carrying cost is $5 per unit per year It takes 5 days to receive a shipment after an order is placed, and the firm wishes to hold 10 days usage in inventory as a safety stock. a. Calculate the EOQ. b. Determine the average level of inventory. (Note: Use a 365-day year to calculate daily usage.) c. Determine the reorder point. d. Indicate which of the following variables change if the firm does not hold the safety stock: order cost, (5) economic order quantity 2) carrying cost, 3) total inventory cost, 4 reorder pont a. Alexis EOQ isunits. (Round to the nearest whole number) Enter your answer in the answer box and then click Check Answer parts remaining Clear All Check Answer

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins s Cut ta copy. Σ AutoSum ー E ゴWrap Text B า 프 . Ej-., Δ. : r_一 逻锂函Merge & Center. $, % , 弼,8 conditional Format . Cell Insert Delete Format Sort &Find & 2 ClearFe Select Edting Format Painter Formatting, as Table w styles. ▼ ㆆ ▼ Clipboard Alignment Number Cells Formula Bar BH 4 BK CARRYING COST PURCHASE PRICE ANNUAL DEMAND ORDERING COST BJ BL BM BN BO BP BQ BR BT BU BV CP = NOT GIVEN 6 907 0- 57 8 EOQ= EOQ = SQRT( 2AO/CP)- SQRT(2*907*57/5)143.8040 10 144 (ROUNDED TO ZERO DECIMAL) 12 13 14 15 16 17 18 19 20 21 AVERAGE LEVEL OF INVENTORY EOQ/2(AX SAFETY STOCK DAYS/365) 144/2 (907 X 10/365)96.8493 97 (ROUNDED TO ZERO DECIMAL) REORDER POINT-(AX LEAD TIME DAYS/365) (A X SAFETY STOCK DAYS/365) (907 X 5/365)(907X10/365) 37.274 37 (ROUNDED TO ZERO DECIMAL) ORDERING COST & EOQ DOES NOT CHANGE CARRYING COST, INVENTORY COST & REORDER POINT WILL CHANGE LINE OF CREDIT miler Sheet3 BANKER ACCEPTANC0 erences: AR18 08-01-2019

Add a comment
Know the answer?
Add Answer to:
EOQ, reorder point, and safety stock Alexis Company uses 907 units of a product per year...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • EOQ, reorder point, and safety stock Alexis Company uses 631 units of a product per year...

    EOQ, reorder point, and safety stock Alexis Company uses 631 units of a product per year on a continuous basis. The product has a fixed cost of $41 per order, and its carrying cost is $4 per unit per year. It takes 5 days to receive a shipment after an order is placed, and the firm wishes to hold 10 days' usage in inventory as a safety stock. a. Calculate the EOQ. b. Determine the average level of inventory. (Note:...

  • EOQ, reorder point, and safety stock Alexis Company uses 805 units of a product per year...

    EOQ, reorder point, and safety stock Alexis Company uses 805 units of a product per year on a continuous basis. The product has a fixed cost of $50 per order, and its carrying cost is $4 per unit per year. It takes 5 days to receive a shipment after an order is placed, and the firm wishes to hold 10 days' usage in inventory as a safety stock. a. Calculate the EOQ. b. Determine the average level of inventory. (Note:...

  • Alexis Company uses 881 units of a product per year on a continuous basis. The product...

    Alexis Company uses 881 units of a product per year on a continuous basis. The product has a fixed cost of ​$45 per​ order, and carrying cost is $4 per unit per year. It takes 5 days to receive a shipment after an order is​ placed, and the firm wishes to hold 10​ days' usage in inventory as a safety stock. a.  Calculate the EOQ in units b.  Determine the average level of inventory.   ​(Note​:  Use a​ 365-day year to...

  • Alexis Company uses 800 units of product per year on a continuous basis. The product has...

    Alexis Company uses 800 units of product per year on a continuous basis. The product has a fixed cost of $50 per order, and its carrying cost is $2 per unit per year. It takes 5 days to receive a shipment after an order is placed, and the firm wishes to hold 10 day’s usage in inventory as safety stock. a. Calculate the EOQ b. Determine the average level of inventory (Note: Use a 365-day year to calculate day usage)...

  • Alexis Company uses 900 units of a product per year on a continuous basis. The product...

    Alexis Company uses 900 units of a product per year on a continuous basis. The product has a fixed cost of $55 per order, and its carrying cost is $2 per unit per year. It takes 5 days to receive a shipment after an order is placed. And the firm wishes to hold 10 days usage in inventory as a safety stock Indicate which of the following variable change if the firm does not hold the safety stock: (1) order...

  • Compute the safety stock (S.S.) and reorder point (ROP) for the following situation: Annual Demand =...

    Compute the safety stock (S.S.) and reorder point (ROP) for the following situation: Annual Demand = 6570 units Unit Price = $11 and no quantity discounts Ordering Cost = $25/order Holding Cost = $1.50/unit Lead Time = 5 days Desired Customer Service Level = 97.5% Assume 365 days/year and that demand and lead time are constant. Safety Stock = 10; ROP = 90 Safety Stock = 0; ROP = 90 Safety Stock = 5; ROP = 150 Safety Stock =...

  • E15-3 Mama Leone's Frozen Pizzas uses 50,000 units of cheese per year. Each unit costs $2.50. The ordering cost for the...

    E15-3 Mama Leone's Frozen Pizzas uses 50,000 units of cheese per year. Each unit costs $2.50. The ordering cost for the cheese is $250 per order, and its carrying cost is $0.50 per unit per year. Calculate the firm's economic order quantity (EOQ) for the cheese. Mama Leone's operates 250 days per year and maintains a minimum inventory level of 2 days' worth of cheese as a safety stock. If the lead time to receive orders of cheese is 3...

  • 1. Tangshan Mining was extended credit terms of 2/10 net 30. The cost of giving up...

    1. Tangshan Mining was extended credit terms of 2/10 net 30. The cost of giving up the cash discount, assuming payment would be made on the last day of the credit period, would be 2. The General Chemical Company uses 1,100,000 gallons of hydrochloric acid per year. The cost of carrying the chemical in inventory is 50 cents per gallon per year, and the cost of ordering the chemical is $110 per order. The firm uses the chemical at a...

  • reorder point

        Assuming that there is no safety stock and that the present stock level is 400 components, when should the next order be placed? (Assume a 360-day year.)         lead time= 3 days4000units per month= 4000/31=129units per day          reorder point= lead time demand + safety stock                = (lead time x average daily usage) + safety stock               = ???

  • A product with an annual demand of 1000 units has EOQ (Economic Order Quantity) = 80....

    A product with an annual demand of 1000 units has EOQ (Economic Order Quantity) = 80. The demand during the lead time follows a normal probability distribution with µ = 25 and ϭ =5 during the reorder period. How much safety stock is required, if the firm desires at most a 2% probability of a stockout on any given order cycle? If a manager sets the reorder point at 30, what is the probability of a stockout on any given...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT