You would like to make a nutritious meal of steak and potatoes. the meal should provide at least 50 g of carbohydrates, at least 40 g of protein, and no more than 60 g of fat. a piece of steak contains 5 g of carbohydrates, 20 g of protein, and 15 g of fat. a potato contains 15 g of carbohydrates, 5 g of protein, and 2 g of fat. a steak costs $4 and a potato costs $2. you have formulated the following linear optimization model to determine the number of pieces of steak and the number of potatoes that should be in the meal in order to meet the nutrition requirements at minimal cost. let s be the number of pieces of steak to eat p be the number of potatoes to eat minimize 4s + 2p subject to 5s + 15p ≥ 50 (carbohydrates) 20s + 5p ≥ 40 (protein) 15s + 2p ≤ 60 (fat) s, p ≥ 0 homework 4 ©2015 david czerwinski 3 bus 190 (a) enter the model in excel and use the solver to find the optimal solution. turn in your excel file. (b) report the optimal solution. (c) report the optimal value of the objective function. (d) report the slack/surplus for each constraint. problem 5 recall the sonoma apple problem from homework 3. (you can find the formulation in the homework 3 solutions.) (a) enter the model in excel and use the solver to find the optimal solution. turn in your excel file. (b) how many jars of applesauce and bottles of apple juice should they produce? (c) how much should they spend on advertising for applesauce and apple juice? (d) what will their profit be?