Question

B н 1 Quantity Discounts EOQ 2 Categories Feasible Range O to 200 Item Cost, C % Discount 3 100 4 200 to 800 3 97 800 or more

1) What is the order quantity to minimize total cost or EOQ, given the information in the Excel sheet?

2) Graph the problem.

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

Fog (fconomirc Re-order Chuanhng) dх рх Со 0.3. 900 uuits fer order. Aeve for o Ihi grbm 3 Citigeres lange of ý KconomicglyCost To tal Cost, HOLDIN, COST ORDERING COST Re-eredar Gnanhitg Tokl Cost if minimum at 60C. CS Scanned with CamScanner

Add a comment
Know the answer?
Add Answer to:
1) What is the order quantity to minimize total cost or EOQ, given the information in...
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
  • Problem 13-9 The Economic Order Quantity (EOQ) model is a classical model used for controlling in...

    Problem 13-9 The Economic Order Quantity (EOQ) model is a classical model used for controlling inventory and satisfying demand. Costs included in the model are holding cost per unit, ordering cost and the cost of goods ordered. The assumptions for that model are: only a single item is considered; the entire quantity ordered arrives at one time; the demand for the item is constant over time; no shortages are allowed Suppose we relax the first assumption and allow for multiple...

  • The economic order quantity (EOQ) model is a classical model used for controlling inventory and s...

    The economic order quantity (EOQ) model is a classical model used for controlling inventory and satisfying demand. Costs included in the model are holding cost per unit, ordering cost, and the cost of goods ordered. The assumptions for that model are that only a single item is considered, that the entire quantity ordered arrives at one time, that the demand for the item is constant over time, and that no shortages arc allowed. Suppose we relax the first assumption and...

  • What does an economic order quantity, or EOQ and the total cost formula tell management? What...

    What does an economic order quantity, or EOQ and the total cost formula tell management? What is the reorder point?

  • The Economic Order Quantity (EOQ) model is a classical model used for controlling inventory and satisfying...

    The Economic Order Quantity (EOQ) model is a classical model used for controlling inventory and satisfying demand. Costs included in the model are holding cost per unit, ordering cost and the cost of goods ordered. The assumptions for that model are that only a single item is considered, that the entire quantity ordered arrives at one time, that the demand for the item is constant over time, and that no shortages are allowed. Suppose we relax the first assumption and...

  • Which one of the following is incorrect? 1) The formula for the EOQ (Economic Order Quantity)...

    Which one of the following is incorrect? 1) The formula for the EOQ (Economic Order Quantity) is the square root of a fraction, whose numerator is twice the product of the annual item demand and the cost per order, and whose denominator is the product of the unit price and the annual carrying rate. 2) Annual ordering cost is the EOQ multiplied by variable ordering cost. 3) Average inventory on hand is the order size multiplied by half. 4) Annual...

  • A chemical distributor can purchase raw material from Mexico at three different price policies. Complete the...

    A chemical distributor can purchase raw material from Mexico at three different price policies. Complete the shaded cells and answer the following questions. Policy Discount Quantity (lbs) Discount (%) Discount Price (C) per lb EOQ Feasible/Not feasible Optimal Order Size for the discount range policy 1 0 to 199 No discount 20 565 ______________ _____________ 2 200 to 800 5 19 580 Feasible 580 3 801 and above 10 18 ___ ______________ ___________ (Annual demand = 20000 lbs; Ordering cost...

  • 3. Calculate the total cost of Orueng all calling utullu P2-2 Economic Order Quantity; Ordering and...

    3. Calculate the total cost of Orueng all calling utullu P2-2 Economic Order Quantity; Ordering and Carrying Costs LO1 Mayer, Inc. predicts it will use 63,000 units of material during the year. The expected daily usage is 500 units, and there is an expected lead time of five days and a desired safety stock of 1,500 units. The material is expected to cost $5 per unit. Mayer anticipates it will cost $194.45 to place each order. The annual carrying cost...

  • Please help me find Q1 Q2 Q3 and total cost. Thank you. eBook The Economic Order...

    Please help me find Q1 Q2 Q3 and total cost. Thank you. eBook The Economic Order Quantity (EOQ) model is a classical model used for controlling inventory and satisfying demand. Costs included in the model are holding cost per unit, ordering cost and the cost of goods ordered. The assumptions for that model are that only a single item is considered, that the entire quantity ordered arrives at one time, that the demand for the item is constant over time,...

  • For questions 26-75, choose the most appropriate choice 26. In the A-B-C classification system, items represent...

    For questions 26-75, choose the most appropriate choice 26. In the A-B-C classification system, items represent 50%-60% of all items but only 10%-15% of the total value? A. A items B. B items C. C items D. A items plus B items E. B items plus C items 27. If no variations in demand during the item's lead time exist and no safety stock is needed, then the ROP will equal to: A. the EOC B. expected demand during lead...

  • 1. Basic EOQ Question: The inventory manager of ABC, Ltd., wants to order flour for its...

    1. Basic EOQ Question: The inventory manager of ABC, Ltd., wants to order flour for its bakery in a cost effective manner. The bakery uses an average of 12,000 bags a year. Preparing an order and receiving a shipment of flour involves a cost of $40 per order. Annual carrying costs are $37.50 per bag. REQUIRED: A. Determine the economic order quanity. B. What is the average number of bags on hand? C How many orders will there be per...

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