Question: Determine the optimum solution to the problem below. Use the Excel sensitivity report to determine how much the price per can of A 3 needs

Determine the optimum solution to the problem below. Use the Excel sensitivity report to determine how much the price per can of A3 needs to be increased by for it to be worthwhile for the store to sell the A3 brand of cola.
B&K grocery store sells three types of soft drinks: the brand names A1 Cola, A2 Cola, and the cheaper store brand BK Cola. The price per can for A1, A2, and BK are 80,70, and 60 cents, respectively. On the average, the store sells no more than 500 cans of all colas a day. Although A1 is a recognized brand name, customers tend to buy more A2 and BK because they are cheaper. It is estimated that at least 100 cans of A1 are sold daily and that A2 and BK combined outsell A1 by a margin of at least 4:2.
 Determine the optimum solution to the problem below. Use the Excel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!