Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

the Pitts Barbecue Company makes 3 kinds of barbecue sauce:Extra Hot, Hot, and Mild.Pitts' president of marketing estimates that the company can sell 8,000 cases

the Pitts Barbecue Company makes 3 kinds of barbecue sauce:Extra Hot, Hot, and Mild.Pitts' 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 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 made 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 it wants to maximize profits?

a.Formulate an LP model for this problem.b. Create an Excel spreadsheet model for this problem and solve it using Solver.c. What is the optimal solution?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting Tools For Business Decision Making

Authors: Jerry J Weygandt, Paul D Kimmel, Jill E Mitchell

9th Edition

1119754054, 9781119754053

More Books

Students also viewed these Accounting questions

Question

=+b) Obtain a forecast for March 2007.

Answered: 1 week ago