V187 Price by Cup Size (use Week 9 Prices) New Cup Prices by Size Small Small 5% increase 10% increase 15% increase JS 0.13 $ 0.27 $ 0.40 S 0 .17 S 0.35 $ 0.52 $ 0.21 $ 0.43 $ 0.54 Medium 2.65 3.45...

V187 Price by Cup Size (use Week 9 Prices) New Cup Prices by Size Small Small 5% increase 10% increase 15% increase JS 0.13 $ 0.27 $ 0.40 S 0 .17 S 0.35 $ 0.52 $ 0.21 $ 0.43 $ 0.54 Medium 2.65 3.45 4.25 $ $ Large Large O 1,679 O 959 735 291 Customer Response to Coffee Price C5% increase No change 87% Reduce purchases by 30% per week 12 Go to another café . 1 Cost of Goods Sold (GOGS) Cost of each Cup Small Cup Medium Cup Large Cup 956 53 54 Coffee Sales by Cup for Six Weeks 55 Week 1 Smal Coffee Medium Coffee Large Coffee 58 Week 5 Small Caffee Medium Coffee Large Coffee Small Coffre Medium Coffee Large Coffee Small Coffee Medium Coffee Large Coffee 67 Week 8 Sl Coffee Medium Coffee Large Coffee 70 Week 9 Small Coffee Medium Coffee Large Coffee 10% increase 15% increase 79% 68% 18 22% 3 1 09 0.08 0.09 0.10 729 285 890 $ 667 Cost of Coffee per pound Most Recent (Decision (91 259 $ 7.00 New Cost of Coffee per pound after Supplier increase New price per pound (4% increase per pound) New price per pound (4% increase per pound) 873 7.28 619 251 785 593 230 0.12 Coffee cost for each Cup Size 1/64 lb. or.016 lbs. of Coffee (Small) 2/64 b or 032 lbs. of Coffee (Medium) 3/64 lb. or.048 lbs. of Coffee Large New Coffee cost for each Cup Size 1/64 lb. or.016 lbs. of Coffee Small) 2/64 lb. or.032 lbs. of Coffee (Medium) 3/64 Ib.or.048 lbs. of Coffee Large 0.35 74 To Complete the tasks you need to use functions/create formuals and reference the cells above when completing the tasks. 75 Getting you started: In Cell 882 you should use the average Function and reference the cellls with "Coffee Sales by Cup for Six Weeks" 76 Getting you started: In Cell CS2 you should reference cell F55 (will not lose points if you type in the value of F55). 77 78 Task 1 79 What is your average weekly revenue from Week 4 to Week 9? 80 81 Cups Size Average Weekly Sales Price Per Cuo Weekly Revenue 82 Small Coffee 2.65 83 Medium Coffee 3.45 84 Large Coffee 85 Total Weekly Rewenue using six week average sales 86 87 88 Task 2 4.25 Total Cost of Goods Sold 90 What is your average weeldy cost of goods sold? 91 Cups Size Average Weekly Sales frc COGS per Cup 92 Small Coffee 99 Medium Coffee 94 Large Coffor 95 Total Weeky COGS using six week average 97 Task 3 98 what is your avenge wody gross profit? 100 Total Revenue fron Total Cost of Goods Sol Average Wendly Gross Profit 101 102 103 Task 4 104 What is your weekly gross profit for a large cup of coffee after raising the price? 105 New Price Per Cup Averare Weekly for New Averare Weekly Sales ap New Revenue COGS per Cup New COGS Sold New Gross Profit 106 Price Increase Old Price per Cup 107 1998 108 15% 110 Task 5 111 Your coffee supplier has increased their coffee price by 4% per pound what is new coffee cost for a large cup of coffee? 112 113 Coffee Cost Per Pc Price increase New Coffee Cost P Amount of coffee New Cost of Coffee for a large Cup 114 115 116 5% increase 10% increase 15% increase Price by Cup Size (use Week 9 Prices) Small Medium Large New Cup Prices by Size Small Medium Large Coffee Sales by Cup for Six Weeks Week 4 Small Coffee Medium Coffee Large Coffee Week 5 Small Coffee Medium Coffee Large Coffee Week 6 Small Coffee Medium Coffee Large Coffee Week 7 Small Coffee Medium Coffee Taree Coffee Week 8 Small Coffee Medium Coffee Large Coffee Week 9 Small Coffee Medium Coffee large Coffee Cost of Goods Sold (GOGS) Cost of each Cup Small Cup Medium Cup Large Cup Customer Response to Coffee Pric 5% increase 10% increase 15% increase No change 879579946896 Reduce purchases by 30% per weet 12% 22% 2296 Go to another café 193 % 10% Cost of Coffee per pound Most Recent (Decision (9) New Cost of Coffee per pound after Supplier Increase New price per pound (4% increase per pound) New price per pound (4% increase per pound) Coffee cost for each Cup Size 1/64 lb. or .016 lbs. of Coffee (Small) 2/64 lb. or.032 lbs. of Coffee (Medium) 3/64 lb. or.048 lbs. of Coffee (Large) New Coffee cost for each Cup Size 1/64 lb. or .016 lbs. of Coffee (Small) 2/64 lb. or.032 lbs. of Coffee (Medium) 3/64 lb. or.048 lbs. of Coffee (Large) To Complete the tasks you need to use functions/create formuals and reference the cells above when completing the tasks. Getting you started: In Cell B82 you should use the Average Function and reference the cellls withn" Coffee Sales by Cup for Six Weeks" Getting you started: In Cell C82 you should reference cell F55 (will not lose points if you type in the value of F55). Task 1 What is your average weekly revenue from Week 4 to Week 9? Weekly Revenue Cups Size Average Weekly Sales Price Per Cup Small Coffee Medium Coffee Large Coffee Total Weekly Revenue using six week average sales Task 2 What is your average weekly cost of goods sold? Cups Size Average Weekly Sales COGS per Cup Total Cost of Goods Sold Small Coffee Medium Coffee Large Coffee Total Weekly COGS using six week average Task 3 What is your average weekly gross profit? Total Revenue frc Total Cost of Goods So Average Weekly Gross Profit What is your weekly gross profit for a large cup of coffee after raising the price? Price Increase 5% Old Price per Cup New Price Per Cup Average Weekly ft New Average Weekly Sales: New Revenue COGS per Cup New COGS Sold New Gross Profit 15% Task 5 Your coffee supplier has increased their coffee price by 4% per pound what is new coffee cost for a large cup of coffee? Coffee Cost Per P Price increase New Coffee Cost Famount of coffee New Cost of Coffee for a Large Cup Price by Cup Size (use Week 9 Prices) Small Medium Large $ 2.65 3.45 4.25 1,679 0 959 735 291 956 729 53 54 Coffee Sales by Cup for Six Weeks 55 Week 4 Small Coffee Medium Coffee Large Coffee 58 Week 5 Small Coffee Medium Coffee Large Coffee 51 Week 6 Small Coffee Medium Coffee Large Coffee 54 Week 7 Small Coffee Medium Coffee Large Coffee 57 Week 8 Small Coffee Medium Coffee Large Coffee 70 Week 9 Small Coffee Medium Coffee Large Coffee Cost of Goods Sold (GOGS) Cost of each Cup Small Cup Medium Cup Large Cup 0.08 0.09 0.10 285 890 667 259 Cost of Coffee per pound Most Recent (Decision (9) $ 7.00! 873 619 251 785 593 Coffee cost for each Cup Size 1/64 lb. or .016 lbs. of Coffee (Small) 2/64 lb. or.032 lbs. of Coffee (Medium) 3/64 lb. or.048 lbs. of Coffee (Large) $ $ $ 0.11 0.22 0.34 230 74 To Compltete the tasks you need to use functions/create formuals and reference the cells above when completing the tasks. 25 Getting you started: In Cell B82 you should use the Average Function and reference the cellls withn" Coffee Sales by Cup for Six Weeks" 76 Getting you started: In Cell C82 you should reference cell F55 (will not lose points if you type in the value of F55). >> 78 Task 1 70 Nbati Moravakbonfronto Atalo