Lemonade Business
- Computer
- Senior

- Activity Time
- Materials
- Concepts / Topics
Learners play a 25-day lemonade stand simulation, record its data, build Excel spreadsheets, an income statement and charts, then create and present a PowerPoint report to classmates.
Lemonade Stand
Time allowed: 3–4 weeks. This includes watching and evaluating other students’ presentations as well as giving your own. Presentations are estimated to take 3–5 days, allowing one practice run for each student.
Objective
To learn to use all features of Microsoft Excel and Microsoft PowerPoint to create charts and graphs and use them in a PowerPoint presentation on your lemonade stand’s profit or loss for the month.
Use the information generated while playing Lemonade Stand to create an income statement in Excel for use in the PowerPoint presentation.
Basic Directions
- Go to www.littlejason.com and play the lemonade game on the Internet for the full 25 days. Record all data on the chart provided. You may work with a class member: they can help you record the data you need on the first day, and you can help them record data on the second day.
- Use the recorded data to create graphs and charts in Excel.
- Create a basic income statement in Excel.
- Create an INTERESTING PowerPoint presentation incorporating the graphs and charts along with pictures, sounds, etc. Report to your Board of Directors on the month’s profits or losses.
- Use PowerPoint to print your slides with notes for your presentation.
- Use PowerPoint to create handouts with three slides per page so your board can take notes while you present.
- Give your presentation to the board (4–5 class members).
Specific Directions
1. Excel Spreadsheet
Enter the data from the highlighted columns into an Excel spreadsheet. The Temperature column is optional, depending on which graph you choose from the third list of graphs.
Use the SUM function (or Sigma button) to total Advertising, Total Expense, Revenue, Cup Expense, and Profit. Use the AVERAGE function to calculate average Cost per Cup and Price per Cup.
- Print the spreadsheet once as it is.
- Print it once with the formulas showing. Go to [Tools], then [Options], and check the box in front of [View Formulas]. Use Print Preview to make sure it is one page.
2. Income Statement
Create an income statement that looks like the following. Use the directions given to put the numbers into the income statement.
- Print the income statement once as it is.
- Print it once with the formulas showing. Go to [Tools], then [Options], and check the box in front of [View Formulas]. Use Print Preview to make sure it is one page.
Jason’s Lemonade Stand Income Statement February 28, 2000
| Revenue | $205.35 |
| Expenses | |
| Cost of Lemonade | $51.98 |
| Rent Expense | $18.75 |
| Advertising Expense | $93.00 |
| Total Expenses | $163.73 |
| Net Profit | $41.62 |
3. Graphs to Make
Make all of these:
- Grand Total Revenue, Grand Total Profit, and Grand Total Expense (bar, column, or a similar graph).
- Average cost per cup compared with average selling price per cup (bar, column, or a similar graph).
- Total rainy days compared with total sunny days (pie graph).
Make at least two of these four:
- Daily Revenue compared with Daily Expenses (line graph).
- Daily Profit compared with Daily Expenses (stacked bar or column graph).
- Daily Revenue compared with Daily Advertising (line graph).
- Daily Profit compared with Daily Advertising (stacked bar or column graph).
Make at least one of these as a line graph:
- Temperature.
- Cups made compared with cups sold.
- Cost per cup compared with selling price per cup.
No two graphs should be the same kind. Some should have data labels and some should include the data table, but do not put both on the same graph.
4. PowerPoint Presentation
Create a PowerPoint presentation and present it to part of the class.
- Include a minimum of 12 slides.
- Use one graph on each of seven slides.
- Put the income statement on one slide, probably one of the last slides.
- Use animation on over half of all parts of the show.
- Use slide transitions on at least half of the slides.
- Use a background design, but change it on two slides to a texture, color, or another background without the design showing.
- Type presentation notes in the show and print them for use during your presentation.
- Print handouts with three slides per page so your board can take notes.
- Put your slides in a good order so the information flows together and does not jump around.
- Practice the presentation.
- Use action buttons so you can go back to a slide if you want.
- Hide one slide and hyperlink to and from it with an action button.
- Create a Custom Show with just half of your slides.
- Do not set the timing. You will move from slide to slide with the mouse as you talk.
Requirements and Points
Name ___________
Data, Spreadsheet, Income Statement, and Graphs
| Requirement | Points Available | Points Earned |
|---|---|---|
| Data kept while playing: all grids are filled in. | 25 | |
| Excel spreadsheet: all required columns included — 9; totals calculated for required categories — 7; averages calculated for required categories — 2; printed on one full sheet — 2; printed with formulas — 5. | 25 | |
| Income statement: good format — 5; numbers are linked — 4; Total Expenses formula — 1; Net Profit formula — 1; date in correct format — 1; correct use of borders — 3. | 15 | |
| Graph 1: correct kind for data displayed — 2; altered so it looks good — 4; labeled properly so the information presented is easy to understand — 4; readable labels — 4. | 15 | |
| Graph 2: correct kind for data displayed — 2; altered so it looks good — 4; labeled properly so the information presented is easy to understand — 4; readable labels — 4. | 15 | |
| Graph 3: correct kind for data displayed — 2; altered so it looks good — 4; labeled properly so the information presented is easy to understand — 4; readable labels — 4. | 15 | |
| Graph 4: correct kind for data displayed — 2; altered so it looks good — 4; labeled properly so the information presented is easy to understand — 4; readable labels — 4. | 15 | |
| Graph 5: correct kind for data displayed — 2; altered so it looks good — 4; labeled properly so the information presented is easy to understand — 4; readable labels — 4. | 15 | |
| Graph 6: correct kind for data displayed — 2; altered so it looks good — 4; labeled properly so the information presented is easy to understand — 4; readable labels — 4. | 15 | |
| Graphs are basically all different, with at least one with data labels and one with the data chart. | 10 | |
| TOTAL | 165 |
PowerPoint Presentation
| Requirement | Points Available | Points Earned |
|---|---|---|
| 12 slides minimum. | 24 | |
| Graphs used on slides. | 14 | |
| Income statement on a slide. | 2 | |
| Animation used on over half of all elements. | 10 | |
| Slide transitions used on at least half of the slides. | 12 | |
| Design used on some slides but changed to a plain background on at least two. | 4 | |
| Presentation notes written for each slide. | 24 | |
| Handouts printed with three slides per page. | 6 | |
| Information presented in a good order. | 10 | |
| One slide is hidden. | 2 | |
| Hyperlink with an action button from one slide to the hidden slide and then back to the original slide. | 4 | |
| Back action buttons on each slide except the first slide and the hidden slide. | 10 | |
| Create a Custom Slide Show (a smaller version of your presentation) with just half your slides. Just show me when done. | 8 | |
| Presentation given: few pauses, “and,” “ums,” “ahs,” etc. (10 or fewer); mouse used with little trouble. | 30 | |
| TOTAL POINTS | 160 |
Teachers.Net · https://teachers.net/lessons/1542.html