Your current tutor clients
Today we’re going to be making a spreadsheet which lists the current clients we have. We’re going to be making some projections with this data as well. It’s not hard, it just takes a little time to do. We’ll be having a video that should be up tomorrow. If you want to wait on that for a full explanation you can.
There are two links below – the first link – client’s list – the second link – a sample list.
You can download both of those. Below we’ve explained how to fill them out.
Client / Student – You can fill out the student’s or the parent’s name.
Grade – student’s grade
Subjects Tutored (if you tutor various subjects) – if you only tutor one subject you can leave this out.
Tutor Sessions / year (or month or six months)
Cost per session
Type of session
Extras – here you want to put any extra services the student may use. Examples could include homework hotline, Summer camp etc. If you have extra services you’ll put those down later in the spreadsheet. You’ll want to create an abbreviation for those and you’ll want to put the abbreviations here.
Extras Cost – put the total cost of extras.
Total revenue – this is automatically created using a formula. It totals the tutor and extras revenue.
Future Earnings -
These columns will help you gauge what your future income will be.
An estimate of the chance they will enroll again. If 100 percent put 1. If 50 percent put 0.5. Do you think they’ll be your student next year. If you teach high school and they are a senior then you would want to put 0 here. I always guess low here.
Extras – this is the $ value of extras you expect them to purchase during the next year.
A line for totals – below the students. We have ten lines in place, if you have more it should work (the formulas should work).
Below this we have a description of our current extras program.
Extras program – List the extras program.
Cost – list the cost of the program
Abbreviation – the abbreviation used for the program
New programs – any new programs you’re planning to use.
** We’ve also included an example spreadsheet and tomorrow we’ll put up a video that will explain how to do it.
Questions / Comments – please let us know using the comments section.