Purchase Solution

Linear programming model, Excel Solver

Not what you're looking for?

Ask Custom Question

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.