Play the lemonade stand game again using the coding methodology adopted by YOUR TEAM in week 2. • Look at the pricing for lemons, ice, cups, and sugar. – Remember that a pitcher will serve 12 cups if there is no ice, and about 20 cups if there are 3 ice

•Play the lemonade stand game again using the coding methodology adopted by YOUR TEAM in week 2.

•Look at the pricing for lemons, ice, cups, and sugar.

–Remember that a pitcher will serve 12 cups if there is no ice, and about 20 cups if there are 3 ice cubes per cup.

Then, write a summary to reflect on your experience (250 word minimum).

 

Address the Following in your Paper:

 

•Follow the following 5 step process. SHOW YOUR WORK.

–1. Calculate the number of cups/pitcher you can serve. ROUND UP to the nearest whole number.

–2.  Calculate the number of lemons, cups of sugar, and cups you’ll need to buy.

–3. Look at the quantity pricing for each item and add up the cost to purchase your supplies.

–4. Look at your costs. For every $1.00 of cost, how much is Cups? Sugar? Lemons? Ice?

–5. Calculate your cost and revenue per cup (revenue should be price per cup).  How did changing         ingredients/quantity purchases affect your unit costs?

–Put the summary data you want to focus on (i.e., what is your hypothesis regarding which variable affects net revenue) and put this information into a table

•Discuss what your table reveals

•Graph your cost and revenue data in a bar chart.

•Graph your daily net revenue (revenue – cost).

•Discuss/describe what your graphs reveal.

2

>Sample Data

# Cups

Assets after Cups

Per Pitcher Per Cup

Sales

.2

4 4

0

0

8

8

.12

2

3 3 10

8

0

.

3

4 4 7

35 85 7

4

4 4 7

20

0

35

5 Overcast

4 4 7

12 9 500

.63

50

6 Overcast

0.20 3 3 3

12 20 500

.17

32

8

7 Overcast

0.15 4 4 4

33

500

61

8

8 Coudy

0.15 4 4 4

25

500

9

70 0.15 4 4 4

23 29

36

10 Sunny 64 0.20 4 4 6

11 17 100

16 68

8

11 Sunny 51 0.20 3 4 4

13 17 250

33 71

12 Sunny 69 0.20 3 4 4

14 13 250

29 65 5.8

13 Rain 69 0.10 3 4 4

15 29 250

22 78 2.2

14 Rain 72 0.10 3 4 4 97 19 21 0

9.02 0 67 0

15 Hazy 50 0.15 3 4 4 97 16 17 250

25 69

16 Sunny 76 0.20 4 4 7 72 17 13 250

35 68 7

3.34

17 Rain 71 0.10 3 4 4

15 21 250

22

2.2

18 Rain 78 0.10 3 4 7

5 9 0

10.37 0 71 0

19 Sunny 93

4 4 7 115 15 21 250 7.74

35 73

20 Rain 66 0.10 3 4 8

13 17 250

15.27 21 76 2.1 2.91

21 Sunny 71 0.20 4 4 8 60 17 29 250

61

22 Sunny 97 0.20 4 4 7

19 21 500

51 63

2.65

23 Hazy 78 0.20 3 4 7 78 23 25 250

60 9.2

24 Hazy

0.20 3 4 5

23 29 250

38 68

25 Rain 68 0.10 3 4 4

12 17 100

21 81 2.1

26 Coudy

0.15 3 4 7 73 16 17 250

35 67 5.25

27 Rain

0.10 3 4 8 63 14 1 0

24.69 0 72 0

28 Hazy 75 0.20 4 4 8 63 14 9 250

31

6.2

29

91 0.20 4 4 5 57 16 9 250

27 72 5.4

30 Overcast 94 0.15 4 4 5 31 15 17 250

31 67 4.65

11.77

11.77 11.77

0.00 0.00

16.11 0.00

26.08

55.90

16.11 0.00

0.00 22.98

55.90

3.50 3.93

