Question: 4. Cafe X is selling coffee in 3 different sizes at the prices and costs shown in the table below. They are considering raising the
4. Cafe X is selling coffee in 3 different sizes at the prices and costs shown in the table below. They are considering raising the price of their small to $2.75, and they project that sales of smalls will go down while sales of mediums and larges will go up slightly. Create a spreadsheet to calculate the projected change in gross margin based on the estimated changes in cups sold. Be sure to show all intermediate calculations. Size Price per Cup Cost per Cup Cups Sold Est. Change in Cups Sold with Small @ $2.75 Small $2.50 $0.20 2,500 -10% Medium $3.50 $0.35 1,500 +6% Large $4.50 $0.50 800 +3%
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
