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
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.