On the table is a notebook in which images appear with the ingredients you need to find them. After choosing recipe will be looking through the kitchen all the ingredients you need. If you're good you can choose toughest recipes. If cooking is not your thing I suggest you choose a simple recipe, gets its great omelet or banana bread. You have a choice of 10 delicious recipes. At first you should choose the recipe you want to cook. Pay us a like if you enjoyed our game and leave us a comment with your opinion about Dora. In this game, Dora will be with you and will tell you what to do. 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.In this game you have the opportunity to learn more food recipes and will have to give proof of skill to succeed in the kitchen to make a delicious dish. 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. Record all data on the spreadsheet as you go.
*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. Step 11: After the day ends, record the following on your spreadsheet: number of cups sold, number of potential customers. *Do not alter the cup price during the day. Step 10: Run the simulation game for the day. These items DO NOT get recorded on your spreadsheet. Step 9: Determine the amount of lemon, sugar, and ice you will use for your lemonade recipe. 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. Each day, check the weather forecast and average temperature. Format the appropriate columns to currency Game Play Step 6: Visit the game website, choose the 30 day simulation. Step 5: Format fonts and fills on your spreadsheet. The lemonade stand game can be found at: 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 32-for now no answers will appear. Transcribed image text: 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.
0 kommentar(er)
