Line 131:
Line 131:
====== Growth Rates ======
====== Growth Rates ======
−
'''Annual growth rates:''' At the moment there is only an option to exponential growth. Users should enter the average annual growth rate as a percentage of each stakeholder. If the growth rate is left blank, they it is assumed to be zero.
+
To estimate regulatory impacts, you need to know how many stakeholders are in the market at any given time. The RCC takes the initial stakeholder counts from the Stakeholder Profile tab, and applies the growth rates in every year throughout the analytical period.
+
+
'''Annual growth rates:''' At the moment there is only an option to exponential growth. Users should enter the average annual growth rate as a percentage of each stakeholder. If the growth rate is left blank, they it is assumed to be zero. In a future version you may be able to model growth in different ways, and if that sounds like something you’d like to work on, feel free to reach out to TBS CORE and offer your services!
+
+
•The number of affected businesses at any time is determined by the following formula:
+
+
Businesses in Period ''p'' = Businesses in period<sub>0</sub> ∗ (1+growth rate)^(''p''/frequency)
+
+
The exponent at the end of the formula just splits your annual growth rates into periodic growth rates. For example if you have a monthly requirement, it happens 12 times per year, and over 10 years you would have 120 different periods where you’d want to know the stakeholder count. This formula automates that for you, so you only need to enter the annual growth rate and the frequency of the activity.
+
+
EXAMPLE: businesses in period 0 = 100; growth rate = 1%
+
+
What is the number of businesses in period 2 if an activity’s annual frequency = 1? = 100∗ (1+0.01)^(2/1)=102
+
+
What is the number of businesses in period 2 if an activity’s annual frequency = 4? =100∗ (1+0.01)^(2/4)=100.5
'''Assumptions and Notes''' : As a best practice, users should record the assumptions and notes about that stakeholder group.
'''Assumptions and Notes''' : As a best practice, users should record the assumptions and notes about that stakeholder group.
Line 142:
Line 156:
This section discusses Step Three of the Calculator implementation process. This information can be entered directly into the spreadsheet in the '''Activities''' tab.
This section discusses Step Three of the Calculator implementation process. This information can be entered directly into the spreadsheet in the '''Activities''' tab.
[[File:Activities Tab 1of2 .png|alt=Activities Tab 1 of 2 |center|thumb|1375x1375px|Activities Tab 1 of 2 ]]
[[File:Activities Tab 1of2 .png|alt=Activities Tab 1 of 2 |center|thumb|1375x1375px|Activities Tab 1 of 2 ]]
−
New activities should be entered in the Activities Table at the row indicated by "Type Here →".
+
New activities should be entered in the Activities Table at the row indicated by "'''''Type Here ⮚'''''".
====== '''Activity''' ('''column B'''): ======
====== '''Activity''' ('''column B'''): ======
Line 161:
Line 175:
'''Upfront or Ongoing'''
'''Upfront or Ongoing'''
−
•Upfront activities occur one time per affected stakeholder. The impacts are assumed to occur at the start of each period. Example: affected stakeholders must spend $100 on a piece of equipment (one time only). Important point: although upfront costs only occur one time per affected stakeholder, that does not mean that they only appear in one year of the analysis. If there is a positive stakeholder growth rate, that means new businesses are entering the market over time, and they incur the upfront costs too. Example: if you have a stakeholder growth rate the see new entrants every year, there would be upfront cost appearing in every year throughout the analytical period.
+
•'''Upfront''' activities occur one time per affected stakeholder. The impacts are assumed to occur at the start of each period. Example: affected stakeholders must spend $100 on a piece of equipment (one time only). Important point: although upfront costs only occur one time per affected stakeholder, that does not mean that they only appear in one year of the analysis. If there is a positive stakeholder growth rate, that means new businesses are entering the market over time, and they incur the upfront costs too. Example: if you have a stakeholder growth rate the see new entrants every year, there would be upfront cost appearing in every year throughout the analytical period.
−
−
•Ongoing activities can occur multiple times per affected stakeholder. Impacts are assumed to occur at the end of each period. Example: affected stakeholders must submit a report to the government 3 times per year (3 * 10 = 30 times over a 10-year period).
−
−
−
•
−
−
•
−
•
+
'''Ongoing:''' activities can happen multiple times per stakeholder, on a recurring basis at some specific frequency throughout the analytical period. These impacts are assumed to occur at the end of each period. An example of an ongoing activity is stakeholders submitting a report to the government 3 times per year (and 3 times per year over 10 years means this activity would happen 30 times).
−
ONGOING: activities happen multiple times per stakeholder, on a recurring basis at some specific frequency throughout the analytical period. These impacts are assumed to occur at the end of each period. An example of an ongoing activity is stakeholders submitting a report to the government 3 times per year (and 3 times per year over 10 years means this activity would happen 30 times).
+
'''Start Year'''
−
Following that, you would select the start year, choosing any year on or after the registration period.
+
Activities can occur any year on or after the registration period. the start year for a particular activity can be selected from a dropdown list. The list is determined by the
Similarly, you would select an end year, which can be any year after the start year or the end of the period. For activities that only occur in one year, you would select the same year as the start and end. This is different from the previous versions.
Similarly, you would select an end year, which can be any year after the start year or the end of the period. For activities that only occur in one year, you would select the same year as the start and end. This is different from the previous versions.