Lemonade+Stand


 * Thing 13: Lucrative Lemonade **

** Student Activity **

In this Quest, your data collection will come from your work at the Lucrative Lemonade Stand. Depending on the weather and customer preferences, the company will either gain or lose money. The owner of the company has contacted your teacher and requested a student to investigate the operations. You will have **14 days at the company** to try to make as much profit as possible. Be careful because you can lose everything. You must record all of your data and conditions in a spreadsheet and analyze the data over the 14 days of work. Your teacher will be watching for your report at the end of this activity.

** Steps: ** =**Use the link below to access your data collection sh**eet=

Link to Excel Lucrative lemonade data collection sheet

2. Go to the Lemonade Stand website. You will be doing a 14 day simulation. (*Your computer will need the java plugin installed. You may have to click on a link to allow it to run, if it doesn’t work please inform your teacher.) ** Hint: ** On the bottom right is a Fast Forward button. This will make your days go by quicker. It is recommend that you use this function so you can finish all 14 days before the end of class. 3. Notice you start with $20. Your goal is to make more money than you started with. However, in order to make money, you’ll have to spend some money. In this game, you’ll decide **how many lemons, cups of sugar, and ice cubes to use per cup of lemonade**. Also, you’ll have to buy the right amounts of each, plus cups. //Don’t forget, though, your ice will always melt by the end of the day, bugs can get in your sugar, and lemons will spoil.// So, now buy all of your supplies in what you predict to be the “right” amount for the day.

4. Next, on your information sheet, write down the **temperature and the weather forecast**. This will be important when deciding how to mix your lemonade for the day.

5. Now it’s time to set up your recipe.

=
6. On the next screen, choose how much to charge for each cup of lemonade. You need to make enough money per cup to cover your expenses, but don’t make it so expensive that people won’t buy it. (Hint…you can add up what you spent on your spreadsheet for the day to help decide how much to charge.) Also, do not change your price during the day as it will not show in your data. ======

=
9. Repeat these steps for days 2-14, buying supplies, mixing your lemonade, and recording your results. Between each day’s sales is where you can make changes to your recipe or price but be sure to record each day on your spreadsheet. When you have completed all 14 days then it is time to analyze the data. If you have been working on a paper collection sheet be sure to input everything into your spreadsheet. ======

10. Highlight the daily balance column and click the insert tab to begin making your **line graph that shows the change over 14 days**.

=** 11. Customize your graph with a chart title and axes labels. Remember that your starting amount was $20.00 and your goal was to make a profit. **= =** 12. Answer the following questions in a //Word Processing// program: **=
 * 1) **// 1. //** **// How often did you profit? Would you recommend this company to continue sales or shut down its business according to your profit? //**


 * 1) **// 2. //** **// Did you go bankrupt and have to start over? What happened? What would the line graph look like for a bankruptcy //**


 * 1) **// 3. //** **// How often did you change your recipe? Describe how and why you changed it. //**


 * 1) **// 4. //** **// What was the average price you charged for your lemonade? (Do not forget about functions in your Excel program.) //**
 * 2) **// 5. //** **// Describe your overall sales trend over the 14 days. Was it mostly increasing, decreasing or a constant change daily? //**
 * 1) **// 5. //** **// Describe your overall sales trend over the 14 days. Was it mostly increasing, decreasing or a constant change daily? //**

** Completing this Quest **

To complete this Quest, Save your report in 8th Grade Tech/Lemonade/Coffee