Purchase Solution

# Linear programming model, Excel Solver

Not what you're looking for?

The munchies cereal makes a cereal from several ingredients. Two of the ingredients, oats and rice provide A & B. The company wants to know how many ounces of oats andd rice should include in each box of cereal to meet the minimum requirements of 48 milligrams of vitamin A and 12 milligrams of vitamin B while minimizing cost. An ounce of oats contributes 8 milligrams of vitamin A and 1 milligram of B, whereas an ounce of rice contributes 6 milligrams of A and 2 milligrams of B. An ounce of oats cost \$0.05, and an ounce of rice costs \$0.03.

a. Formulate a linear programming model
b. Solve this model using a grid line

I need help on solving this in solver and on a graph line.

##### Solution Summary

The solution formulates a Linear programming model and solves it using Excel Solver

##### Free BrainMass Quizzes

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

##### Basic Social Media Concepts

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

##### Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

##### Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

##### Basics of corporate finance

These questions will test you on your knowledge of finance.