Find the optimal solution using excel solver

Assignment Help Operation Management

Reference no: EM131861141

The marketing manager for Mountain Mist soda needs to decide how many TV spots and magazine ads to run during the next quarter. Each TV spot costs $5,000 and is expected to increase sales by 300,000 cans.

Each magazine ad costs $2,000 and is expected to increase sales by 500,000 cans. A total of ?100,000 may be spent on TV and magazine ads; however, Mountain Mist wants to spend no more than $70,000 on TV spots and no more than $50,000 on magazine ads. Mountain Mist earns a profit of $0.05 on each can it sells.

(a). Formulate an LP model for this problem,

(b). Sketch the feasible region for this model,

(c). Find the optimal solution to thie problem using isoprofit lines,

(d). Find the optimal solution using Excel Solver,

(e). Find the optimal solution using MATLAB.

Reference no: EM131861141

Questions Cloud

Economic and political power : What sort of people and institutions might acquire special economic and political power because of social media?

Affordable care act : Are the theories advanced dependent upon whether or not the Affordable Care Act is the health care law of the land or will they work if another health care

Why is marketing to women so bad : Why is marketing to women so bad? How well do you feel marketers target women segments?

Draft all the interviewer controls you believe are necessary : Take the role of the marketing research projects director. Draft all the interviewer controls you believe are necessary to ensure data collection.

Find the optimal solution using excel solver : The marketing manager for Mountain Mist soda needs to decide how many TV spots and magazine ads to run during the next quarter.

Discuss the setting and stage directions in play you read : Discuss the setting and stage directions in the play you read. Does the setting produce certain responses from the audience?

Importance of effective communication within an organization : 1. What is the importance of effective communication within an organization?

What would you have done differently and why : Do you believe that this ad targeted the baby boomer population adequately and why or why not? What would you have done differently and why?

Definition of management : The text defines management as "The art of getting things done through the efforts of other people." Based on your own experiences

User Account

All Pages