# I am stuck on #3 to find the weekly gross profit based on your average weekly cup sales? I got \$4,93

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

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