Central Service Agencies Cost Allocation Training Plan

Slide Note
Embed
Share

This training plan by the Department of Finance's Fiscal Systems and Consulting Unit focuses on understanding Central Service Agency costs, cost allocation plan development, workload spreadsheets, data analysis, and due dates. It covers the definition of workloads, expenditures, and centralized services provided to state departments for efficient state operations. The plan includes course objectives, agenda, and detailed descriptions of Central Service Agency costs and functions.


Uploaded on Sep 20, 2024 | 0 Views


Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

E N D

Presentation Transcript


  1. Department of Finance Fiscal Systems and Consulting Unit Pro Rata/SWCAP Training for Central Service Agencies 2016-17 Plan 1

  2. Agenda Central Service Agency/Functions Central Service Costs Allocation Definition of Workload Definition of Expenditures Workload and Expenditure Spreadsheets Data Analysis Transmittal Instructions 2

  3. Course Objectives To understand: Cost Allocation Plan Development How to complete workload and expenditure spreadsheets CSA/FSCU analysis Due dates 3

  4. What is a Central Service Agency (CSA) Cost? 4

  5. Central Service Agency Costs State Administrative Manual Section 8753 Central service costs are those amounts expended by central service departments and the Legislature foroverall administration of state government and for providing centralized services to state departments. These functions are necessary for state operations and are centralized to provide efficient and consistent statewide policy and services. 5

  6. Central Services Function Code Finance (DOF) Central Service Workload Unit Source 004 005 011 Audits Audit Hours DOF/OSAE Budgets Budget Hours DOF/Admin Fiscal Systems & Consulting Unit State Ops $ DOF/Sch. 10 California Technology Agency 105 CA Dept of Technology Financial Information Systems for California Financial Information System for California (SWCAP only) State Controller s Office (SCO) 201 Accounting & Reporting 202 Claim Audits 203 Payroll 204 General Disbursements State Ops $ DOF/Sch. 10 110 State Ops $ DOF/Sch. 10 Transactions SCO Warrants SCO Warrants SCO Warrants SCO

  7. Central Services Function Code State Controller s Office (SCO) Central Service Workload Unit Source 205 211 Field Audits Audit Hours SCO Personnel/Payroll Services Division and Information Systems Division Positions SCO State Treasurer s Office (STO) 301 Investment (Pro Rata Only) 302 Item Processing 303 Treasury/Security Mgmt and Public Finance Division Interest Earned SCO Warrants SCO State Ops $ DOF/Sch. 10 400 State Personnel Board (SPB) Positions SCO California Human Resources (CalHR) formerly DPA Office of Admin Law (OAL) SCO 410 Positions 510 520 Review Hours OAL CA State Library (CSL) State Ops $ DOF/Sch.10

  8. Central Services Function Code Central Service Workload Unit Source Health Benefits (HB) for Annuitants (Retired Employees) Dental Benefits (DB) for Annuitants' (Retired Employees) Health Benefits (HB) for CA State Universities (Retired Employees) HB Costs for Active Employees DB Costs for Active Employees HB Costs for Active Employees SCO/PERS/ CalHR SCO/PERS/ CalHR 600 601 SCO/PERS/ CalHR 602 Department of Justice (DOJ) 605 Legal (SWCAP Only) Attorney Hours DOJ 607 Tort Liability (SWCAP Only) Attorney Hours DOJ 700 Secretary for CA Health & Human Services Agency (Weighted avg of State Ops for depts within the Agency) State Ops/Sch.10 799 Audit Hours California State Auditor CA State Auditor 8

  9. Central Services Function Code Central Service Workload Unit Source Sum of Past Actual Costs for Functions 004-799 800 Legislature (Pro Rata Only) DOF/FSCU Legislative Counsel Bureau (Pro Rata Only) Sum of Past Actual Costs for Functions 004-799 805 DOF/FSCU Sum of Past Actual Costs for Functions 004-799 Sum of Past Actual Costs for Functions 004-799 Governor s Office (Pro Rata Only) Office of Planning & Research (Pro Rata Only) 810 DOF/FSCU 815 DOF/FSCU 9

  10. Central Service Costs Allocation 10

  11. The Pro Rata Plan & the SWCAP Plan Central service costs are allocated through Pro Rata for special funds and through SWCAP for federal funds. We refer to this allocation process as the Pro Rata Plan and the SWCAP Plan. 11

  12. The Pro Rata Plan & the SWCAP Plan -- continued The Plan distributes CSA costs to each state department based on workload. The total allocation for each department is calculated using the formula below. PY is prior year and BY is budget year. PY PY Roll - BY Actual Estimate Forward Estimate = = + Total Allocation 12

  13. The Pro Rata Plan & the SWCAP Plan -- continued In Pro Rata, a department s allocation is then further allocated to each fund within the department. In SWCAP, since only Federal funds are billable, the Federal portion is calculated using the department s ratio of Federal funding to their total State Operations amount. 13

  14. The Pro Rata Plan & the SWCAP Plan -- continued Funds are classified as billable or nonbillable For Pro Rata: Billable funds: Funded by special revenue sources such as fees, licenses, penalties, assessments, interests, etc. Nonbillable funds: General Fund Federal Funds Special Deposit Fund For SWCAP, only federal funds are billable. 14

  15. Pro Rata /SWCAP Reports CSA Reported Expenditure Data CSA Reported Workload Data Budget Data (Schedule 10 download) Miscellaneous Agencies Reported Data PY Actual and BY Estimate PY Actual CSA Cost Allocation SWCAP Pro Rata Reports Reports

  16. What is Workload? 16

  17. Workload Each function code represents a specific type of workload. Workload is obtained from a variety of sources and can be from more than one CSA. 17

  18. Workload - continued Hours Transactions Warrants Positions State Operations Interest earned Other 18

  19. What are Expenditures? 19

  20. Expenditure Data Actual Expenditures (only State Ops): General Fund (GF) Central Service Cost Recovery Fund (CSCRF) Expenditures excluded in plan development: Reimbursements Non-CSA Expenditures/Other Funds Unallowable costs (Title 2 Code of Federal Regulations, Part 200) 20

  21. Expenditure Data continued Reimbursed CSA expenditures are excluded because they represent services the CSA provided and which they received reimbursement. Unallowable CSA expenditures are identified in federal regulation (Title 2 Code of Federal Regulations, Part 200) Some examples: Fines, Penalties Cost of Assets $5,000 and up Lawsuits against the federal government 21

  22. Expenditure Data - continued Actual Expenditures $ XXXX Less: Reimbursements Non-CSA Expenditures/Other Funds XX Unallowable Costs* Adjusted Actual Expenditures** $ XX XX -XXX $ XXXX * SWCAP only ** Distributed in CSA cost allocation plans 22

  23. Workload Spreadsheets 23

  24. Workload Requirements What you need: Workload Data Checklist Workload spreadsheet Crossover table 24

  25. Workload Data Checklist 25

  26. Workload 26

  27. Comparison Non-Reimbursed Autofill from prior worksheet Pre-populated by FSCU 27

  28. Comparison Reimbursed Autofill from prior worksheet Pre-populated by FSCU 28

  29. Department Hours 29

  30. Uniform Codes Manual (UCM) 30

  31. Crossover Table Workload is summarized into approximately 180 primary departments for budgeting purposes. The crossover table is used to consolidate the workload into the primary organization code. 31

  32. Crossover 32

  33. Crossover Example Orig Agcy Pro Rata Original Agency Name Pro Rata Agency 1110 Consumer Affairs - Regulatory Boards, Department of 1110 Consumer Affairs - Regulatory Boards, Department of 1111 Dept. of Consumer Affairs - Bureaus, Prog. Div. 1110 Consumer Affairs - Regulatory Boards, Department of 1120 California Board of Accountancy 1110 Consumer Affairs - Regulatory Boards, Department of 1130 California Board of Architectural Examiners 1110 Consumer Affairs - Regulatory Boards, Department of 1140 State Athletic Commission 1110 Consumer Affairs - Regulatory Boards, Department of 1150 Bureau of Automotive Repair (Moved to 1111) 1110 Consumer Affairs - Regulatory Boards, Department of 1160 Board of Barber Examiners (Moved to 1111) 1110 Consumer Affairs - Regulatory Boards, Department of 1165 Board of Barbering and Cosmetology, State (Moved to 1111) 1110 Consumer Affairs - Regulatory Boards, Department of 1170 Board of Behavioral Sciences 1110 Consumer Affairs - Regulatory Boards, Department of 1180 Cemetery Board (Moved to 1111) 1110 Consumer Affairs - Regulatory Boards, Department of 1190 Bureau of Security & Investigative Serv. (Moved to 1111) 1110 Consumer Affairs - Regulatory Boards, Department of 1200 Bureau of Security & Investigative Serv.( Moved to 1111) 1110 Consumer Affairs - Regulatory Boards, Department of 33

  34. Crossover to 0000 Pro Rata Orig. UCM Title Payment of Interest on PMIA Loans Resources - DOF USE ONLY 3880 0000 General Obligation Bonds Resources - DOF USE ONLY 3882 0000 State Mandated Local Costs Resources - DOF USE ONLY 3884 0000 Miscellaneous Adjustments Resources - DOF USE ONLY 3886 0000 3945 0000 Payment of Interest on PMIA Loans - DO NOT USE 34

  35. Crossover Table If an agency is not listed on the crossover table or workload spreadsheet: Check input Research organization code Call us Place in other entity 35

  36. Description Verification Along with your workload spreadsheets you will receive a Description Verification document. Function descriptions are required in the SWCAP package that is submitted annually to the federal government. 36

  37. Description Verification - continued 37

  38. Description Verification - continued We ask that you verify the descriptions are correct. If necessary, make any required changes to the document. Complete reviewer s name and date, and save your changes. Email the document back to us along with the Workload file. 38

  39. Expenditures Spreadsheets 39

  40. What You Need Expenditure Data Checklist Expenditure spreadsheets (actual and estimated) Expenditure supporting schedules (only some departments) 40

  41. Expenditure Spreadsheets Expenditure Data Checklist Actual Expenditures* (must agree with the year-end financial statements) Estimated Expenditures* Comparison tab *enter data in white cells only 41

  42. Expenditure Data Checklist 42

  43. Actual Expenditures 43

  44. Estimated Expenditures 44

  45. Comparison Tab The comparison tab compares expenditure data from the prior year. Ten percent or less is an acceptable growth rate. Please provide explanation for changes (+/-) beyond 10 percent for both actual and estimated expenditures. 45

  46. Comparison 46

  47. Federal Requirement (Support Schedule) Certain CSAs must complete additional financial statements to support actual expenditures. Expenditure schedules provide a breakdown of cost items reported in the SWCAP plan. 47

  48. Adjustments for Assets Tangible and intangible assets of at least $5,000 are treated as an Unallowable Cost subtracted from CSA expenditures Straight-line depreciation method applied to assets at least $5,000 and added to CSA expenditures. 48

  49. Your Responsibility Check for accuracy/post correctly Explain any variances Workload explanation is needed only if total workload changed by more than plus or minus 10 percent. Expenditure explanation is needed for any change of more than plus or minus 10 percent. Send support documentation if required Call us immediately if workload or expenditure data submitted needs to be changed 49

  50. Transmittal Instructions The workload and expenditure worksheets must be reviewed and approved by the departmental budget officer. Departmental budget officer must email completed workload spreadsheet(s) by and expenditure spreadsheet(s) by the specified deadlines. To: fiproswp@dof.ca.gov Email subject line must include: Function code, Workload or Expenditure , and 4 digit department/agency code e.g., F204 Workload 0840 (SCO) 50

Related


More Related Content