Question: 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

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 the problem using level curves.

Step by Step Solution

★★★★★

3.31 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a X 1 of TV spots X 2 of magazine ads MAX 15 X 1 25 ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

167-B-M-L-M-D-A (35).docx

120 KBs Word File

Students Have Also Explored These Related Management Leadership Questions!

1. From the partial work sheet for Major Advising below, prepare an income statement. Major Advising Work Sheet (Partial) For Month Ended January 31, 20- Income Statement Balance Sheet ACCOUNT TITLE...

A sweatshirt supplier is trying to decide how many sweatshirts to print for the upcoming NCAA basketball championships. The final four teams have emerged from the quarterfinal round, and there is now...

The local Toyota dealer has to decide how many spare shock absorbers of a particular type to order for repairing Toyota automobiles. This shock absorber has a demand of four units per month and costs...

The marketing manager for the Charlotte Times newspaper has commissioned a study of the advertisements in the classified section. The results for the Wednesday edition showed that 204 are help-wanted...

Formulate an LP model Find the optimal solution by using Excel Solver and submit Excel Template with your solution results. Provide an interpretation of the Sensitivity Report. The marketing manager...

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 $5000 and is expected to increase sales by 300,000...

4. 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 $5000 and is expected to increase sales by...

Blacktop Refining extracts minerals from ore mined at two different sites in Montana. Each ton of ore type 1 contains 20% copper, 20% zinc, and 15% magnesium. Each ton of ore type 2 contains 30%...

Question 1 (Total of 28 marks) Joe Bright, the marketing manager for Mountain Mist soda needs to decide how many TV spots and magazine advertisements to run during the next quarter. Each TV spot...

Journalize the transactions in the books of Busy Bank - Main Branch . On 8/3/2015, Wise Decision Inc. deposited in their current account, at Busy Bank - Main Branch, checks totaling JD 7000 drawn on...

John is a long-time employee of ABC Ltd. (the Company) and has been granted the following employee stock options. The following two cases are independent of each other. Answer both cases and clearly...

What is a bankruptcy?

Profit allocation involving interest on capital balances. Rivera, Sampson, and Elliott are partners in a commercial plumbing business. Rivera and Sampson have also started another contracting company...

a) What is the journal entry to record deferred or unearned revenue? What is the total amount of unearned revenue that is deferred from being recognized in income for FY2015? b) What is the journal...

1. The bars A andB are supported by smooth pins at C and D and by a roller at B and E. Neglecting the mass of the bars, analyze completely and summarize your answers in a table format. 1120 N 680 N.m...

There has been a lot of regulatory and legislative change to accommodate the disruption caused to business by the COVID19 pandemic. In the context of this unit, lets examine the impact on financial...

GreenPoint Credit, LLC had a security interest in a mobile home owned by Rosetta Lunsford. The home was destroyed by fire, and Lunsfords insurer, Kentucky Farm Bureau Mutual Insurance Co. issued a...

The central Florida high school basketball tournament pits teams from four different counties against one another. The average distance (in miles) between tournament locations in each country is...

The Chickn-Pickn fast-food chain is considering how to expand its operations. Three types of retail outlets are possible: a lunch counter operation designed for office buildings in downtown areas, an...

A private foundation has offered $3 million to allocate to cities to help fund programs that aid the homeless. Grant proposals were received from cities A, B, and C seeking assistance of $750,000,...

" C + + . ( 1 8 ) 1 . _ title DVD . . 2 . . . 3 . checkD 1 movieID ( ) . 4 . checkD 2 movie _ title ( ) . . 5 . checkM MemberID . 6 . ID MemberID . . 7 . . 8 . . ( " > > " ) . ! > > . > > . > >...

a.Roderick Electric Scooter, Inc., staff has come up with the following estimates for the electric scooter project: Pessimistic Expected Optimistic Market size 2.5 million 3.0 million 3.2 million...

You are faced with downsizing payroll costs by 12%. Currently GCC has 648 employees, all non-union. The event that has triggered the need to downsize is the recent tariffs placed on the plastics...