Your job today is to create a coffee shop similar to the lemonade stand.
Step 1: Open and save the excel spreadsheet as "Coffee Shop"
Step 2: Open and play the game while recording the data into the excel spreadsheet.
Step 3: Create a graph. Include:
Step 5: In a text box answer these questions:
How often did you profit? Would you recommend this company to continue sales or shut down its business according to your profit?
Did you go bankrupt and have to start over? What happened? What would the line graph look like for a bankruptcy?
How often did you change your recipe? Describe how and why you changed it.
What was the average price you charged for your coffee? (Do not forget about functions in your Excel program.)
Describe your overall sales trend over the 14 days. Was it mostly increasing, decreasing or a constant change daily?
Step 1: Open and save the excel spreadsheet as "Coffee Shop"
Step 2: Open and play the game while recording the data into the excel spreadsheet.
Step 3: Create a graph. Include:
- Chart Title: Money Made
- Place and Arrow and a Line at the $30 mark
Step 5: In a text box answer these questions:
How often did you profit? Would you recommend this company to continue sales or shut down its business according to your profit?
Did you go bankrupt and have to start over? What happened? What would the line graph look like for a bankruptcy?
How often did you change your recipe? Describe how and why you changed it.
What was the average price you charged for your coffee? (Do not forget about functions in your Excel program.)
Describe your overall sales trend over the 14 days. Was it mostly increasing, decreasing or a constant change daily?