The Job Costing report can be used when tracking time at jobs to learn what jobs are profitable for you or not. Here is a overview of the report and what information it provides.
When you initially bring up the "Job Costing" report this is what you will see:
This screen enables you to control what information is brought up when you run the report.
Crew Range: Which crews are you wanting to check the profitability on.
Customer Range: Do you want to see just a specific customer or a range of customers
Job Numbers: This range allows you to limit the jobs you are checking the profitability on
Start Date/Stop Date: These dates enable you to check for a specific date or whole season or more
Show History: Displays more of the customers history on the report
Only Jobs that are under or over projection time: This allows you to weed out the jobs that are right in your target spot.
Include Jobs on Hold: Do you wish to see jobs that are no longer active, but have been preformed during the given date range?
Active Customers Only: This will make sure no "on hold" customer generate on the report
PRINT OPTIONS:
Detail: This will bring up and display each job and each time a job was done during that range.
Summary: This will only display the job that you are trying view once. If you have selected a range you will only see one line for the job. It will add all the costs, charges, and times together to give you a average for the date range.
SORT OPTIONS:
You are able to sort the report by job number, customer name, customer number, crew, DOLLARS PER HOUR (I find this option to be the most useful most often), travel time, dollar/hour including travel time
COLOUR CODING
There is also a neat feature that allows you to set the Dollars/hour to show up in red or green depending on if it is above or bellow a certain amount
VIEWING THE ACTUAL REPORT
Here is a sample of the Job Costing detail report
The first thing to note is how the job is set up, this report brings in and displays the information from the job that does not change:
Notice:
Man Hour Rating for this job is 0.62
Average Time is 0.48
Average Difference is 0.14
The Amount Charged is $40
This next section shows the 2 times that this job was done for this customer during the specified date range.
It gives details on the actual time per visit as well as the travel time. For this customer I must have spent more time chatting during the second visit as I was slightly over my budgeted time during the second visit.
The bottom line in the red box averages out the times from the 2 visits and puts the totals so you can easily read them.
In this last picture I want to bring to your attention the difference in the totals for $/man hour.
The first red box shows the total $/hour while one job.
The second shows the total including the travel time from the last job as well as a version excluding travel time.