Purchase Solution

Case study: BEST Health Food Company

Not what you're looking for?

Ask Custom Question

1. Set up the following linear programming problem in an Excel spreadsheet so I can work it with Solver.

2. Provide a written step by step explanation so I will understand similar problems on the midterm next week.

After I work through the problem and explanation I would like you to review my answers to be certain I am on the right track. I will provide additional compensation, of course.

Purchase this Solution

Solution Summary

Here is just a sample of what you will find in the solution:

"There are standards for each of the mixtures, based on the weight of the key components.

? A box of the Nutrition mixture must contain 5 pounds of the key components(*note: I take this as an "equal" constraint), must contain at least twice as much component C as component B, and must contain at least 20 percent component A."

Solution Preview

Please refer to the attachment.

A Health Food Blend Case

The BEST Health Food company produces two blends of health food:

1. A mixture named Nutrition. and
2. A mixture named Taste.

The market dictates that BEST produce each month at least 60,000 boxes of the Nutrition mixture and 100,000 boxes of the Taste mixture. Demand for these products is projected to be no more than 100,000 boxes of the Nutrition mixture and 400,000 boxes of the Taste mixture per month.

For next month's production, BEST estimates it will be able to buy as much as it needs of the three key components for these two health foods at a cost of $3 per pound of component A, $2 per pound of component B, and $5 per pound of component C. Each type of component requires a different type of processing before going into a final health food. The BEST plant is able to process no more than 200,000 pounds of ...

Purchase this Solution

Free BrainMass Quizzes

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

Operations Management

This quiz tests a student's knowledge about Operations Management

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

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