excel solver 1. Media Planning. GreenLawns provides a lawn fertilizing and weed control service. The companyis adding a special aeration treatment as a low-cost extra service option that it hopes will helpattract new customers. Management is planning to promote this new service in two media: radioand direct-mail advertising. A media budget of $3,000 is available for this promotional campaign.Based on past experience in promoting its other services, GreenLawns has obtained the followingestimate of the relationship between sales and the amount spent on promotion in these two media:S-2R²10M² - 8RM +18R+ 34M whereS = total sales in thousands of dollarsR = thousands of dollars spent on radio advertisingM =thousands of dollars spent on direct-mail advertisingGreenLawns would like to develop a promotional strategy that will lead to maximum sales subjectto the restriction provided by the media budget.a. What is the value of sales if $2,000 is spent on radio advertising and $1,000 is spent on direct-mail advertising?b. Formulate an optimization problem that can be solved to maximize sales subject to the mediabudget of spending no more than $3,000 on total advertising.c. Determine the optimal amount to spend on radio and direct-mail advertising. How much insales will be generated?

Given Total sales function S=-2R2-10M2-8RM+18R+34M ........(1) S is the total sales (in…

1. Media Planning. GreenLawns provides a lawn fertilizing and weed control service. The company is adding a special aeration treatment as a low-cost extra service option that it hopes will help attract new customers. Management is planning to promote this new service in two media: radio and direct-mail advertising. A media budget of $3,000 is available for this promotional campaign. Based on past experience in promoting its other services, GreenLawns has obtained the following estimate of the relationship between sales and the amount spent on promotion in these two media: S-2R²10M² - 8RM +18R+ 34M

1. Media Planning. GreenLawns provides a lawn fertilizing and weed control service. The company is adding a special aeration treatment as a low-cost extra service option that it hopes will help attract new customers. Management is planning to promote this new service in two media: radio and direct-mail advertising. A media budget of $3,000 is available for this promotional campaign. Based on past experience in promoting its other services, GreenLawns has obtained the following estimate of the relationship between sales and the amount spent on promotion in these two media: S-2R²10M² - 8RM +18R+ 34M

ENGR.ECONOMIC ANALYSIS

14th Edition

ISBN:9780190931919

Author:NEWNAN

Publisher:NEWNAN

Chapter1: Making Economics Decisions

Section: Chapter Questions

Problem 1QTC

See similar textbooks

Similar questions

Where are you getting the number 11?
Calculate the value of APS if Savings is $320 million and income is $420 million
Please assist with the calculation
Sarah is unemployed if she is working at the accounting department of General Motor. is laid off and still looking for a job. has looked for a job for two months and then give up looking. is not looking for a job.
Identify each person with the appropriate classification Heather just finished college, is not working, but is looking for a teaching job. Luis worked at an auto plant. The plant shut down and Luis Gave up looking for a job 2 years ago. Robert has a nursing degree and is looking for a nursing job. He is sacking groceries part-time until he finds a job. Brittany is serving for 4 years in the Navy. Dan is a stay-at-home dad who is now looking for an engineering job? Bill is retired and volunteers at meal-on wheels every Monday Gina is attending college but not working : Labor Force- Employed : Labor Force- Unemployed :: Not in the Labor Force
What are the mathematical tools in research
Solve it now. Not copy paste answer provided
Typed plz and asap thanks
Discuss MFIs objectives, challenges it is facing in achieving its objectives and how technology can help it overcome some of the challenges
how to calculate future value
How did you get the formula for letter B?
What is a transfer payment?