Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please provide the formula and please fill up the blue highlight boxes in the excel sheet Caf X is selling coffee in three different sizes
Please provide the formula and please fill up the blue highlight boxes in the excel sheet
Caf X is selling coffee in three different sizes at the prices and costs shown in the table below.They are considering raising the price of their small to $3.25, and 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 profit based on the estimated changes in cups sold. Be sure to show all intermediate calculations COGS per Cup $0.20 $0.35 $0.50 Price per Cup Cups Sold |$3.00 |$3.50 |$4.50 Revenue COGS Gross Profit 2400 1300 Small Medium Large 900 Total Gross Profit Price per Cup Est. Change Small @$3.25 Cups Sold Small at $3.00 |$3.25 $3.50 $4.50 Cups Sold with Small Cup at $3.25Revenue COGS per Cup |$0.20 |$0.35 $0.50 COGS Gross Profit -9% 6% 3% 2400 Small Medium 1300 900 Large Total Gross Profit Change in Gross Profit (G37 vs I143)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started