1. Formulate a linear program model. (Decision variables, objective function, constraint)
2. Solve the problem using Excel Solver. Show spreadsheet (Formulas and Solution)

Thank you so much!

2. David Holloway, 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: David has learned that he can have no more than 2,000 calories per day to avoid repeating the "freshman fifteen" weight gain from each of the last 3 years. David 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 David plans to consume at least 4 beers at Harry's and requires a food consumption plan to allow for that. David 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 fulfill 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: MIN1.75B+1.50P+0.95C+0.60D+3.25Ss.t.84.5B+338P+67C+4D+245S3007.5P+15S>451B410C+7.5D>30B,P,C,D,S0(Calories)(Fat)(Carbohydrates)(Protein)(BeerConsumption)(Caffeine)(Non-negativity) Turn in printouts showing the formulas and values in each cell