Question: PLEASE INCLUDE EXCEL SOLUTION!!! Formulate a model to select the best competitors in these two events. No need to solve. 4) (20 marks) The Wild

PLEASE INCLUDE EXCEL SOLUTION!!!

PLEASE INCLUDE EXCEL SOLUTION!!! Formulate a

Formulate a model to select the best competitors in these two events. No need to solve. 4) (20 marks) The Wild 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 $4 per Kg and must consist of at least 70% white meat. Cutlet 2 sells for $3 per Kg and must consist of at least 60% white meat. At most 5000 Kg of cutlet 1 and 3000 pounds of cutlet 2 can be sold. The two types of turkey used to manufacture the cutlets are purchased from Gobble-Gobble Turkey Farm. Each type 1 turkey costs $10 and yields 5 Kg of white meat and 2 Kg of dark meat. Each type 2 turkey costs $8 and yields 3 Kg of white meat and 3 pounds of dark meat. Gobble-Gobble cannot sell less than 100 of type 1 turkey, i.e., if Wild Turkey decides to purchase any type 1 turkey, it has to purchase at least 100Kg. Formulate a model to help Wild Turkey maximize profit. Use solver to find the optimal solution. Formulate a model to select the best competitors in these two events. No need to solve. 4) (20 marks) The Wild 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 $4 per Kg and must consist of at least 70% white meat. Cutlet 2 sells for $3 per Kg and must consist of at least 60% white meat. At most 5000 Kg of cutlet 1 and 3000 pounds of cutlet 2 can be sold. The two types of turkey used to manufacture the cutlets are purchased from Gobble-Gobble Turkey Farm. Each type 1 turkey costs $10 and yields 5 Kg of white meat and 2 Kg of dark meat. Each type 2 turkey costs $8 and yields 3 Kg of white meat and 3 pounds of dark meat. Gobble-Gobble cannot sell less than 100 of type 1 turkey, i.e., if Wild Turkey decides to purchase any type 1 turkey, it has to purchase at least 100Kg. Formulate a model to help Wild Turkey maximize profit. Use solver to find the optimal solution

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!