Question: I am looking for a solution in Excel. Please show formulas: The Fresh Turkey Company produces two types of turkey cutlets for sale to fast

I am looking for a solution in Excel. Please show formulas:
The Fresh Turkey Company produces two types of turkey cutlets for sale to fast-food restaurants. Each type of cutlet consists of white meat and dark meat. Cutlet 1 sells for $2.97 a pound and must consist of at least 65% white meat. Cutlet 2 sells for $1.97 per pound and must consist of at least 50% white meat. At most, 10,000 pounds of cutlet 1 and 6000 pounds of cutlet two can be sold. The two types of turkey sued to manufacture the cutlets are purchased form a turkey farm. Each type 1 turkey costs $8.99 and yields six pounds of white meat and two pounds of dark meat. Each type 23 turkey costs $5.99 and yields three pounds of white meat and three pounds of dark meat.
a. Determine how to maximize Fresh Turkeys profit. Please include your answer report with the model, and a description of your recommendation.
b. Use SolverTable to determine how a change in the cost per pound of type 1 turkey changes the optimal profit. Specifically, vary the cost from $5.99 to $10.99 in steps of $0.50, and explain the results.
c. We would now like to change the required percentage of white meat in cutlet 1(between 50% and 80% in steps of 5%), as well as the number of pounds of cutlet 1 that can be sold. Change the number of pounds of cutlet 1 that can be sold between -15% and +15% in steps of 5%. Comment on the changes in the optimal profit.

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!