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.
Sheet1 Sample Data Day Weather Price Lemons Sugar Ice # Cups # Lemons # Cups # Ice Cubes Assets after Cups # Customers Total Sales Total Expense Per Cup Per Pitcher of Sugar Expenses Sales Sold Overcast Cloudy Hazy Sunny Rain End of Season Report Total Income Total Expenses Liquidated Inventory Net Profit/Loss Mean Standard Deviation Net Revenue Coudy Lemonade Analysis – Tom Dullaghan Coeff. Of variation CV in % CV of Group1(%) CV of Group2(%) CV of Group3(%) CV of Group4(%) CV of Group5(%) CV of Group6(%) For entire data CV of…
Attachments:
1sol._2.xls