Explore BrainMass
Share

Explore BrainMass

    Excel Solver Product Mix Maximizes Revenues

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

    Stanley Furniture produces two types of china cabinets, First Provincial (FP) and Deluxe Modern (DM). Each cabinet goes through 3 departments: carpentry, painting and finishing. The following table contains relevant information on production times per cabinet produced, daily production capacities for each department and net revenue per cabinet produced. Woodstock has a contract with its distributor to supply at least 60 units of each type of cabinet per day. The company would like to determine a product mix to maximize daily net revenue.

    Department

    Carpentry Painting Finishing Net Revenue
    hrs/cabinet hrs./cabinet hrs./cabinet $'s /cabinet
    Cabinet type
    FP 3 1.5 0.75 28
    DM 2 1 0.75 25
    Dept. capacity (hrs.) 360 200 125

    Using Excel and the Excel Solver:

    (a) What product mix maximizes daily net revenue, and what is daily net revenue?

    (b) Stanley Furniture can purchase 30 additional hours of carpentry time for $20 per hour. Should the company purchase the additional time? Explain.

    © BrainMass Inc. brainmass.com October 10, 2019, 2:01 am ad1c9bdddf
    https://brainmass.com/business/finance/excel-solver-product-mix-maximizes-revenues-359309

    Solution Summary

    An Excel Solver examines the product mix maximization for revenues.

    $2.19