Your Lemonade Business

1. Your Lemonade Business Accounting II

2. Introduction • You will be running your own lemonade stand. • You will keep track of your data through out the month of business the stand is in operation on the computer. • Your goal is to maximize profit and minimize any losses for the month of operation. • You will use the information recorded to create charts, graphs and an income statement. • You will create a Power Point Presentation with all this information and give an oral presentation to the Board of Directors.

3. Process – Step 1 • Go to http://www.lemonadestands.com • You will play the lemonade game on the Internet for the full 30 days. • You will record all the data in the Spreadsheet provided. (See copy of Spreadsheet) • You can work with a class member and they can help you record all the data you need the first and you can help them record the second day. Go To Instructions for Step 1

4. Process – Step 2 • Utilize the data you recorded to create Graphs and Charts in Excel. Go To Instructions for Step 2

5. Process – Step 3 • Create a Basic Income Statement using Excel Go To Instructions for Step 3

6. Process – Step 4 • Create an INTERESTING Power Point presentation incorporating the graphs and charts along with pictures, sounds, etc. to give a report to your Board of Directors on the profits/loss of the month. Go To Instructions for Step 4

7. Process – Step 5 • Use Power Point to create printouts of your slides with notes for your presentation. Go To Instructions for Step 5

8. Process – Step 6 • Use Power Point to create handouts – 3 to a page for your board to take notes while you present. Go To Instructions for Step 6

9. Process – Step 7 • Give your presentation to the board (4-5 class members). Go To Instructions for Step 7

10. Grading Rubric for this Project: • Grading of Project will be based on these areas: • Recording Data • Graphs & Charts • Income Statement • Power Point Project • Presentation to Board Click here for detailed Rubric: RUBRIC

11. Instructions for Process - Step 1Recording Data • Type the data in the highlighted columns into an Excel Spreadsheet. • Use the SUM FUNCTION (or Sigma Button) to total the Profit/Loss Column. • Use the AVERAGE FUNCTION to calculate the average: • Price per Cup • Lemons per Pitcher • Sugar per Pitcher • Cubes per Pitcher • High Temperature • Print it once like it is • Print once with the formulas showing. To do this go to [Tools] then [Options] and check the box in front of [View Formulas]. Print preview to make sure it is on one page. Return to Process –Step 1

12. Instructions for Process – Step 2Graphs and Charts • Create Charts for each of these groups of information: • Grand Total Revenue – Grand Total Profit – Grand Total Expense (Use Bar or Column or something along that order) • Average Cost Per Cup to Average Selling Price Per Cup (Use Bar or Column or something along that order) • Total Rainy days to Total Sunny Days (Pie Graph) • Cups Sold compared to Potential Customers (Line Graph) • Cost per Cup to Selling Price Per Cup (Line Graph) • Daily Profit to Daily Expense (Stacked Bar or Column Graph) Return to Process –Step 2

13. Instructions for Process – Step 3Income Statement • Create an Income Statement that looks like the Example. (See Example) • Use the directions given to put the numbers into the Income Statement. • Print it once like it is. • Print once with the formulas showing. To do this go to [Tools] then [Options] and check the box in front of [View Formulas] Print preview to make sure it is on one page. Return to Process –Step 3

14. Instructions for Process – Step 4Power Point Presentation • You need a minimum of 12 slides • Use one graph on each of 7 slides • Put the income statement on one slide – probably on 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 or color or something without the design showing. (Directions Continued on Next Slide)

15. Instructions for Process – Step 4Power Point Presentation (Continued) • Type Presentation notes on the show and print for use during your presentation. • Print handouts with three slides per page for your board to take notes. • Put your slides in good order for the presentation so your 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. Return to Process –Step 4

16. Instructions for Process – Step 5Printing Slides with Notes • Type Presentation notes on the show and print for use during your presentation. • Print handouts with three slides per page for your board to take notes. Return to Process –Step 5

17. Instructions for Process – Step 6Create Handouts • Print handouts with three slides per page for your board to take notes. Return to Process –Step 6

18. Instructions for Process – Step 7Presentation to the Board • Print handouts with three slides per page for your board members to take notes. • Give presentation with a clear and direct message to your board members. Return to Process –Step 7