Essentials of Business Analytics (MindTap Course List)
Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
bartleby

Videos

Textbook Question
Book Icon
Chapter 13, 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 (MindTap Course List), Chapter 13, Problem 1P , additional homework tip  1

Solver:

Essentials of Business Analytics (MindTap Course List), Chapter 13, Problem 1P , additional homework tip  2

Output:

Essentials of Business Analytics (MindTap Course List), Chapter 13, 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
亚 ח Variables Name avgdr employ educ exerany Label AVG ALCOHOLIC DRINKS PER DAY IN PAST 30 EMPLOYMENT STATUS EDUCATION LEVEL EXERCISE IN PAST 30 DAYS
Variables Name wage hours IQ KWW educ exper tenure age married black south urban sibs brthord meduc feduc Label monthly earnings average weekly hours IQ score knowledge of world work score years of education years of work experience years with current employer age in years =1 if married =1 if black =1 if live in south =1 if live in SMSA number of siblings birth order mother's education father's education
Information for questions 4 • • Please Download "wages" from Canvas (the link to this dataset is right below the HWA1 questions - it is a Microsoft excel worksheet) and store it in your favorite folder. It contains 797 observations and 16 variables. The "state" variable gives the names of the states involved in this dataset. • You need to have excel on your computer to open this dataset. i. You should use File > Import > Excel Spreadsheet etc. as done in class 3 convert this file into a Stata dataset. Once you are done, write the final STATA code that makes the transformation of an excel file to a STATA file possible. ii. Write a code that will close the log file that has been open since Question 1 part ii.
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