SOLVE THE PROBLEM COMPLETELY USING SIMPLEX METHOD OF LINEAR PROGRAMMING.

The solution must be composed of DECISION VARIABLES, OBJECTIVE FUNCTION, EXPLICIT CONSTRAINTS,and the MODIFICATION OF OBJECTIVE FUNCTION and EXPILICIT CONSTRAINTS.Must also include DECISION and SHADOW PRICES.

Kindly attach the Excel File. Needed ASAP. Thank you so much.

# 1

Tracy McCoy has committed to the local PTA to make some items for a bake sale on Saturday. She has decided to make some combination of chocolate cakes, loaves of white bread, custard pies, and sugar cookies. Thursday evening she goes to the store and purchases 20 pounds of flour, 10 pounds of sugar, and 3 dozen eggs, which are the three main ingredients in all the baked goods she is thinking about making. The following table shows how much of each of the main ingredients is required for each baked good:

Items	Ingredients
Flour (cups)	Sugar (cups)	Eggs (piece)	Baking Time (minutes)
Cake	2.5	2	2	45
Bread	9	0.25	0	35
Pie	1.3	1	5	50
Cookies	2.5	1	2	16

There are 18.5 cups in a 5-pound bag of flour and 12 cups in a 5-pound bag of sugar. Tracy plans to get up and start baking on Friday morning after her kids leave for school and finish before they return after soccer practice (8 hours). She knows that the PTA will sell a chocolate cake for $12, a loaf of bread for $8, a custard pie for $10, and a batch of cookies for $6. Tracy wants to decide how many of each type of baked good she should make in order for the PTA to make the most money possible. Formulate a linear programming model for this problem. SAMPLE ANSWER SHEET:

TABLE 1 5VAR SVAL TABLE 2 SVAR SVAL CJ-21Decision Variables: Objective Function: Explicit Constraints: Implicit Constraints: MODIFICATIONS: Objective Function: Explicit Constraints: