Product Mix Model using Excel Solver for MBI Corporation
Not what you're looking for?
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
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
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.