Lemonade Analysis – Tom Dullaghan
Day	Weather	Price	Lemons	Sugar	Ice		#	Cups	# Lemons	# Ice Cubes		Assets after	# Customers	Total	Sales	Total Expense	Net Revenue
	Per Cup		Per Pitcher	of Sugar	Expenses	Sold
	1					Overcast													7						8										0					5																																																							4			10																				3				20		2		50	7.88	1	5.8		32		70					12	-4.12
							Rain		85								0.10			6		18		36			100	8.					16			11	66						35		65	3.5	7.				72	-4.			22
							Sunny				63												0.20	1		33	1					9					23						500	4.37	12.	75	7.						29	-0.29
		Coudy	89					0.					15	98								21				25	9.88	15.					13				69		5.25	2.87	2.	38
86			0.15	113	10.13											17					71	7.5	5.00	2.50
		76				67	9.05					14			61	6.4	8.58	–		2.1
90	83	49	4.89	8.49		24	3.6		9.2	-5.				68
		51	59	41	4.	64	8.54		26					78	3.9	3.85	0.05
				Hazy	133																250		2.65	8.05	55		5.4	5.89	-0.49
			97	7.13	10.33	3.2	0.92			2.2
	81	6.74	1	3.34	6.6	3.59	3.01
48	9.86	15.66	3.48	2.32
1			19	7.		73	9.	93	7.93	-5.73
	9.02	0.	91	-0.91
8.18	11.93	3.75	0.84		2.91
8.		27		15.27	3.66
137		7.74	12.14			60	7.53	-5.33
	115		10.37	1.77	-1.77
0.25	16.	30	8.75	2.63	6.12
80	13.39	-0.81
10.99	17.19				31		6.2	4.	28	1.92
129	9.64	19.84	10.2	7.55
1	3.93	23.13	46	5.91	3.29
62	132	15.84	23.44	7.6	7.29	0.31
	94	22.55	2	4.65	0.89	1.21
82	21.00	26.25	3.65	1.60
	57		24.69	1.56	-1.56
21.80	28.00	79	2.89	3.31
Cloudy	23.75	28.95	4.25	1.15
25.06	29.71	3.89	0.76
CV of groups
CV of Group1(%)	13.00	33.53				11.77	30.30	23.20	32.81	44.17	61.24	28.51	16.47	19.15	10.58	29.66	49.42	-442.06
CV of Group2(%)	20.55			16.11		26.08	33.27	44.64	43.74	50.20	4	3.50	25.55	28.71	13.61	29.98	60.36	-246.41
CV of Group3(%)	17.29	33.33						0.00	29.77	14.95	31.27			55.90	14.40	22.23	59.05	7.14	73.06	86.13	1169.89
CV of Group4(%)	13.26	47.14		22.98	36.08	32.19	25.56	18.05	63.40	8.77	91.98	60.68	1445.57
CV of Group5(%)	17.93	24.85	26.50	31.97	24.49	21.55	53.35	34.75	14.15	31.90	12.94	44.83	52.67	62.48
CV of Group6(%)	18.53	26.15	15.21	27.59	6.67	63.14	7.68	7.42	57.05	6.90	57.36	32.86	166.80
For entire data
Mean	74.0666666667	0.16	5.77	89.73	17.13	20.57	290.00	11.57	16.59	28.47	69.03	4.97	4.70	0.27
Standard Deviation	13.0276452297	0.0472	0.5085	0.2537	1.8134	28.6416	5.7279	9.9955	196.6969	6.5092	6.6114	12.5526	6.9256	2.7231	2.8795	3.0253
Coeff. Of variation	0.1759	0.2891	0.1453	0.0645	0.3145	0.3192	0.3343	0.4860	0.6783	0.5626	0.3985	0.4410	0.1003	0.5485	0.6130	11.3165
CV in %	17.59	28.91	14.53	6.45	31.45	31.92	33.43	48.60	67.83	56.26	39.85	44.10	10.03	54.85	61.30	1131.65
End of Season Report
Total Income	148.95
Total Expenses	140.93
Liquidated Inventory	0.42
Net Profit/Loss	8.02

Sheet1