- Click
on the SubModules button.
The user
will be presented with the SUB_MODULES worksheet as shown below:
§
Please enter information for all submodules.
§
This worksheet captures the related functional module, submodule
name, a description, allocation_type, and the optional fields for the budgeted
or actual costs for the sub-module.
§
Sub-modules can be used to provide a second-level
aggregation for the allocation.
§
Sub-modules (e.g., management or staff for the Alerts
functional module) are captured on the SUB_MODULES worksheet as shown on the
screenshot.
- IMPORTANT
NOTE: The CAM-TOOL uses column “F” – the ALLOCATION_TYPE
indicator to determine the information that should be inserted into the
SHARED_USAGE_LOE Worksheet.
- Therefore,
column “F” must remain as the ALLOCATION_TYPE indicator.
- To
provide a complete view of the system functionality, the CAM-TOOL
captures information about system functionality used by only one
benefiting program and captures information on system functionality used
by two or more benefiting programs on the ALL_SYSTEM_USAGE worksheet.
- However,
the actual cost allocation percentages calculated by the CAM-TOOLonly
include system functionality shared by two or more benefiting programs.
The cost allocation percentages are calculated using data on the
SHARED_USAGE_LOE worksheet.
- The
CAM-TOOL automatically extracts submodules that are direct charges to one
benefiting program from the data that is inserted on to the SHARED_USAGE_LOE
worksheet based on the designation in the ALLOCATION_TYPE field on the
SUBMODULES worksheet.
- Users
may insert rows anywhere below the header rows that include the worksheet
name and the names of each of the columns
The
SUB_MODULE worksheet has one menu item “Copy to the Details Worksheet.”
This button copies the functional module and submodule names to the
DETAILS worksheet to document the relationship of the details to the
functional modules and the submodules in the system allocation hierarchy.