In this final article within the series we look at the HR worksheet within the model, the Assorted Costs sheet, and Budget Detail pages.
This worksheet includes a list of all employees who will likely be employed during the duration of the 60 month model. Emphasis is placed on the first 18-months in order to get the model as accurately as possible.
To enable better categorisation and analysis of resources each employee is broken down by business unit, locale, type of resource, type of employee (FTE, PT, Contractor, et alia), salary, allowances, bonuses and pay rise percentage for future years (including inflation).
The table calculates both the monthly and annual cost per employee.
The variables include:
- 12 MONTH PAY INCREASE
- PAYRISES ARE GIVEN ANNUALLY, AFTER EACH 12 MONTHS OF EMPLOYMENT
- ADDITIONAL PAYROLL COSTS
- PAYROLL TAX
- TOTAL COSTS
Other costs included in this sheet are Directors fees, and commission.
To calculate the total commission number we use variables for the following attributes:
- SALES PERSON
- SALES MANAGER
- SALES DIRECTOR
ASSORTED COSTS PAGE
The ‘Assorted Costs’ sheet includes monthly and annual breakdowns of costs not included elsewhere in the model. These costs are best organised into two categories:
- OFFICE AND ADMINISTRATION
- FINANCE AND PROFESSIONAL SERVICES
Again, the costs include inflation for future years.
The ‘Budget Detail’ page operates in the same way as a standard Profit and Loss document. It highlights and predicts all monthly costs and revenues, broken down first by month and then by year. This page forms the basis of the P&L for the entire group business.
The ‘Content Matrix as discussed in more detail elsewhere within this website. It is included in the workbook to highlight more detail with the business and visually explain what the content spend returns.
This was the final article in this series. If you have enjoyed it, or have any feedback please feel free to drop me an Email.
If you are a patying subscriber you will be able to download the (boilerplate) workbook that includes all of the models. For your reference, below is a link to the other articles within this series.