Question

I am stuck on #3 to find the weekly gross profit based on your average weekly cup sales? I got $4,930.19 for my average weekly revenue. Would I add the 3 total sums of each Average sales for each size cup and subtract from the average weekly revenue. If so I resulted in 373.19

instructions: Using the data for the assignment complete your spreadsheet and answer the five questions. When you make the changes for question 4 and 5 your spreadsheet will change and your spreadsheet answer from the previous question may change depending on how you build your spreadsheet.

That is OK, we can look at your spreadsheet and do some quick checks. Again, we are expecting to see formulas/functions in the spreadsheet.

This assignment is similar to the Biz Café Individual Assignment pricing worksheet. What is your average weekly revenue over the six weeks the students gathered their data? Insert the answer and the cell for answer here .

We will look for it in your spreadsheet. We need the cell so that we don’t have to navigate your spreadsheet to find your calculations. Hint: You need to average sales for each cup size separately before determining your revenue.

Coffee Sales by Cup for Six Weeks Week 1 Small Coffee 2045 Medium Coffee 1689 Large Coffee 922

Week 2 Small Coffee 2065 Medium Coffee 1751 Large Coffee 901

Week 3 Small Coffee 2057 Medium Coffee 1008 Large Coffee 868

Week 4 Small Coffee 2032 Medium Coffee 1698 Large Coffee 901

Week 5 Small Coffee 2035 Medium Coffee 1723 Large Coffee 865

Week 6 Small Coffee 2076 Medium Coffee 1802 Large Coffee 903

Price by Cup Size Small - $2.50 Medium - $3.50 Large - $4.50

What is the Cost of Goods Sold for a large cup of coffee? Insert the answer and the cell with the answer here ............ We will check the cell in your spread sheet. Hint: We are looking for the Cost of Goods Sold for a single large cup of coffee not the total of all large cups sold. Cost of Goods Sold (GOGS) Cost of each Cup Small Cup - $ .08 Medium Cup- $ .09 Large Cup - $.11 Coffee cost for each Cup Size 1/64 lb. of Coffee (Small) - $.11 2/64 lb. of Coffee (Medium) - $.22 3/64 lb. of Coffee (Large) - $.33 What is your weekly gross profit based on your average weekly cup sales? Insert the answer and the cell with the answer here _______________. We will check the cell in your spread sheet. Hint: This is where you have to use your average cup sales to determine your average cost of goods sold. No new data required.

Answer 1

Particulars	Small Coffee	Medium Coffee	Large Coffee
Average weekly sales (Cups) (A)	2052	1612	893
Price per cup (B)	$2.50	$3.50	$4.50
Average weekly revenue ($) (C)	5130	5642	4018.5
Cost of each cup (D)	.08	.09	.11
Cost of coffee for each cup	.11	.22	.33
COGS each cup	.19	.31	.44
Total COGS	389.88	499.72	392.92
Gross profit	4740.12	5142.28	3625.58