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
For each of the time​ series, construct a line chart of the data and identify the characteristics of the time series​ (that is,​ random, stationary,​ trend, seasonal, or​ cyclical). Year    Month    Rate (%)2009    Mar    8.72009    Apr    9.02009    May    9.42009    Jun    9.52009    Jul    9.52009    Aug    9.62009    Sep    9.82009    Oct    10.02009    Nov    9.92009    Dec    9.92010    Jan    9.82010    Feb    9.82010    Mar    9.92010    Apr    9.92010    May    9.62010    Jun    9.42010    Jul    9.52010    Aug    9.52010    Sep    9.52010    Oct    9.52010    Nov    9.82010    Dec    9.32011    Jan    9.12011    Feb    9.02011    Mar    8.92011    Apr    9.02011    May    9.02011    Jun    9.12011    Jul    9.02011    Aug    9.02011    Sep    9.02011    Oct    8.92011    Nov    8.62011    Dec    8.52012    Jan    8.32012    Feb    8.32012    Mar    8.22012    Apr    8.12012    May    8.22012    Jun    8.22012    Jul    8.22012    Aug    8.12012    Sep    7.82012    Oct…
For each of the time​ series, construct a line chart of the data and identify the characteristics of the time series​ (that is,​ random, stationary,​ trend, seasonal, or​ cyclical). Date    IBM9/7/2010    $125.959/8/2010    $126.089/9/2010    $126.369/10/2010    $127.999/13/2010    $129.619/14/2010    $128.859/15/2010    $129.439/16/2010    $129.679/17/2010    $130.199/20/2010    $131.79 a. Construct a line chart of the closing stock prices data. Choose the correct chart below.
For each of the time​ series, construct a line chart of the data and identify the characteristics of the time series​ (that is,​ random, stationary,​ trend, seasonal, or​ cyclical) Date    IBM9/7/2010    $125.959/8/2010    $126.089/9/2010    $126.369/10/2010    $127.999/13/2010    $129.619/14/2010    $128.859/15/2010    $129.439/16/2010    $129.679/17/2010    $130.199/20/2010    $131.79
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
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
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