V
vsoler
I have all the fixed expenses of my office recorded in one table:
Table 1: CostCenters
CostCenterCode
AnnualBudget
In another table, I allocate the costs according to several keys
expressed as %
Table 2: Allocation keys
CostCenterOrigin
CostCenterDestination
Key
Say for example that cost center "3" will work for cost center "7"
30% of its time. In this case the record in table 2 would show:
3
7
30
Knowing that not all cost centers provide services (not all couples of
cost centers exist in table 2), and that some others do not work 100%
of their time for others (they do not allocate 100% of their costs),
how can I combine queries to calculate the annual budget per cost
center after allocations?
Any help that you can provide is highly appreciated.
Thank you
Table 1: CostCenters
CostCenterCode
AnnualBudget
In another table, I allocate the costs according to several keys
expressed as %
Table 2: Allocation keys
CostCenterOrigin
CostCenterDestination
Key
Say for example that cost center "3" will work for cost center "7"
30% of its time. In this case the record in table 2 would show:
3
7
30
Knowing that not all cost centers provide services (not all couples of
cost centers exist in table 2), and that some others do not work 100%
of their time for others (they do not allocate 100% of their costs),
how can I combine queries to calculate the annual budget per cost
center after allocations?
Any help that you can provide is highly appreciated.
Thank you