K5 Computer Lab Lesson Plans

iWork Numbers - Lemonade Stand Profit and Loss

Students Create a Profit and Loss Spreadsheet for a Lemonade Stand

Students enter sales and expense data and use formulas to calculate profits or losses for 6 days.

 

Students learn to save time by using AutoFill to automatically fill in the days of the week, recurring number values (Rent), and repeating formulas (Total Expenses, Profit and Loss).

 

Grades 4+

 

 

 

 

iWork Numbers Lemonade Stand Profit and Loss Finished Example:

iWorks Numbers Lemonade Stand

 

Spreadsheet Instructions:

Step 1 - Spreadsheet Setup

Enter data as shown. Use autofill to automatically enter weekdays Tues - Sat into the cells. Improve visual appearance by formatting text using larger font size and bold as necessary.

lemonade stand spreadsheet

 

 

20 Second Autofill Tutorial:

Drag the handle (lower right corner) of a selected cell to autofill.

 

 

 

Step 2 - Generate and Enter Sales and Expense Data

Use the Lemonade Stand Sales and Expense Number Generator to quickly generate numbers for each day of the week. Enter the sales and expense data for each day as shown.

lemonade stand data

 

 

Step 3 - Create Formula to Sum Total Expenses

Select all of the expenses in the Monday column as shown. Click the Formula button and click Sum. This will add all the selected expenses and enter the total underneath the selection ($17.00).

Use Autofill to calculate the total expenses for weekdays Tues - Sat.

lemonade stand calculate total expenses

 

 

Step 4 - Create Formula to Calculate Profit or Loss

Select the cell in the Profit and Loss row in the Monday Column. Enter the equal sign and the cell location of Monday's Sales (b4) minus the cell location of Monday's Total Expenses (b12) as shown below. Click the green checkmark to complete the calculation.

Use Autofill to calculate the profits or losses for weekdays Tues - Sat.

lemonade stand profit and loss

 

 

Lemonade Stand Finished Example:

Students can format the completed spreadsheet with their name, alternate fonts, font colors, sizes, etc.

lemonade stand spreadsheet

 

Popular:
For PC's and Microsoft Office

  • Excel
    Bar Chart

    Excel Bar Chart
  • Thanksgiving
    Copy and Paste

    Thanksgiving Copy and Paste
  • Green Screen
    Photo Editing

    Green Screen Photo Editing
  • Computer Lab
    Rules

    Computer Lab Rules Essentials
  • California Regions
    Brochure

    California Regions Brochure
  • Amazing Animals
    PowerPoint

    Amazing Animals
  • I Am
    Poem Generator

    I Am Poem Generator
  • "Floater"
    Animation

    I Can Float Animation
  • Copy and Paste
    Practice

    Copy and Paste Practice
  • Learn PowerPoint
    in One Minute

    Learn PowerPoint in One Minute
  • M & M
    Excel Chart

    Excel Pie Chart
  • Newspaper
    Template

    Newspaper Template