Noble Beginnings – 1st 10-Day Period

The following is the information for the first 10 day period during the month of September. Following the graphs are descriptions of the data:

day temp forecast inv cups bought cups  cost cups inv lemons
1 86 clear/sunny 200 200  $       6.12 60
2 84 overcast 150 0  $           – 45
3 96 overcast 110 0  $           – 33
4 75 overcast 66 200  $       5.88 51
5 68 cloudy 244 0  $           – 45
6 71 hazy 223 0  $           – 41
7 77 overcast 178 0  $           – 26
8 56 rain 151 0  $           – 16
9 73 rain 134 0  $           – 8
10 50 overcast 114 0  $           – 12

 

bought lemons  cost lemons inv sugar bought sugar  cost sugar inv ice bought ice
60  $           4.84 96 96  $        6.82 350 350
0  $               – 66 0  $            – 250 250
30  $           2.37 42 0  $            – 0 250
0  $               – 18 20  $        1.66 0 250
0  $               – 0 48  $        3.44 0 250
0  $               – 36 0  $            – 0 250
0  $               – 1 68  $        4.79 0 500
0  $               – 48 0  $            – 0 250
10  $           0.85 36 0  $            – 0 250
0  $               – 24 0  $            – 0 100

 

 cost ice  expenses  price cup lemons in pitcher sugar in pitcher cubes in cup cups sold
 $    3.07  $     19.62  $      0.24 3 6 3 50
 $    2.13  $       2.13  $      0.24 3 6 3 40
 $    2.20  $       4.57  $      0.25 3 6 3 44
 $    2.08  $       9.62  $      0.23 2 6 2 22
 $    2.21  $       5.65  $      0.23 2 6 3 21
 $    2.06  $       2.06  $      0.24 3 7 3 45
 $    3.99  $       8.78  $      0.25 3 7 5 27
 $    2.12  $       2.12  $      0.20 3 6 3 17
 $    2.10  $       2.95  $      0.22 3 6 4 20
 $    0.86  $       0.86  $      0.22 3 6 3 12

 

 income spoilage potential cust cust satis popularity  $ balance profit or <loss>
 $        – ICE 99 79% 5%  $      12.60 loss
 $     0.07 ICE 95 76% 9%  $      20.07 profit
 $     6.06 ICE 100 82% 13%  $      26.06 profit
 $     1.50 ICE/SUG 83 76% 15%  $      21.50 profit
 $     0.68 ICE 99 70% 17%  $      20.68 profit
 $     9.42 ICE 112 66% 22%  $      29.42 profit
 $     7.19 ICE/ 1 LEM 90 66% 24%  $      27.19 profit
 $     8.47 ICE/ 2 LEM 98 64% 26%  $      28.47 profit
 $     9.92 ICE 98 63% 28%  $      29.92 profit
 $   11.67 ice 103 65% 29%  $      31.67 profit

Analysis

As you can see from this data I was initially trying quite a few different combinations for the lemonade to try to figure out the best possible way to sell. The prices that period of time varied from twenty-one cents to twenty-five cents. The only time I happened to ever have a loss during the first month occurred on the first day, when I had to purchase my initial materials and supplies for the business week. My customer popularity rose from zero to twenty-nine percent in those 10 days. The temperature was an average of 73.6 degrees throughout the week, and there was a variety of different forecasts. The business received an average customer satisfaction rating of 70.7%  among that ten-day period of time during September.

Spoilage

I only had to buy cups at 2 different times, since there is no actual way for cups to spoil. The ice spoiled everyday when it melted. One lemon spoiled on the seventh day, and two lemons spoiled on the eighth day. On the fourth day, all of the sugar spoiled when the ants went on a feeding frenzy in it, so the whole amount that was there had to be discarded.

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s