Factor allocation
A factor is a value associated with each post-to activity in an allocation. Factors can be square footage, hours spent, units produced, to-date costs, or revenues for specific activities, and so on. The application uses this formula to determine the percentage for each post-to activity in a factor allocation:
Since the calculation determines percentages based on each post-to activity's pro rata share, 100% of the pool will always be allocated in factor allocations.
Two kinds of factors exist: fixed and dynamic. With fixed factors, you define a value for each post-to activity that remains constant such as square footage. With dynamic factors, you map existing Project Accounting data to each post-to activity such as labor hours or period-to-date revenues posted to a given activity. You can use a dynamic factor to determine allocation percentages using posted or budgeted activity balances.
Consider using a fixed factor allocation when:
-
you want to allocate 100% of the pool
-
the values on which the driver is based are unchanging
-
the values on which the driver is based are not already collected or stored in Project Accounting
Consider using a dynamic factor allocation when:
-
you want to allocate 100% of the pool
-
the values on which the driver is based change frequently
-
you are regularly posting or budgeting the units or amounts on which the driver is based in Project Accounting
In these examples of fixed and dynamic factor allocations, Moose Wood Outfitters is using Project Accounting to track sales and costs for each of its store locations.
Fixed factor example
Moose Wood Outfitters wants to allocate overhead costs to stores based on each store's square footage. They define an allocation that includes a factor for each post-to activity. In this example, each store is a posting activity. The factor identifies the square footage of each store.
| Activity | Factor (sq ft) | Calculation | Driver |
|---|---|---|---|
| St. Paul store | 40,000 | 40,000/100,000 | 40% |
| Chicago store | 35,000 | 35,000/100,000 | 35% |
| Denver store | 25,000 | 25,000/100,000 | 25% |
| 100,000 | 100% |
The St. Paul store is allocated 40% of the pool. If the square footage of store changed, such as for an expansion, then they would change the factor and the percentages would be adjusted accordingly.
Dynamic factor example
In this example, Moose Wood Outfitters wants to allocate overhead costs to stores based on each store's sales. They defined a Sales account category for each store activity to capture this information. In the allocation, they associated each store's activity and Sales account category with the respective post-to activity. When they process the allocation, the application uses each store's sales amount to determine the percentage of total sales for each store.
| Activity | Sales | Calculation | Driver |
|---|---|---|---|
| St. Paul store | $580,000 | 580,000/1,800,000 | 32.2% |
| Chicago store | 750,000 | 750,000/1,800,000 | 41.7% |
| Denver store | 470,000 | 470,000/1,800,000 | 26.1% |
| $1,800,000 | 100.0% |