§
Click on the SHARED_USAGE_LOE button.
The
user will be presented with the SHARED_USAGE_LOE worksheet as shown below:
§
The above screenshot of the SHARED_USAGE_LOE worksheet has
been pre-populated with data by clicking on the “Calculate Shared Usage Level
of Effort (LOE)” button on the SYSTEM_USER_COUNTS worksheet. The process of
creating the level of effort values for this worksheet is explained in the description
of the “Calculate Shared Usage Level of Effort (LOE)” button in the
SYSTEM_USER_COUNTS worksheet section.
§
At this point in the cost allocation process, the final
shared usage level of effort values have been calculated. These numbers are
used to create the cost allocation plan for all of the benefiting programs.
Functional Module |
SubModule |
Detail |
Base
Value |
Weight |
FS |
TANF |
MED |
Program4 |
Program5 |
Total |
Alerts |
Management |
AL1 |
20 |
|
6.664 |
6.664 |
6.664 |
0.01 |
|
20 |
Alerts |
Management |
AL2 |
25 |
|
12.48 |
|
12.48 |
0.0175 |
0.0225 |
25 |
Alerts |
Management |
AL3 |
10 |
|
9.982 |
|
|
|
0.018 |
10 |
Alerts |
Management |
AL4 |
5 |
|
2.4955 |
2.4955 |
|
0.004 |
0.0045 |
5 |
Alerts |
Management |
AL5 |
5 |
|
1.6665 |
1.6665 |
1.6665 |
|
|
5 |
TOTALS: |
33.288 |
10.826 |
20.8105 |
0.0315 |
0.045 |
65 |
||||
Percent Share in decimal format: |
0.5121 |
0.1666 |
0.3202 |
0.0005 |
0.0007 |
1.0000 |
§
Create
Cost Allocation Plan Section: Users use this button to generate
a cost allocation summary for a specific section of the system functionality. The “Create Cost Allocation Section” window will appear
after clicking on this button.
§
Users select specific system functionality to create a cost
allocation summary. In the example in the screenshot, all Management alerts
have been selected. A summary of the cost allocation for the management alerts
will be inserted on to the COST_ALLOCATION_PLAN worksheet.
§
After clicking the “Create Cost Allocation Section” button ,
users will be asked to provide a name for the cost allocation summary that will
be inserted with the cost allocation summary on to the COST_ALLOCATION_PLAN
worksheet.
§ Create
Program Base Summary (Shared): is
an optional button indicated by the italics of the button. This button will
create a summary of usage by benefiting program on the PROGRAM_SUMMARY
worksheet. For example, if a benefiting program only uses 45 of 100 system
functionality components, then the 45 components will be listed for that
benefiting program on the PROGRAM_SUMMARY worksheet.
§ Format Shared Usage LOE (Copy): is an optional button that allows the user to copy the
information on this worksheet to the worksheet FORMAT_SHARED_USAGE_LOE for any
desired formatting purposes or other analysis.