Example
Moose Wood Outfitters wants to allocate project management costs to a list of activities, as shown in this table:
Pool | * | Driver compute statement | Driver value | Activities in Post-to List | Allocation |
---|---|---|---|---|---|
Project Management $10,000 |
* | Each activity's hours / Total activity hours |
40% 35% 25% |
Carpentry Electrical Decorating |
$4,000 $3,500 $2,500 |
First, they defined an automatic list that selects the post-to activities they want (MWO-PM-ALLOC). Next, they defined the following compute statement to calculate the pro rata share of hours for each activity in the list to total hours for all activities in the list.
Moose Wood Outfitters used the Compute statement name PM-HOURS and the statement PRDACU/PRDACT(PM-AC).
The compute statement's numerator must identify each individual activity in the list to make allocations on a pro rata basis. To do this, Moose Wood Outfitters used Compute Parameters (AC34.1) to identify the account categories on which the calculation should be based (03010-03010), but they left the activity options on Compute Parameters (AC34.1) blank. This indicates to the system that the allocation for each post-to activity should be calculated based on the balances for each individual activity in the list. The Compute Parameter Name used is PW-ALLOC.
The compute statement's denominator uses a total name to identify the entire list of activities (PM-AC). The activity list (MWO-PM-ALLOC) is associated with the total name on Activity Total Names (AC35.1). On the Main tab, the units is chosen as the type to retrieve the hours for each activity.
On List Allocation (AC30.3), Moose Wood Outfitters created a list allocation using these information: the Allocation Name, Pool, and Post to List are entered as MWO-PM, MWO-PMPOOL, and MWO-PM-ALLOC respectively. They select an Activity Post Option, Acct Cat Post Option (Consolidate for both), a Post to Acct Cat (03020) and whether or not to Automatic Reverse the entry. Add Compute Name PM-HOURS and Parameter Name PM-ALLOC.
Alternative method
As an alternative, Moose Wood Outfitters could have used a total name in the numerator for the compute statement. For example, they can define this compute statement:
PRDACT(IND-ACTVY)/PRDACT(PM-AC)
If they chose to do this, then they would need to select the account categories they wanted associated with the numerator on the AC Parameters tab on Activity Total Names (AC35.1). To enable the system to calculate the driver for each post-to activity, they would not populate the Activity or Activity List field on the Activity Total Names (AC35.1).