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