cost allocation 101 - · pdf filezcost of support services missing ... uses for cost...
TRANSCRIPT
![Page 1: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/1.jpg)
COST ALLOCATION 101COST ALLOCATION 101City and County of San FranciscoCity and County of San Francisco
![Page 2: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/2.jpg)
Public Resource Management Group * MGT of America, Inc.
2
PurposePurpose
Increase understandingDiscuss concepts and methodsReview how to use
Increase understandingDiscuss concepts and methodsReview how to use
![Page 3: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/3.jpg)
Public Resource Management Group * MGT of America, Inc.
3
DefinitionsDefinitions
Cost Allocation Plan – a distribution of central service costs to receiving departments
Federal or A-87 PlanFull Cost Plan
2 CFR Part 225 or OMB A-87 or A-87 = Office of Management and Budget Circular A-87
Cost Allocation Plan – a distribution of central service costs to receiving departments
Federal or A-87 PlanFull Cost Plan
2 CFR Part 225 or OMB A-87 or A-87 = Office of Management and Budget Circular A-87
![Page 4: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/4.jpg)
Public Resource Management Group * MGT of America, Inc.
4
Definitions (continued)Definitions (continued)
Direct costs – “can be identified specifically with a particular final cost objective.” OMB A-87Central service costs - services performed on a centralized basis; administrative costs
Direct costs – “can be identified specifically with a particular final cost objective.” OMB A-87Central service costs - services performed on a centralized basis; administrative costs
![Page 5: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/5.jpg)
Public Resource Management Group * MGT of America, Inc.
5
Definitions (continued)Definitions (continued)
Indirect Costs – “incurred for a common or joint purpose benefiting more than one cost objective” and “not readily assignable to the cost objectives specifically benefited, without effort disproportionate to the results achieved.” (Source: OMB A-87)Indirect Cost Rate – Ratio of indirect costs to a direct cost base
Indirect Costs – “incurred for a common or joint purpose benefiting more than one cost objective” and “not readily assignable to the cost objectives specifically benefited, without effort disproportionate to the results achieved.” (Source: OMB A-87)Indirect Cost Rate – Ratio of indirect costs to a direct cost base
![Page 6: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/6.jpg)
Public Resource Management Group * MGT of America, Inc.
6
Cost Allocation Plan ConceptCost Allocation Plan Concept
Direct operating programs benefit from government-wide central services
Programs should reimburse for central support
ProblemGovernmental accounting systems focus upon direct cost of serviceFull cost of service calculation not possibleCost of support services missing
Direct operating programs benefit from government-wide central services
Programs should reimburse for central support
ProblemGovernmental accounting systems focus upon direct cost of serviceFull cost of service calculation not possibleCost of support services missing
![Page 7: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/7.jpg)
Public Resource Management Group * MGT of America, Inc.
7
Flow of CostsFlow of Costs
Accounting -Payroll
A/R, etc.Bldg Maint Mayor Legal Support Budgeting
Police Dept Fire DeptCommunityDevelpment TransportationPark/Recreation
Short Term Planning
Long RangePlanning Building Div
Planner II
CitywideIndirect Costs
DepartmentwideIndirect Costs
ProgramIndirect Costs
Program DirectCosts
Planner I
![Page 8: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/8.jpg)
Public Resource Management Group * MGT of America, Inc.
8
Flow of Costs (continued)Flow of Costs (continued)
General accounting systems not designed to track ALL costs at lowest level
Direct costs can be trackedIndirect costs cannot be tracked
General accounting systems not designed to track ALL costs at lowest level
Direct costs can be trackedIndirect costs cannot be tracked
![Page 9: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/9.jpg)
Public Resource Management Group * MGT of America, Inc.
9
Accounting SolutionAccounting Solution
Cost Allocation PlanCost Allocation Plan
![Page 10: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/10.jpg)
Public Resource Management Group * MGT of America, Inc.
10
Distribution of CostsDistribution of Costs
Based on measurement of benefit and use
Allocation bases – accounting transactions, payroll transactions, square footage, headcount, equipment depreciationAllocate to operating AND administrative (central service) departments
Based on measurement of benefit and use
Allocation bases – accounting transactions, payroll transactions, square footage, headcount, equipment depreciationAllocate to operating AND administrative (central service) departments
![Page 11: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/11.jpg)
Public Resource Management Group * MGT of America, Inc.
11
Uses for Cost Allocation PlansUses for Cost Allocation Plans
Federal/State grant reimbursementCalculation of general fund support costs to non-general fund departments /servicesTotal cost of providing user fee related servicesGood business
Sound decisions based on better infoSubsidy decisionsFunding decisions
Federal/State grant reimbursementCalculation of general fund support costs to non-general fund departments /servicesTotal cost of providing user fee related servicesGood business
Sound decisions based on better infoSubsidy decisionsFunding decisions
![Page 12: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/12.jpg)
Public Resource Management Group * MGT of America, Inc.
12
ANY ?ANY ?
![Page 13: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/13.jpg)
Public Resource Management Group * MGT of America, Inc.
13
Developing a Cost PlanDeveloping a Cost Plan
Classify departmentsDirect service provider/benefiting agency orCentral service/indirect agency
Interview central service departmentsIdentify services and/or functions and allocation baseWho performs the services?Which departments are served?Are departments are billed?
Classify departmentsDirect service provider/benefiting agency orCentral service/indirect agency
Interview central service departmentsIdentify services and/or functions and allocation baseWho performs the services?Which departments are served?Are departments are billed?
![Page 14: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/14.jpg)
Public Resource Management Group * MGT of America, Inc.
14
Developing a Cost Plan (cont)Developing a Cost Plan (cont)
Gather accounting dataGather allocation dataInput data into softwareReview draft with CityRevise draftPrepare final report
Gather accounting dataGather allocation dataInput data into softwareReview draft with CityRevise draftPrepare final report
![Page 15: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/15.jpg)
Public Resource Management Group * MGT of America, Inc.
15
Indirect Cost RatesIndirect Cost Rates
Cost plan versus indirect cost ratesCost plans allocate costsIndirect cost rates compare allocated costs to direct cost base, such as salaries and wagesDepartmental indirect cost rates may also include allocated departmental administrative costs
Cost plan versus indirect cost ratesCost plans allocate costsIndirect cost rates compare allocated costs to direct cost base, such as salaries and wagesDepartmental indirect cost rates may also include allocated departmental administrative costs
![Page 16: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/16.jpg)
Public Resource Management Group * MGT of America, Inc.
16
Developing IC RateDeveloping IC Rate
Analyze departmental personnel assignments by:
TimesheetsAssignment of dutiesPercentage of timeTime study sample
Analyze departmental personnel assignments by:
TimesheetsAssignment of dutiesPercentage of timeTime study sample
Distribute supply and service costs
Direct assignmentDistribute on percentage
Distribute supply and service costs
Direct assignmentDistribute on percentage
![Page 17: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/17.jpg)
Public Resource Management Group * MGT of America, Inc.
17
Example IC RateExample IC Rate
A Central Service Costs $321,528
B Payroll Amount $848,238
C Indirect Cost Rate (A/B) 37.91%
![Page 18: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/18.jpg)
Public Resource Management Group * MGT of America, Inc.
18
Uses of IC RateUses of IC Rate
Apply rate to grant direct base to recover indirect costsApply rate to direct cost base to find “full cost” of a service or program
Apply rate to grant direct base to recover indirect costsApply rate to direct cost base to find “full cost” of a service or program
![Page 19: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/19.jpg)
Public Resource Management Group * MGT of America, Inc.
19
PAGES FROM A SAMPLE COST ALLOCATION PLAN
PAGES FROM A SAMPLE COST ALLOCATION PLAN
![Page 20: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/20.jpg)
Public Resource Management Group * MGT of America, Inc.
20
TABLE OF CONTENTSTABLE OF CONTENTS
![Page 21: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/21.jpg)
Public Resource Management Group * MGT of America, Inc.
21
SUMMARY SCHEDULE ASUMMARY SCHEDULE A
![Page 22: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/22.jpg)
Public Resource Management Group * MGT of America, Inc.
22
DEPARTMENT EXPENDITURESDEPARTMENT EXPENDITURES
![Page 23: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/23.jpg)
Public Resource Management Group * MGT of America, Inc.
23
INCOMING COSTSINCOMING COSTS
![Page 24: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/24.jpg)
Public Resource Management Group * MGT of America, Inc.
24
ALLOCATION OF COSTSALLOCATION OF COSTS
![Page 25: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/25.jpg)
Public Resource Management Group * MGT of America, Inc.
25
ALLOCATED COSTS SUMMARYALLOCATED COSTS SUMMARY
![Page 26: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/26.jpg)
Public Resource Management Group * MGT of America, Inc.
26
SUMMARY SCHEDULE ASUMMARY SCHEDULE A
![Page 27: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/27.jpg)
Public Resource Management Group * MGT of America, Inc.
27
ANY ?ANY ?
![Page 28: COST ALLOCATION 101 - · PDF filezCost of support services missing ... Uses for Cost Allocation Plans ... FY 06-07 AAO Budget FY 07-08 AAO Budget FY 08-09 Preliminary](https://reader031.vdocuments.us/reader031/viewer/2022030401/5a75a44a7f8b9a9c548cb035/html5/thumbnails/28.jpg)
Public Resource Management Group * MGT of America, Inc.
28
Departmental COWCAP Allocations (in thousands)
Departmental COWCAP Allocations (in thousands)
DeptFY 05-06
AAO BudgetFY 06-07
AAO Budget FY 07-08
AAO Budget FY 08-09
PreliminaryWTR 2,237$ 1,133$ 1,585$ 2,569$ CWP 1,870 1,658 1,894 2,258HHP 812 537 451 902PUC 1,168 in bureaus in bureaus in bureausSubtotal PUC 6,086 3,329 3,931 5,729REC 2,002 1,304 1,315 1,302TIS 935 859 198 808PRT 1,013 1,278 335 758ECD 328 500 226 566DBI 450 1,083 466 551MTA-PTC 950 805 615 498CPC 484 262 314 380WAR unbilled unbilled 167 307DPW 215 95 10 238RNT 108 179 167 67FIR 112 112 57 61TXC 16 35 104 6LIB 5 8 3 2ASR 484 262 197 0MTA-MUNI in basline in baseline in baseline in baselineTotal Allocated* 13,189$ 10,110$ 8,104$ 11,273$
Citywide Costs 134,532$ 172,222$ 142,954$ 153,361$ % Allocated 9.8% 5.9% 5.7% 7.4%
* excludes Superior Courts