Purchase Solution

Product Mix Model using Excel Solver for MBI Corporation

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Solution Summary

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

Purchase this Solution


Free BrainMass Quizzes
Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.