A meat packing house is creating a new variety of hot dog for the low-calorie, low-fat, low- cholesterol market. This new hot dog will be made of beef and pork, plus either chicken, turkey, or both. It will be marketed as a 2-ounce all-meat hot dog, with no fillers. Also, it will have no more than 6 grams of fat, no more than 27 grams of cholesterol, and no more than 100 calories. The cost per pound for beef, pork, chicken, and turkey, plus their calorie, fat, and cholesterol counts are shown in the following table.

Meat

Cost/pound

Calories/pound

Fat(G/pound)

Cholesterol (G/pound)

Beef

0.76

640

32.5

210

Pork

0.82

1055

54

205

Chicken

0.64

780

25.6

220

Turkey

0.58

528

6.4

172

The packer would like each 2-ounce hot dog to be at least 25% beef and at least 25% pork. What is the most economical combination of the four meats to make this hot dog, find using excel?

1. Declare all the choice variables, state the objective function and state all the constraints.
2. Find the most economical combination of the four meats to make this hot dog.
3. Generate the sensitivity report in excel.
4. What is the value of the shadow price of the weight constraint? Interpret this number.

A meat packing house is creating a new variety of hot dog for the low-calorie, low-fat, low- cholesterol market. This new hot dog will be made of beef and pork, plus either chicken, turkey, or both. It will be marketed as a 2-ounce all-meat hot dog, with no fillers. Also, it will have no more than 6 grams of fat, no more than 27 grams of cholesterol, and no more than 100 calories. The cost per pound for beef, pork, chicken, and turkey, plus their calorie, fat, and cholesterol counts are shown in the following table. Meat Cost/pound Calories/pound Fat(G/pound) Cholesterol (G/pound) Beet D.76 640 32.5 210 Pork D.82 1055 54 205 Chicken D.64 780 25.6 220 Turkey D.58 528 6.4 172 The packer would like each 2-ounce hot dog to be at least 25% beef and at least 25% pork. What is the most economical combination of the four meats to make this hot dog, find using excel? a. Declare all the choice variables, state the objective function and state all the constraints. b. Find the most economical combination of the four meats to make this hot dog. c. Generate the sensitivity report in excel. d. What is the value of the shadow price of the weight constraint? Interpret this number