Lemonade Stand

1
Lemonade Stand
2
Game Instructions
3
Step 1 Open the Game

• Open Internet Explorer and go to the Web site
• http//www.coolmath-games.com/lemonade/

4
Step 2 Read Introduction

• Read the introduction to the game, and then click
  the OK button.

5
Step 3 Select 7 Days

• When asked How long would you like to play?
  select 7 Days.

6
Step 4 Gathering Information

• A lot of useful information is provided on the
  Inventory/Purchasing screen.

7
Step 4 Inventory

• The current inventory is listed.

8
Step 4 Money

• The amount of money
• you currently have is listed.

9
Step 4 Weather

• The Weather Forecast
• and
• High Temperature
• are listed.

10
Step 4 - Purchasing

• You can purchase supplies for your lemonade stand
  by clicking the Buy More buttons.

11
Step 5 Buy More Cups

• Clicking the Buy More Cups
• button brings up the
• Acquisition screen.

12
Step 5 Inventory

• Again you are told how
• many of the product you
• have, and how much
• money you have.

13
Step 5 Buying Options

• You are given options for
• how many of each supply
• to buy. Some are a better
• deal than others.

14
Step 5 Buy it!

• Click Buy it! To buy a supply.
• NOTE All sales are final, and you cannot take
  them back after purchasing.

15
Step 5 Stocking up

• When you have enough of a
• supply click OK.
• Stock up on any supplies
• you need.

16
Step 6 Pricing Information

• The Pricing/Quality Control screen allows you
• to adjust the price and quality of your lemonade.

17
Step 6 Price Control

• The higher the price, the less people who will be
  willing to pay to buy a cup.

18
Step 6 Quality Control

• The lower the quality, the less people who will
  be willing to pay to buy a cup.

19
Step 6 Starting the Game

• When you are happy with your price and quality,
  click OK to start the game.

20
Step 7 Playing the Game

• You can watch customers walk by, and order your
  lemonade.

21
Step 7 Speeding up Play

• Click the Fast Forward button to make time pass
  faster, and speed up play.

22
Step 7 Making Money

• Every time a customer buys a cup of lemonade your
  Money increases.

23
Step 8 End of Day Reports

• Information about income and sales for a day are
  shown on the End of Day Reports screen.

24
Step 8 Daily Sales

• The number of cups sold, and the number of
  potential customers are shown on this screen.

25
Step 8 Daily Popularity

• The Customer Satisfaction and Popularity ratings
  are shown as percentages.

26
Step 9 Inventory Losses

• Unused ice will be lost at the end of a day.
• Lemons and sugar can also be spoiled.

27
Step 10 Days 2-7

• Continue buying supplies and adjusting
  prices/quality for the next 6 days.

28
Step 11 End of Season Report

• The End of Season Report lists the Total Income,
  Total Expenses, and Net Profit/Losses.

29
The Assignment
30
Part 1 Record Data
31
Note
Make sure that you collect all of your data on
Thursday, so that you can spend Friday doing
calculations and making charts.
32
Step 1 Open Lemonade Stand.xls

• Open Lemonade Stand.xls found in
• S\wood\BTT1O\6 Spreadsheets

33
Step 2 Inventory Purchasing

• On the Inventory sheet of the spreadsheet, each
  day record
• Leftover Stock from the previous day

34
Step 3 Acquisition

• On the Expenses sheet of the spreadsheet record
  all purchases made, including
• Day
• Item

• Quantity
• Cost

35
Note
Make sure you pay attention and record ALL
purchases! It is very easy to forget one if not
paying close attention.
36
Step 4 Price/Quality Control

• On the Income sheet of the spreadsheet, each day
  record
• Price Per Cup
• Lemons Per Pitcher

• Sugar Per Pitcher
• Ice Per Cup

37
Step 4 Price/Quality Control

• On the Income sheet of the spreadsheet, each day
  record the following
• Temperature
• Weather Forecast

38
Step 5 End of Day Report

• On the Income sheet of the spreadsheet, each day
  record
• Cups Sold
• Potential Customers

• Customer Satisfaction
• Popularity

39
Step 6 Inventory Losses

• On the Inventory sheet of the spreadsheet, each
  day record
• Stock Lost

40
Note
Make sure you pay attention and record ALL
inventory losses!
41
Step 7 Repeat

• Keep recording the data in the appropriate areas
  for the rest of the days (Step 2 Step 6).

42
Step 8 End of Season Report

• On the Income sheet of the spreadsheet, each day
  record
• Total Income
• Total Expenses
• Net Profit/Loss

43
Part 2 - Calculations
44
Step 1 - Inventory

• Calculate for each item
• Bought Stock (from Expenses)
• Used Stock
• Calculate the following totals for each item
• Bought Stock
• Used Stock
• Lost Stock

• Lost Ice

NOTE UsedStock(Day) Leftover(Day)
Bought(Day) Lost(Day) - Leftover(NextDay) UsedIc
e CupsSold X IcePerCup
45
Step 2 - Expenses

• For each purchase calculate
• Price Per Item
• For each item calculate
• Total Quantity purchased
• Total Cost of purchasing

NOTE PricePerItem ___Cost___ Quantity
NOTE Use the sumif() function
46
Step 3 - Income

• For each row in the Daily Income Data section
  calculate
• Average
• Also calculate
• Daily Income for each day
• Highest sales in a day
• Lowest sales in a day
• Total Income
• Total Expenses
• Net Profit/Loses

NOTE Daily Income CupsSold X PricePerCup
NOTE Net Profit/Loses TotalIncome -
TotalExpenses
47
Part 3 - Charts
48
Graph 1 - Sales

• Create a Clustered Column chart to display the
  number of cups sold per day and save it in a new
  sheet called Sales.

49
Graph 2 - Lemons

• Create a Stacked Column chart to display the
  number of lemons in stock each day and save it in
  a new sheet called Lemons.

NOTE Only use the Leftover and Bought rows.
50
Graph 3 - Ratings

• Create a Line chart to display the customer
  satisfaction and popularity rating each day and
  save it in a new sheet called Ratings.

51
Graph 4 Weekly Income

• Create a Pie chart to display the breakdown of
  the total income by each day and save it in a new
  sheet called Weekly Income.

52
Done Early?

• Develop a strategy to get the highest Net Profit.