The SHARED_USAGE_LOE Worksheet

 

§         Click on the SHARED_USAGE_LOE button.

 

Shared UsageThe 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.

Create Button

 

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 ButtonCreate CAPCreate 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 ButtonCreate 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 Button

§   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.