Explore BrainMass

Explore BrainMass

    EOQ to Minimize Annual Cost

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Georgia Pacific offers the following discount schedule for its 4X8 ft. sheets of quality plywood.

    (see chart in attached file)

    Ace Lumber and Building Supply regularly stocks this product from Georgia pacific and has an annual demand of 1000 sheets. The carrying cost at Ace Lumber is 20% of product cost, and a cost of $45 is incurred with each order.
    a. Determine the optimal order quantity for Ace Lumber.

    © BrainMass Inc. brainmass.com June 3, 2020, 6:57 pm ad1c9bdddf
    https://brainmass.com/business/business-math/eoq-minimize-annual-cost-80615

    Attachments

    Solution Preview

    Hello

    ** Please see the attached file for the complete solution response **

    Please see the word document and the Excel sheet for all the details. In the Excel sheet you can see all the formulas in action. You can use this Excel sheet for any other quantity discount problem or perform sensitivity analysis within the current problem.

    Georgia Pacific offers the following discount schedule for its 4X8 ft. sheets of quality plywood.
    Order Unit Cost ($)
    Less than 100 sheets 18.00
    100 to 499 sheets 17.50
    500 to 750 sheets 17.25
    More than 750 ...

    Solution Summary

    This solution contains the optimal order quantity calculation to minimize ordering cost, inventory carrying cost and quantity discount schedule.

    $2.19

    ADVERTISEMENT