answer question 1-8 please and show formula plese i need it to understand it in excel
AutoSave Off H2 IMA Case Study - Snowies Shaved Ice Excel Template (1) - Excel Search olayerao78 X File Home Insert Page Layout Formulas Data Review View Help Share Comments G8 X fx Per Item B B E F G H | 1 2 Amount Notes Data Selling price per large Snowie 3 $ 4.00 Per Item 4 Requirements 1. Assumptions (set by the instructor for the case): a. Number of days you anticipate opening the kiosk per month b. Number of hours you will work (no wages required) per day c. Number of hours you will pay an employee to work in the kiosk per day 8 5 4 0.20 Per Item Per Item 6 6 0.02 0.08 7 $ Per Item Ice per Snowie $ Spoon straw (need one per Snowie) $ Styrofoam cup (need one per Snowie) Napkin (need two per Snowie) $ Servings per gallon of syrup Cost per gallon of syrup (concentrate, preservative, and sugar) $ 8 Per Item 2. Cost of syrup per Snowie (use four decimal places): Formula required in cell C9 Example: Cost per gallon / Servings per gallon 0.01 28 9 Per Gallon Per Gallon 10 4.25 11 12 13 14 3. Cost of worker wages per day and month: Worker wages per day; formula required in cell C13 Hourly rate for workers $ Event registration fee per day $ Electricity, insurance, maintenance, and permit costs per month $ Kiosk rental cost per month $ Purchase cost of two ice shavers combined (5-year life) $ Purchase cost of a flavor station (5-year life) $ Worker wages per month; formula required in cell C15 10.00 Per Hour 25.00 Per Day 250.00 Per Month 650.00 Per Month 3,180.00 Depreciable 1,080.00 Depreciable 15 16 17 18 4. Total variable cost per Snowie (include supplies and syrup): List variable item(s) and use a formula to retrieve and/or calculate values 19 20 21 22 Examples of Formulas in Cells Click on F21 - this is a formula $ 40.00 earn points Click on F22 - this is a formula $ 40.00 earn points Click on F23 - this is not a formula $ 40.00 no points 23 24 25 Total variable cost per Snowie $0.0000 26 27 5. Total fixed cost per month (convert as necessary to monthly) Part 1 Ready 3 + 100% Type here to search O jt .' a W C ENG 11:02 30/09/2020 6 AutoSave Off H2 IMA Case Study - Snowies Shaved Ice Excel Template (1) - Excel Search olayerao78 X File Home Insert Page Layout Formulas Data Review View Help Share Comments G8 X fx Per Item B B E F G H 1 2 Amount Notes Data Selling price per large Snowie 3 $ 4.00 Per Item 4 Requirements 1. Assumptions (set by the instructor for the case): a. Number of days you anticipate opening the kiosk per month b. Number of hours you will work (no wages required) per day c. Number of hours you will pay an employee to work in the kiosk per day 8 5 4 0.20 Per Item Per Item 6 6 0.02 0.08 7 $ Per Item Ice per Snowie $ Spoon straw (need one per Snowie) $ Styrofoam cup (need one per Snowie) Napkin (need two per Snowie) $ Servings per gallon of syrup Cost per gallon of syrup (concentrate, preservative, and sugar) $ 8 Per Item 2. Cost of syrup per Snowie (use four decimal places): Formula required in cell C9 Example: Cost per gallon / Servings per gallon 0.01 28 9 Per Gallon Per Gallon 10 4.25 11 12 13 14 3. Cost of worker wages per day and month: Worker wages per day; formula required in cell C13 10.00 Per Hour 25.00 Per Day 250.00 Per Month 650.00 Per Month 3,180.00 Depreciable 1,080.00 Depreciable 15 Hourly rate for workers $ Event registration fee per day $ Electricity, insurance, maintenance, and permit costs per month $ Kiosk rental cost per month $ Purchase cost of two ice shavers combined (5-year life) $ Purchase cost of a flavor station (5-year life) $ Worker wages per month; formula required in cell C15 16 17 27 28 29 30 5. Total fixed cost per month (convert as necessary to monthly) List fixed item(s) and use a formula to retrieve and/or calculate values 31 32 33 34 Total fixed cost per month 35 36 6. Break-even volume (i.e. units) per month Part 1 Ready 3 + 100% Type here to search i a W C ENG 11:02 30/09/2020 6 AutoSave Off H2 IMA Case Study - Snowies Shaved Ice Excel Template (1) - Excel Search olayerao78 X File Home Insert Page Layout Formulas Data Review View Help Share Comments G8 X fx Per Item B B E F G H 1 2 Amount Notes Data Selling price per large Snowie 3 $ 4.00 Per Item 4 Requirements 1. Assumptions (set by the instructor for the case): a. Number of days you anticipate opening the kiosk per month b. Number of hours you will work (no wages required) per day c. Number of hours you will pay an employee to work in the kiosk per day 8 5 4 0.20 Per Item Per Item 6 6 0.02 0.08 7 $ Per Item Ice per Snowie $ Spoon straw (need one per Snowie) $ Styrofoam cup (need one per Snowie) Napkin (need two per Snowie) $ Servings per gallon of syrup Cost per gallon of syrup (concentrate, preservative, and sugar) $ 8 Per Item 2. Cost of syrup per Snowie (use four decimal places): Formula required in cell C9 Example: Cost per gallon / Servings per gallon 0.01 28 9 Per Gallon Per Gallon 10 4.25 11 12 13 14 3. Cost of worker wages per day and month: Worker wages per day; formula required in cell C13 Hourly rate for workers $ Event registration fee per day $ Electricity, insurance, maintenance, and permit costs per month $ Kiosk rental cost per month $ Purchase cost of two ice shavers combined (5-year life) $ Purchase cost of a flavor station (5-year life) $ 10.00 Per Hour 25.00 Per Day 250.00 Per Month 650.00 Per Month 3,180.00 Depreciable 1,080.00 Depreciable 15 Worker wages per month; formula required in cell C15 16 17 36 37 38 39 40 6. Break-even volume (i.e. units) per month Contribution margin per unit = (price per unit - variable cost per unit) Break-even point formula is in Cost-Volume-Profit chapter of the textbook Round up to a whole value 7. Number of Snowies to be sold to earn target profit of $2,000 per month Target income formula is in Cost-Volume-Profit chapter of the textbook Round up to a whole value 41 42 43 44 45 8. Think about the break-even and target profit quantities. Are these quantities realistic (try calculating how many Snowies per day and/or per hour must be sold as a reference point). Number of Snowies to be sold per day Number of Snowies to be sold per hour Part 1 Ready 3 + 100% Type here to search o ir a W C ENG 11:03 30/09/2020 6 AutoSave Off H2 IMA Case Study - Snowies Shaved Ice Excel Template (1) - Excel Search olayerao78 X File Home Insert Page Layout Formulas Data Review View Help Share Comments G8 X fx Per Item B B E F G H | 1 2 Amount Notes Data Selling price per large Snowie 3 $ 4.00 Per Item 4 Requirements 1. Assumptions (set by the instructor for the case): a. Number of days you anticipate opening the kiosk per month b. Number of hours you will work (no wages required) per day c. Number of hours you will pay an employee to work in the kiosk per day 8 5 4 0.20 Per Item Per Item 6 6 0.02 0.08 7 $ Per Item Ice per Snowie $ Spoon straw (need one per Snowie) $ Styrofoam cup (need one per Snowie) Napkin (need two per Snowie) $ Servings per gallon of syrup Cost per gallon of syrup (concentrate, preservative, and sugar) $ 8 Per Item 2. Cost of syrup per Snowie (use four decimal places): Formula required in cell C9 Example: Cost per gallon / Servings per gallon 0.01 28 9 Per Gallon Per Gallon 10 4.25 11 12 13 14 3. Cost of worker wages per day and month: Worker wages per day; formula required in cell C13 Hourly rate for workers $ Event registration fee per day $ Electricity, insurance, maintenance, and permit costs per month $ Kiosk rental cost per month $ Purchase cost of two ice shavers combined (5-year life) $ Purchase cost of a flavor station (5-year life) $ Worker wages per month; formula required in cell C15 10.00 Per Hour 25.00 Per Day 250.00 Per Month 650.00 Per Month 3,180.00 Depreciable 1,080.00 Depreciable 15 16 17 18 4. Total variable cost per Snowie (include supplies and syrup): List variable item(s) and use a formula to retrieve and/or calculate values 19 20 21 22 Examples of Formulas in Cells Click on F21 - this is a formula $ 40.00 earn points Click on F22 - this is a formula $ 40.00 earn points Click on F23 - this is not a formula $ 40.00 no points 23 24 25 Total variable cost per Snowie $0.0000 26 27 5. Total fixed cost per month (convert as necessary to monthly) Part 1 Ready 3 + 100% Type here to search O jt .' a W C ENG 11:02 30/09/2020 6 AutoSave Off H2 IMA Case Study - Snowies Shaved Ice Excel Template (1) - Excel Search olayerao78 X File Home Insert Page Layout Formulas Data Review View Help Share Comments G8 X fx Per Item B B E F G H 1 2 Amount Notes Data Selling price per large Snowie 3 $ 4.00 Per Item 4 Requirements 1. Assumptions (set by the instructor for the case): a. Number of days you anticipate opening the kiosk per month b. Number of hours you will work (no wages required) per day c. Number of hours you will pay an employee to work in the kiosk per day 8 5 4 0.20 Per Item Per Item 6 6 0.02 0.08 7 $ Per Item Ice per Snowie $ Spoon straw (need one per Snowie) $ Styrofoam cup (need one per Snowie) Napkin (need two per Snowie) $ Servings per gallon of syrup Cost per gallon of syrup (concentrate, preservative, and sugar) $ 8 Per Item 2. Cost of syrup per Snowie (use four decimal places): Formula required in cell C9 Example: Cost per gallon / Servings per gallon 0.01 28 9 Per Gallon Per Gallon 10 4.25 11 12 13 14 3. Cost of worker wages per day and month: Worker wages per day; formula required in cell C13 10.00 Per Hour 25.00 Per Day 250.00 Per Month 650.00 Per Month 3,180.00 Depreciable 1,080.00 Depreciable 15 Hourly rate for workers $ Event registration fee per day $ Electricity, insurance, maintenance, and permit costs per month $ Kiosk rental cost per month $ Purchase cost of two ice shavers combined (5-year life) $ Purchase cost of a flavor station (5-year life) $ Worker wages per month; formula required in cell C15 16 17 27 28 29 30 5. Total fixed cost per month (convert as necessary to monthly) List fixed item(s) and use a formula to retrieve and/or calculate values 31 32 33 34 Total fixed cost per month 35 36 6. Break-even volume (i.e. units) per month Part 1 Ready 3 + 100% Type here to search i a W C ENG 11:02 30/09/2020 6 AutoSave Off H2 IMA Case Study - Snowies Shaved Ice Excel Template (1) - Excel Search olayerao78 X File Home Insert Page Layout Formulas Data Review View Help Share Comments G8 X fx Per Item B B E F G H 1 2 Amount Notes Data Selling price per large Snowie 3 $ 4.00 Per Item 4 Requirements 1. Assumptions (set by the instructor for the case): a. Number of days you anticipate opening the kiosk per month b. Number of hours you will work (no wages required) per day c. Number of hours you will pay an employee to work in the kiosk per day 8 5 4 0.20 Per Item Per Item 6 6 0.02 0.08 7 $ Per Item Ice per Snowie $ Spoon straw (need one per Snowie) $ Styrofoam cup (need one per Snowie) Napkin (need two per Snowie) $ Servings per gallon of syrup Cost per gallon of syrup (concentrate, preservative, and sugar) $ 8 Per Item 2. Cost of syrup per Snowie (use four decimal places): Formula required in cell C9 Example: Cost per gallon / Servings per gallon 0.01 28 9 Per Gallon Per Gallon 10 4.25 11 12 13 14 3. Cost of worker wages per day and month: Worker wages per day; formula required in cell C13 Hourly rate for workers $ Event registration fee per day $ Electricity, insurance, maintenance, and permit costs per month $ Kiosk rental cost per month $ Purchase cost of two ice shavers combined (5-year life) $ Purchase cost of a flavor station (5-year life) $ 10.00 Per Hour 25.00 Per Day 250.00 Per Month 650.00 Per Month 3,180.00 Depreciable 1,080.00 Depreciable 15 Worker wages per month; formula required in cell C15 16 17 36 37 38 39 40 6. Break-even volume (i.e. units) per month Contribution margin per unit = (price per unit - variable cost per unit) Break-even point formula is in Cost-Volume-Profit chapter of the textbook Round up to a whole value 7. Number of Snowies to be sold to earn target profit of $2,000 per month Target income formula is in Cost-Volume-Profit chapter of the textbook Round up to a whole value 41 42 43 44 45 8. Think about the break-even and target profit quantities. Are these quantities realistic (try calculating how many Snowies per day and/or per hour must be sold as a reference point). Number of Snowies to be sold per day Number of Snowies to be sold per hour Part 1 Ready 3 + 100% Type here to search o ir a W C ENG 11:03 30/09/2020 6
