The marketing manager for Mountain Mist soda needs to decide how many TV spots and magazine...

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 $6000 and is expected to increase sales by 400,000 cases. Each magazine ad costs $2500 and is expected to increase sales by 500,000 cases. A total of $100,000 may be spent on TV and magazine ads combined. 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 $1.80 on each case of soda that it sells. Set up an Excel sheet for this problem showing the information, variables, objective (hint, you’re maximizing something) and constraints. You do not have to solve it.

Expert Solution

Below is the Excel setup for solving this linear programming problem as shown in Excel screenshot as given,

Now setup Solve with decision variables, constraints and objective function as shown below.

(Data -> Solver)

Below is the optimal solution:

	Number of Ads
TV	0
Magazine	40

Maximum profit increase is $36,000,000.

Please give thumbs up/ likes if you find this answer helpful. Thank you!

keosha answered 6 days ago

: A concert promoter needs to decide how many concert T- shirt to order supplied with...

: A concert promoter needs to decide how many concert T- shirt to order supplied with its logo name on the front side of T-shirt. The profit on each one sold at the concert is 50 L.E. and any unsold T-shirt and returned to the supplied company will cause a loss of 30 L.E for the promoter. Demand is uncertain but is estimated to be between 200 to 1000 T-shirt. The probabilities of different demand levels are as follows: Demand...

BP Cola Must Decide How Much Money To Allocate For New Soda And Traditional Soda Advertising...

BP Cola Must Decide How Much Money To Allocate For New Soda And Traditional Soda Advertising ... Question: BP Cola must decide how much money to allocate for new soda and traditional soda advertising over... BP Cola must decide how much money to allocate for new soda and traditional soda advertising over the coming year. The advertising budget is $10,000,000. Because BP wants to push its new sodas, at least one-half of the advertising budget is to be devoted to...

Problem 2 A manager must decide how many machines of a certain type to buy. The...

Problem 2 A manager must decide how many machines of a certain type to buy. The machines will be used to manufacture a new gear for which there is increased demand. The manager has narrowed the decision to two alternatives: buy one machine or buy two. If only one machine is purchased and demand is more than it can handle, a second machine can be purchased at a later time. However, the cost per machine would be lower if the...

The marketing manager at the Magazine Company suggests a new customer acquisition strategy with customer acquisition...

The marketing manager at the Magazine Company suggests a new customer acquisition strategy with customer acquisition cost of $15. The strategy basically is to offer $15 discount to the new customers. This discount is only for the first year, and the fee is going to jump to the regular fee for the following years. Assume that this strategy does not have any effect on retention rate and contribution margin for each customer. Is this strategy worth pursuing? In other words,...

Q1) A well-known firm produces automobiles. The planning team needs to decide how many items to...

Q1) A well-known firm produces automobiles. The planning team needs to decide how many items to produce monthly. The monthly fixed cost is $42,000 and variable costs are $3 per charger. Items sell for $7 each. a. Draw a table showing fixed costs, variable costs, total costs, total revenues, and total profits, for monthly volumes of 10,000, 12,000 and 15,000 units. b. What is the break-even point? c. Determine profit when volume equals 25,000 units.

A manager must decide how many machines of a certain type to purchase. Each machine can...

A manager must decide how many machines of a certain type to purchase. Each machine can process 101 customers per day. One machine will result in a fixed cost of $2,038 per day, while two machines will result in a fixed cost of $3,836 per day. Variable cost will be $22 per customer and revenue will be $49 per customer. Determine the break-even point in units for TWO machines. *Round your answers to 3 decimal places in your calculation if...

The manager of a clinic can have many varied responsibilities based on the needs of the...

The manager of a clinic can have many varied responsibilities based on the needs of the specific facility. Discuss five duties and their importance to the facility.

In your new job as a retail store manager you decide to add mobile marketing to...

In your new job as a retail store manager you decide to add mobile marketing to your promotional campaign. Describe how a Bluetooth Low Energy (BLE) beacon could increase sales in your store.

A population of splendid fungus beetles lives in my backyard. A gene determines how many spots...

A population of splendid fungus beetles lives in my backyard. A gene determines how many spots they have on their hindwings. Those with the dominate phenotype (BB and Bb) have 3 large spots, and those with the recessive phenotype (bb) have 7 small spots. The population isn't very big - only 50 beetles. I counted them and notice that 18 have three large spots and 32 have seven small spots. If there is no natural selection, mutation or gene flow...

How can marketing manager segment a market?

Question