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.
Purchase this Solution
Solution Summary
The solution formulates a Linear programming model and solves it using Excel Solver
Purchase this Solution
Free BrainMass Quizzes
Writing Business Plans
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.