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

profileshapoo
tomdata_1sol._2.xls
Home>Business & Finance homework help>Accounting homework help>write a summary to reflect on your experience (250 word minimum).

Sample Data

Lemonade Analysis - Tom Dullaghan
Day Weather Price Lemons Sugar Ice # Cups # Lemons # Cups # Ice Cubes Assets after Assets after Cups # Customers Total Sales Total Expense Net Revenue
Per Cup Per Pitcher Per Pitcher Per Cup of Sugar Expenses Sales Sold
1 Overcast 78 0.25 4 4 4 100 30 20 250 7.88 15.88 32 70 8 12.12 -4.12
2 Rain 85 0.10 3 3 10 68 18 36 1000 8.16 11.66 35 65 3.5 7.72 -4.22
3 Sunny 63 0.20 4 4 7 133 19 23 500 4.37 12.75 35 85 7 7.29 -0.29
4 Coudy 89 0.15 4 4 7 98 20 21 250 9.88 15.13 35 69 5.25 2.87 2.38
5 Overcast 86 0.15 4 4 7 113 12 9 500 10.13 17.63 50 71 7.5 5.00 2.50
6 Overcast 76 0.20 3 3 3 67 12 20 500 9.05 14.17 32 61 6.4 8.58 -2.18
7 Overcast 90 0.15 4 4 4 83 33 49 500 4.89 8.49 24 61 3.6 9.28 -5.68
8 Coudy 51 0.15 4 4 4 59 25 41 500 4.64 8.54 26 78 3.9 3.85 0.05
9 Hazy 70 0.15 4 4 4 133 23 29 250 2.65 8.05 36 55 5.4 5.89 -0.49
10 Sunny 64 0.20 4 4 6 97 11 17 100 7.13 10.33 16 68 3.2 0.92 2.28
11 Sunny 51 0.20 3 4 4 81 13 17 250 6.74 13.34 33 71 6.6 3.59 3.01
12 Sunny 69 0.20 3 4 4 48 14 13 250 9.86 15.66 29 65 5.8 3.48 2.32
13 Rain 69 0.10 3 4 4 119 15 29 250 7.73 9.93 22 78 2.2 7.93 -5.73
14 Rain 72 0.10 3 4 4 97 19 21 0 9.02 9.02 0 67 0 0.91 -0.91
15 Hazy 50 0.15 3 4 4 97 16 17 250 8.18 11.93 25 69 3.75 0.84 2.91
16 Sunny 76 0.20 4 4 7 72 17 13 250 8.27 15.27 35 68 7 3.66 3.34
17 Rain 71 0.10 3 4 4 137 15 21 250 7.74 12.14 22 60 2.2 7.53 -5.33
18 Rain 78 0.10 3 4 7 115 5 9 0 10.37 10.37 0 71 0 1.77 -1.77
19 Sunny 93 0.25 4 4 7 115 15 21 250 7.74 16.30 35 73 8.75 2.63 6.12
20 Rain 66 0.10 3 4 8 80 13 17 250 13.39 15.27 21 76 2.1 2.91 -0.81
21 Sunny 71 0.20 4 4 8 60 17 29 250 10.99 17.19 31 61 6.2 4.28 1.92
22 Sunny 97 0.20 4 4 7 129 19 21 500 9.64 19.84 51 63 10.2 7.55 2.65
23 Hazy 78 0.20 3 4 7 78 23 25 250 13.93 23.13 46 60 9.2 5.91 3.29
24 Hazy 62 0.20 3 4 5 132 23 29 250 15.84 23.44 38 68 7.6 7.29 0.31
25 Rain 68 0.10 3 4 4 94 12 17 100 22.55 24.65 21 81 2.1 0.89 1.21
26 Coudy 82 0.15 3 4 7 73 16 17 250 21.00 26.25 35 67 5.25 3.65 1.60
27 Rain 57 0.10 3 4 8 63 14 1 0 24.69 24.69 0 72 0 1.56 -1.56
28 Hazy 75 0.20 4 4 8 63 14 9 250 21.80 28.00 31 79 6.2 2.89 3.31
29 Cloudy 91 0.20 4 4 5 57 16 9 250 23.75 28.95 27 72 5.4 4.25 1.15
30 Overcast 94 0.15 4 4 5 31 15 17 250 25.06 29.71 31 67 4.65 3.89 0.76
CV of groups
CV of Group1(%) 13.00 33.53 11.77 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 11.77 11.77 26.08 33.27 44.64 43.74 50.20 43.50 25.55 28.71 13.61 29.98 60.36 -246.41
CV of Group3(%) 17.29 33.33 0.00 0.00 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 16.11 0.00 22.98 26.08 36.08 32.19 55.90 25.56 18.05 63.40 8.77 91.98 60.68 1445.57
CV of Group5(%) 17.93 24.85 16.11 0.00 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 0.00 22.98 27.59 6.67 63.14 55.90 7.68 7.42 57.05 6.90 57.36 32.86 166.80
For entire data
Mean 74.0666666667 0.16 3.50 3.93 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