This worksheet will provide an actual record of each day work was performed on a project.
Use this overhead calculation method to allocate actual resource use for each specific project and match those with the actual costs incurred.
This file will be updated each month.
Sample quarters are provided to demonstrate how to use the app.
Data will be entered only in the light-green cells.
Enter Project Name at “Job” column.
Enter date Project was started (01/22/20XX) at “Start” column
When the Project is completed, enter the date (9/12/20XX) at “Complete” column.
Enter days each month that Project was active. If project was started during the month, enter from start day to end of month. If project was completed during the month, enter days from first of month to completion day.
Enter the total monthly overhead (General and Administrative) expenses under the appropriate month.
Job Days is defined in this app as the number of days the project was active during the month.
If the month is January, and the project began on the 15th and continued through the 31st, then there were 17 Job Days during the month.
You may also wish to track the number of days that work actually occurred on the job site, and use that as the Job Day count.
However you wish to count the Job Days for a project, be consistent across all projects.
At the end of each row, you will find:
the total number of Job Days for the Project
the total Overhead Allocation for the Project.
This information is useful in providing a summary of the time required to complete the project and the overhead resources absorbed by the project.
If the project carries over into a new year, begin a new version of the app.
If you have more than 30 projects in a year, just start another version of the app.
Be sure to save your work after each entry session, and store the file where it can be easily accessed.
I would suggest book-marking the app for easy access.