Update Previous Year Resource and Activity Rates

This section is used to define functions which store the resource and activity rates calculated by the cost-push allocation process and allows you to edit these rates.

It comprises the following functions:

Write Resource Unit Price

This Writer function is used to write results for rate Resource Unit Price from Join function Calculate Activity per Unit, Resource per Activity and Resource Consumed per Activity into Resource Unit Price Model Table.

Resource Unit Price

This model table accepts the data written with the previous function Write Resource Unit Price and it is used for updating the Resource Unit Price rate.

Update Resource Unit Price

This Query function is used to provide read and edit data access to the Resource Unit Price Model Table data, which serves as an input for demand-pull allocation process.

Write Resource Consumed per Activity

This Writer function is used to write results for rate Resource Consumed per Activity from Join function Calculate Activity per Unit, Resource per Activity and Resource Consumed per Activity into Resource Consumed per Activity Model Table.

Resource Consumed per Activity

This Model Table accepts the data written with the previous function Write Resource Consumed per Activity and it is used for updating the Resource Consumed per Activity rate.

Update Resource Consumed per Activity

This Query function is used to provide read and edit data access to Resource Consumed per Activity Model Table data, which serves as an input for demand-pull allocation process.

Write Activity per Unit

This Writer function is used to write results for rate Activity per Unit from Join function Calculate Activity per Unit, Resource per Activity and Resource Consumed per Activity into Activity per Unit Model Table.

Update Activity per Unit

This Query function is used to provide read and edit data access to Activity per Unit Model Table data, which serves as an input for demand-pull allocation process.