136
edits
Changes
mLine 299:
Line 299: − + Line 351:
Line 351: + + + + + + + +
→Labour: Time Spent (hours)
====== Capital: Number of Units ======
====== Capital: Number of Units ======
This is the number of units that the one stakeholder would be expected to purchase at one instance. This is not the same as the number of units per year, if the Annual Frequency is greater than 1. For example when the Number of Units is 5 and the annual frequency is 6, then the total number of unit per year is 30.
This is the number of units that the one stakeholder would be expected to purchase at one instance. If the Annual Frequency is greater than 1 then the number of units is not the same as the number of units per year. For example when the Number of Units is 5 and the annual frequency is 6, then the total number of unit per year is 30 (i.e., 5 units will be purchased on 6 separate occasions).
====== Capital: Unit Price ======
====== Capital: Unit Price ======
===== Labour: Time Spent (hours) =====
===== Labour: Time Spent (hours) =====
The value in this cell determines how much time will be spent for each instance that the activity is conducted. This value has to be entered in hours, but feel free to use a formula in the cell to divide any number of minutes by 60.
===== Labour: Internal or External Overhead =====
===== Labour: Internal or External Overhead =====
If a regulated business must pay staff to perform a new activity as a result of a regulatory change, then the total cost per hour is more than just the hourly wage: there is also an overhead rate. The overhead rate simply inflates the wage by 25% for an internal staff member or 50% for an external staff member (e.g., if a third-party firm is hired to perform the activity). The overhead rate is a proxy for things like benefits, vacation, sick leave, building rental, utilities, supplies, etc.
If you don't want to add any overhead then just leave this column blank (for example if you want to enter a custom wage that already includes overhead, or if overhead is not applicable for some reason).
===== Labour: Staff Level (hourly wage without overhead) =====
===== Labour: Staff Level (hourly wage without overhead) =====
This cell contains a drop-down menu in which you can select the type of employee who will conduct each regulatory activity. The drop-down menu is supplied by a table on the Labour sheet, which by default contains 52 employee types based on Statistics Canada data.
Custom wages can be added by adding new rows to the table on the Labour sheet, or by simply typing in the wage directly into the Labour: Staff Level (Hourly Wage Without Overhead) column on the Activities table. If you enter a custom wage directly in the table on the Activities sheet then just enter the numerical value only (i.e., don't add a description here).
If you enter a custom wage on the Labour sheet you must specify the price year for the wage (e.g., did you get it from a report from 2019?), but if you enter it directly in the Activities table then it is assumed that you've entered it in the price year matching what was selected on the Initiatives sheet. So if your price year on the initiatives sheet is 2024, make sure you enter the custom wage in 2024 prices.
===== Error check =====
===== Error check =====