Linear programming model by excel solver

Assignment Help Operation Management
Reference no: EM1323610

Linear programming model, Excel Solver

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

Reference no: EM1323610

Questions Cloud

Blending problem-linear programming : A drug company produces the drug NasaMist from four chemicals. Find out the cheapest manner of producing today's batch of NasaMist.
Five-component model of information systems : It identifies the five components of an information system such such hardware, software, data, procedures, and people. It suggests on how these components are utilized to come up with a fully functional systems.
Behavior in the field of biological psychology : How Neuron Processes Affect Behavior and Impact the Field of Biological Psychology.
Explain in-store versus online purchase : Explain In-store versus online purchase and explain why marketers should consider what happens during the information search phase of the consumer decision process when they create their marketing mix strategy
Linear programming model by excel solver : The munchies cereal makes a cereal from several ingredients. Two of the ingredients, oats and rice provide A & B. Formulate a linear programming model. Solve this model using a grid line
Describe cloud computing and web 2.0 : A Discussion On Cloud Computing And Web 2.0 - Describe cloud computing and Web 2.0 and Explain how organizations use these tools.
Explain customer paths on a business site : Explain Customer Paths on a Business Site and you periodically study the customer paths on your site
Function of brain and transmission of information : Jay view a dog and the visual signal is transmitted by neurons by using (a)____ ___ signals inside the neurons and by using chemicals termed
Linear programming problem-qm for windows : Outdoor furniture manufactures two products, benches and picnic tables. The firm has 2 main resources: its carpenters(labor force) and supply of redwood for use in furniture. This query contains 1 Linear programming problem solved by using QM for wi..

Reviews

Write a Review

Operation Management Questions & Answers

  Shortest-route technique

Minimal-spanning tree technique and Shortest-route technique

  Linear programming with decision variables and constraints

Illustrate the linear programming model with its decision variables and its constraints. Use the computer solution generated by Excel (Solve) to see which team works with which project. Provide the Excel file.

  Solution to linear programming model

Frank Hurley is the farmer with 250 acres on which he wishes to plant wheat and corn to maximize his expected return for season. Based upon the output, what key points would you recommend to Frank?

  Basic research methodologies-difference in qualitative

Describe the key characteristics and differences of the qualitative, quantitative, mixed, and action research methodologies.

  Serious financial trouble

Your business, a closely held corporation with 4 other shareholders, is in serious financial trouble. A lender has suggested that it might provide lending if you could reduce your current debt load by 50%.

  Strategy of sherman anti-trust act

The strategy of the Sherman Anti-Trust Act and other U.S. antimonopoly legislation is to ensure that each company has meaningful competitors in every product market in which it participates.

  Foreign exchange traders

X and Y are foreign exchange traders in Germany. X agrees to sell 100 million Mexican pesos to Y for delivery within 1 week at an agreed price in German marks.

  Segment analysis section

For this Discussion Forum, please document all of the steps needed to create a specific strategic group map for the beer industry. Then create a strategic group map, based upon the following industry definition:

  Culture and multinational negotiations

This solution describes cultural influence on multinational negotiations. Culture has been referred to as the "silent language of overseas business." Discuss how the languages of time, space, things, friendship, and agreements influence negotiating..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Recontacting market research participants

Discussion on why a company would recontact respondents of the marketing research interview. Includes reasons why and if this must happen each time the interview is conducted.

  Ftc regulations on diet product claims

What do you think a court will decide here? If the company wants to comply with the FTC regulations on diet product claims, what language would need to change in the ads mentioned above?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd