Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And Systems Exam Questions And Explanations

Authors: Irvin N. Gleim, William A. Hillison

13th Edition

1581945272, 978-1581945270

More Books

Students also viewed these Accounting questions