# tutorial for analyzing linear programming questions

I need help with these problems. Problems 8-4, 8-6 MUST use Excel's Solver to complete the problems. Note, the template is also attached for these 2 problems and must be solved using this template.

8-4 (Animal feed mix problem) The Battery Park Stable feeds and houses the horses used to pull tourist-filled

carriages through the streets of Charleston's historic waterfront area. The stable owner, an ex-racehorse

trainer, recognizes the need to set a nutritional diet for the horses in his care. At the same time, he would like

to keep the overall daily cost of feed to a minimum. The feed mixes available for the horses' diet are

an oat product, a highly enriched grain, and a mineral product. Each of these mixes contains a certain

amount of five ingredients needed daily to keep the average horse healthy. The table on this page shows

these minimum requirements, units of each ingredient per pound of feed mix, and costs for the three mixes.

In addition, the stable owner is aware that an overfed horse is a sluggish worker. Consequently, he

determines that 6 pounds of feed per day are the most that any horse needs to function properly. Formulate

this problem and solve for the optimal daily mix of the three feeds. Please see attached excel spead sheet for original data from problem.

8-6 Eddie Kelly is running for re-election as mayor of a small town in Alabama. Jessica Martinez, Kelly's

campaign manager during this election, is planning the marketing campaign, and there is some stiff

competition. Martinez has selected four ways to advertise: television ads, radio ads, billboards, and

newspaper ads. The costs of these, the audience reached by each type of ad, and the maximum number

of each is shown in the following table:

See attached spreadsheet for table

In addition, Martinez has decided that there should be at least six ads on TV or radio or some

combination of those two. The amount spent on billboards and newspapers together must not exceed the

amount spent on TV ads. While fundraising is still continuing, the monthly budget for advertising has

been set at $15,000. How many ads of each type should be placed to maximize the total number of

people reached?

https://brainmass.com/math/optimization/tutorial-for-analyzing-linear-programming-questions-499312

#### Solution Summary

In the tutorial, there are two linear programming problems. One is animal feed mix and the other is number of audience reached. Though they look different, the logic to solve these two are the same. In the solution for both, we have the sensitivity report, limits report and answer report. To carry out the solver analysis, we first choose the decision variables and make them 0 as the default. Then based on the questions, we find out those constraints. Meanwhile, we come up with the goal or objective function for the question. After all these are determined, we then run solver in excel to find the optimal solution by using linear programming and non-negative options.