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

Firm A has a domestic Salary of $12000 million, exports is $3500 million and purchase are $5000 million Calculate the value added by firm A
Refer to the figure below. Insurance and pensions 11.9% Item a. Entertainment b. Transportation c. Clothing Housing 32.8% Source: U.S. Bureau of Labor Statistics, Consumer Expenditure Survey (2018 date). Entertainment 5,3% Item Weight 0.053 0.159 0.03 Transportation 15.9% Health care 8.1% Use the item weights in the figure to determine the percentage change in the CPI that would result from a(n) a. 20 percent increase in entertainment prices. b. 8 percent decrease in transportation costs. c. doubling of clothing prices. (Note: Review the table titled "Computing Changes in the CPI" in your text for assistance.) Instructions: Enter your responses as a percentage rounded to two decimal places. If you are entering any negative numbers be sure to include a negative sign (-) in front of those numbers. Price Change 20% -8% 100% Food 12.9% Clothing 3.0% Impact on CPI (Inflation Effect) Miscellaneous 10.1%
Why we cannot have UBI and employ of last resort as the sametime?
Inflation rate for the developed country (New Zealand).
The fractions make no sense
The CPI in December of the year 2000 was equal to 174.6. In May of 2023, the most recent month available, the CPI was 304.2. If you made $35,000 in 2000, how much income would you have to make in March of 2023 to maintain the same purchasing power? Please show your work.
Lachlan is 46 years of age and is a single parent. He has one dependent child – a daughter named Rory who is 22 years of age. She is a full time student whose only income for the year was Youth Allowance totalling $7,882.Lachlan received the following income –$52,300 Wages$1,980 Tattslotto win$1,300 Disability support pension$5,900 Jobseeker payment$960 Bank interestLachlan also had the following amounts listed on his income statement –Reportable fringe benefits amount $29,999Reportable employer super contributions $10,000He had work related deductions totalling $1,240, a HELP debt of $5,893 and neither he nor Rory have private health insurance.Will Lachlan be required to pay back any of his HELP debt? If so, how much will he be required to pay (show full workings) and why.
8
Turnover (EUR) 2015 2016 2017 2018 2019 2020 prices 179 408 186 287 180 802 181 825 174 922 178 632 203 206 210 744 204 841 205 529 188 995 184 830 174 203 180 682 176 062 176 973 190 562 189 118 207 017 214 936 208 476 209 527 205 449 196 190 2015 2016 2017 2018 210 672 202 746 207 919 212 905 215 358 212 925 217 367 207 480 219 291 224 067 220 738 227 471 2019 2020 The 2nd element of the base quantity-index series standard weighted is Give their value with 4 decimals. Pay attention for the sequencing: in case of a base index series the '1', in case of a chain index series the is considered the 0th element of the relevant index series!!!
Give typing answer with explanation and conclusion
What are the benefit and disadvantages of A working capital loan ?