Explore BrainMass
Share

Explore BrainMass

    Formulating a Linear Program

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

    Hi, I need some help formulating this problem as a linear program and setting it up in Excel to solve.

    Problem: A garden store prepares various grades of pine bark for mulch: nuggets, mini nuggets, and chips.The following table gives information regarding the different requirements.
    Nuggets Mini-Nuggets Chips
    Bark 5 6 3
    Machine time (minutes) 2 4 5
    Labor time (hours) 2 4 3
    Storage (bags) 1 1 1

    In addition, there are only 600 pounds of pine bark, 600 minutes of machine time, 480 hours of labor time, and 150 bags in storage. The profits are $9, $9, and $6, respectively for every bag of nuggets, mini-nuggets, or chips.

    © BrainMass Inc. brainmass.com October 10, 2019, 5:44 am ad1c9bdddf
    https://brainmass.com/business/derivatives/formulating-linear-program-515832

    Solution Preview

    See the attached file for full the solution. Thanks

    Nuggets Mini-Nuggets Chips Available
    Bark (Pounds) 5.00 6.00 ...

    Solution Summary

    The expert formulates a linear program.

    $2.19