Question
In this assignment, you will formulate and solve mathematical problems using python in google colab. You will submit two files: 1. A word file with
In this assignment, you will formulate and solve mathematical problems using python in google colab. You will submit two files:
1. A word file with the mathematical formulations of the problems,
2. An excel file with solutions to each problem.
You are expected to type the mathematical formulations of questions 2, 3, and 4 using the Equation editor (under the Insert Menu). Also, solve each question in a separate spreadsheet in the excel file. Name the spreadsheets as Question 1, Question 2, Question 3, and Question 4.
3. Jason has decided to go on a steady diet of only steak and potatoes (plus some liquids and vitamin supplements) for all his meals. He realizes that this isn't the healthiest diet, so he wants to make sure that he eats the right quantities of the two foods to satisfy some key nutritional requirements. He has obtained the nutritional and cost information shown at the top of the next column.
Grams of Ingredient per Serving | |||
Ingredient | Steak | Potatoes | Daily Requirement (Grams) |
Carbohydrates | 5 | 15 | 50 |
Protein | 20 | 5 | 40 |
Fat | 15 | 2 | 60 |
Cost per serving | $8 | $4 |
Jason wishes to determine the number of daily servings (may be fractional) of steak and potatoes that will meet these requirements at a minimum cost.
(a) Formulate a linear programming model for this problem (You need to clearly define decision variables, generate the objective function and constraints).
(b) Use a Excel solver to solve this model by the simplex method.
PLEASE SHOW THE PROCESS ON EXCEL
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started