Gmw auto manufactures luxury cars and trucks the company, Ask an Expert

Management Studies

GMW Auto manufactures luxury cars and trucks. The company believes that its most likely customers are high-income women and men. To reach these groups, GMW Auto has embarked on an ambitious TV advertising campaign and has decided to purchase commercial spots on two types of programs: Drama show and Super Bowl game. A drama show commercial’s length is 1.4-minutes and each drama show commercial is seen by 12 million high-income women and 8 million high-income men. A Super Bowl commercial’s length is 0.5-minute and each Super Bowl commercial is seen by 11 million high-income women and 16 million high-income men. GMW Auto has 4.7-minutes of commercial spots available. A 1.4-minutes drama show ad costs $246,000, and a 0.5-minute Super Bowl ad costs $457,000. GMW would like the commercials to be seen by at least 47 million high-income women and 35 million high-income men.

a) Formulate a linear programming model to determine how GMW Auto can meet its advertising requirements at minimum cost. (Write the complete model for the problem. Make sure to give clear definitions of your decision variables).

b) Solve the problem by using Excel Solver (Hand-in the value and formulas printouts for the problem). Show the optimal solution and optimal value in your printouts.

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M92288974

Have any Question?Write your Review or question?

Related Questions in Operation Management

1 discuss two strategies that can be used for leading

1. Discuss two strategies that can be used for leading change. How do these strategies increase stakeholder support and create momentum for a change initiative to be successful? Why might you want to consider including t ...

You are a hospital administrator assigned to oversee

You are a hospital administrator assigned to oversee patient satisfaction and you have two health care workers that have been neglecting patients because of their difficulty in working together due to their dislike for o ...

Interview a classmate or friend or family member of the

Interview a classmate (or friend or family member) of the other gender about the way he or she most likes to enjoy nature, or to describe his or her most memorable experience in nature, or to describe the aspect of being ...

Discuss whether you believe the following are privacy

Discuss whether you believe the following are privacy issues: Receiving an email from a friend which was forwarded from your friend's colleague, who had forwarded it to 12 other email addresses, where ALL of the email ad ...

1 technology is leading to a breakdown is basic

1. Technology is leading to a breakdown is basic communication skills. Text and email are replacing phone call and face-to-face meetings. Discuss developing soft skills such as emotional intelligence, collaboration, and ...

We often hear people complain about how employees exhibit

We often hear people complain about how employees exhibit poor behaviors in the workplace, particularly in recent years. Share with the class one thing you have observed in a place of business (either where you work or a ...

1 ldquothe social responsibility of business is to increase

1. “The social responsibility of business is to increase its profits.” So said Milton Friedman in a famous 1970 missive in the New York Times. (Friedman, Milton. 1970. How do you respond to this statement? Do you support ...

Consider the following order point without safety stock is

Consider the following: Order point without safety stock is 200. Carrying cost is $40 per unit per year. Cost of a stock out is $70 per unit per year. The probability of demand during lead time is as follows: Demand Duri ...

In may 2012 the doj announced it had reached a settlement

In May 2012, the DOJ announced it had reached a settlement totaling $1.5 billion with Abbott Laboratories for unlawful promotion of the drug Depakote. Abbott had promoted the drug to control agitation and aggression in e ...

Write an 8ndash10-page report discussing what factors you

Write an 8–10-page report discussing what factors you think should be considered when creating a compensation system for an organization and why. Include the organization you work for (past or present) and describe the o ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert