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.

#### 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