Purchase Solution

Formulating a Linear Program

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Solution Summary

The expert formulates a linear program.

Solution Preview

See the attached file for full the solution. Thanks

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

Purchase this Solution


Free BrainMass Quizzes
Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)