Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Operation Research Expert


The answer to Linear programming model on a spreadsheet using Solver

JL Foods is planning to increase its advertising campaign from $1.4 million to $2 million based, in part, in the introduction of a new product. JL Taco Sauce, to accompany its traditional products, JL Ketchup and JL Spaghetti Sauce. In the past, JL Foods promoted its two products individually, splitting its advertising budget equally between ketchup and spaghetti sauce.

From past experience, the marketing department estimates that each dollar spent advertising only ketchup increases ketchup sales by four bottles and each dollar spent advertising only spaghetti sauce increases its sales by 3.2 bottles. Since JL makes $0.30 per bottle of ketchup and $0.35 per bottle of spaghetti sauce sold (excluding the sunk cost of the given advertising budget), this amounts to a return of $1.20 (=4 * $0.30) per advertising dollar on ketchup and $1.12 (=3.2 * $0.35) per advertising dollar on spaghetti sauce. Because taco sauce is a new product, its initial return is projected to be only $0.10 per bottle, but each advertising dollar spent solely on taco sauce is estimated to increase sales by 11 bottles. The company also projects that sales of each product would increase by another 1.4 bottles for each dollar spent on joint advertising of the three products.

JL wishes to maximize its increase in profits this year from advertising while also "building for the future" by adhering to the following guidelines for this year's advertising spending:

A maximum of $2 million total advertising
At most $400,000 on joint advertising
At least $100,000 on joint advertising
At least $1 million promoting taco sauce, either individually or through joint advertising
At least $250,000 promoting ketchup only
At least $250,000 promoting spaghetti sauce only
At least $750,000 promoting taco sauce only
At least as much spent this year as last year promoting ketchup, either individually or by joint advertising
At least 7.5 million total bottles of product sold

a) Construct, in equation form, the linear programming model that determines the optimal allocation of advertising dollars among the four advertising possibilities (each individual & joint).
b) Solve the problem using Solver
c) What is the total return per advertising dollar?
d) Suppose the constraint requiring that at least $750,000 be spent on promoting taco sauce were lowered to $700,000. How much would the profit increase?

hint: to find out the profit impact of $1 in advertising as one of the objective function coefficients, you have to use a weighted average of the profit from each type of product since they have increased sales of 1.4 bottles each.

Operation Research, Management Studies

  • Category:- Operation Research
  • Reference No.:- M924001

Have any Question? 


Related Questions in Operation Research

Read and answer following questions with1-2 pages papermike

"Read and answer following questions with1-2 pages paper." Mike graduated from school a few months ago. He applied to various companies and has decided to take a position as a supervisor at a well-known local restaurant. ...

Michael has decided to invest 40000 in three types of funds

Michael has decided to invest $40,000 in three types of funds. Fund A has projected an annual return of 8 percent, Fund B has projected an annual return of 10 percent, and Fund C has projected an annual return of 9 perce ...

Consider you need to conduct a business forecastdescribe

Consider you need to conduct a business forecast. Describe your forecast process according to the following steps: - Define the purpose of the forecast o Establish a time horizon - Select a forecasting technique o Gather ...

Monitoring and evaluationinitial postings must be 250-350

Monitoring and Evaluation Initial postings must be 250-350 words (not including references). Effective health care organizations recognize the importance of monitoring the implementation of a strategy as well as ongoing ...

A critical review on use of operations research for

A critical review on use of Operations Research for Decision Making

The agile approach towards system analysis and development

The agile approach towards system analysis and development emphasizes iterative and incremental development, in which requirements and solutions evolve through collaboration. Prepare a 1000 word essay on the requirements ...

Please explain how each department in a company could

Please explain how each department in a company could approach assessing customer expectations of a new product launch product. Describe how to use a TQM approach for fulfilling customer expectations associated with a ne ...

In every organization inputs of some kind services

In every organization, inputs of some kind (services, information, and/or products) are transformed into outputs (services, information, and/or products) on an ongoing, continuous basis, which are of value to internal or ...

Short essays no required length1 discuss how occupational

Short essays (no required length) 1. Discuss how occupational safety and health laws and regulations are established, implemented and possibly altered. 2. Compare and contrast this with the establishment of environmental ...

In this discussion forum you will discuss the implications

In this discussion forum, you will discuss the implications of not having a clear and precise scope of the project, and why it needs to be approved by higher management. Also discuss the importance of listing, sequencing ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro