Explore BrainMass
Share

Explore BrainMass

    Product Mix Model using Excel Solver for MBI Corporation

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

    Introduction:

    A small retail store is trying to decide on the best use of its advertising budget of $1,000 per month. The store can advertise on local radio for $5 per minute or on local TV for $100 per minute. Each minute of TV advertisement generates 25 times as many sales as each minute of radio advertisement. The store wants to use radio at least twice as much as TV.

    Instruction:

    - Review the attached document.

    Problem:

    - Create a spreadsheet in Excel to represent this situation and then use the Excel add-in Solver to determine the optimal number of minutes of radio and TV advertising the store should use to maximize its sales.
    - Return the spreadsheet showing the optimal solution.

    © BrainMass Inc. brainmass.com October 9, 2019, 4:31 pm ad1c9bdddf
    https://brainmass.com/business/sales-revenue/product-mix-model-excel-solver-mbi-corporation-34961

    Attachments

    Solution Summary

    This solution sets up and solves the problem in an attached Excel file.

    $2.19