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