IMA Case Study Snowies Shaved Ice Excel Template AutoSave L Search Nicc File Home Insert Draw Page Layout Formulas Data Review View Help A12 C D E F G H 1 Part 2 3 Data (all from Part 1 except for new selling price and cup cost) 4 Selling price per large Snowie 3.00 6 Ice per Snowie 7 Spoon straw (need one per Snowie) 8 Styrofoam cup (need one per Snowie) 9 Napkin (need two per Snowie) 10 Syrup cost per Snowie (from Part 1, Question 2) 11 0.2000 0.0200 $ (zero because supplied by Kent Oktoberfest) 0.0200 (fill in this value from your work in Part 1) Total variable cost per Snowie 3 Data (all from Part 1 except for new selling price and cup cost) 4 Selling price per large Snowie 0.2400 $ 3.00 5 6 Ice per Snowie 7 Spoon straw (need one per Snowie) 8 Styrofoam cup (need one per Snowie) 9 Napkin (need two per Snowie) 10 Syrup cost per Snowie (from Part 1, Question 2) 11 $ 0.2000 0.0200 $ (zero because supplied by Kent Oktoberfest) $ 0.0200 (fill in this value from your work in Part 1) Total variable cost per Snowie 0.2400 12 3 4 Do you accept Main Street Kent's special price offer? 5 Try calcluating the revenue expected from the event and the contribution margin as support for your answer. Part 1 Part 2 Part 3 dy Circular References Type here to search O e 12 IMA Case Study Snowies Shaved Ice Excel Template AutoSave L Search Nicc File Home Insert Draw Page Layout Formulas Data Review View Help A12 C D E F G H 1 Part 2 3 Data (all from Part 1 except for new selling price and cup cost) 4 Selling price per large Snowie 3.00 6 Ice per Snowie 7 Spoon straw (need one per Snowie) 8 Styrofoam cup (need one per Snowie) 9 Napkin (need two per Snowie) 10 Syrup cost per Snowie (from Part 1, Question 2) 11 0.2000 0.0200 $ (zero because supplied by Kent Oktoberfest) 0.0200 (fill in this value from your work in Part 1) Total variable cost per Snowie 3 Data (all from Part 1 except for new selling price and cup cost) 4 Selling price per large Snowie 0.2400 $ 3.00 5 6 Ice per Snowie 7 Spoon straw (need one per Snowie) 8 Styrofoam cup (need one per Snowie) 9 Napkin (need two per Snowie) 10 Syrup cost per Snowie (from Part 1, Question 2) 11 $ 0.2000 0.0200 $ (zero because supplied by Kent Oktoberfest) $ 0.0200 (fill in this value from your work in Part 1) Total variable cost per Snowie 0.2400 12 3 4 Do you accept Main Street Kent's special price offer? 5 Try calcluating the revenue expected from the event and the contribution margin as support for your answer. Part 1 Part 2 Part 3 dy Circular References Type here to search O e 12