Once you have determined your gross profit based on the historical data you will have to determine the impact of increasing your coffee prices using the preference changes that the students calculated based on the survey responses. Finally your coffee supplier increases their coffee prices and you will have to recalculate your gross profit. 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. R S 1. 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 a. Hint: You need to average sales for each cup size separately before determining your revenue. Coffee Sales by Cup for Six Weeks Week 1 Week 2 Small Coffee Medium Coffee Large Coffee Small Coffee Medium Coffee Large Coffee Small Coffee Medium Coffee Large Coffee Small Coffee Medium Coffee 2045 1689 922 2065 1751 901 2057 1008 868 2032 1698 Week 3 Week 4 A HP 2. 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. a. 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 ANSFER Medium Cup- $.09 ESSERE Large Cup - $.11 HREFERESSERE TRE Coffee cost for each Cup Size 1/64 lb. of Coffee (Small) - $.11 2/64 lb. of Coffee (Medium) - $.22 ER 3/64 lb. of Coffee (Large) - $.33 3. 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. a. Hint: This is where you have to use your average cup sales to determine your average cost of goods sold. No new data required. BERNER TENERE RRRRRRR AFTER SEVER Once you have determined your gross profit based on the historical data you will have to determine the impact of increasing your coffee prices using the preference changes that the students calculated based on the survey responses. Finally your coffee supplier increases their coffee prices and you will have to recalculate your gross profit. 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. R S 1. 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 a. Hint: You need to average sales for each cup size separately before determining your revenue. Coffee Sales by Cup for Six Weeks Week 1 Week 2 Small Coffee Medium Coffee Large Coffee Small Coffee Medium Coffee Large Coffee Small Coffee Medium Coffee Large Coffee Small Coffee Medium Coffee 2045 1689 922 2065 1751 901 2057 1008 868 2032 1698 Week 3 Week 4 A HP 2. 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. a. 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 ANSFER Medium Cup- $.09 ESSERE Large Cup - $.11 HREFERESSERE TRE Coffee cost for each Cup Size 1/64 lb. of Coffee (Small) - $.11 2/64 lb. of Coffee (Medium) - $.22 ER 3/64 lb. of Coffee (Large) - $.33 3. 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. a. Hint: This is where you have to use your average cup sales to determine your average cost of goods sold. No new data required. BERNER TENERE RRRRRRR AFTER SEVER