SPREADSHEET

1
SPREADSHEET

• GET READY FOR AN ASSESSMENT!

2
This Lesson

• Assessment How you are marked.
• The Business Plan spreadsheet model
• Using spreadsheets to see if a business idea is
  likely to make money.

3
What earns you marks

• Using a spreadsheet.
• Adding simple formulas to calculate values.
• Drawing real life conclusions from using a
  spreadsheet.
• Writing about how useful a particular spreadsheet
  is - suggesting improvements.
• Designing spreadsheet layouts from scratch.

4
Car Washing
Isnt it about time you started earning your own
pocket money?
No Haribo! No Mobile! No Pokemon Cards!
5
What will it cost you?

• 50p for materials for each car.
• 50p in hot water for each car.
• 5 each month in rent.

6
What will you get?

• 5 for each car that you wash.

7
Lets make some guesses

• Working Saturday and Sunday you wash about 40
  cars each month.

8
Making the spreadsheet
9
Stage 1

• Add the headings.
• Use the autofill tool to make this happen
  quickly.
• Enter basic items.

10
Stage 2

• Fixed Costs
• You pay the same amount each month.
• Rent

11
Stage 3

• Variable Costs
• This changes if you do more or less work.
• You pay more for hot water and materials if you
  wash more cars.
• Add up all the money you spend each month.

12
Stage 4

• Income
• Work out how much money you make each month.
• Work out your profit

13
Stages 5 7

• Using the model

14
Stage 8

• Finding ways to display the data.
• Why do people find graphs easier to understand
  than tables of figures?

15
Evaluation

• Will the business make a profit?
• Does the spreadsheet answer the question?
• Are we guaranteed to make a profit?
• If we wrote out all these figures on paper, why
  would this not be as useful as the spreadsheet
  that we have made?

16
Evaluation

• What could we do to make the spreadsheet
• More accurate
• Easier to understand

17
The Example

• J\it\8_Files\New_8_Files\Car Washing.xls