PROBLEM 8- 4. Determining the Profit- Maximizing Price [ LO 1] RoverPlus, a pet product superstore, is considering pricing a new RoverPlus- labeled dog food. The company will buy the premium dog food from a company in Indiana that packs the product with a RoverPlus label. Rover pays $7 for a 50- pound bag delivered to its store.
The company also sells Royal Dog Food ( under the Royal Dog Food label), which it purchases for $ 10 per 50- pound bag and sells for $ 17.99. The company currently sells 26,000 bags of Royal Dog Food per month, but that is expected to change when the RoverPlus brand is introduced.
The company will continue to price the Royal Dog Food brand at $ 17.99. The quantity of RoverPlus and the quantity of Royal Dog Food that will be sold at various prices for Royal are estimated as:
Price of Royal Plus Quantity Rover Plus Quanity of Royal
$7.99 36,000 12,000
$8.99 35,500 12,300
$9.99 35,000 12,500
$10.99 34,000 13,000
$11.99 31,000 14,000
$12.99 26,000 15,000
$13.99 16,000 16,000
$14.99 11,000 20,000
$15.99 6,000 22,000
For example, if RoverPlus is priced at $ 7.99, the company will sell 36,000 bags of RoverPlus and 12,000 bags of Royal at $ 17.99. If the company prices RoverPlus at $ 15.99, it will sell 6,000 bags of RoverPlus and 22,000 bags of Royal at $ 17.99. This is 4,000 fewer bags of Royal than is currently being sold.
Price of Roval Plus (Given) Quantity Rover Plus (Given) Quanity of Royal (Given) Price of Royal (Given) Total Revenue1 Rover Plus (VC per Unit) Royal (VC per Unit) Cost of Rover Plus2 Cost of Royal3 Total Cost4 Profit5
b. At the price calculated in part a, what is the incremental profit over the profit earned before the introduction of the Rover-Plus branded dog food?
Your tutorial is attached in Excel. Click in cells to see computations.