Problem 1(30%):Chapter 2-Question 2. The formulation for this LP is given in the problem description. Make a spreadsheet model of this LP using the formulation provided and solve for the optimal solution and optimal value. Copy the formulation into a textbox alongside your model. Ignore the sentence, "Turn in printouts showing the formulas and values in each cell." Make a Answer report of the solved model as well.

2. Gregory Smith, a senior in management, has devised a way to get through Fridays just eating the 5 basic food groups: beer, pizza, coffee, diet soda, and sandwiches. Consider the following information regarding his 5 basic food groups: BEER PIZZA COFFEE DIET SODA SANDWICH CALORIES 84.5 338 67 4 245 FAT 0.5 12 3 0 5 CARBOHYDRATES 20 50 10 35 PROTEIN 0 7.5 0 0 15 ALCOHOL 0 0 0 0 CAFFEINE 0 0 10 7.5 0 PRICE $ 1.75 $ 1.50 $ 0.95 $ 0.60 $ 3.25Greg has learned that he can have no more than 2,000 calories per day in order to avoid repeating the \"freshman fteen\" weight gain from each of the last 3 years. Greg would like to keep the following nutritional content: - less than or equal to 55 grams of fat per day; - at least 300 grams of carbohydrates; at least 45 grams of protein. Greg plans to consume at least4 beers at Harry's and requires a food consumption plan to allow for that. Greg has gotten used to consuming either 3 coffees or 4 diet sodas per day in order to stay awake in Accounting class. He also has learned from Accounting class that it is critical to minimize his expenses in order to fulll this routine every Friday. Decision variables: B = number of beers consumed per Friday P = number of slices of pizza consumed per Friday C = number of cups of coffee consumed per Friday D = number of cans of diet soda consumed per Friday S = number of sandwiches consumed per Friday Design a spreadsheet model for this problem with well-defined Title, Data Table, Decision Variables, Constraints, and Objective Function. The LP model is given as follows: MIN 1.75B + 1.50P + 0.95C + 0.60D + 3.25S s.t. 84.5B + 338P + 67C+ 4D + 245S 300 (Carbohydrates) 7.5P + 15S > 45 Protein) 1B Z 4 (Beer Consumption) 10C + 7.5D > 30 (Caffeine) B, P, C, D, S > 0 Turn in printouts showing the formulas and values in each cell