Problem
The pitts barbecue company makes 3 kinds or barbecue sauce: extra hot, hot, and mild. pitt'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 its spends 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 cost 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 the 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 case 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 a spreadsheet model for this problem and solve it using solver.
C. what is the optimal solution?