Explore BrainMass

Explore BrainMass

    tutorial for analyzing linear programming questions

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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?

    © BrainMass Inc. brainmass.com April 3, 2020, 11:24 pm ad1c9bdddf


    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.