
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:
where
S = total sales in thousands of dollars
R = thousands of dollars spent on radio advertising
M = thousands of dollars spent on direct-mail advertising
GreenLawns would like to develop a promotional strategy that will lead to maximum sales subject to 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 media budget 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 in sales will be generated?
a.

To find the amount of sales generated when $2,000 and $1,000 is spend on radio and direct-mail advertising.
Explanation of Solution
To find the amount of sales generated, substitute $2,000 and $1,000 is spend on radio and direct-mail advertising in the below relationship equation.
Therefore, sales of $36,000 will be generated with the budget allocated for promotion.
b.

To formulate optimization problem to maximize sales when total advertising cost is not more than $3,000.
Explanation of Solution
The formulation is for the problem is shown below,
c.

To solve and find the optimal amount to be spend on advertising to determine the amount of sales generated.
Explanation of Solution
Formula:
Solver:
Output:
The solution is R = $2,500 and M = $500 with Sales of $37,000
Want to see more full solutions like this?
Chapter 10 Solutions
Essentials Of Business Analytics
- please find the answers for the yellows boxes using the information and the picture belowarrow_forwardA marketing agency wants to determine whether different advertising platforms generate significantly different levels of customer engagement. The agency measures the average number of daily clicks on ads for three platforms: Social Media, Search Engines, and Email Campaigns. The agency collects data on daily clicks for each platform over a 10-day period and wants to test whether there is a statistically significant difference in the mean number of daily clicks among these platforms. Conduct ANOVA test. You can provide your answer by inserting a text box and the answer must include: also please provide a step by on getting the answers in excel Null hypothesis, Alternative hypothesis, Show answer (output table/summary table), and Conclusion based on the P value.arrow_forwardA company found that the daily sales revenue of its flagship product follows a normal distribution with a mean of $4500 and a standard deviation of $450. The company defines a "high-sales day" that is, any day with sales exceeding $4800. please provide a step by step on how to get the answers Q: What percentage of days can the company expect to have "high-sales days" or sales greater than $4800? Q: What is the sales revenue threshold for the bottom 10% of days? (please note that 10% refers to the probability/area under bell curve towards the lower tail of bell curve) Provide answers in the yellow cellsarrow_forward
- Business Discussarrow_forwardThe following data represent total ventilation measured in liters of air per minute per square meter of body area for two independent (and randomly chosen) samples. Analyze these data using the appropriate non-parametric hypothesis testarrow_forwardeach column represents before & after measurements on the same individual. Analyze with the appropriate non-parametric hypothesis test for a paired design.arrow_forward
- Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin HarcourtGlencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill

