Provide a complete description of the decision variables

Assignment Help Operation Management

Reference no: EM131866092

A meatpacking 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.

	Cost/Pound	Calories/Pound	Fat(G/lb)	Cholesterol(G/lb)
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.

Formulate the given problem scenario as a linear program for the meatpacking house by recommending the most economical combination of four meats to make this hot dog. Solve the problem using Microsoft Excel Solver.

For the formulation, provide a complete description of the decision variables used along with their units and also label the constraints mentioned in the problem as completely as possible.

Also, the Excel set-up should provide clearly labeled values used for the decision variables, constraints, and objective function.

Reference no: EM131866092

Questions Cloud

Explain in detail why it may take longer : Explain in detail why it may take longer for you to fight off the flu virus the first time this season than it would if you caught the same strain a second time

Steps in the binomial tree increases to very large number : Explain to students what happens when the number of steps in the binomial tree increases to a very large number.

Lower legs due to venous insufficiency : What is a physical exercise that they could do to help assist in increasing the blood flow back to the heart. explain your answer.

Explain what is the advertising and sponsorship : What is the difference between advertising and sponsorship? Explain what motivates a company to engage in a sponsorship opportunity rather than simply being.

Provide a complete description of the decision variables : Provide a complete description of the decision variables used along with their units and also label the constraints mentioned in the problem.

Equal is equal to market value of equity : Equity is worth $30 per share, and book value of equity is equal is equal to market value of equity.

Experiencing difficulty with urination : An old male pt reports to his doctor that he has recently been experiencing difficulty with urination. What the doctor suspect is the problem. Explain your answ

What is memory-how is the memory retrieved : What is memory? How is the memory retrieved? If the mind resides in the brain, how is the mind connected to memory and how is the mind connected to the body?

Find information on slow twitch muscle fiber : Find information on slow twitch muscle fiber using anaerobic pathway.Fast twitch muscle that cannot use anaerobic pathways.

User Account

All Pages