In this part you will solve a Linear Programming problem using Excel Solver. Norin kitchen wants to develop a special diet using 2 kinds of food Food1 and Food2. Each portion of Food1 contains 12 units of protein, 4 units of iron, 6 units of cholesterol and 6 units of vitamin E. Each portion of Food2 contains 3 units of protein, 20 units of iron, 4 units of cholesterol and 3 units of vitamin E. The diet requires at least 240 units of protein, at least 460 units of iron and at most 300 units of cholesterol. How many portions of each food should be used to minimise the amount of vitamin E in the diet? What is the minimum amount of vitamin E? ?Task 1 a. Model the above problem as an optimization problem maximizing the weekly profit contribution: b. 1. Define the decision variables 2. Define the objective function 3. State the constraints 1. Activate Solver Add-in in your Microsoft Excel 2. Create an excel sheet to put the information of the above problem. 3. Solve the problem using Solver. ?Task 2 Norin Kitchen decided to add one more kind of food, Food3. Each portion of Food3 contains 40 units of protein, 60 units of iron,4 units of cholesterol and 9 units of vitamin E. 1. Update the model you created for Task-1 2. What is your suggestion for Norin kitchen regarding Food3 ? Justify your answer.
In this part you will solve a Linear Programming problem using Excel Solver. Norin kitchen wants to develop a special diet using 2 kinds of food Food1 and Food2. Each portion of Food1 contains 12 units of protein, 4 units of iron, 6 units of cholesterol and 6 units of vitamin E. Each portion of Food2 contains 3 units of protein, 20 units of iron, 4 units of cholesterol and 3 units of vitamin E. The diet requires at least 240 units of protein, at least 460 units of iron and at most 300 units of cholesterol. How many portions of each food should be used to minimise the amount of vitamin E in the diet? What is the minimum amount of vitamin E? ?Task 1 a. Model the above problem as an optimization problem maximizing the weekly profit contribution: b. 1. Define the decision variables 2. Define the objective function 3. State the constraints 1. Activate Solver Add-in in your Microsoft Excel 2. Create an excel sheet to put the information of the above problem. 3. Solve the problem using Solver. ?Task 2 Norin Kitchen decided to add one more kind of food, Food3. Each portion of Food3 contains 40 units of protein, 60 units of iron,4 units of cholesterol and 9 units of vitamin E. 1. Update the model you created for Task-1 2. What is your suggestion for Norin kitchen regarding Food3 ? Justify your answer.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
Transcribed Image Text:In this part you will solve a Linear Programming problem using Excel Solver.
Norin kitchen wants to develop a special diet using 2 kinds of food Food1 and Food2. Each
portion of Food1 contains 12 units of protein, 4 units of iron, 6 units of cholesterol and 6
units of vitamin E. Each portion of Food2 contains 3 units of protein, 20 units of iron, 4
units of cholesterol and 3 units of vitamin E. The diet requires at least 240 units of protein,
at least 460 units of iron and at most 300 units of cholesterol. How many portions of each
food should be used to minimise the amount of vitamin E in the diet? What is the minimum
amount of vitamin E?
Linear Programming
? Task 1
a. Model the above problem as an optimization problem maximizing the weekly
profit contribution:
b.
?Task 2
1. Define the decision variables
2. Define the objective function
3. State the constraints
1. Activate Solver Add-in in your Microsoft Excel
2. Create an excel sheet to put the information of the above problem.
3. Solve the problem using Solver.
Norin Kitchen decided to add one more kind of food, Food3. Each portion of Food3
contains 40 units of protein, 60 units of iron,4 units of cholesterol and 9 units of
vitamin E.
1. Update the model you created for Task-1
2. What is your suggestion for Norin kitchen regarding Food3? Justify
your answer.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 10 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.