QuickHelper

(10)

$20/per page/

About QuickHelper

Levels Tought:
Elementary,High School,College,University,PHD

Expertise:
Accounting,Applied Sciences See all
Accounting,Applied Sciences,Business & Finance,Chemistry,Engineering,Health & Medical Hide all
Teaching Since: May 2017
Last Sign in: 352 Weeks Ago, 6 Days Ago
Questions Answered: 20103
Tutorials Posted: 20155

Education

  • MBA, PHD
    Phoniex
    Jul-2007 - Jun-2012

Experience

  • Corportae Manager
    ChevronTexaco Corporation
    Feb-2009 - Nov-2016

Category > Business & Finance Posted 06 Jun 2017 My Price 15.00

The Pitts Barbecue Company makes three kinds of barbecue sauce

Question description

 

 

The Pitts Barbecue Company makes three kinds of barbecue sauce: Extra hot, Hot, and Mild. Pitts's vice president of marketing estimates that the company can sell 8,000 cases of its Extra Hot sauce plus 10 extra cases for every dollar it spends promoting this sauce; 10,000 cases of Hot sauce plus 8 extra cases for every dollar spent promoting this sauce; and 12,000 cases of its Mild sauce plus 5 extra cases for every dollar spent promoting this sauce. Although each barbecue sauce sells for $10 per case, the cost of producing the different types of sauce varies. It costs the company $6 to produce a case of Extra Hot sauce, $5.50 to produce a case of Hot sauce, and $5.25 to produce a case of Mild sauce. The president of the company wants to make sure the company manufactures at least the minimum amounts of each sauce that the marketing vice president thinks the company can sell. A budget of $25,000 total has been approved for promoting these items of which at least $5,000 must be spent advertising each item. How many cases of each type of sauce should be made and how do you suggest that the company allocate the promotional budget if its wants to maximize profits?

1. Formulate an LP model for this problem 

2. Create a spreadsheet model for this problem and solve it using Solver 

3. What is the optimal solution?

Please include solver solution and mathematical equation

Answers

QuickHelper
(10)
Status NEW Posted 06 Jun 2017 07:06 PM My Price 15.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k Y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l

Not Rated(0)