Explore BrainMass

Explore BrainMass

    Use excel solver to find the minimal cost

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

    Andalus Furniture Company has two manufacturing plants, one at Aynor and another at Spartanburg. The cost in dollars of producing a kitchen chair at each of the two plants is given here.

    Aynor Cost = 75Q_1+ 5Q2/1 + 100
    Spartanburg Cost = 25Q_2+ 2.5Q2/2+ 150
    Where
    Q1 = number of Chairs produced at Aynor
    Q2 = Number of Chairs produced at Spartanburg

    Andalus needs to manufacture a total of 40 Kitchen Chairs to met an order just received. How many chairs should be made at Aynor and how many should be made at Spartanburg in order to minimize production costs.

    (Use excel solver)

    © BrainMass Inc. brainmass.com June 4, 2020, 2:35 am ad1c9bdddf
    https://brainmass.com/statistics/quantative-analysis-of-data/excel-solver-find-minimal-cost-468019

    Solution Summary

    The solution provides detailed explanations how to find the minimal cost using excel solver.

    $2.19

    ADVERTISEMENT