Essentials Of Business Analytics
Essentials Of Business Analytics
1st Edition
ISBN: 9781285187273
Author: Camm, Jeff.
Publisher: Cengage Learning,
bartleby

Videos

Textbook Question
Book Icon
Chapter 10, Problem 1P

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 = 2 R 2 10 M 2 8 R M + 18 R + 34 M ,

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.

  1. a. What is the value of sales if $2,000 is spent on radio advertising and $1,000 is spent on direct-mail advertising?
  2. 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.
  3. c. Determine the optimal amount to spend on radio and direct-mail advertising. How much in sales will be generated?

a.

Expert Solution
Check Mark
To determine

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.

S=2R210M28RM+18R+34M=2(22)10(12)8(2)(1)+18(2)+34(1)=36

Therefore, sales of $36,000 will be generated with the budget allocated for promotion.

b.

Expert Solution
Check Mark
To determine

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,

Max2R210M28RM+18R+34Ms.t.

R+M3000R,M0

c.

Expert Solution
Check Mark
To determine

To solve and find the optimal amount to be spend on advertising to determine the amount of sales generated.

Explanation of Solution

Formula:

Essentials Of Business Analytics, Chapter 10, Problem 1P , additional homework tip  1

Solver:

Essentials Of Business Analytics, Chapter 10, Problem 1P , additional homework tip  2

Output:

Essentials Of Business Analytics, Chapter 10, Problem 1P , additional homework tip  3

The solution is R = $2,500 and M = $500 with Sales of $37,000

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
GreenLawns provides a lawn fertilizing and weed control service. The company is adding a special aeration treatment as a low-cost extra service option, which 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 $2,500 is available for this promotional campaign. Based on past experience in promoting its other services, GreenLawns 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 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 (in dollars) if $2,000 is spent on radio advertising and $500 is spent on…
Spring is a peak time for selling houses. Suppose the data below contains the selling price, number of bathrooms, square footage, and number of bedrooms of 26 homes sold in Ft. Thomas, Kentucky, in spring 2018. Selling Price Baths Sq Ft Selling Price 160,000 170,000 178,000 182,500 195,100 212,500 245,900 250,000 255,000 258,000 267,000 268,000 275,000 1.5 1,786 2 1,768 1 1,219 1 1,578 1.5 1,125 2 1,196 2 2,128 N W 3 2 1,280 1,596 3.5 2,374 2.5 2,439 2 1,470 2 1,688 Beds 3 3 3 2 3 2 3 3 3 4 3 4 4 295,000 325,000 325,000 328,400 331,000 344,500 365,000 385,000 395,000 399,000 430,000 430,000 454,000 Baths Sq Ft 2.5 1,860 3 2,056 3.5 2,776 2 1,408 1.5 1,972 2.5 1,736 2.5 1,990 2.5 3,640 2.5 1,928 2 2,108 2 2,462 2 2,615 3.5 3,700 Beds 3 4 4 4 3 3 4 4 4 3 4 4 4 Consider the estimated regression equation we developed that can be used to predict the selling price given the number of bathrooms, square footage, and number of bedrooms in the house. (x, denotes number of bathrooms, x₂ denotes…
A car dealership keeps track of how much it spends on advertising each month and of its monthly revenue. From this information, the list of advertising expenditures and probable associated revenues are shown in the table below.
Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
What Are Research Ethics?; Author: HighSchoolScience101;https://www.youtube.com/watch?v=nX4c3V23DZI;License: Standard YouTube License, CC-BY
What is Ethics in Research - ethics in research (research ethics); Author: Chee-Onn Leong;https://www.youtube.com/watch?v=W8Vk0sXtMGU;License: Standard YouTube License, CC-BY