Excel Lesson Plan
Lemonade Stand Profit or Loss

Assignment: Students create a profit or loss spreadsheet and chart for a lemonade stand with 6 days of sales and expenses. Students use the random number generator to get their sales and expenses numbers for each day.

Students enter their data in the spreadsheet for each day. Students use a formula (sum) to calculate expenses. Students use a simple formula to calculate profits or losses (sales - total expenses = profit ).

Download: lemonade-stand-profit-or-loss-spreadsheet-finished-example.xlsx

Lemonade Stand Profit or Loss Finished Example:

Lemonade Stand Random Number Generator

Students can use this online random number generator to help them create the numeric values for their spreadsheet. Simply click the "Get Numbers Now!" button to generate random sales and expense numbers for the lemonade stand.

Download: lemonade-stand-profit-or-loss-spreadsheet-instructions.pdf

Lemonade Stand Spreadsheet Instructions:

Download: rubric-for-spreadsheet-with-chart.pdf

Excel Spreadsheet Rubric for Grading Assignments