Question: please clearly label each answer. You would like to make a nutritious meal of steak and potatoes. The meal should provide at least 50g of

please clearly label each answer. You would like

please clearly label each answer.

You would like to make a nutritious meal of steak and potatoes. The meal should provide at least 50g of carbohydrates, at least 40g of protein, and no more than 60 g of fat. A piece of steak contains 5g of carbohydrates, 20g of protein, and 15g of fat. A potato contains 15g of carbohydrates, 5g 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) 205 + 5P > 40 (Protein) 15S + 2P 0 (a) Enter the model in Excel and use the Solver to find the optimal solution. Also, create the answer report and sensitivity report. Turn in your Excel file or screen shots pasted on paper (pdf or doc) (b) Report the optimal solution. (c) Report the optimal value of the objective function. (d) Report the slack/surplus for each constraint please clearly label and write each

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!