Your task is to track all sales and sale expenses for a 30 day time period for your lemonade stand. Open the Word Doc below and follow the directions.

Spreadsheet Set up Net Step 1: Set up the page layout for landscape Set up column headings as shown Wrap all text in the column headings Type the numbers 1 to 30 in cells A3 to A32 D E F H Carolyn's Lemonade Stand Money Money Money Money Price Day Spent on spent on spend spend on Total charged Cups Potential Gross 2 Number cups lemons on sugarice Expenses per cup Sold Customers Profit Profit 3 1 $ 1.61 S 243 S 2.18 $ 2.07 S 8.29 $ 0.25 50 101 $12.50 $ 4.21 2 $ 1.58 $ 2.38 $ 1.60 $ 2.24 $ 7.80 $ 0.25 50 99 $12.50 $ 4.70 5 3ls 1.56 ls 0.50 ls 1.58 S 0.98 4.62 15 0.25 25 981 $ 6.25 $ 1.63 Step 2: Format title of spread sheet as shown Your name's lemonade stand Lemonade Stand Excel Project Your task is to track all sales and sale expenses for a 30 day time period for your lemonade stand. The lemonade stand game can be found at: http://www.coolmath-games.com/lemonade/ Merge A1 to ki Step 3: Turn on all borders for A2 to K32 Step 4: Create formulas for columns F,J,K Total expenses-add all expenses together Gross Profit-Number of cups sold * price charged per cup Net Profit-Gross profit - expenses Use auto fill to drag the formulas all the way down to row 32for now no answers will appear.... Step 5: Format fonts and fills on your spreadsheet. Format the appropriate columns to currency Game Play Step 6: Visit the game website, choose the 30 day simulation. Each day, check the weather forecast and average temperature. Make purchase selections for: cups, lemons, ice, sugar that you think you will need for that day Step 7: Record how much you spent on each item in your spreadsheet EVERY DAY! Step 8: Set the price you will charge per cup each day. Record this price in row G each day. Step 9: Determine the amount of lemon, sugar, and ice you will use for your lemonade recipe. These items DO NOT get recorded on your spreadsheet. Step 10: Run the simulation game for the day. *Do not alter the cup price during the day. Step 11: After the day ends, record the following on your spreadsheet: number of cups sold, number of potential customers. *The game will not give you values for Columns F, J, K-you have to write formulas for those 3 columns! Step 12: Run the simulation again for 29 more days. Record all data on the spreadsheet as you go. Graphing Step 13: Create the following 2 graphs of your lemonade stand data Graph #1--Line graph showing net profit each day Graph #2--Column graph showing comparison of potential customers vs. cups sold 340 Cups sold and Potential customers Net Profit of Carolyn's Lemonade Stand Step 14: Edit the fill colors for both graphs 120 $12.00 300 Step 15: Insert appropriate titles on both graphs 58.00 56.00 Cues Sold 54.00 252.00 13513151719 21 23 2729 562.000 4.000 58.00 Ow Number 16 7 10 13 16 19 22 25 Spreadsheet Set up Net Step 1: Set up the page layout for landscape Set up column headings as shown Wrap all text in the column headings Type the numbers 1 to 30 in cells A3 to A32 D E F H Carolyn's Lemonade Stand Money Money Money Money Price Day Spent on spent on spend spend on Total charged Cups Potential Gross 2 Number cups lemons on sugarice Expenses per cup Sold Customers Profit Profit 3 1 $ 1.61 S 243 S 2.18 $ 2.07 S 8.29 $ 0.25 50 101 $12.50 $ 4.21 2 $ 1.58 $ 2.38 $ 1.60 $ 2.24 $ 7.80 $ 0.25 50 99 $12.50 $ 4.70 5 3ls 1.56 ls 0.50 ls 1.58 S 0.98 4.62 15 0.25 25 981 $ 6.25 $ 1.63 Step 2: Format title of spread sheet as shown Your name's lemonade stand Lemonade Stand Excel Project Your task is to track all sales and sale expenses for a 30 day time period for your lemonade stand. The lemonade stand game can be found at: http://www.coolmath-games.com/lemonade/ Merge A1 to ki Step 3: Turn on all borders for A2 to K32 Step 4: Create formulas for columns F,J,K Total expenses-add all expenses together Gross Profit-Number of cups sold * price charged per cup Net Profit-Gross profit - expenses Use auto fill to drag the formulas all the way down to row 32for now no answers will appear.... Step 5: Format fonts and fills on your spreadsheet. Format the appropriate columns to currency Game Play Step 6: Visit the game website, choose the 30 day simulation. Each day, check the weather forecast and average temperature. Make purchase selections for: cups, lemons, ice, sugar that you think you will need for that day Step 7: Record how much you spent on each item in your spreadsheet EVERY DAY! Step 8: Set the price you will charge per cup each day. Record this price in row G each day. Step 9: Determine the amount of lemon, sugar, and ice you will use for your lemonade recipe. These items DO NOT get recorded on your spreadsheet. Step 10: Run the simulation game for the day. *Do not alter the cup price during the day. Step 11: After the day ends, record the following on your spreadsheet: number of cups sold, number of potential customers. *The game will not give you values for Columns F, J, K-you have to write formulas for those 3 columns! Step 12: Run the simulation again for 29 more days. Record all data on the spreadsheet as you go. Graphing Step 13: Create the following 2 graphs of your lemonade stand data Graph #1--Line graph showing net profit each day Graph #2--Column graph showing comparison of potential customers vs. cups sold 340 Cups sold and Potential customers Net Profit of Carolyn's Lemonade Stand Step 14: Edit the fill colors for both graphs 120 $12.00 300 Step 15: Insert appropriate titles on both graphs 58.00 56.00 Cues Sold 54.00 252.00 13513151719 21 23 2729 562.000 4.000 58.00 Ow Number 16 7 10 13 16 19 22 25