Document Alpinecountyca_doc_b075ece9aa

A COST ANALYSIS for the CITY OF WACO, TEXAS RISK Dd County of Alpine, CA OMB A-87 COST ALLOCATION PLAN BASED FISCAL YEAR 2011/2012 FOR USE IN FISCAL YEAR 2013/2014 © MAXIMUS, INC. 2013 Helping Government Serve the People 17310 Red Hill Avenue, Suite 340 Irvine, CA 92614 (949) 440-0845 ---PAGE BREAK--- © MAXIMUS Consulting Services, Inc. COST PLAN FOR USE IN THE 2013/2014 FISCAL YEAR CERTIFICATION OF COST ALLOCATION PLAN This is to certify that I have reviewed the cost allocation plan submitted herewith and to the best of my knowledge and belief: All costs included in this proposal dated June 27, 2013 to establish cost allocation or billings for 07/01/11 to 06/30/12 are allowable in accordance with the requirements of OMB Circular A-87, “Cost Principles for State and Local Governments” and the Federal award(s) to which they apply. Unallowable costs have been adjusted for in allocating costs as indicated in the costs allocation plan. All costs included in this proposal are properly allocable to Federal awards on the basis of a beneficial or causal relationship between the expenses incurred and the awards to which they are allocated in accordance with applicable requirements. Further, the same costs that have been treated as indirect costs have not been claimed as direct costs. Similar types of costs have been accounted for consistently. I declare that the foregoing is true and correct. Government Unit: County of Alpine Signature: Name of Official: Title: Auditor-Controller Date of Execution: ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Table of Contents 06/27/2013 11:19:47 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023 Summary Data Summary Page # Schedule A - Allocated Costs By Department . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . A 1 Schedule B - Fixed Costs Proposed . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . B 14 Schedule C - Summary Of Allocated Costs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . C 17 Schedule D - Detail Of Allocated Costs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . D 20 Schedule E - Summary Of Allocation Basis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . E 26 BUILDING USE ALLOWANCE Detail Page # Narrative . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1.1 28 Schedule .2 - Detail Costs To Be Allocated. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1.2 29 Schedule .3 - Costs To Be Allocated By Activity. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1.3 30 Schedule .4 - Detail Activity Allocations-COURTHOUSE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1.4.1 32 Schedule .4 - Detail Activity Allocations-LIBRARY . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1.4.2 33 Schedule .4 - Detail Activity Allocations-ADMIN BUILDING . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1.4.3 34 Schedule .4 - Detail Activity Allocations-BV COMM SVCS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1.4.4 35 Schedule .4 - Detail Activity Allocations-SOCIAL SERVICES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1.4.5 36 Schedule .4 - Detail Activity Allocations-PUB HLTH ADDTN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1.4.6 37 Schedule .5 - Allocation Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1.5 38 132-RISK MGMT Detail Page # Narrative . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2.1 39 Schedule .2 - Detail Costs To Be Allocated. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2.2 40 Schedule .3 - Costs To Be Allocated By Activity. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2.3 41 Schedule .4 - Detail Activity Allocations-SFTY & WELLNESS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2.4.1 42 Schedule .4 - Detail Activity Allocations-INSURANCE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2.4.2 44 Schedule .5 - Allocation Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2.5 46 101-BD & CONSULT Detail Page # Narrative . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3.1 48 Schedule .2 - Detail Costs To Be Allocated. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3.2 49 Schedule .3 - Costs To Be Allocated By Activity. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3.3 50 Schedule .4 - Detail Activity Allocations-PERSONNEL SVCS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3.4.1 52 Schedule .4 - Detail Activity Allocations-BUDGET . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3.4.2 54 Schedule .4 - Detail Activity Allocations-MENTAL HLTH . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3.4.3 58 Schedule .5 - Allocation Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3.5 59 103-PERSONNEL Detail Page # Narrative . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4.1 62 Schedule .2 - Detail Costs To Be Allocated. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4.2 63 Schedule .3 - Costs To Be Allocated By Activity. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4.3 64 Schedule .4 - Detail Activity Allocations-PERSONNEL SVCS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4.4.1 65 Schedule .5 - Allocation Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4.5 67 MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Table of Contents 06/27/2013 11:19:47 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023 105-AUDITOR/CONTROLLER Detail Page # Narrative . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5.1 69 Schedule .2 - Detail Costs To Be Allocated. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5.2 70 Schedule .3 - Costs To Be Allocated By Activity. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5.3 71 Schedule .4 - Detail Activity Allocations-ACCTS PAYABLE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5.4.1 73 Schedule .4 - Detail Activity Allocations-PAYROLL SVCS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5.4.2 77 Schedule .4 - Detail Activity Allocations-ACCTG /COST PLN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5.4.3 79 Schedule .4 - Detail Activity Allocations-RISK MGMT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5.4.4 83 Schedule .5 - Allocation Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5.5 84 107-CENTRAL SVCS Detail Page # Narrative . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6.1 87 Schedule .2 - Detail Costs To Be Allocated. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6.2 88 Schedule .3 - Costs To Be Allocated By Activity. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6.3 89 Schedule .4 - Detail Activity Allocations-COMMO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6.4.1 93 Schedule .4 - Detail Activity Allocations-POSTAGE/COPIES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6.4.2 95 Schedule .4 - Detail Activity Allocations-AUDIT/COST PLAN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6.4.3 97 Schedule .4 - Detail Activity Allocations-EDP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6.4.4 101 Schedule .5 - Allocation Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6.5 102 110-TREAS/TAX COLLECTOR Detail Page # Narrative . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7.1 105 Schedule .2 - Detail Costs To Be Allocated. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7.2 106 Schedule .3 - Costs To Be Allocated By Activity. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7.3 107 Schedule .4 - Detail Activity Allocations-WARRANT PROCESS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7.4.1 108 Schedule .5 - Allocation Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7.5 112 119-BUILDINGS & GROUNDS Detail Page # Narrative . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8.1 115 Schedule .2 - Detail Costs To Be Allocated. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8.2 116 Schedule .3 - Costs To Be Allocated By Activity. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8.3 117 Schedule .4 - Detail Activity Allocations-COURTHOUSE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8.4.1 119 Schedule .4 - Detail Activity Allocations-LIBRARY . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8.4.2 120 Schedule .4 - Detail Activity Allocations-ADMIN BUILDING . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8.4.3 121 Schedule .4 - Detail Activity Allocations-JANITORIAL SVCS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8.4.4 122 Schedule .4 - Detail Activity Allocations-B&G SERVICES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8.4.5 123 Schedule .5 - Allocation Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8.5 124 MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- 06/27/2013 11:19:10 AM COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Allocated Costs By Department * Group Version 1.0023-1 Central Service Departments 128-INSURANCE 109-INFORMATION TECHNOLOGY 104-COUNTY CLERK 113-COUNTY ASSESSOR 116-ELECTIONS 126-CHAMBER OF COMMERCE 133-RETIRED BENEFITS BUILDING USE 0 0 575 927 0 0 0 132-RISK MGMT 0 0 520 654 0 0 0 101-BD & CONSULT 0 201 1,027 1,494 51 131 615 103-PERSONNEL 0 0 2,134 3,201 0 0 0 105-AUDITOR/CONTROLLE 0 850 3,888 4,545 1,000 199 2,951 107-CENTRAL SVCS 0 243 1,833 21,227 3,054 159 743 110-TREAS/TAX 0 591 1,279 787 866 59 2,125 119-BUILDINGS & 0 0 19,439 31,351 0 0 0 Total Allocated 0 1,885 30,695 64,186 4,971 548 6,434 Roll Forward ( 3,167) ( 10,416) ( 8,287) ( 5,063) ( 3,015) ( 2,849) ( 9,385) Cost With Roll Forward ( 3,167) ( 8,531) 22,408 59,123 1,956 ( 2,301) ( 2,951) Adjustments 0 0 0 0 0 0 0 Proposed Costs ( 3,167) ( 8,531) 22,408 59,123 1,956 ( 2,301) ( 2,951) Page 1 Schedule A.001 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:10 AM COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Allocated Costs By Department * Group Version 1.0023-1 Central Service Departments 134-SURVEYOR/ENGR 138-GRAND JURY 141-COUNTY COUNSEL 145 GRANT VERTICAL PROSECUTION 146-DISTRICT ATTORNEY 147-PUBLIC DEFENDER 292 ANTI DRUG ABUSE BUILDING USE 0 0 0 0 0 0 0 132-RISK MGMT 0 343 164 0 557 0 343 101-BD & CONSULT 15 19 829 8 1,309 117 479 103-PERSONNEL 0 0 533 0 2,721 0 1,067 105-AUDITOR/CONTROLLE 144 128 2,089 137 6,352 399 2,264 107-CENTRAL SVCS 18 72 868 10 1,794 141 237 110-TREAS/TAX 118 98 610 118 2,794 256 964 119-BUILDINGS & 0 0 0 0 5,649 0 0 Total Allocated 295 660 5,093 273 21,176 913 5,354 Roll Forward ( 3,275) ( 1,753) ( 9,704) ( 3,464) ( 5,401) ( 5,947) ( 4,522) Cost With Roll Forward ( 2,980) ( 1,093) ( 4,611) ( 3,191) 15,775 ( 5,034) 832 Adjustments 0 0 0 0 0 0 0 Proposed Costs ( 2,980) ( 1,093) ( 4,611) ( 3,191) 15,775 ( 5,034) 832 Page 2 Schedule A.002 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:10 AM COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Allocated Costs By Department * Group Version 1.0023-1 Central Service Departments 149-COUNTY SHERIFF 150 JAIL COSTS 294-VICTIM WITNESS 158-PROBATION DEPT 159/163-FIRE 160/164 EMERGENCY SERVICES 165-FIRE/EMS BUILDING USE 620 0 0 40 0 0 0 132-RISK MGMT 8,529 0 388 487 625 14 0 101-BD & CONSULT 7,063 0 685 742 92 147 416 103-PERSONNEL 10,136 0 481 1,067 0 0 1,067 105-AUDITOR/CONTROLLE 23,527 0 3,474 3,712 114 1,485 6,042 107-CENTRAL SVCS 8,153 0 144 736 630 178 733 110-TREAS/TAX 6,335 0 1,220 1,436 19 1,220 5,135 119-BUILDINGS & 47,053 0 0 3,063 0 0 0 Total Allocated 111,416 0 6,392 11,283 1,480 3,044 13,393 Roll Forward ( 70,604) 0 1,488 ( 8,542) ( 16,148) ( 5,318) 0 Cost With Roll Forward 40,812 0 7,880 2,741 ( 14,668) ( 2,274) 13,393 Adjustments 0 0 0 0 0 0 0 Proposed Costs 40,812 0 7,880 2,741 ( 14,668) ( 2,274) 13,393 Page 3 Schedule A.003 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:10 AM COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Allocated Costs By Department * Group Version 1.0023-1 Central Service Departments 166 KIRKWOOD EMS 168 BV EMS 167-BUILDING DEPT 170 AGRICULTURAL COMMISSION 175 CDA 176-PLANNING DEPT 179-LOCAL AGENCY FORMATION BUILDING USE 0 0 0 0 0 0 0 132-RISK MGMT 0 179 442 0 887 1,092 0 101-BD & CONSULT 0 292 996 30 2,085 1,595 2 103-PERSONNEL 0 1,067 1,067 0 4,268 6,402 5,335 105-AUDITOR/CONTROLLE 65 1,184 3,612 52 8,150 5,481 45 107-CENTRAL SVCS 0 26 871 36 3,406 414 8 110-TREAS/TAX 59 177 925 19 2,872 335 40 119-BUILDINGS & 0 0 5,198 0 0 2,546 0 Total Allocated 124 2,925 13,111 137 21,668 17,865 5,430 Roll Forward 0 0 ( 14,283) ( 665) ( 18,059) ( 2,708) ( 318) Cost With Roll Forward 124 2,925 ( 1,172) ( 528) 3,609 15,157 5,112 Adjustments 0 0 0 0 0 0 0 Proposed Costs 124 2,925 ( 1,172) ( 528) 3,609 15,157 5,112 Page 4 Schedule A.004 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:10 AM COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Allocated Costs By Department * Group Version 1.0023-1 Central Service Departments 182-LOCAL HEALTH DEPT 185-SOLID WASTE 186-WELFARE DEPT 187 SOCIAL SERVICES ASSISTANCE 188-GENERAL RELIEF 193/194-COUNTY LIBRARY 195/196-CO PARKS BUILDING USE 0 0 41,208 0 0 940 0 132-RISK MGMT 0 97 3,083 0 0 685 0 101-BD & CONSULT 48 185 5,542 240 0 1,344 32 103-PERSONNEL 0 533 6,509 0 0 2,668 0 105-AUDITOR/CONTROLLE 48 607 21,672 1,859 0 6,653 764 107-CENTRAL SVCS 58 46 8,602 289 0 2,265 179 110-TREAS/TAX 0 40 8,401 1,476 0 2,853 669 119-BUILDINGS & 0 0 31,510 0 0 74,220 31,715 Total Allocated 154 1,508 126,527 3,864 0 91,628 33,359 Roll Forward ( 1,064) 25 ( 54,913) ( 2,663) ( 62) ( 12,280) ( 1,411) Cost With Roll Forward ( 910) 1,533 71,614 1,201 ( 62) 79,348 31,948 Adjustments 0 0 0 0 0 0 0 Proposed Costs ( 910) 1,533 71,614 1,201 ( 62) 79,348 31,948 Page 5 Schedule A.005 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:10 AM COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Allocated Costs By Department * Group Version 1.0023-1 Central Service Departments 198-MUSEUM (120) HEALTH DEPT (121) MENTAL HEALTH (122) DRUGS & ALCOHOL (151) TOBACCO (217) FEDERAL FAMILY PRESERVTN (219/220) ROAD DEPT BUILDING USE 0 10,867 1,096 4,395 0 0 0 132-RISK MGMT 380 1,448 1,043 760 1,728 0 2,800 101-BD & CONSULT 610 2,409 2,436 2,073 1,244 0 6,574 103-PERSONNEL 1,067 4,108 672 1,526 800 0 8,536 105-AUDITOR/CONTROLLE 2,824 13,256 12,094 9,853 6,811 0 22,052 107-CENTRAL SVCS 361 2,212 1,918 1,574 1,155 0 6,107 110-TREAS/TAX 748 6,551 5,174 4,466 3,089 0 9,424 119-BUILDINGS & 30,862 14,035 2,546 5,409 0 0 12,279 Total Allocated 36,852 54,886 26,979 30,056 14,827 0 67,772 Roll Forward 395 ( 22,807) 3,298 ( 3,728) ( 1,680) 0 ( 50,742) Cost With Roll Forward 37,247 32,079 30,277 26,328 13,147 0 17,030 Adjustments 0 0 0 0 0 0 0 Proposed Costs 37,247 32,079 30,277 26,328 13,147 0 17,030 Page 6 Schedule A.006 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:10 AM COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Allocated Costs By Department * Group Version 1.0023-1 Central Service Departments 214 PARKING/RECORDS MGMT (330) FISH & GAME (276) WATER SHED COORD (273) BT EMERGENCY PREP (240) AIRPORT (290) COPS GRANT (291) OTHER STATE GRANTS BUILDING USE 0 0 0 0 0 0 0 132-RISK MGMT 136 0 0 1,120 0 0 186 101-BD & CONSULT 220 127 97 1,981 10 361 470 103-PERSONNEL 1,067 0 0 0 0 1,067 1,067 105-AUDITOR/CONTROLLE 936 343 723 11,168 52 945 1,695 107-CENTRAL SVCS 186 152 258 369 11 244 226 110-TREAS/TAX 177 197 570 4,406 40 157 453 119-BUILDINGS & 0 0 0 0 0 0 0 Total Allocated 2,722 819 1,648 19,044 113 2,774 4,097 Roll Forward 1,505 ( 1,672) ( 1,603) 16,713 ( 993) ( 5,449) ( 8,980) Cost With Roll Forward 4,227 ( 853) 45 35,757 ( 880) ( 2,675) ( 4,883) Adjustments 0 0 0 0 0 0 0 Proposed Costs 4,227 ( 853) 45 35,757 ( 880) ( 2,675) ( 4,883) Page 7 Schedule A.007 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:10 AM COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Allocated Costs By Department * Group Version 1.0023-1 Central Service Departments (295) LAW ENFORCEMENT AB443 (310) MPUD 221 CO ROAD IMPROVEMENT FD (340) CSA #1 216 FEDERAL COPS TECH GRANT 218 IECGP 2010 GRANT (350) ARCD BUILDING USE 0 0 0 0 0 0 0 132-RISK MGMT 1,079 157 0 0 0 0 0 101-BD & CONSULT 2,839 301 131 308 1,670 536 0 103-PERSONNEL 3,735 0 0 0 0 0 0 105-AUDITOR/CONTROLLE 7,298 2,210 737 1,003 1,700 546 0 107-CENTRAL SVCS 1,706 398 159 373 2,017 648 0 110-TREAS/TAX 708 1,396 551 629 0 0 0 119-BUILDINGS & 0 0 0 0 0 0 0 Total Allocated 17,365 4,462 1,578 2,313 5,387 1,730 0 Roll Forward 2,383 709 344 ( 22,842) 0 0 0 Cost With Roll Forward 19,748 5,171 1,922 ( 20,529) 5,387 1,730 0 Adjustments 0 0 0 0 0 0 0 Proposed Costs 19,748 5,171 1,922 ( 20,529) 5,387 1,730 0 Page 8 Schedule A.008 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:10 AM COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Allocated Costs By Department * Group Version 1.0023-1 Central Service Departments (361/370) CO TRANSIT (400'S) SCHOOLS 215 STATE OES 293 OHV GRANT FUND 341 BV PUBLIC SAFETY (500) OTHER TRUST & AGENCY 375 STUPD MITIGATION BUILDING USE 0 0 0 0 0 0 0 132-RISK MGMT 165 896 112 223 2,200 0 0 101-BD & CONSULT 779 1,476 2,472 355 2,153 6 165 103-PERSONNEL 1,067 0 0 0 1,600 0 0 105-AUDITOR/CONTROLLE 2,870 36,420 3,445 1,649 7,101 15,013 210 107-CENTRAL SVCS 640 142 2,780 73 550 8 199 110-TREAS/TAX 1,318 28,739 453 492 531 13,713 40 119-BUILDINGS & 0 0 0 0 0 0 0 Total Allocated 6,839 67,673 9,262 2,792 14,135 28,740 614 Roll Forward 2,664 62,261 4,999 ( 5,518) ( 3,869) 21,549 ( 3,339) Cost With Roll Forward 9,503 129,934 14,261 ( 2,726) 10,266 50,289 ( 2,725) Adjustments 0 0 0 0 0 0 0 Proposed Costs 9,503 129,934 14,261 ( 2,726) 10,266 50,289 ( 2,725) Page 9 Schedule A.009 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:10 AM COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Allocated Costs By Department * Group Version 1.0023-1 Central Service Departments 376 YOUTH OFFENDER BLOCK 377 MENTAL HEALTH SVCS ACT 260 CAPITAL OUTLAY OTHER* 261 HAWKINS PEAK 262 PER CAPITA GRANT 263 MARKLEEVILLE PIPELINE BUILDING USE 0 0 0 0 0 0 0 132-RISK MGMT 0 927 0 0 0 0 0 101-BD & CONSULT 211 2,221 958 62 6,192 0 1,490 103-PERSONNEL 0 6,658 0 0 0 0 0 105-AUDITOR/CONTROLLE 732 11,650 2,288 85 7,340 0 1,711 107-CENTRAL SVCS 256 988 1,157 76 7,483 0 1,799 110-TREAS/TAX 472 5,312 1,201 19 945 0 177 119-BUILDINGS & 0 0 0 0 0 0 0 Total Allocated 1,671 27,756 5,604 242 21,960 0 5,177 Roll Forward ( 4,592) 19,488 1,968 0 12,485 ( 931) 3,398 Cost With Roll Forward ( 2,921) 47,244 7,572 242 34,445 ( 931) 8,575 Adjustments 0 0 0 0 0 0 0 Proposed Costs ( 2,921) 47,244 7,572 242 34,445 ( 931) 8,575 Page 10 Schedule A.010 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:10 AM COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Allocated Costs By Department * Group Version 1.0023-1 Central Service Departments 267 LEVIATHAN PEAK PROJ 297 FEDERAL ANTI-DRUG 298 FEDERAL CAL-MMET 299 DEA GRANTS 271 GRANTS CLEARING 272 SAMSHA GRANT 274 HPP BUILDING USE 0 0 0 0 0 0 0 132-RISK MGMT 0 120 112 0 0 0 186 101-BD & CONSULT 772 494 303 0 502 22 559 103-PERSONNEL 0 0 0 0 0 0 0 105-AUDITOR/CONTROLLE 1,109 1,324 915 0 1,028 130 1,698 107-CENTRAL SVCS 932 392 161 0 606 26 332 110-TREAS/TAX 295 354 157 0 472 98 373 119-BUILDINGS & 0 0 0 0 0 0 0 Total Allocated 3,108 2,684 1,648 0 2,608 276 3,148 Roll Forward 0 0 0 0 ( 3,512) ( 869) ( 2,932) Cost With Roll Forward 3,108 2,684 1,648 0 ( 904) ( 593) 216 Adjustments 0 0 0 0 0 0 0 Proposed Costs 3,108 2,684 1,648 0 ( 904) ( 593) 216 Page 11 Schedule A.011 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:10 AM COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Allocated Costs By Department * Group Version 1.0023-1 Central Service Departments 275 HPP-H1N1 296 COPS (FEDERAL) 311 ASSESSORS SPEC REV 312 RECORDERS SPEC REV 379 SAFER GRANT ALL OTHER SubTotal BUILDING USE 0 0 0 0 0 0 60,668 132-RISK MGMT 0 186 0 0 0 0 35,053 101-BD & CONSULT 57 442 13 7 0 0 73,939 103-PERSONNEL 0 1,067 0 0 0 0 84,293 105-AUDITOR/CONTROLLE 59 1,708 530 115 0 0 308,868 107-CENTRAL SVCS 69 192 16 9 0 0 96,133 110-TREAS/TAX 0 492 472 98 0 0 138,855 119-BUILDINGS & 0 0 0 0 0 0 316,875 Total Allocated 185 4,087 1,031 229 0 0 1,114,684 Roll Forward ( 828) 924 956 22 ( 2,389) ( 2,092) ( 279,079) Cost With Roll Forward ( 643) 5,011 1,987 251 ( 2,389) ( 2,092) 835,605 Adjustments 0 0 0 0 0 0 0 Proposed Costs ( 643) 5,011 1,987 251 ( 2,389) ( 2,092) 835,605 Page 12 Schedule A.012 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:10 AM COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Allocated Costs By Department * Group Version 1.0023-1 Central Service Departments Direct Billed Unallocated Total BUILDING USE 0 0 60,668 132-RISK MGMT 0 0 35,053 101-BD & CONSULT 0 337,308 411,247 103-PERSONNEL 0 0 84,293 105-AUDITOR/CONTROLLE 0 0 308,868 107-CENTRAL SVCS 25,868 2,018 124,019 110-TREAS/TAX 0 196,666 335,521 119-BUILDINGS & 0 0 316,875 Total Allocated 25,868 535,992 1,676,544 Roll Forward 0 0 ( 279,079) Cost With Roll Forward 25,868 535,992 1,397,465 Adjustments 0 0 0 Proposed Costs 25,868 535,992 1,397,465 Page 13 Schedule A.013 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:11 AM Receiving Departments COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Fixed Costs Proposed Version 1.0023-1 Fiscal 2012 Final Costs Fixed Costs Roll Forward w/ Roll Fwd Actual Costs Adjustments Future Period Proposed Costs * Group 128-INSURANCE 0 ( 3,167) 0 ( 3,167) ( 3,167) 3,167 109-INFORMATION TECHNOLOGY 1,885 ( 8,531) 0 ( 8,531) ( 10,416) 12,301 104-COUNTY CLERK 30,695 22,408 0 22,408 ( 8,287) 38,982 113-COUNTY ASSESSOR 64,186 59,123 0 59,123 ( 5,063) 69,249 116-ELECTIONS 4,971 1,956 0 1,956 ( 3,015) 7,986 126-CHAMBER OF COMMERCE 548 ( 2,301) 0 ( 2,301) ( 2,849) 3,397 133-RETIRED BENEFITS 6,434 ( 2,951) 0 ( 2,951) ( 9,385) 15,819 134-SURVEYOR/ENGR 295 ( 2,980) 0 ( 2,980) ( 3,275) 3,570 138-GRAND JURY 660 ( 1,093) 0 ( 1,093) ( 1,753) 2,413 141-COUNTY COUNSEL 5,093 ( 4,611) 0 ( 4,611) ( 9,704) 14,797 145 GRANT VERTICAL 273 ( 3,191) 0 ( 3,191) ( 3,464) 3,737 146-DISTRICT ATTORNEY 21,176 15,775 0 15,775 ( 5,401) 26,577 147-PUBLIC DEFENDER 913 ( 5,034) 0 ( 5,034) ( 5,947) 6,860 292 ANTI DRUG ABUSE 5,354 832 0 832 ( 4,522) 9,876 149-COUNTY SHERIFF 111,416 40,812 0 40,812 ( 70,604) 182,020 150 JAIL COSTS 0 0 0 0 NA NA 294-VICTIM WITNESS 6,392 7,880 0 7,880 1,488 4,904 158-PROBATION DEPT 11,283 2,741 0 2,741 ( 8,542) 19,825 159/163-FIRE 1,480 ( 14,668) 0 ( 14,668) ( 16,148) 17,628 160/164 EMERGENCY SERVICES 3,044 ( 2,274) 0 ( 2,274) ( 5,318) 8,362 165-FIRE/EMS 13,393 13,393 0 13,393 NA NA 166 KIRKWOOD EMS 124 124 0 124 NA NA 168 BV EMS 2,925 2,925 0 2,925 NA NA 167-BUILDING DEPT 13,111 ( 1,172) 0 ( 1,172) ( 14,283) 27,394 170 AGRICULTURAL COMMISSION 137 ( 528) 0 ( 528) ( 665) 802 175 CDA 21,668 3,609 0 3,609 ( 18,059) 39,727 176-PLANNING DEPT 17,865 15,157 0 15,157 ( 2,708) 20,573 179-LOCAL AGENCY FORMATION 5,430 5,112 0 5,112 ( 318) 5,748 182-LOCAL HEALTH DEPT 154 ( 910) 0 ( 910) ( 1,064) 1,218 185-SOLID WASTE 1,508 1,533 0 1,533 25 1,483 186-WELFARE DEPT 126,527 71,614 0 71,614 ( 54,913) 181,440 187 SOCIAL SERVICES ASSISTANCE 3,864 1,201 0 1,201 ( 2,663) 6,527 188-GENERAL RELIEF 0 ( 62) 0 ( 62) ( 62) 62 193/194-COUNTY LIBRARY 91,628 79,348 0 79,348 ( 12,280) 103,908 195/196-CO PARKS 33,359 31,948 0 31,948 ( 1,411) 34,770 198-MUSEUM 36,852 37,247 0 37,247 395 36,457 (120) HEALTH DEPT 54,886 32,079 0 32,079 ( 22,807) 77,693 Page 14 Schedule B.001 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:11 AM Receiving Departments COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Fixed Costs Proposed Version 1.0023-1 Fiscal 2012 Final Costs Fixed Costs Roll Forward w/ Roll Fwd Actual Costs Adjustments Future Period Proposed Costs * Group (121) MENTAL HEALTH 26,979 30,277 0 30,277 3,298 23,681 (122) DRUGS & ALCOHOL 30,056 26,328 0 26,328 ( 3,728) 33,784 (151) TOBACCO 14,827 13,147 0 13,147 ( 1,680) 16,507 (217) FEDERAL FAMILY PRESERVTN 0 0 0 0 NA NA (219/220) ROAD DEPT 67,772 17,030 0 17,030 ( 50,742) 118,514 214 PARKING/RECORDS MGMT 2,722 4,227 0 4,227 1,505 1,217 (330) FISH & GAME 819 ( 853) 0 ( 853) ( 1,672) 2,491 (276) WATER SHED COORD 1,648 45 0 45 ( 1,603) 3,251 (273) BT EMERGENCY PREP 19,044 35,757 0 35,757 16,713 2,331 (240) AIRPORT 113 ( 880) 0 ( 880) ( 993) 1,106 (290) COPS GRANT 2,774 ( 2,675) 0 ( 2,675) ( 5,449) 8,223 (291) OTHER STATE GRANTS 4,097 ( 4,883) 0 ( 4,883) ( 8,980) 13,077 (295) LAW ENFORCEMENT AB443 17,365 19,748 0 19,748 2,383 14,982 (310) MPUD 4,462 5,171 0 5,171 709 3,753 221 CO ROAD IMPROVEMENT FD 1,578 1,922 0 1,922 344 1,234 (340) CSA #1 2,313 ( 20,529) 0 ( 20,529) ( 22,842) 25,155 216 FEDERAL COPS TECH GRANT 5,387 5,387 0 5,387 NA NA 218 IECGP 2010 GRANT 1,730 1,730 0 1,730 NA NA (350) ARCD 0 0 0 0 NA NA (361/370) CO TRANSIT 6,839 9,503 0 9,503 2,664 4,175 (400'S) SCHOOLS 67,673 129,934 0 129,934 62,261 5,412 215 STATE OES 9,262 14,261 0 14,261 4,999 4,263 293 OHV GRANT FUND 2,792 ( 2,726) 0 ( 2,726) ( 5,518) 8,310 341 BV PUBLIC SAFETY 14,135 10,266 0 10,266 ( 3,869) 18,004 (500) OTHER TRUST & AGENCY 28,740 50,289 0 50,289 21,549 7,191 375 STUPD MITIGATION 614 ( 2,725) 0 ( 2,725) ( 3,339) 3,953 376 YOUTH OFFENDER BLOCK 1,671 ( 2,921) 0 ( 2,921) ( 4,592) 6,263 377 MENTAL HEALTH SVCS ACT 27,756 47,244 0 47,244 19,488 8,268 260 CAPITAL OUTLAY 5,604 7,572 0 7,572 1,968 3,636 OTHER* 242 242 0 242 NA NA 261 HAWKINS PEAK 21,960 34,445 0 34,445 12,485 9,475 262 PER CAPITA GRANT 0 ( 931) 0 ( 931) ( 931) 931 263 MARKLEEVILLE PIPELINE 5,177 8,575 0 8,575 3,398 1,779 267 LEVIATHAN PEAK PROJ 3,108 3,108 0 3,108 NA NA 297 FEDERAL ANTI-DRUG 2,684 2,684 0 2,684 NA NA 298 FEDERAL CAL-MMET 1,648 1,648 0 1,648 NA NA 299 DEA GRANTS 0 0 0 0 NA NA Page 15 Schedule B.002 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:11 AM Receiving Departments COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Fixed Costs Proposed Version 1.0023-1 Fiscal 2012 Final Costs Fixed Costs Roll Forward w/ Roll Fwd Actual Costs Adjustments Future Period Proposed Costs * Group 271 GRANTS CLEARING 2,608 ( 904) 0 ( 904) ( 3,512) 6,120 272 SAMSHA GRANT 276 ( 593) 0 ( 593) ( 869) 1,145 274 HPP 3,148 216 0 216 ( 2,932) 6,080 275 HPP-H1N1 185 ( 643) 0 ( 643) ( 828) 1,013 296 COPS (FEDERAL) 4,087 5,011 0 5,011 924 3,163 311 ASSESSORS SPEC REV 1,031 1,987 0 1,987 956 75 312 RECORDERS SPEC REV 229 251 0 251 22 207 379 SAFER GRANT 0 ( 2,389) 0 ( 2,389) ( 2,389) 2,389 ALL OTHER 0 ( 2,092) 0 ( 2,092) ( 2,092) 2,092 Total 1,114,684 25,868 535,992 1,676,544 SubTotal Direct Billed Unallocated 835,605 25,868 535,992 1,397,465 0 835,605 ( 279,079) 1,362,522 Page 16 Schedule B.003 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:11 AM Total Expenditures Department COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Summary Of Allocated Costs * Group Cost Adjustments Total Allocated Version 1.0023-1 BUILDING USE ALLOWANCE 0 63,169 132-RISK MGMT 48,017 ( 13,575) 101-BD & CONSULT 358,450 0 103-PERSONNEL 89,729 0 105-AUDITOR/CONTROLLER 287,264 0 107-CENTRAL SVCS 134,568 35,837 110-TREAS/TAX COLLECTOR 293,951 0 119-BUILDINGS & GROUNDS 397,604 ( 18,470) 128-INSURANCE 0 109-INFORMATION TECHNOLOGY 1,885 104-COUNTY CLERK 30,695 113-COUNTY ASSESSOR 64,186 116-ELECTIONS 4,971 126-CHAMBER OF COMMERCE 548 133-RETIRED BENEFITS 6,434 134-SURVEYOR/ENGR 295 138-GRAND JURY 660 141-COUNTY COUNSEL 5,093 145 GRANT VERTICAL PROSECUTION 273 146-DISTRICT ATTORNEY 21,176 147-PUBLIC DEFENDER 913 292 ANTI DRUG ABUSE 5,354 149-COUNTY SHERIFF 111,416 150 JAIL COSTS 0 294-VICTIM WITNESS 6,392 158-PROBATION DEPT 11,283 159/163-FIRE 1,480 160/164 EMERGENCY SERVICES 3,044 165-FIRE/EMS 13,393 166 KIRKWOOD EMS 124 168 BV EMS 2,925 167-BUILDING DEPT 13,111 170 AGRICULTURAL COMMISSION 137 175 CDA 21,668 176-PLANNING DEPT 17,865 179-LOCAL AGENCY FORMATION 5,430 182-LOCAL HEALTH DEPT 154 Page 17 Schedule C.001 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:11 AM Total Expenditures Department COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Summary Of Allocated Costs * Group Cost Adjustments Total Allocated Version 1.0023-1 185-SOLID WASTE 1,508 186-WELFARE DEPT 126,527 187 SOCIAL SERVICES ASSISTANCE 3,864 188-GENERAL RELIEF 0 193/194-COUNTY LIBRARY 91,628 195/196-CO PARKS 33,359 198-MUSEUM 36,852 (120) HEALTH DEPT 54,886 (121) MENTAL HEALTH 26,979 (122) DRUGS & ALCOHOL 30,056 (151) TOBACCO 14,827 (217) FEDERAL FAMILY PRESERVTN 0 (219/220) ROAD DEPT 67,772 214 PARKING/RECORDS MGMT 2,722 (330) FISH & GAME 819 (276) WATER SHED COORD 1,648 (273) BT EMERGENCY PREP 19,044 (240) AIRPORT 113 (290) COPS GRANT 2,774 (291) OTHER STATE GRANTS 4,097 (295) LAW ENFORCEMENT AB443 17,365 (310) MPUD 4,462 221 CO ROAD IMPROVEMENT FD 1,578 (340) CSA #1 2,313 216 FEDERAL COPS TECH GRANT 5,387 218 IECGP 2010 GRANT 1,730 (350) ARCD 0 (361/370) CO TRANSIT 6,839 (400'S) SCHOOLS 67,673 215 STATE OES 9,262 293 OHV GRANT FUND 2,792 341 BV PUBLIC SAFETY 14,135 (500) OTHER TRUST & AGENCY 28,740 375 STUPD MITIGATION 614 376 YOUTH OFFENDER BLOCK 1,671 377 MENTAL HEALTH SVCS ACT 27,756 260 CAPITAL OUTLAY 5,604 OTHER* 242 Page 18 Schedule C.002 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:11 AM Total Expenditures Department COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Summary Of Allocated Costs * Group Cost Adjustments Total Allocated Version 1.0023-1 261 HAWKINS PEAK 21,960 262 PER CAPITA GRANT 0 263 MARKLEEVILLE PIPELINE 5,177 267 LEVIATHAN PEAK PROJ 3,108 297 FEDERAL ANTI-DRUG 2,684 298 FEDERAL CAL-MMET 1,648 299 DEA GRANTS 0 271 GRANTS CLEARING 2,608 272 SAMSHA GRANT 276 274 HPP 3,148 275 HPP-H1N1 185 296 COPS (FEDERAL) 4,087 311 ASSESSORS SPEC REV 1,031 312 RECORDERS SPEC REV 229 379 SAFER GRANT 0 ALL OTHER 0 25,868 535,992 Direct Billed Total Unallocated Total Totals 1,609,583 66,961 1,676,544 0 Deviation Page 19 Schedule C.003 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:12 AM Department COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Detail Of Allocated Costs * Group Version 1.0023-1 BUILDING USE 132-RISK MGMT 101-BD & CONSULT 103-PERSONNEL105-AUDITOR/CONTRO 1.5 2.5 3.5 4.5 5.5 107-CENTRAL SVCS 6.5 110-TREAS/TAX 7.5 BUILDING USE ( 63,169) 0 0 0 0 0 0 132-RISK MGMT 0 ( 38,203) 324 952 1,656 112 717 101-BD & CONSULT 1,197 1,301 ( 416,733) 5,714 7,159 1,418 1,379 103-PERSONNEL 153 201 480 ( 99,496) 2,138 530 1,122 105-AUDITOR/CONTROLLE 453 602 1,399 3,735 ( 338,762) 29,107 1,030 107-CENTRAL SVCS 322 0 354 0 3,418 ( 187,911) 2,611 110-TREAS/TAX 376 638 1,493 2,668 5,492 31,674 ( 348,892) 119-BUILDINGS & 0 408 1,436 2,134 10,031 1,051 6,512 128-INSURANCE 0 0 0 0 0 0 0 109-INFORMATION 0 0 201 0 850 243 591 104-COUNTY CLERK 575 520 1,027 2,134 3,888 1,833 1,279 113-COUNTY ASSESSOR 927 654 1,494 3,201 4,545 21,227 787 116-ELECTIONS 0 0 51 0 1,000 3,054 866 126-CHAMBER OF 0 0 131 0 199 159 59 133-RETIRED BENEFITS 0 0 615 0 2,951 743 2,125 134-SURVEYOR/ENGR 0 0 15 0 144 18 118 138-GRAND JURY 0 343 19 0 128 72 98 141-COUNTY COUNSEL 0 164 829 533 2,089 868 610 145 GRANT VERTICAL 0 0 8 0 137 10 118 146-DISTRICT ATTORNEY 0 557 1,309 2,721 6,352 1,794 2,794 147-PUBLIC DEFENDER 0 0 117 0 399 141 256 292 ANTI DRUG ABUSE 0 343 479 1,067 2,264 237 964 149-COUNTY SHERIFF 620 8,529 7,063 10,136 23,527 8,153 6,335 150 JAIL COSTS 0 0 0 0 0 0 0 294-VICTIM WITNESS 0 388 685 481 3,474 144 1,220 158-PROBATION DEPT 40 487 742 1,067 3,712 736 1,436 159/163-FIRE 0 625 92 0 114 630 19 160/164 EMERGENCY 0 14 147 0 1,485 178 1,220 165-FIRE/EMS 0 0 416 1,067 6,042 733 5,135 166 KIRKWOOD EMS 0 0 0 0 65 0 59 168 BV EMS 0 179 292 1,067 1,184 26 177 167-BUILDING DEPT 0 442 996 1,067 3,612 871 925 170 AGRICULTURAL 0 0 30 0 52 36 19 175 CDA 0 887 2,085 4,268 8,150 3,406 2,872 176-PLANNING DEPT 0 1,092 1,595 6,402 5,481 414 335 179-LOCAL AGENCY 0 0 2 5,335 45 8 40 182-LOCAL HEALTH DEPT 0 0 48 0 48 58 0 185-SOLID WASTE 0 97 185 533 607 46 40 Page 20 Schedule D.001 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:12 AM Department COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Detail Of Allocated Costs * Group Version 1.0023-1 BUILDING USE 132-RISK MGMT 101-BD & CONSULT 103-PERSONNEL105-AUDITOR/CONTRO 1.5 2.5 3.5 4.5 5.5 107-CENTRAL SVCS 6.5 110-TREAS/TAX 7.5 186-WELFARE DEPT 41,208 3,083 5,542 6,509 21,672 8,602 8,401 187 SOCIAL SERVICES 0 0 240 0 1,859 289 1,476 188-GENERAL RELIEF 0 0 0 0 0 0 0 193/194-COUNTY LIBRARY 940 685 1,344 2,668 6,653 2,265 2,853 195/196-CO PARKS 0 0 32 0 764 179 669 198-MUSEUM 0 380 610 1,067 2,824 361 748 (120) HEALTH DEPT 10,867 1,448 2,409 4,108 13,256 2,212 6,551 (121) MENTAL HEALTH 1,096 1,043 2,436 672 12,094 1,918 5,174 (122) DRUGS & ALCOHOL 4,395 760 2,073 1,526 9,853 1,574 4,466 (151) TOBACCO 0 1,728 1,244 800 6,811 1,155 3,089 (217) FEDERAL FAMILY 0 0 0 0 0 0 0 (219/220) ROAD DEPT 0 2,800 6,574 8,536 22,052 6,107 9,424 214 PARKING/RECORDS 0 136 220 1,067 936 186 177 (330) FISH & GAME 0 0 127 0 343 152 197 (276) WATER SHED COORD 0 0 97 0 723 258 570 (273) BT EMERGENCY 0 1,120 1,981 0 11,168 369 4,406 (240) AIRPORT 0 0 10 0 52 11 40 (290) COPS GRANT 0 0 361 1,067 945 244 157 (291) OTHER STATE 0 186 470 1,067 1,695 226 453 (295) LAW ENFORCEMENT 0 1,079 2,839 3,735 7,298 1,706 708 (310) MPUD 0 157 301 0 2,210 398 1,396 221 CO ROAD 0 0 131 0 737 159 551 (340) CSA #1 0 0 308 0 1,003 373 629 216 FEDERAL COPS TECH 0 0 1,670 0 1,700 2,017 0 218 IECGP 2010 GRANT 0 0 536 0 546 648 0 (350) ARCD 0 0 0 0 0 0 0 (361/370) CO TRANSIT 0 165 779 1,067 2,870 640 1,318 (400'S) SCHOOLS 0 896 1,476 0 36,420 142 28,739 215 STATE OES 0 112 2,472 0 3,445 2,780 453 293 OHV GRANT FUND 0 223 355 0 1,649 73 492 341 BV PUBLIC SAFETY 0 2,200 2,153 1,600 7,101 550 531 (500) OTHER TRUST & 0 0 6 0 15,013 8 13,713 375 STUPD MITIGATION 0 0 165 0 210 199 40 376 YOUTH OFFENDER 0 0 211 0 732 256 472 377 MENTAL HEALTH SVCS 0 927 2,221 6,658 11,650 988 5,312 260 CAPITAL OUTLAY 0 0 958 0 2,288 1,157 1,201 OTHER* 0 0 62 0 85 76 19 261 HAWKINS PEAK 0 0 6,192 0 7,340 7,483 945 Page 21 Schedule D.002 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:12 AM Department COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Detail Of Allocated Costs * Group Version 1.0023-1 BUILDING USE 132-RISK MGMT 101-BD & CONSULT 103-PERSONNEL105-AUDITOR/CONTRO 1.5 2.5 3.5 4.5 5.5 107-CENTRAL SVCS 6.5 110-TREAS/TAX 7.5 262 PER CAPITA GRANT 0 0 0 0 0 0 0 263 MARKLEEVILLE 0 0 1,490 0 1,711 1,799 177 267 LEVIATHAN PEAK PROJ 0 0 772 0 1,109 932 295 297 FEDERAL ANTI-DRUG 0 120 494 0 1,324 392 354 298 FEDERAL CAL-MMET 0 112 303 0 915 161 157 299 DEA GRANTS 0 0 0 0 0 0 0 271 GRANTS CLEARING 0 0 502 0 1,028 606 472 272 SAMSHA GRANT 0 0 22 0 130 26 98 274 HPP 0 186 559 0 1,698 332 373 275 HPP-H1N1 0 0 57 0 59 69 0 296 COPS (FEDERAL) 0 186 442 1,067 1,708 192 492 311 ASSESSORS SPEC REV 0 0 13 0 530 16 472 312 RECORDERS SPEC 0 0 7 0 115 9 98 379 SAFER GRANT 0 0 0 0 0 0 0 ALL OTHER 0 0 0 0 0 0 0 Direct Billings 0 0 0 0 0 25,868 0 Unallocated 0 0 337,308 0 0 2,018 196,666 0 Total 0 0 0 0 0 0 Page 22 Schedule D.003 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:12 AM Department COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Detail Of Allocated Costs * Group Version 1.0023-1 119-BUILDINGS & Total Plan Allocated 8.5 BUILDING USE 0 0 132-RISK MGMT 0 0 101-BD & CONSULT 40,115 0 103-PERSONNEL 5,143 0 105-AUDITOR/CONTROLLE 15,172 0 107-CENTRAL SVCS 10,801 0 110-TREAS/TAX 12,600 0 119-BUILDINGS & ( 400,706) 0 128-INSURANCE 0 0 109-INFORMATION 0 1,885 104-COUNTY CLERK 19,439 30,695 113-COUNTY ASSESSOR 31,351 64,186 116-ELECTIONS 0 4,971 126-CHAMBER OF 0 548 133-RETIRED BENEFITS 0 6,434 134-SURVEYOR/ENGR 0 295 138-GRAND JURY 0 660 141-COUNTY COUNSEL 0 5,093 145 GRANT VERTICAL 0 273 146-DISTRICT ATTORNEY 5,649 21,176 147-PUBLIC DEFENDER 0 913 292 ANTI DRUG ABUSE 0 5,354 149-COUNTY SHERIFF 47,053 111,416 150 JAIL COSTS 0 0 294-VICTIM WITNESS 0 6,392 158-PROBATION DEPT 3,063 11,283 159/163-FIRE 0 1,480 160/164 EMERGENCY 0 3,044 165-FIRE/EMS 0 13,393 166 KIRKWOOD EMS 0 124 168 BV EMS 0 2,925 167-BUILDING DEPT 5,198 13,111 170 AGRICULTURAL 0 137 175 CDA 0 21,668 176-PLANNING DEPT 2,546 17,865 179-LOCAL AGENCY 0 5,430 182-LOCAL HEALTH DEPT 0 154 185-SOLID WASTE 0 1,508 Page 23 Schedule D.004 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:12 AM Department COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Detail Of Allocated Costs * Group Version 1.0023-1 119-BUILDINGS & Total Plan Allocated 8.5 186-WELFARE DEPT 31,510 126,527 187 SOCIAL SERVICES 0 3,864 188-GENERAL RELIEF 0 0 193/194-COUNTY LIBRARY 74,220 91,628 195/196-CO PARKS 31,715 33,359 198-MUSEUM 30,862 36,852 (120) HEALTH DEPT 14,035 54,886 (121) MENTAL HEALTH 2,546 26,979 (122) DRUGS & ALCOHOL 5,409 30,056 (151) TOBACCO 0 14,827 (217) FEDERAL FAMILY 0 0 (219/220) ROAD DEPT 12,279 67,772 214 PARKING/RECORDS 0 2,722 (330) FISH & GAME 0 819 (276) WATER SHED COORD 0 1,648 (273) BT EMERGENCY 0 19,044 (240) AIRPORT 0 113 (290) COPS GRANT 0 2,774 (291) OTHER STATE 0 4,097 (295) LAW ENFORCEMENT 0 17,365 (310) MPUD 0 4,462 221 CO ROAD 0 1,578 (340) CSA #1 0 2,313 216 FEDERAL COPS TECH 0 5,387 218 IECGP 2010 GRANT 0 1,730 (350) ARCD 0 0 (361/370) CO TRANSIT 0 6,839 (400'S) SCHOOLS 0 67,673 215 STATE OES 0 9,262 293 OHV GRANT FUND 0 2,792 341 BV PUBLIC SAFETY 0 14,135 (500) OTHER TRUST & 0 28,740 375 STUPD MITIGATION 0 614 376 YOUTH OFFENDER 0 1,671 377 MENTAL HEALTH SVCS 0 27,756 260 CAPITAL OUTLAY 0 5,604 OTHER* 0 242 261 HAWKINS PEAK 0 21,960 Page 24 Schedule D.005 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- 06/27/2013 11:19:12 AM Department COUNTY OF ALPINE, CALIFORNIA MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Groups OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Detail Of Allocated Costs * Group Version 1.0023-1 119-BUILDINGS & Total Plan Allocated 8.5 262 PER CAPITA GRANT 0 0 263 MARKLEEVILLE 0 5,177 267 LEVIATHAN PEAK PROJ 0 3,108 297 FEDERAL ANTI-DRUG 0 2,684 298 FEDERAL CAL-MMET 0 1,648 299 DEA GRANTS 0 0 271 GRANTS CLEARING 0 2,608 272 SAMSHA GRANT 0 276 274 HPP 0 3,148 275 HPP-H1N1 0 185 296 COPS (FEDERAL) 0 4,087 311 ASSESSORS SPEC REV 0 1,031 312 RECORDERS SPEC 0 229 379 SAFER GRANT 0 0 ALL OTHER 0 0 Direct Billings 0 25,868 Unallocated 0 535,992 0 Total 1,676,544 Page 25 Schedule D.006 All Monetary Values Are $ Dollars MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule E - Summary of Allocation Basis 06/27/2013 11:19:12 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 Allocation Basis: Allocation Source: Department BUILDING USE ALLOWANCE SQUARE FEET AUDITOR'S OFFICE 1.4.1 COURTHOUSE DIRECT ALLOCATION DIRECT ALLOCATION 1.4.2 LIBRARY SQUARE FOOTAGE COUNTY BUILDINGS 1.4.3 ADMIN BUILDING SQUARE FOOTAGE COUNTY BUILDING 1.4.4 BV COMM SVCS SQUARE FOOTAGE COUNTY BUILDING 1.4.5 SOCIAL SERVICES SQUARE FOOTAGE COUNTY BUILDING 1.4.6 PUB HLTH ADDTN 132-RISK MGMT NUMBER OF PAYROLL WARRANTS auditor's office 2.4.1 SFTY & WELLNESS WORKERS' COMP CHARGES Public Budget 2.4.2 INSURANCE 101-BD & CONSULT NUMBER OF PAYROLL WARRANTS AUDITOR'S OFFICE 3.4.1 PERSONNEL SVCS RELATIVE BUDGET SIZE COUNTY BUDGET 3.4.2 BUDGET DIRECT ALLOCATION DIRECT ALLOCATION 3.4.3 MENTAL HLTH 103-PERSONNEL # OF FTE POSITION ALLOCATION LIST 4.4.1 PERSONNEL SVCS 105-AUDITOR/CONTROLLER NUMBER OF NON-PAYROLL WARRANTS County Worksheet 5.4.1 ACCTS PAYABLE NUMBER OF PAYROLL WARRANTS AUDITOR'S OFFICE 5.4.2 PAYROLL SVCS RELATIVE BUDGET SIZE COUNTY BUDGET 5.4.3 ACCTG /COST PLN DIRECT ALLOCATION FOR FURTHER DISTRIBUTION DIRECT 5.4.4 RISK MGMT 107-CENTRAL SVCS NUMBER OF PHONES COUNTY WORKSHEET-AUDITOR 6.4.1 COMMO COSTS ABATED Auditor's Office 6.4.2 POSTAGE/COPIES RELATIVE BUDGET SIZE ($000) APPROVED BUDGET 6.4.3 AUDIT/COST PLAN PERCENT OF USAGE EDP 6.4.4 EDP 110-TREAS/TAX COLLECTOR NUMBER OF NON-PAYROLL WARRANTS County Worksheet 7.4.1 WARRANT PROCESS Page 26 All Monetary Values Are $ Dollars Schedule E.001 MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule E - Summary of Allocation Basis 06/27/2013 11:19:12 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 Allocation Basis: Allocation Source: Department 119-BUILDINGS & GROUNDS SQUARE FEET BUILDINGS 8.4.1 COURTHOUSE SQUARE FEET County Records 8.4.2 LIBRARY SQUARE FEET County Records 8.4.3 ADMIN BUILDING SQUARE FOOTAGE CLEANED AUDITOR CONTROLLER 8.4.4 JANITORIAL SVCS TOTAL SQUARE FOOTAGE OCCUPIED AUDITOR CONTROLLER 8.4.5 B&G SERVICES Page 27 All Monetary Values Are $ Dollars Schedule E.002 MAXCars © 2013 MAXIMUS, INC. Report Output Prepared By MAXIMUS ---PAGE BREAK--- © MAXIMUS Consulting Services, Inc. COST PLAN FOR USE IN THE 2013/2014 FISCAL YEAR Schedule 1.1 Fiscal 2011/12 COUNTY OF ALPINE, CALIFORNIA BUILDING USE ALLOWANCE NATURE AND EXTENT OF SERVICES A Building Use Allowance of two percent per year is allowable for cost plan purposes. The use allowance is applied to all county buildings that were purchased with county funds. The use allowance applicable to buildings occupied by more than one department is allocated to those departments based upon occupied square footage. The use allowance for the Social Services building is based on the annual rental rate and is directly allocated to Social Services*. The use allowance for the Public Health Addition is based on the annual rental rate and is allocated based on square footage*. * On file with the State Controller’s Office. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .2 - Costs To Be Allocated 06/27/2013 11:19:13 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department BUILDING USE ALLOWANCE 1st Allocation Total Sub-Total 2nd Allocation Expenditures Per Financial Statement: 0 0 Total Allocated Additions: 0 0 BUILD USE ALLOWANCE 6,603 SOCIAL SVCS BLDG 41,208 PUBLIC HEALTH ADDTN 15,358 Total Departmental Cost Adjustments: 63,169 63,169 Total To Be Allocated: 63,169 0 63,169 Page 29 Schedule 1.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .3 - Costs Allocated By Activity 06/27/2013 11:19:13 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 General & Admin COURTHOUSE LIBRARY For Department BUILDING USE ALLOWANCE ADMIN BUILDING Wages & Benefits SALARIES & WAGES 0 0 0 0 0 FRINGE BENEFITS 0 0 0 0 0 Departmental Totals Total Expenditures 0 0 0 0 0 Deductions Total Deductions 0 0 0 0 0 Cost Adjustments BUILD USE ALLOWANCE 6,603 0 660 440 4,003 SOCIAL SVCS BLDG 41,208 0 0 0 0 PUBLIC HEALTH ADDTN 15,358 0 0 0 0 Functional Cost 63,169 0 660 440 4,003 Allocation Step 1 1st Allocation 63,169 0 660 440 4,003 Allocation Step 2 2nd Allocation 0 0 0 0 0 Total For 010 BUILDING USE ALLOWANCE Total Allocated 63,169 0 660 440 4,003 Page 30 Schedule 1.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. * - Indicates Disallowed Expenditure ---PAGE BREAK--- BV COMM SVCS COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .3 - Costs Allocated By Activity 06/27/2013 11:19:13 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 SOCIAL SERVICES PUB HLTH ADDTN For Department BUILDING USE ALLOWANCE Wages & Benefits SALARIES & WAGES 0 0 0 FRINGE BENEFITS 0 0 0 Departmental Totals Total Expenditures 0 0 0 Deductions Total Deductions 0 0 0 Cost Adjustments BUILD USE ALLOWANCE 1,500 0 0 SOCIAL SVCS BLDG 0 41,208 0 PUBLIC HEALTH ADDTN 0 0 15,358 Functional Cost 1,500 41,208 15,358 Allocation Step 1 1st Allocation 1,500 41,208 15,358 Allocation Step 2 2nd Allocation 0 0 0 Total For 010 BUILDING USE ALLOWANCE Total Allocated 1,500 41,208 15,358 Page 31 Schedule 1.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:14 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department BUILDING USE ALLOWANCE Activity - COURTHOUSE Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 149-COUNTY SHERIFF 2,335 93.8882 620 620 620 158-PROBATION DEPT 152 6.1118 40 40 40 SubTotal 2,[PHONE REDACTED] 660 660 660 Total 2,[PHONE REDACTED] 660 660 660 Allocation Basis: SQUARE FEET Allocation Source: AUDITOR'S OFFICE Page 32 Schedule 1.4.1 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:15 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department BUILDING USE ALLOWANCE Activity - LIBRARY Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 193/194-COUNTY LIBRARY [PHONE REDACTED] 440 440 440 SubTotal [PHONE REDACTED] 440 440 440 Total [PHONE REDACTED] 440 440 440 Allocation Basis: DIRECT ALLOCATION Allocation Source: DIRECT ALLOCATION Page 33 Schedule 1.4.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:16 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department BUILDING USE ALLOWANCE Activity - ADMIN BUILDING Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 101-BD & CONSULT 1,560 29.9022 1,197 1,197 1,197 103-PERSONNEL 200 3.8336 153 153 153 105-AUDITOR/CONTROLLER 590 11.3092 453 453 453 107-CENTRAL SVCS 420 8.0506 322 322 322 110-TREAS/TAX COLLECTOR 490 9.3924 376 376 376 104-COUNTY CLERK 749 14.3569 575 575 575 113-COUNTY ASSESSOR 1,208 23.1551 927 927 927 SubTotal 5,[PHONE REDACTED] 4,003 4,003 4,003 Total 5,[PHONE REDACTED] 4,003 4,003 4,003 Allocation Basis: SQUARE FOOTAGE Allocation Source: COUNTY BUILDINGS Page 34 Schedule 1.4.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:16 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department BUILDING USE ALLOWANCE Activity - BV COMM SVCS Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 193/194-COUNTY LIBRARY 533 33.3125 500 500 500 (120) HEALTH DEPT 533 33.3125 500 500 500 (121) MENTAL HEALTH 107 6.6875 100 100 100 (122) DRUGS & ALCOHOL 427 26.6875 400 400 400 SubTotal 1,[PHONE REDACTED] 1,500 1,500 1,500 Total 1,[PHONE REDACTED] 1,500 1,500 1,500 Allocation Basis: SQUARE FOOTAGE Allocation Source: COUNTY BUILDING Page 35 Schedule 1.4.4 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:17 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department BUILDING USE ALLOWANCE Activity - SOCIAL SERVICES Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 186-WELFARE DEPT 4,[PHONE REDACTED] 41,208 41,208 41,208 SubTotal 4,[PHONE REDACTED] 41,208 41,208 41,208 Total 4,[PHONE REDACTED] 41,208 41,208 41,208 Allocation Basis: SQUARE FOOTAGE Allocation Source: COUNTY BUILDING Page 36 Schedule 1.4.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:18 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department BUILDING USE ALLOWANCE Activity - PUB HLTH ADDTN Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 (120) HEALTH DEPT 1,863 67.5000 10,367 10,367 10,367 (121) MENTAL HEALTH 179 6.4855 996 996 996 (122) DRUGS & ALCOHOL 718 26.0145 3,995 3,995 3,995 SubTotal 2,[PHONE REDACTED] 15,358 15,358 15,358 Total 2,[PHONE REDACTED] 15,358 15,358 15,358 Allocation Basis: SQUARE FOOTAGE Allocation Source: COUNTY BUILDING Page 37 Schedule 1.4.6 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .5 - Allocation Summary 06/27/2013 11:19:19 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 BV COMM SVCS ADMIN BUILDING LIBRARY COURTHOUSE For Department BUILDING USE ALLOWANCE Receiving Department SOCIAL SERVICES PUB HLTH ADDTN 101-BD & CONSULT 1,197 0 0 1,197 0 0 0 103-PERSONNEL 153 0 0 153 0 0 0 105-AUDITOR/CONTROLLE 453 0 0 453 0 0 0 107-CENTRAL SVCS 322 0 0 322 0 0 0 110-TREAS/TAX 376 0 0 376 0 0 0 104-COUNTY CLERK 575 0 0 575 0 0 0 113-COUNTY ASSESSOR 927 0 0 927 0 0 0 149-COUNTY SHERIFF 620 620 0 0 0 0 0 158-PROBATION DEPT 40 40 0 0 0 0 0 186-WELFARE DEPT 41,208 0 0 0 0 41,208 0 193/194-COUNTY LIBRARY 940 0 440 0 500 0 0 (120) HEALTH DEPT 10,867 0 0 0 500 0 10,367 (121) MENTAL HEALTH 1,096 0 0 0 100 0 996 (122) DRUGS & ALCOHOL 4,395 0 0 0 400 0 3,995 Direct Billed 0 0 0 0 0 0 0 Total 63,169 660 440 4,003 1,500 41,208 15,358 Page 38 Schedule 1.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- © MAXIMUS Consulting Services, Inc. COST PLAN FOR USE IN THE 2013/2014 FISCAL YEAR Schedule 2.1 Fiscal 2011/12 COUNTY OF ALPINE, CALIFORNIA RISK MANAGEMENT NATURE AND EXTENT OF SERVICES Risk Management handles both Safety and Wellness Training and the County’s Insurance. The costs associated with the Safety and Wellness Training is allocated based on the number of payroll warrants. While the costs associated with Insurance is allocated based on the workers’ comp charges per department. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .2 - Costs To Be Allocated 06/27/2013 11:19:19 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 132-RISK MGMT 1st Allocation Total Sub-Total 2nd Allocation Expenditures Per Financial Statement: 48,017 48,017 132-RISK MGMT 184 184 101-BD & CONSULT 324 324 103-PERSONNEL 952 952 105-AUDITOR/CONTROLLER 1,656 1,656 107-CENTRAL SVCS 112 112 110-TREAS/TAX COLLECTOR 717 717 Total Allocated Additions: 3,945 3,945 3,945 Misc Revenue ( 13,575) Total Departmental Cost Adjustments: ( 13,575) ( 13,575) Total To Be Allocated: 34,442 3,945 38,387 Page 40 Schedule 2.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .3 - Costs Allocated By Activity 06/27/2013 11:19:20 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 General & Admin SFTY & WELLNESS INSURANCE For Department 132-RISK MGMT Wages & Benefits SALARIES & WAGES 30,735 0 15,367 15,368 FRINGE BENEFITS 9,738 0 9,738 0 Other Expense & Cost SUPP & SERVICES 7,544 0 3,772 3,772 Departmental Totals Total Expenditures 48,017 0 28,877 19,140 Deductions Total Deductions 0 0 0 0 Cost Adjustments Misc Revenue ( 13,575) 0 ( 6,787) ( 6,788) Functional Cost 34,442 0 22,090 12,352 Allocation Step 1 1st Allocation 34,442 0 22,090 12,352 Allocation Step 2 Inbound- All Others 3,945 3,945 0 0 Reallocate Admin Costs ( 3,945) 1,972 1,973 2nd Allocation 3,945 0 1,972 1,973 Total For 045 132-RISK MGMT Total Allocated 38,387 0 24,062 14,325 Page 41 Schedule 2.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. * - Indicates Disallowed Expenditure ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:20 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 132-RISK MGMT Activity - SFTY & WELLNESS Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 132-RISK MGMT 25 0.7757 171 171 171 101-BD & CONSULT 150 4.6540 1,028 1,028 92 1,120 103-PERSONNEL 25 0.7757 171 171 15 186 105-AUDITOR/CONTROLLER 68 2.1098 466 466 42 508 110-TREAS/TAX COLLECTOR 75 2.3270 514 514 46 560 119-BUILDINGS & GROUNDS 50 1.5514 343 343 31 374 104-COUNTY CLERK 50 1.5514 343 343 31 374 113-COUNTY ASSESSOR 75 2.3270 514 514 46 560 141-COUNTY COUNSEL 20 0.6205 137 137 12 149 146-DISTRICT ATTORNEY 68 2.1098 466 466 42 508 292 ANTI DRUG ABUSE 25 0.7757 171 171 15 186 149-COUNTY SHERIFF 326 10.1148 2,237 2,237 204 2,441 294-VICTIM WITNESS 50 1.5514 343 343 31 374 158-PROBATION DEPT 48 1.4893 329 329 30 359 168 BV EMS 24 0.7446 164 164 15 179 167-BUILDING DEPT 55 1.7065 377 377 34 411 175 CDA 100 3.1027 685 685 62 747 176-PLANNING DEPT 121 3.7543 829 829 75 904 185-SOLID WASTE 13 0.4034 89 89 8 97 186-WELFARE DEPT 237 7.3534 1,624 1,624 146 1,770 193/194-COUNTY LIBRARY 75 2.3270 514 514 46 560 198-MUSEUM 48 1.4893 329 329 30 359 (120) HEALTH DEPT 126 3.9094 864 864 78 942 (121) MENTAL HEALTH 137 4.2507 939 939 84 1,023 (122) DRUGS & ALCOHOL 99 3.0717 679 679 61 740 (151) TOBACCO 75 2.3270 514 514 46 560 (219/220) ROAD DEPT 175 5.4297 1,199 1,199 108 1,307 214 PARKING/RECORDS MGMT 18 0.5585 123 123 11 134 Page 42 Schedule 2.4.1 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:20 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 132-RISK MGMT Activity - SFTY & WELLNESS Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 (273) BT EMERGENCY PREP 150 4.6540 1,028 1,028 92 1,120 (290) COPS GRANT 14 0.4344 96 96 9 105 (291) OTHER STATE GRANTS 25 0.7757 171 171 15 186 (295) LAW ENFORCEMENT AB443 126 3.9094 864 864 78 942 (310) MPUD 13 0.4034 89 89 8 97 (361/370) CO TRANSIT 22 0.6826 151 151 14 165 (400'S) SCHOOLS 120 3.7232 822 822 74 896 215 STATE OES 15 0.4654 103 103 9 112 293 OHV GRANT FUND 26 0.8067 178 178 16 194 341 BV PUBLIC SAFETY 150 4.6540 1,028 1,028 92 1,120 377 MENTAL HEALTH SVCS ACT 124 3.8473 850 850 76 926 297 FEDERAL ANTI-DRUG 15 0.4654 103 103 9 112 298 FEDERAL CAL-MMET 15 0.4654 103 103 9 112 274 HPP 25 0.7757 171 171 15 186 296 COPS (FEDERAL) 25 0.7757 171 171 15 186 SubTotal 3,[PHONE REDACTED] 22,090 22,090 1,972 24,062 Total 3,[PHONE REDACTED] 22,090 22,090 1,972 24,062 Allocation Basis: NUMBER OF PAYROLL WARRANTS Allocation Source: auditor's office Page 43 Schedule 2.4.1 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:21 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 132-RISK MGMT Activity - INSURANCE Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 132-RISK MGMT 289 0.1091 13 13 13 101-BD & CONSULT 3,351 1.2654 156 156 25 181 103-PERSONNEL 289 0.1091 13 13 2 15 105-AUDITOR/CONTROLLER 1,733 0.6544 81 81 13 94 110-TREAS/TAX COLLECTOR 1,444 0.5453 67 67 11 78 119-BUILDINGS & GROUNDS 615 0.2322 29 29 5 34 104-COUNTY CLERK 2,711 1.0237 126 126 20 146 113-COUNTY ASSESSOR 1,733 0.6544 81 81 13 94 138-GRAND JURY 6,355 2.3998 296 296 47 343 141-COUNTY COUNSEL 289 0.1091 13 13 2 15 146-DISTRICT ATTORNEY 901 0.3402 42 42 7 49 292 ANTI DRUG ABUSE 2,886 1.0898 135 135 22 157 149-COUNTY SHERIFF 112,489 42.4779 5,250 5,250 838 6,088 294-VICTIM WITNESS 260 0.0982 12 12 2 14 158-PROBATION DEPT 2,367 0.8938 110 110 18 128 159/163-FIRE 11,554 4.3630 539 539 86 625 160/164 EMERGENCY SERVICES 254 0.0959 12 12 2 14 167-BUILDING DEPT 578 0.2183 27 27 4 31 175 CDA 2,600 0.9818 121 121 19 140 176-PLANNING DEPT 3,466 1.3088 162 162 26 188 186-WELFARE DEPT 24,271 9.1651 1,132 1,132 181 1,313 193/194-COUNTY LIBRARY 2,313 0.8734 108 108 17 125 198-MUSEUM 393 0.1484 18 18 3 21 (120) HEALTH DEPT 9,340 3.5269 436 436 70 506 (121) MENTAL HEALTH 370 0.1397 17 17 3 20 (122) DRUGS & ALCOHOL 370 0.1397 17 17 3 20 (151) TOBACCO 21,593 8.1539 1,007 1,007 161 1,168 (219/220) ROAD DEPT 27,590 10.4184 1,287 1,287 206 1,493 Page 44 Schedule 2.4.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:21 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 132-RISK MGMT Activity - INSURANCE Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 214 PARKING/RECORDS MGMT 46 0.0174 2 2 2 (290) COPS GRANT -1,943 -0.7339 -91 -91 -14 -105 (295) LAW ENFORCEMENT AB443 2,539 0.9588 118 118 19 137 (310) MPUD 1,109 0.4190 52 52 8 60 293 OHV GRANT FUND 534 0.2016 25 25 4 29 341 BV PUBLIC SAFETY 19,962 7.5383 931 931 149 1,080 377 MENTAL HEALTH SVCS ACT 23 0.0087 1 1 1 297 FEDERAL ANTI-DRUG 144 0.0544 7 7 1 8 SubTotal 264,[PHONE REDACTED] 12,352 12,352 1,973 14,325 Total 264,[PHONE REDACTED] 12,352 12,352 1,973 14,325 Allocation Basis: WORKERS' COMP CHARGES Allocation Source: Public Budget Page 45 Schedule 2.4.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .5 - Allocation Summary 06/27/2013 11:19:22 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 INSURANCE SFTY & WELLNESS For Department 132-RISK MGMT Receiving Department 132-RISK MGMT 184 171 13 101-BD & CONSULT 1,301 1,120 181 103-PERSONNEL 201 186 15 105-AUDITOR/CONTROLLE 602 508 94 110-TREAS/TAX 638 560 78 119-BUILDINGS & 408 374 34 104-COUNTY CLERK 520 374 146 113-COUNTY ASSESSOR 654 560 94 138-GRAND JURY 343 0 343 141-COUNTY COUNSEL 164 149 15 146-DISTRICT ATTORNEY 557 508 49 292 ANTI DRUG ABUSE 343 186 157 149-COUNTY SHERIFF 8,529 2,441 6,088 294-VICTIM WITNESS 388 374 14 158-PROBATION DEPT 487 359 128 159/163-FIRE 625 0 625 160/164 EMERGENCY 14 0 14 168 BV EMS 179 179 0 167-BUILDING DEPT 442 411 31 175 CDA 887 747 140 176-PLANNING DEPT 1,092 904 188 185-SOLID WASTE 97 97 0 186-WELFARE DEPT 3,083 1,770 1,313 193/194-COUNTY LIBRARY 685 560 125 198-MUSEUM 380 359 21 (120) HEALTH DEPT 1,448 942 506 (121) MENTAL HEALTH 1,043 1,023 20 (122) DRUGS & ALCOHOL 760 740 20 (151) TOBACCO 1,728 560 1,168 (219/220) ROAD DEPT 2,800 1,307 1,493 214 PARKING/RECORDS 136 134 2 (273) BT EMERGENCY 1,120 1,120 0 (291) OTHER STATE 186 186 0 (295) LAW ENFORCEMENT 1,079 942 137 (310) MPUD 157 97 60 (361/370) CO TRANSIT 165 165 0 Page 46 Schedule 2.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .5 - Allocation Summary 06/27/2013 11:19:22 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 INSURANCE SFTY & WELLNESS For Department 132-RISK MGMT Receiving Department (400'S) SCHOOLS 896 896 0 215 STATE OES 112 112 0 293 OHV GRANT FUND 223 194 29 341 BV PUBLIC SAFETY 2,200 1,120 1,080 377 MENTAL HEALTH SVCS 927 926 1 297 FEDERAL ANTI-DRUG 120 112 8 298 FEDERAL CAL-MMET 112 112 0 274 HPP 186 186 0 296 COPS (FEDERAL) 186 186 0 Direct Billed 0 0 0 Total 38,387 24,062 14,325 Page 47 Schedule 2.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- © MAXIMUS Consulting Services, Inc. COST PLAN FOR USE IN THE 2013/2014 FISCAL YEAR Schedule 3.1 Fiscal 2011/12 COUNTY OF ALPINE, CALIFORNIA BOARD AND CONSULTANT NATURE AND EXTENT OF SERVICES Included in the Board of Supervisor's budget unit is the cost of a consultant, which performs the same services as a County Administrative Officer would in other counties. The allowable costs for administrative services included in the plan are Personnel, and the Purchasing efforts. All Board related services were not considered allowable. Using daily time records the costs are broken down into the following functions functions: Personnel Svcs based on number of payroll warrants (the county did not allocate any time to this function in the current year), Accounting Services Budget/CAP which is based on county budgeted expenditures, Direct Support based on direct hours identified, and Unallowed, which is not allocated. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .2 - Costs To Be Allocated 06/27/2013 11:19:23 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 101-BD & CONSULT 1st Allocation Total Sub-Total 2nd Allocation Expenditures Per Financial Statement: 358,450 358,450 BUILDING USE ALLOWANCE 1,197 1,197 132-RISK MGMT 1,184 117 1,301 101-BD & CONSULT 2,070 2,070 103-PERSONNEL 5,714 5,714 105-AUDITOR/CONTROLLER 7,159 7,159 107-CENTRAL SVCS 1,418 1,418 110-TREAS/TAX COLLECTOR 1,379 1,379 119-BUILDINGS & GROUNDS 40,115 40,115 Total Allocated Additions: 2,381 57,972 60,353 60,353 Total To Be Allocated: 360,831 57,972 418,803 Page 49 Schedule 3.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .3 - Costs Allocated By Activity 06/27/2013 11:19:23 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 General & Admin PERSONNEL SVCS BUDGET For Department 101-BD & CONSULT MENTAL HLTH Wages & Benefits SALARIES & WAGES 203,468 0 20,286 25,454 0 FRINGE BENEFITS 98,724 0 9,843 12,350 0 Other Expense & Cost SERVICES & SUPPLIES 56,258 0 0 0 0 Departmental Totals Total Expenditures 358,450 0 30,129 37,804 0 Deductions Total Deductions 0 0 0 0 0 Functional Cost 358,450 0 30,129 37,804 0 Allocation Step 1 Inbound- All Others 2,381 2,381 0 0 0 Reallocate Admin Costs ( 2,381) 237 298 0 Unallocated Costs ( 292,363) 0 0 0 0 1st Allocation 68,468 0 30,366 38,102 0 Allocation Step 2 Inbound- All Others 57,972 57,972 0 0 0 Reallocate Admin Costs ( 57,972) 5,778 7,249 0 Unallocated Costs ( 44,945) 0 0 0 0 2nd Allocation 13,027 0 5,778 7,249 0 Total For 050 101-BD & CONSULT Total Allocated 81,495 0 36,144 45,351 0 Page 50 Schedule 3.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. * - Indicates Disallowed Expenditure ---PAGE BREAK--- UNALLOWED COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .3 - Costs Allocated By Activity 06/27/2013 11:19:23 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 101-BD & CONSULT Wages & Benefits SALARIES & WAGES 157,728 FRINGE BENEFITS 76,531 Other Expense & Cost SERVICES & SUPPLIES 56,258 Departmental Totals Total Expenditures 290,517 Deductions Total Deductions 0 Functional Cost 290,517 Allocation Step 1 Inbound- All Others 0 Reallocate Admin Costs 1,846 Unallocated Costs ( 292,363) 1st Allocation 0 Allocation Step 2 Inbound- All Others 0 Reallocate Admin Costs 44,945 Unallocated Costs ( 44,945) 2nd Allocation 0 Total For 050 101-BD & CONSULT Total Allocated 0 Page 51 Schedule 3.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:24 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 101-BD & CONSULT Activity - PERSONNEL SVCS Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 132-RISK MGMT 25 0.7757 236 236 236 101-BD & CONSULT 150 4.6540 1,413 1,413 1,413 103-PERSONNEL 25 0.7757 236 236 47 283 105-AUDITOR/CONTROLLER 68 2.1098 641 641 129 770 110-TREAS/TAX COLLECTOR 75 2.3270 707 707 142 849 119-BUILDINGS & GROUNDS 50 1.5514 471 471 95 566 104-COUNTY CLERK 50 1.5514 471 471 95 566 113-COUNTY ASSESSOR 75 2.3270 707 707 142 849 141-COUNTY COUNSEL 20 0.6205 188 188 38 226 146-DISTRICT ATTORNEY 68 2.1098 641 641 129 770 292 ANTI DRUG ABUSE 25 0.7757 236 236 47 283 149-COUNTY SHERIFF 326 10.1148 3,070 3,070 621 3,691 294-VICTIM WITNESS 50 1.5514 471 471 95 566 158-PROBATION DEPT 48 1.4893 452 452 91 543 168 BV EMS 24 0.7446 226 226 45 271 167-BUILDING DEPT 55 1.7065 518 518 104 622 175 CDA 100 3.1027 942 942 190 1,132 176-PLANNING DEPT 121 3.7543 1,140 1,140 229 1,369 185-SOLID WASTE 13 0.4034 122 122 25 147 186-WELFARE DEPT 237 7.3534 2,233 2,233 449 2,682 193/194-COUNTY LIBRARY 75 2.3270 707 707 142 849 198-MUSEUM 48 1.4893 452 452 91 543 (120) HEALTH DEPT 126 3.9094 1,187 1,187 239 1,426 (121) MENTAL HEALTH 137 4.2507 1,291 1,291 260 1,551 (122) DRUGS & ALCOHOL 99 3.0717 933 933 188 1,121 (151) TOBACCO 75 2.3270 707 707 142 849 (219/220) ROAD DEPT 175 5.4297 1,649 1,649 332 1,981 214 PARKING/RECORDS MGMT 18 0.5585 170 170 34 204 Page 52 Schedule 3.4.1 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:24 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 101-BD & CONSULT Activity - PERSONNEL SVCS Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 (273) BT EMERGENCY PREP 150 4.6540 1,413 1,413 284 1,697 (290) COPS GRANT 14 0.4344 132 132 27 159 (291) OTHER STATE GRANTS 25 0.7757 236 236 47 283 (295) LAW ENFORCEMENT AB443 126 3.9094 1,187 1,187 239 1,426 (310) MPUD 13 0.4034 122 122 25 147 (361/370) CO TRANSIT 22 0.6826 207 207 42 249 (400'S) SCHOOLS 120 3.7232 1,131 1,131 227 1,358 215 STATE OES 15 0.4654 141 141 28 169 293 OHV GRANT FUND 26 0.8067 245 245 49 294 341 BV PUBLIC SAFETY 150 4.6540 1,413 1,413 284 1,697 377 MENTAL HEALTH SVCS ACT 124 3.8473 1,168 1,168 235 1,403 297 FEDERAL ANTI-DRUG 15 0.4654 141 141 28 169 298 FEDERAL CAL-MMET 15 0.4654 141 141 28 169 274 HPP 25 0.7757 236 236 47 283 296 COPS (FEDERAL) 25 0.7757 236 236 47 283 SubTotal 3,[PHONE REDACTED] 30,366 30,366 5,778 36,144 Total 3,[PHONE REDACTED] 30,366 30,366 5,778 36,144 Allocation Basis: NUMBER OF PAYROLL WARRANTS Allocation Source: AUDITOR'S OFFICE Page 53 Schedule 3.4.1 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:25 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 101-BD & CONSULT Activity - BUDGET Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 132-RISK MGMT 48,017 0.2311 88 88 88 101-BD & CONSULT 358,450 1.7251 657 657 657 103-PERSONNEL 89,729 0.4318 165 165 32 197 105-AUDITOR/CONTROLLER 287,264 1.3825 527 527 102 629 107-CENTRAL SVCS 161,690 0.7782 296 296 58 354 109-INFORMATION TECHNOLOGY 91,725 0.4414 168 168 33 201 110-TREAS/TAX COLLECTOR 293,951 1.4147 539 539 105 644 119-BUILDINGS & GROUNDS 397,604 1.9135 729 729 141 870 104-COUNTY CLERK 210,460 1.0129 386 386 75 461 113-COUNTY ASSESSOR 294,312 1.4164 540 540 105 645 116-ELECTIONS 23,533 0.1133 43 43 8 51 126-CHAMBER OF COMMERCE 60,000 0.2888 110 110 21 131 133-RETIRED BENEFITS 280,837 1.3516 515 515 100 615 134-SURVEYOR/ENGR 6,852 0.0330 13 13 2 15 138-GRAND JURY 8,883 0.0428 16 16 3 19 141-COUNTY COUNSEL 275,139 1.3241 505 505 98 603 145 GRANT VERTICAL PROSECUTION 3,902 0.0188 7 7 1 8 146-DISTRICT ATTORNEY 246,119 1.1845 451 451 88 539 147-PUBLIC DEFENDER 53,480 0.2574 98 98 19 117 292 ANTI DRUG ABUSE 89,659 0.4315 164 164 32 196 149-COUNTY SHERIFF 1,540,245 7.4126 2,824 2,824 548 3,372 294-VICTIM WITNESS 54,505 0.2623 100 100 19 119 158-PROBATION DEPT 90,913 0.4375 167 167 32 199 159/163-FIRE 41,822 0.2013 77 77 15 92 160/164 EMERGENCY SERVICES 67,263 0.3237 123 123 24 147 165-FIRE/EMS 189,839 0.9136 348 348 68 416 166 KIRKWOOD EMS 204 0.0010 168 BV EMS 9,740 0.0469 18 18 3 21 Page 54 Schedule 3.4.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:25 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 101-BD & CONSULT Activity - BUDGET Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 167-BUILDING DEPT 170,508 0.8206 313 313 61 374 170 AGRICULTURAL COMMISSION 13,727 0.0661 25 25 5 30 175 CDA 434,945 2.0932 798 798 155 953 176-PLANNING DEPT 103,313 0.4972 189 189 37 226 179-LOCAL AGENCY FORMATION 1,063 0.0051 2 2 2 182-LOCAL HEALTH DEPT 21,864 0.1052 40 40 8 48 185-SOLID WASTE 17,355 0.0835 32 32 6 38 186-WELFARE DEPT 1,306,242 6.2864 2,395 2,395 465 2,860 187 SOCIAL SERVICES ASSISTANCE 109,450 0.5267 201 201 39 240 193/194-COUNTY LIBRARY 226,054 1.0879 415 415 80 495 195/196-CO PARKS 14,499 0.0698 27 27 5 32 198-MUSEUM 30,709 0.1478 56 56 11 67 (115) COURT SERVICES 28,578 0.1375 52 52 10 62 (120) HEALTH DEPT 448,688 2.1594 823 823 160 983 (121) MENTAL HEALTH 404,132 1.9449 741 741 144 885 (122) DRUGS & ALCOHOL 434,406 2.0906 797 797 155 952 (151) TOBACCO 180,568 0.8690 331 331 64 395 (219/220) ROAD DEPT 2,097,772 10.0958 3,847 3,847 746 4,593 214 PARKING/RECORDS MGMT 7,104 0.0342 13 13 3 16 (330) FISH & GAME 57,649 0.2774 106 106 21 127 (276) WATER SHED COORD 44,365 0.2135 81 81 16 97 (273) BT EMERGENCY PREP 130,025 0.6258 238 238 46 284 (240) AIRPORT 4,451 0.0214 8 8 2 10 (290) COPS GRANT 92,275 0.4441 169 169 33 202 (291) OTHER STATE GRANTS 85,421 0.4111 157 157 30 187 (295) LAW ENFORCEMENT AB443 645,100 3.1046 1,183 1,183 230 1,413 (310) MPUD 70,389 0.3388 129 129 25 154 221 CO ROAD IMPROVEMENT FD 60,242 0.2899 110 110 21 131 Page 55 Schedule 3.4.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:25 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 101-BD & CONSULT Activity - BUDGET Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 (340) CSA #1 140,870 0.6780 258 258 50 308 216 FEDERAL COPS TECH GRANT 762,849 3.6713 1,399 1,399 271 1,670 218 IECGP 2010 GRANT 245,058 1.1794 449 449 87 536 (361/370) CO TRANSIT 242,221 1.1657 444 444 86 530 (400'S) SCHOOLS 53,864 0.2592 99 99 19 118 215 STATE OES 1,051,728 5.0616 1,929 1,929 374 2,303 293 OHV GRANT FUND 27,944 0.1345 51 51 10 61 341 BV PUBLIC SAFETY 208,087 1.0014 382 382 74 456 (500) OTHER TRUST & AGENCY 2,823 0.0136 5 5 1 6 375 STUPD MITIGATION 74,994 0.3609 138 138 27 165 376 YOUTH OFFENDER BLOCK 96,738 0.4656 177 177 34 211 377 MENTAL HEALTH SVCS ACT 373,564 1.7978 685 685 133 818 260 CAPITAL OUTLAY 437,540 2.1057 802 802 156 958 261 HAWKINS PEAK 2,828,145 13.6106 5,186 5,186 1,006 6,192 263 MARKLEEVILLE PIPELINE 680,596 3.2754 1,248 1,248 242 1,490 267 LEVIATHAN PEAK PROJ 352,622 1.6970 647 647 125 772 297 FEDERAL ANTI-DRUG 148,140 0.7129 272 272 53 325 298 FEDERAL CAL-MMET 61,006 0.2936 112 112 22 134 271 GRANTS CLEARING 229,246 1.1033 420 420 82 502 272 SAMSHA GRANT 10,000 0.0481 18 18 4 22 274 HPP 125,713 0.6050 231 231 45 276 275 HPP-H1N1 26,144 0.1258 48 48 9 57 296 COPS (FEDERAL) 72,453 0.3487 133 133 26 159 311 ASSESSORS SPEC REV 5,998 0.0289 11 11 2 13 312 RECORDERS SPEC REV 3,359 0.0162 6 6 1 7 SubTotal 20,778,[PHONE REDACTED] 38,102 38,102 7,249 45,351 Total 20,778,[PHONE REDACTED] 38,102 38,102 7,249 45,351 Page 56 Schedule 3.4.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations For Department 101-BD & CONSULT Allocation Basis: RELATIVE BUDGET SIZE Allocation Source: COUNTY BUDGET Page 57 Schedule 3.4.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:26 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 101-BD & CONSULT Activity - MENTAL HLTH Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 Activity has no Allocatable Costs SubTotal Total Allocation Basis: DIRECT ALLOCATION Allocation Source: DIRECT ALLOCATION Page 58 Schedule 3.4.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .5 - Allocation Summary 06/27/2013 11:19:26 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 MENTAL HLTH BUDGET PERSONNEL SVCS For Department 101-BD & CONSULT Receiving Department 132-RISK MGMT 324 236 88 0 101-BD & CONSULT 2,070 1,413 657 0 103-PERSONNEL 480 283 197 0 105-AUDITOR/CONTROLLE 1,399 770 629 0 107-CENTRAL SVCS 354 0 354 0 109-INFORMATION 201 0 201 0 110-TREAS/TAX 1,493 849 644 0 119-BUILDINGS & 1,436 566 870 0 104-COUNTY CLERK 1,027 566 461 0 113-COUNTY ASSESSOR 1,494 849 645 0 116-ELECTIONS 51 0 51 0 126-CHAMBER OF 131 0 131 0 133-RETIRED BENEFITS 615 0 615 0 134-SURVEYOR/ENGR 15 0 15 0 138-GRAND JURY 19 0 19 0 141-COUNTY COUNSEL 829 226 603 0 145 GRANT VERTICAL 8 0 8 0 146-DISTRICT ATTORNEY 1,309 770 539 0 147-PUBLIC DEFENDER 117 0 117 0 292 ANTI DRUG ABUSE 479 283 196 0 149-COUNTY SHERIFF 7,063 3,691 3,372 0 294-VICTIM WITNESS 685 566 119 0 158-PROBATION DEPT 742 543 199 0 159/163-FIRE 92 0 92 0 160/164 EMERGENCY 147 0 147 0 165-FIRE/EMS 416 0 416 0 168 BV EMS 292 271 21 0 167-BUILDING DEPT 996 622 374 0 170 AGRICULTURAL 30 0 30 0 175 CDA 2,085 1,132 953 0 176-PLANNING DEPT 1,595 1,369 226 0 179-LOCAL AGENCY 2 0 2 0 182-LOCAL HEALTH DEPT 48 0 48 0 185-SOLID WASTE 185 147 38 0 186-WELFARE DEPT 5,542 2,682 2,860 0 187 SOCIAL SERVICES 240 0 240 0 Page 59 Schedule 3.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .5 - Allocation Summary 06/27/2013 11:19:26 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 MENTAL HLTH BUDGET PERSONNEL SVCS For Department 101-BD & CONSULT Receiving Department 193/194-COUNTY LIBRARY 1,344 849 495 0 195/196-CO PARKS 32 0 32 0 198-MUSEUM 610 543 67 0 (115) COURT SERVICES 62 0 62 0 (120) HEALTH DEPT 2,409 1,426 983 0 (121) MENTAL HEALTH 2,436 1,551 885 0 (122) DRUGS & ALCOHOL 2,073 1,121 952 0 (151) TOBACCO 1,244 849 395 0 (219/220) ROAD DEPT 6,574 1,981 4,593 0 214 PARKING/RECORDS 220 204 16 0 (330) FISH & GAME 127 0 127 0 (276) WATER SHED COORD 97 0 97 0 (273) BT EMERGENCY 1,981 1,697 284 0 (240) AIRPORT 10 0 10 0 (290) COPS GRANT 361 159 202 0 (291) OTHER STATE 470 283 187 0 (295) LAW ENFORCEMENT 2,839 1,426 1,413 0 (310) MPUD 301 147 154 0 221 CO ROAD 131 0 131 0 (340) CSA #1 308 0 308 0 216 FEDERAL COPS TECH 1,670 0 1,670 0 218 IECGP 2010 GRANT 536 0 536 0 (361/370) CO TRANSIT 779 249 530 0 (400'S) SCHOOLS 1,476 1,358 118 0 215 STATE OES 2,472 169 2,303 0 293 OHV GRANT FUND 355 294 61 0 341 BV PUBLIC SAFETY 2,153 1,697 456 0 (500) OTHER TRUST & 6 0 6 0 375 STUPD MITIGATION 165 0 165 0 376 YOUTH OFFENDER 211 0 211 0 377 MENTAL HEALTH SVCS 2,221 1,403 818 0 260 CAPITAL OUTLAY 958 0 958 0 261 HAWKINS PEAK 6,192 0 6,192 0 263 MARKLEEVILLE 1,490 0 1,490 0 267 LEVIATHAN PEAK PROJ 772 0 772 0 297 FEDERAL ANTI-DRUG 494 169 325 0 Page 60 Schedule 3.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .5 - Allocation Summary 06/27/2013 11:19:26 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 MENTAL HLTH BUDGET PERSONNEL SVCS For Department 101-BD & CONSULT Receiving Department 298 FEDERAL CAL-MMET 303 169 134 0 271 GRANTS CLEARING 502 0 502 0 272 SAMSHA GRANT 22 0 22 0 274 HPP 559 283 276 0 275 HPP-H1N1 57 0 57 0 296 COPS (FEDERAL) 442 283 159 0 311 ASSESSORS SPEC REV 13 0 13 0 312 RECORDERS SPEC 7 0 7 0 Direct Billed 0 0 0 0 Total 81,495 36,144 45,351 0 Page 61 Schedule 3.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- © MAXIMUS Consulting Services, Inc. COST PLAN FOR USE IN THE 2013/2014 FISCAL YEAR Schedule 4.1 Fiscal 2011/12 COUNTY OF ALPINE, CALIFORNIA PERSONNEL NATURE AND EXTENT OF SERVICES The department of Personnel provides departmental assistance to all county departments. One function was created to allocate the costs of this department: Personnel Services. The Personnel function is allocated based on the number of budgeted positions. This allocation basis has been updated from prior year for a more accurate allocation to each county department. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .2 - Costs To Be Allocated 06/27/2013 11:19:27 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 103-PERSONNEL 1st Allocation Total Sub-Total 2nd Allocation Expenditures Per Financial Statement: 89,729 89,729 FIXED ASSETS 0 Total Deductions: 0 0 BUILDING USE ALLOWANCE 153 153 132-RISK MGMT 184 17 201 101-BD & CONSULT 401 79 480 103-PERSONNEL 952 952 105-AUDITOR/CONTROLLER 2,138 2,138 107-CENTRAL SVCS 530 530 110-TREAS/TAX COLLECTOR 1,122 1,122 119-BUILDINGS & GROUNDS 5,143 5,143 Total Allocated Additions: 738 9,981 10,719 10,719 Total To Be Allocated: 90,467 9,981 100,448 Page 63 Schedule 4.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .3 - Costs Allocated By Activity 06/27/2013 11:19:28 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 General & Admin PERSONNEL SVCS For Department 103-PERSONNEL Wages & Benefits SALARIES & WAGES 30,735 0 30,735 FRINGE BENEFITS 9,738 0 9,738 Other Expense & Cost SERVICES & SUPP 49,256 0 49,256 FIXED ASSETS 0 0 0 * Departmental Totals Total Expenditures 89,729 0 89,729 Deductions Total Deductions 0 0 0 Functional Cost 89,729 0 89,729 Allocation Step 1 Inbound- All Others 738 738 0 Reallocate Admin Costs ( 738) 738 1st Allocation 90,467 0 90,467 Allocation Step 2 Inbound- All Others 9,981 9,981 0 Reallocate Admin Costs ( 9,981) 9,981 2nd Allocation 9,981 0 9,981 Total For 055 103-PERSONNEL Total Allocated 100,448 0 100,448 Page 64 Schedule 4.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. * - Indicates Disallowed Expenditure ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:28 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 103-PERSONNEL Activity - PERSONNEL SVCS Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 132-RISK MGMT 1.00 1.0526 952 952 952 101-BD & CONSULT 6.00 6.3158 5,714 5,714 5,714 103-PERSONNEL 1.00 1.0526 952 952 952 105-AUDITOR/CONTROLLER 3.50 3.6842 3,333 3,333 402 3,735 110-TREAS/TAX COLLECTOR 2.50 2.6316 2,381 2,381 287 2,668 119-BUILDINGS & GROUNDS 2.00 2.1053 1,905 1,905 229 2,134 104-COUNTY CLERK 2.00 2.1053 1,905 1,905 229 2,134 113-COUNTY ASSESSOR 3.00 3.1579 2,857 2,857 344 3,201 141-COUNTY COUNSEL 0.50 0.5263 476 476 57 533 146-DISTRICT ATTORNEY 2.55 2.6842 2,428 2,428 293 2,721 292 ANTI DRUG ABUSE 1.00 1.0526 952 952 115 1,067 149-COUNTY SHERIFF 9.50 10.0002 9,050 9,050 1,086 10,136 294-VICTIM WITNESS 0.45 0.4737 429 429 52 481 158-PROBATION DEPT 1.00 1.0526 952 952 115 1,067 165-FIRE/EMS 1.00 1.0526 952 952 115 1,067 168 BV EMS 1.00 1.0526 952 952 115 1,067 167-BUILDING DEPT 1.00 1.0526 952 952 115 1,067 175 CDA 4.00 4.2105 3,809 3,809 459 4,268 176-PLANNING DEPT 6.00 6.3158 5,714 5,714 688 6,402 179-LOCAL AGENCY FORMATION 5.00 5.2632 4,761 4,761 574 5,335 185-SOLID WASTE 0.50 0.5263 476 476 57 533 186-WELFARE DEPT 6.10 6.4211 5,809 5,809 700 6,509 193/194-COUNTY LIBRARY 2.50 2.6316 2,381 2,381 287 2,668 198-MUSEUM 1.00 1.0526 952 952 115 1,067 (120) HEALTH DEPT 3.85 4.0526 3,666 3,666 442 4,108 (121) MENTAL HEALTH 0.63 0.6632 600 600 72 672 (122) DRUGS & ALCOHOL 1.43 1.5053 1,362 1,362 164 1,526 (151) TOBACCO 0.75 0.7895 714 714 86 800 Page 65 Schedule 4.4.1 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:28 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 103-PERSONNEL Activity - PERSONNEL SVCS Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 (219/220) ROAD DEPT 8.00 8.4211 7,618 7,618 918 8,536 214 PARKING/RECORDS MGMT 1.00 1.0526 952 952 115 1,067 (290) COPS GRANT 1.00 1.0526 952 952 115 1,067 (291) OTHER STATE GRANTS 1.00 1.0526 952 952 115 1,067 (295) LAW ENFORCEMENT AB443 3.50 3.6842 3,333 3,333 402 3,735 (361/370) CO TRANSIT 1.00 1.0526 952 952 115 1,067 341 BV PUBLIC SAFETY 1.50 1.5789 1,428 1,428 172 1,600 377 MENTAL HEALTH SVCS ACT 6.24 6.5684 5,942 5,942 716 6,658 296 COPS (FEDERAL) 1.00 1.0526 952 952 115 1,067 SubTotal 95.00 100.0000 90,467 90,467 9,981 100,448 Total 95.00 100.0000 90,467 90,467 9,981 100,448 Allocation Basis: # OF FTE Allocation Source: POSITION ALLOCATION LIST Page 66 Schedule 4.4.1 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .5 - Allocation Summary 06/27/2013 11:19:29 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 PERSONNEL SVCS For Department 103-PERSONNEL Receiving Department 132-RISK MGMT 952 952 101-BD & CONSULT 5,714 5,714 103-PERSONNEL 952 952 105-AUDITOR/CONTROLLE 3,735 3,735 110-TREAS/TAX 2,668 2,668 119-BUILDINGS & 2,134 2,134 104-COUNTY CLERK 2,134 2,134 113-COUNTY ASSESSOR 3,201 3,201 141-COUNTY COUNSEL 533 533 146-DISTRICT ATTORNEY 2,721 2,721 292 ANTI DRUG ABUSE 1,067 1,067 149-COUNTY SHERIFF 10,136 10,136 294-VICTIM WITNESS 481 481 158-PROBATION DEPT 1,067 1,067 165-FIRE/EMS 1,067 1,067 168 BV EMS 1,067 1,067 167-BUILDING DEPT 1,067 1,067 175 CDA 4,268 4,268 176-PLANNING DEPT 6,402 6,402 179-LOCAL AGENCY 5,335 5,335 185-SOLID WASTE 533 533 186-WELFARE DEPT 6,509 6,509 193/194-COUNTY LIBRARY 2,668 2,668 198-MUSEUM 1,067 1,067 (120) HEALTH DEPT 4,108 4,108 (121) MENTAL HEALTH 672 672 (122) DRUGS & ALCOHOL 1,526 1,526 (151) TOBACCO 800 800 (219/220) ROAD DEPT 8,536 8,536 214 PARKING/RECORDS 1,067 1,067 (290) COPS GRANT 1,067 1,067 (291) OTHER STATE 1,067 1,067 (295) LAW ENFORCEMENT 3,735 3,735 (361/370) CO TRANSIT 1,067 1,067 341 BV PUBLIC SAFETY 1,600 1,600 377 MENTAL HEALTH SVCS 6,658 6,658 Page 67 Schedule 4.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .5 - Allocation Summary 06/27/2013 11:19:29 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 PERSONNEL SVCS For Department 103-PERSONNEL Receiving Department 296 COPS (FEDERAL) 1,067 1,067 Direct Billed 0 0 Total 100,448 100,448 Page 68 Schedule 4.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- © MAXIMUS Consulting Services, Inc. COST PLAN FOR USE IN THE 2013/2014 FISCAL YEAR Schedule 5.1 Fiscal 2011/12 COUNTY OF ALPINE, CALIFORNIA AUDITOR-CONTROLLER NATURE AND EXTENT OF SERVICES The Auditor-Controller provides accounts payable, payroll, and departmental accounting/budgeting services. These costs are allowable and are allocated in the cost plan. Based on time records the salaries are broken down into five functions; those five functions are as follows: Accounts Payable - number of non-payroll warrants Payroll Services - number of payroll warrants Accounting/Cost Plan - Relative budget size per dept/fund Insurance - Direct Allocation Unallowed - This function was not allocated ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .2 - Costs To Be Allocated 06/27/2013 11:19:29 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 105-AUDITOR/CONTROLLER 1st Allocation Total Sub-Total 2nd Allocation Expenditures Per Financial Statement: 287,264 287,264 FIXED ASSETS 0 Total Deductions: 0 0 BUILDING USE ALLOWANCE 453 453 132-RISK MGMT 547 55 602 101-BD & CONSULT 1,168 231 1,399 103-PERSONNEL 3,333 402 3,735 105-AUDITOR/CONTROLLER 3,885 3,885 107-CENTRAL SVCS 29,107 29,107 110-TREAS/TAX COLLECTOR 1,030 1,030 119-BUILDINGS & GROUNDS 15,172 15,172 Total Allocated Additions: 5,501 49,882 55,383 55,383 Total To Be Allocated: 292,765 49,882 342,647 Page 70 Schedule 5.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .3 - Costs Allocated By Activity 06/27/2013 11:19:30 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 General & Admin ACCTS PAYABLE PAYROLL SVCS For Department 105-AUDITOR/CONTROLLER ACCTG /COST PLN Wages & Benefits SALARIES & WAGES 180,262 21,577 77,892 59,468 21,325 FRINGE BENEFITS 67,140 8,037 29,011 22,149 7,943 Other Expense & Cost SVCS & SUPP 39,862 4,771 17,225 13,150 4,716 FIXED ASSETS 0 0 0 0 0 * Departmental Totals Total Expenditures 287,264 34,385 124,128 94,767 33,984 Deductions Total Deductions 0 0 0 0 0 Functional Cost 287,264 34,385 124,128 94,767 33,984 Allocation Step 1 Inbound- All Others 5,501 5,501 0 0 0 Reallocate Admin Costs ( 39,886) 19,578 14,948 5,360 1st Allocation 292,765 0 143,706 109,715 39,344 Allocation Step 2 Inbound- All Others 49,882 49,882 0 0 0 Reallocate Admin Costs ( 49,882) 24,485 18,694 6,703 2nd Allocation 49,882 0 24,485 18,694 6,703 Total For 060 105-AUDITOR/CONTROLLER Total Allocated 342,647 0 168,191 128,409 46,047 Page 71 Schedule 5.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. * - Indicates Disallowed Expenditure ---PAGE BREAK--- RISK MGMT COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .3 - Costs Allocated By Activity 06/27/2013 11:19:30 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 UNALLOWED For Department 105-AUDITOR/CONTROLLER Wages & Benefits SALARIES & WAGES 0 0 FRINGE BENEFITS 0 0 Other Expense & Cost SVCS & SUPP 0 0 FIXED ASSETS 0 0 * Departmental Totals Total Expenditures 0 0 Deductions Total Deductions 0 0 Functional Cost 0 0 Allocation Step 1 Inbound- All Others 0 0 Reallocate Admin Costs 0 0 1st Allocation 0 0 Allocation Step 2 Inbound- All Others 0 0 Reallocate Admin Costs 0 0 2nd Allocation 0 0 Total For 060 105-AUDITOR/CONTROLLER Total Allocated 0 0 Page 72 Schedule 5.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:31 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 105-AUDITOR/CONTROLLER Activity - ACCTS PAYABLE Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 132-RISK MGMT 39 0.4971 714 714 714 101-BD & CONSULT 75 0.9559 1,374 1,374 1,374 103-PERSONNEL 61 0.7775 1,117 1,117 1,117 105-AUDITOR/CONTROLLER 56 0.7137 1,026 1,026 1,026 107-CENTRAL SVCS 142 1.8098 2,601 2,601 457 3,058 109-INFORMATION TECHNOLOGY 30 0.3824 549 549 96 645 110-TREAS/TAX COLLECTOR 84 1.0706 1,539 1,539 270 1,809 119-BUILDINGS & GROUNDS 331 4.2187 6,063 6,063 1,064 7,127 104-COUNTY CLERK 65 0.8284 1,191 1,191 209 1,400 113-COUNTY ASSESSOR 40 0.5098 733 733 129 862 116-ELECTIONS 44 0.5608 806 806 141 947 126-CHAMBER OF COMMERCE 3 0.0382 55 55 10 65 133-RETIRED BENEFITS 108 1.3765 1,978 1,978 347 2,325 134-SURVEYOR/ENGR 6 0.0765 110 110 19 129 138-GRAND JURY 5 0.0637 92 92 16 108 141-COUNTY COUNSEL 31 0.3951 568 568 100 668 145 GRANT VERTICAL PROSECUTION 6 0.0765 110 110 19 129 146-DISTRICT ATTORNEY 142 1.8098 2,601 2,601 457 3,058 147-PUBLIC DEFENDER 13 0.1657 238 238 42 280 292 ANTI DRUG ABUSE 49 0.6245 897 897 158 1,055 149-COUNTY SHERIFF 322 4.1040 5,898 5,898 1,035 6,933 294-VICTIM WITNESS 62 0.7902 1,136 1,136 199 1,335 158-PROBATION DEPT 73 0.9304 1,337 1,337 235 1,572 159/163-FIRE 1 0.0127 18 18 3 21 160/164 EMERGENCY SERVICES 62 0.7902 1,136 1,136 199 1,335 165-FIRE/EMS 261 3.3265 4,780 4,780 839 5,619 166 KIRKWOOD EMS 3 0.0382 55 55 10 65 168 BV EMS 9 0.1147 165 165 29 194 Page 73 Schedule 5.4.1 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:31 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 105-AUDITOR/CONTROLLER Activity - ACCTS PAYABLE Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 167-BUILDING DEPT 47 0.5990 861 861 151 1,012 170 AGRICULTURAL COMMISSION 1 0.0127 18 18 3 21 175 CDA 146 1.8608 2,674 2,674 469 3,143 176-PLANNING DEPT 17 0.2167 311 311 55 366 179-LOCAL AGENCY FORMATION 2 0.0255 37 37 6 43 185-SOLID WASTE 2 0.0255 37 37 6 43 186-WELFARE DEPT 427 5.4423 7,821 7,821 1,373 9,194 187 SOCIAL SERVICES ASSISTANCE 75 0.9559 1,374 1,374 241 1,615 193/194-COUNTY LIBRARY 145 1.8481 2,656 2,656 466 3,122 195/196-CO PARKS 34 0.4333 623 623 109 732 198-MUSEUM 38 0.4843 696 696 122 818 (115) COURT SERVICES 1 0.0127 18 18 3 21 (120) HEALTH DEPT 333 4.2442 6,099 6,099 1,071 7,170 (121) MENTAL HEALTH 263 3.3520 4,817 4,817 846 5,663 (122) DRUGS & ALCOHOL 227 2.8932 4,158 4,158 730 4,888 (151) TOBACCO 157 2.0010 2,876 2,876 505 3,381 (219/220) ROAD DEPT 479 6.1050 8,773 8,773 1,540 10,313 214 PARKING/RECORDS MGMT 9 0.1147 165 165 29 194 (330) FISH & GAME 10 0.1275 183 183 32 215 (276) WATER SHED COORD 29 0.3696 531 531 93 624 (273) BT EMERGENCY PREP 224 2.8550 4,103 4,103 720 4,823 (240) AIRPORT 2 0.0255 37 37 6 43 (290) COPS GRANT 8 0.1020 147 147 26 173 (291) OTHER STATE GRANTS 23 0.2931 421 421 74 495 (295) LAW ENFORCEMENT AB443 36 0.4588 659 659 116 775 (310) MPUD 71 0.9049 1,300 1,300 228 1,528 221 CO ROAD IMPROVEMENT FD 28 0.3569 513 513 90 603 (340) CSA #1 32 0.4079 586 586 103 689 Page 74 Schedule 5.4.1 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:31 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 105-AUDITOR/CONTROLLER Activity - ACCTS PAYABLE Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 (361/370) CO TRANSIT 67 0.8539 1,227 1,227 215 1,442 (400'S) SCHOOLS 1,461 18.6214 26,753 26,753 4,703 31,456 215 STATE OES 23 0.2931 421 421 74 495 293 OHV GRANT FUND 25 0.3186 458 458 80 538 341 BV PUBLIC SAFETY 27 0.3441 495 495 87 582 (500) OTHER TRUST & AGENCY 697 8.8835 12,766 12,766 2,241 15,007 375 STUPD MITIGATION 2 0.0255 37 37 6 43 376 YOUTH OFFENDER BLOCK 24 0.3059 440 440 77 517 377 MENTAL HEALTH SVCS ACT 270 3.4412 4,945 4,945 868 5,813 260 CAPITAL OUTLAY 61 0.7775 1,117 1,117 196 1,313 261 HAWKINS PEAK 48 0.6118 879 879 154 1,033 263 MARKLEEVILLE PIPELINE 9 0.1147 165 165 29 194 267 LEVIATHAN PEAK PROJ 15 0.1912 275 275 48 323 297 FEDERAL ANTI-DRUG 18 0.2294 330 330 58 388 298 FEDERAL CAL-MMET 8 0.1020 147 147 26 173 271 GRANTS CLEARING 24 0.3059 440 440 77 517 272 SAMSHA GRANT 5 0.0637 92 92 16 108 274 HPP 19 0.2422 348 348 61 409 296 COPS (FEDERAL) 25 0.3186 458 458 80 538 311 ASSESSORS SPEC REV 24 0.3059 440 440 77 517 312 RECORDERS SPEC REV 5 0.0637 92 92 16 108 SubTotal 7,[PHONE REDACTED] 143,706 143,706 24,485 168,191 Total 7,[PHONE REDACTED] 143,706 143,706 24,485 168,191 Page 75 Schedule 5.4.1 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations For Department 105-AUDITOR/CONTROLLER Allocation Basis: NUMBER OF NON-PAYROLL WARRANTS Allocation Source: County Worksheet Page 76 Schedule 5.4.1 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:32 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 105-AUDITOR/CONTROLLER Activity - PAYROLL SVCS Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 132-RISK MGMT 25 0.7757 851 851 851 101-BD & CONSULT 150 4.6540 5,106 5,106 5,106 103-PERSONNEL 25 0.7757 851 851 851 105-AUDITOR/CONTROLLER 68 2.1098 2,315 2,315 2,315 110-TREAS/TAX COLLECTOR 75 2.3270 2,553 2,553 474 3,027 119-BUILDINGS & GROUNDS 50 1.5514 1,702 1,702 316 2,018 104-COUNTY CLERK 50 1.5514 1,702 1,702 316 2,018 113-COUNTY ASSESSOR 75 2.3270 2,553 2,553 474 3,027 141-COUNTY COUNSEL 20 0.6205 681 681 127 808 146-DISTRICT ATTORNEY 68 2.1098 2,315 2,315 430 2,745 292 ANTI DRUG ABUSE 25 0.7757 851 851 158 1,009 149-COUNTY SHERIFF 326 10.1148 11,096 11,096 2,066 13,162 294-VICTIM WITNESS 50 1.5514 1,702 1,702 316 2,018 158-PROBATION DEPT 48 1.4893 1,634 1,634 304 1,938 168 BV EMS 24 0.7446 817 817 152 969 167-BUILDING DEPT 55 1.7065 1,872 1,872 348 2,220 175 CDA 100 3.1027 3,404 3,404 633 4,037 176-PLANNING DEPT 121 3.7543 4,119 4,119 765 4,884 185-SOLID WASTE 13 0.4034 443 443 82 525 186-WELFARE DEPT 237 7.3534 8,068 8,068 1,499 9,567 193/194-COUNTY LIBRARY 75 2.3270 2,553 2,553 474 3,027 198-MUSEUM 48 1.4893 1,634 1,634 304 1,938 (120) HEALTH DEPT 126 3.9094 4,289 4,289 797 5,086 (121) MENTAL HEALTH 137 4.2507 4,664 4,664 867 5,531 (122) DRUGS & ALCOHOL 99 3.0717 3,370 3,370 626 3,996 (151) TOBACCO 75 2.3270 2,553 2,553 474 3,027 (219/220) ROAD DEPT 175 5.4297 5,957 5,957 1,107 7,064 214 PARKING/RECORDS MGMT 18 0.5585 613 613 114 727 Page 77 Schedule 5.4.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:32 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 105-AUDITOR/CONTROLLER Activity - PAYROLL SVCS Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 (273) BT EMERGENCY PREP 150 4.6540 5,106 5,106 949 6,055 (290) COPS GRANT 14 0.4344 477 477 89 566 (291) OTHER STATE GRANTS 25 0.7757 851 851 158 1,009 (295) LAW ENFORCEMENT AB443 126 3.9094 4,289 4,289 797 5,086 (310) MPUD 13 0.4034 443 443 82 525 (361/370) CO TRANSIT 22 0.6826 749 749 139 888 (400'S) SCHOOLS 120 3.7232 4,085 4,085 759 4,844 215 STATE OES 15 0.4654 511 511 95 606 293 OHV GRANT FUND 26 0.8067 885 885 164 1,049 341 BV PUBLIC SAFETY 150 4.6540 5,106 5,106 949 6,055 377 MENTAL HEALTH SVCS ACT 124 3.8473 4,221 4,221 784 5,005 297 FEDERAL ANTI-DRUG 15 0.4654 511 511 95 606 298 FEDERAL CAL-MMET 15 0.4654 511 511 95 606 274 HPP 25 0.7757 851 851 158 1,009 296 COPS (FEDERAL) 25 0.7757 851 851 158 1,009 SubTotal 3,[PHONE REDACTED] 109,715 109,715 18,694 128,409 Total 3,[PHONE REDACTED] 109,715 109,715 18,694 128,409 Allocation Basis: NUMBER OF PAYROLL WARRANTS Allocation Source: AUDITOR'S OFFICE Page 78 Schedule 5.4.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:33 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 105-AUDITOR/CONTROLLER Activity - ACCTG /COST PLN Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 132-RISK MGMT 48,017 0.2311 91 91 91 101-BD & CONSULT 358,450 1.7251 679 679 679 103-PERSONNEL 89,729 0.4318 170 170 170 105-AUDITOR/CONTROLLER 287,264 1.3825 544 544 544 107-CENTRAL SVCS 161,690 0.7782 306 306 54 360 109-INFORMATION TECHNOLOGY 91,725 0.4414 174 174 31 205 110-TREAS/TAX COLLECTOR 293,951 1.4147 557 557 99 656 119-BUILDINGS & GROUNDS 397,604 1.9135 753 753 133 886 104-COUNTY CLERK 210,460 1.0129 399 399 71 470 113-COUNTY ASSESSOR 294,312 1.4164 557 557 99 656 116-ELECTIONS 23,533 0.1133 45 45 8 53 126-CHAMBER OF COMMERCE 60,000 0.2888 114 114 20 134 133-RETIRED BENEFITS 280,837 1.3516 532 532 94 626 134-SURVEYOR/ENGR 6,852 0.0330 13 13 2 15 138-GRAND JURY 8,883 0.0428 17 17 3 20 141-COUNTY COUNSEL 275,139 1.3241 521 521 92 613 145 GRANT VERTICAL PROSECUTION 3,902 0.0188 7 7 1 8 146-DISTRICT ATTORNEY 246,119 1.1845 466 466 83 549 147-PUBLIC DEFENDER 53,480 0.2574 101 101 18 119 292 ANTI DRUG ABUSE 89,659 0.4315 170 170 30 200 149-COUNTY SHERIFF 1,540,245 7.4126 2,916 2,916 516 3,432 294-VICTIM WITNESS 54,505 0.2623 103 103 18 121 158-PROBATION DEPT 90,913 0.4375 172 172 30 202 159/163-FIRE 41,822 0.2013 79 79 14 93 160/164 EMERGENCY SERVICES 67,263 0.3237 127 127 23 150 165-FIRE/EMS 189,839 0.9136 359 359 64 423 166 KIRKWOOD EMS 204 0.0010 168 BV EMS 9,740 0.0469 18 18 3 21 Page 79 Schedule 5.4.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:33 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 105-AUDITOR/CONTROLLER Activity - ACCTG /COST PLN Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 167-BUILDING DEPT 170,508 0.8206 323 323 57 380 170 AGRICULTURAL COMMISSION 13,727 0.0661 26 26 5 31 175 CDA 434,945 2.0932 824 824 146 970 176-PLANNING DEPT 103,313 0.4972 196 196 35 231 179-LOCAL AGENCY FORMATION 1,063 0.0051 2 2 2 182-LOCAL HEALTH DEPT 21,864 0.1052 41 41 7 48 185-SOLID WASTE 17,355 0.0835 33 33 6 39 186-WELFARE DEPT 1,306,242 6.2864 2,473 2,473 438 2,911 187 SOCIAL SERVICES ASSISTANCE 109,450 0.5267 207 207 37 244 193/194-COUNTY LIBRARY 226,054 1.0879 428 428 76 504 195/196-CO PARKS 14,499 0.0698 27 27 5 32 198-MUSEUM 30,709 0.1478 58 58 10 68 (115) COURT SERVICES 28,578 0.1375 54 54 10 64 (120) HEALTH DEPT 448,688 2.1594 850 850 150 1,000 (121) MENTAL HEALTH 404,132 1.9449 765 765 135 900 (122) DRUGS & ALCOHOL 434,406 2.0906 823 823 146 969 (151) TOBACCO 180,568 0.8690 342 342 61 403 (219/220) ROAD DEPT 2,097,772 10.0958 3,972 3,972 703 4,675 214 PARKING/RECORDS MGMT 7,104 0.0342 13 13 2 15 (330) FISH & GAME 57,649 0.2774 109 109 19 128 (276) WATER SHED COORD 44,365 0.2135 84 84 15 99 (273) BT EMERGENCY PREP 130,025 0.6258 246 246 44 290 (240) AIRPORT 4,451 0.0214 8 8 1 9 (290) COPS GRANT 92,275 0.4441 175 175 31 206 (291) OTHER STATE GRANTS 85,421 0.4111 162 162 29 191 (295) LAW ENFORCEMENT AB443 645,100 3.1046 1,221 1,221 216 1,437 (310) MPUD 70,389 0.3388 133 133 24 157 221 CO ROAD IMPROVEMENT FD 60,242 0.2899 114 114 20 134 Page 80 Schedule 5.4.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:33 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 105-AUDITOR/CONTROLLER Activity - ACCTG /COST PLN Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 (340) CSA #1 140,870 0.6780 267 267 47 314 216 FEDERAL COPS TECH GRANT 762,849 3.6713 1,444 1,444 256 1,700 218 IECGP 2010 GRANT 245,058 1.1794 464 464 82 546 (361/370) CO TRANSIT 242,221 1.1657 459 459 81 540 (400'S) SCHOOLS 53,864 0.2592 102 102 18 120 215 STATE OES 1,051,728 5.0616 1,991 1,991 353 2,344 293 OHV GRANT FUND 27,944 0.1345 53 53 9 62 341 BV PUBLIC SAFETY 208,087 1.0014 394 394 70 464 (500) OTHER TRUST & AGENCY 2,823 0.0136 5 5 1 6 375 STUPD MITIGATION 74,994 0.3609 142 142 25 167 376 YOUTH OFFENDER BLOCK 96,738 0.4656 183 183 32 215 377 MENTAL HEALTH SVCS ACT 373,564 1.7978 707 707 125 832 260 CAPITAL OUTLAY 437,540 2.1057 828 828 147 975 261 HAWKINS PEAK 2,828,145 13.6106 5,358 5,358 949 6,307 263 MARKLEEVILLE PIPELINE 680,596 3.2754 1,289 1,289 228 1,517 267 LEVIATHAN PEAK PROJ 352,622 1.6970 668 668 118 786 297 FEDERAL ANTI-DRUG 148,140 0.7129 280 280 50 330 298 FEDERAL CAL-MMET 61,006 0.2936 116 116 20 136 271 GRANTS CLEARING 229,246 1.1033 434 434 77 511 272 SAMSHA GRANT 10,000 0.0481 19 19 3 22 274 HPP 125,713 0.6050 238 238 42 280 275 HPP-H1N1 26,144 0.1258 50 50 9 59 296 COPS (FEDERAL) 72,453 0.3487 137 137 24 161 311 ASSESSORS SPEC REV 5,998 0.0289 11 11 2 13 312 RECORDERS SPEC REV 3,359 0.0162 6 6 1 7 SubTotal 20,778,[PHONE REDACTED] 39,344 39,344 6,703 46,047 Total 20,778,[PHONE REDACTED] 39,344 39,344 6,703 46,047 Page 81 Schedule 5.4.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations For Department 105-AUDITOR/CONTROLLER Allocation Basis: RELATIVE BUDGET SIZE Allocation Source: COUNTY BUDGET Page 82 Schedule 5.4.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:33 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 105-AUDITOR/CONTROLLER Activity - RISK MGMT Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 Activity has no Allocatable Costs SubTotal Total Allocation Basis: DIRECT ALLOCATION FOR FURTHER DISTRIBUTION Allocation Source: DIRECT Page 83 Schedule 5.4.4 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .5 - Allocation Summary 06/27/2013 11:19:34 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 RISK MGMT ACCTG /COST PLN PAYROLL SVCS ACCTS PAYABLE For Department 105-AUDITOR/CONTROLLER Receiving Department 132-RISK MGMT 1,656 714 851 91 0 101-BD & CONSULT 7,159 1,374 5,106 679 0 103-PERSONNEL 2,138 1,117 851 170 0 105-AUDITOR/CONTROLLE 3,885 1,026 2,315 544 0 107-CENTRAL SVCS 3,418 3,058 0 360 0 109-INFORMATION 850 645 0 205 0 110-TREAS/TAX 5,492 1,809 3,027 656 0 119-BUILDINGS & 10,031 7,127 2,018 886 0 104-COUNTY CLERK 3,888 1,400 2,018 470 0 113-COUNTY ASSESSOR 4,545 862 3,027 656 0 116-ELECTIONS 1,000 947 0 53 0 126-CHAMBER OF 199 65 0 134 0 133-RETIRED BENEFITS 2,951 2,325 0 626 0 134-SURVEYOR/ENGR 144 129 0 15 0 138-GRAND JURY 128 108 0 20 0 141-COUNTY COUNSEL 2,089 668 808 613 0 145 GRANT VERTICAL 137 129 0 8 0 146-DISTRICT ATTORNEY 6,352 3,058 2,745 549 0 147-PUBLIC DEFENDER 399 280 0 119 0 292 ANTI DRUG ABUSE 2,264 1,055 1,009 200 0 149-COUNTY SHERIFF 23,527 6,933 13,162 3,432 0 294-VICTIM WITNESS 3,474 1,335 2,018 121 0 158-PROBATION DEPT 3,712 1,572 1,938 202 0 159/163-FIRE 114 21 0 93 0 160/164 EMERGENCY 1,485 1,335 0 150 0 165-FIRE/EMS 6,042 5,619 0 423 0 166 KIRKWOOD EMS 65 65 0 0 0 168 BV EMS 1,184 194 969 21 0 167-BUILDING DEPT 3,612 1,012 2,220 380 0 170 AGRICULTURAL 52 21 0 31 0 175 CDA 8,150 3,143 4,037 970 0 176-PLANNING DEPT 5,481 366 4,884 231 0 179-LOCAL AGENCY 45 43 0 2 0 182-LOCAL HEALTH DEPT 48 0 0 48 0 185-SOLID WASTE 607 43 525 39 0 186-WELFARE DEPT 21,672 9,194 9,567 2,911 0 Page 84 Schedule 5.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .5 - Allocation Summary 06/27/2013 11:19:34 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 RISK MGMT ACCTG /COST PLN PAYROLL SVCS ACCTS PAYABLE For Department 105-AUDITOR/CONTROLLER Receiving Department 187 SOCIAL SERVICES 1,859 1,615 0 244 0 193/194-COUNTY LIBRARY 6,653 3,122 3,027 504 0 195/196-CO PARKS 764 732 0 32 0 198-MUSEUM 2,824 818 1,938 68 0 (115) COURT SERVICES 85 21 0 64 0 (120) HEALTH DEPT 13,256 7,170 5,086 1,000 0 (121) MENTAL HEALTH 12,094 5,663 5,531 900 0 (122) DRUGS & ALCOHOL 9,853 4,888 3,996 969 0 (151) TOBACCO 6,811 3,381 3,027 403 0 (219/220) ROAD DEPT 22,052 10,313 7,064 4,675 0 214 PARKING/RECORDS 936 194 727 15 0 (330) FISH & GAME 343 215 0 128 0 (276) WATER SHED COORD 723 624 0 99 0 (273) BT EMERGENCY 11,168 4,823 6,055 290 0 (240) AIRPORT 52 43 0 9 0 (290) COPS GRANT 945 173 566 206 0 (291) OTHER STATE 1,695 495 1,009 191 0 (295) LAW ENFORCEMENT 7,298 775 5,086 1,437 0 (310) MPUD 2,210 1,528 525 157 0 221 CO ROAD 737 603 0 134 0 (340) CSA #1 1,003 689 0 314 0 216 FEDERAL COPS TECH 1,700 0 0 1,700 0 218 IECGP 2010 GRANT 546 0 0 546 0 (361/370) CO TRANSIT 2,870 1,442 888 540 0 (400'S) SCHOOLS 36,420 31,456 4,844 120 0 215 STATE OES 3,445 495 606 2,344 0 293 OHV GRANT FUND 1,649 538 1,049 62 0 341 BV PUBLIC SAFETY 7,101 582 6,055 464 0 (500) OTHER TRUST & 15,013 15,007 0 6 0 375 STUPD MITIGATION 210 43 0 167 0 376 YOUTH OFFENDER 732 517 0 215 0 377 MENTAL HEALTH SVCS 11,650 5,813 5,005 832 0 260 CAPITAL OUTLAY 2,288 1,313 0 975 0 261 HAWKINS PEAK 7,340 1,033 0 6,307 0 263 MARKLEEVILLE 1,711 194 0 1,517 0 267 LEVIATHAN PEAK PROJ 1,109 323 0 786 0 Page 85 Schedule 5.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .5 - Allocation Summary 06/27/2013 11:19:34 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 RISK MGMT ACCTG /COST PLN PAYROLL SVCS ACCTS PAYABLE For Department 105-AUDITOR/CONTROLLER Receiving Department 297 FEDERAL ANTI-DRUG 1,324 388 606 330 0 298 FEDERAL CAL-MMET 915 173 606 136 0 271 GRANTS CLEARING 1,028 517 0 511 0 272 SAMSHA GRANT 130 108 0 22 0 274 HPP 1,698 409 1,009 280 0 275 HPP-H1N1 59 0 0 59 0 296 COPS (FEDERAL) 1,708 538 1,009 161 0 311 ASSESSORS SPEC REV 530 517 0 13 0 312 RECORDERS SPEC 115 108 0 7 0 Direct Billed 0 0 0 0 0 Total 342,647 168,191 128,409 46,047 0 Page 86 Schedule 5.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- © MAXIMUS Consulting Services, Inc. COST PLAN FOR USE IN THE 2013/2014 FISCAL YEAR Schedule 6.1 Fiscal 2011/12 COUNTY OF ALPINE, CALIFORNIA CENTRAL SERVICES NATURE AND EXTENT OF SERVICES This budget unit contains the allowable costs of Communications, Postage and the EDP Maintenance Contract. Communications costs are allocated to departments based on the number of phones and EDP costs are allocated based on percent of usage. The County is charging for copies, postage and FAX costs. The costs are allocated on that basis and then subsequently deducted. The credits do not show up in the actual cost of the budget as they are abated against the expense accounts. The county’s audit costs are allocated on the relative budget size. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .2 - Costs To Be Allocated 06/27/2013 11:19:34 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 107-CENTRAL SVCS 1st Allocation Total Sub-Total 2nd Allocation Expenditures Per Financial Statement: 134,568 134,568 FIXED ASSETS 0 INTERFUND TRANSFERS 10,472 VEHICLE GAS ( 504) Total Deductions: 9,968 9,968 BUILDING USE ALLOWANCE 322 322 101-BD & CONSULT 296 58 354 105-AUDITOR/CONTROLLER 2,907 511 3,418 107-CENTRAL SVCS 7,416 7,416 110-TREAS/TAX COLLECTOR 2,611 2,611 119-BUILDINGS & GROUNDS 10,801 10,801 Total Allocated Additions: 3,525 21,397 24,922 24,922 COST ABATEMENTS 25,869 Total Departmental Cost Adjustments: 25,869 25,869 Total To Be Allocated: 173,930 21,397 195,327 Page 88 Schedule 6.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .3 - Costs Allocated By Activity 06/27/2013 11:19:35 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 General & Admin COMMO POSTAGE/COPIES For Department 107-CENTRAL SVCS AUDIT/COST PLAN Wages & Benefits SALARIES & WAGES 0 0 0 0 0 FRINGE BENEFITS 0 0 0 0 0 Other Expense & Cost COMMUNICATIONS 13,108 0 13,108 0 0 SERVICE & SUPPLIES 17,324 5,881 0 9,743 0 PROF SERVICES 53,146 0 0 0 0 AUDIT 45,800 0 0 0 45,800 COST PLAN 233 0 0 0 233 RENTS & LEASES 6,542 0 0 6,542 0 MAINT AGREEMENTS 8,383 0 0 0 0 FIXED ASSETS 0 0 0 0 0 * INTERFUND TRANSFERS ( 10,472) ( 10,472) 0 0 0 * VEHICLE GAS 504 504 0 0 0 * Departmental Totals Total Expenditures 134,568 ( 4,087) 13,108 16,285 46,033 Deductions Total Deductions 9,968 9,968 0 0 0 Cost Adjustments COST ABATEMENTS 25,869 0 0 25,869 0 Functional Cost 170,405 5,881 13,108 42,154 46,033 Allocation Step 1 Inbound- All Others 3,525 3,525 0 0 0 Reallocate Admin Costs ( 9,406) 749 2,410 2,632 Unallocated Costs ( 1,797) 0 0 0 0 1st Allocation 172,133 0 13,857 44,564 48,665 Allocation Step 2 Inbound- All Others 21,397 21,397 0 0 0 Reallocate Admin Costs ( 21,397) 1,705 5,482 5,987 Unallocated Costs ( 221) 0 0 0 0 2nd Allocation 21,176 0 1,705 5,482 5,987 Page 89 Schedule 6.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. * - Indicates Disallowed Expenditure ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .3 - Costs Allocated By Activity 06/27/2013 11:19:35 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 General & Admin COMMO POSTAGE/COPIES For Department 107-CENTRAL SVCS AUDIT/COST PLAN Total For 070 107-CENTRAL SVCS Total Allocated 193,309 0 15,562 50,046 54,652 Page 90 Schedule 6.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- EDP COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .3 - Costs Allocated By Activity 06/27/2013 11:19:35 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 UNALLOWED For Department 107-CENTRAL SVCS Wages & Benefits SALARIES & WAGES 0 0 FRINGE BENEFITS 0 0 Other Expense & Cost COMMUNICATIONS 0 0 SERVICE & SUPPLIES 0 1,700 PROF SERVICES 53,146 0 AUDIT 0 0 COST PLAN 0 0 RENTS & LEASES 0 0 MAINT AGREEMENTS 8,383 0 FIXED ASSETS 0 0 * INTERFUND TRANSFERS 0 0 * VEHICLE GAS 0 0 * Departmental Totals Total Expenditures 61,529 1,700 Deductions Total Deductions 0 0 Cost Adjustments COST ABATEMENTS 0 0 Functional Cost 61,529 1,700 Allocation Step 1 Inbound- All Others 0 0 Reallocate Admin Costs 3,518 97 Unallocated Costs 0 ( 1,797) 1st Allocation 65,047 0 Allocation Step 2 Inbound- All Others 0 0 Reallocate Admin Costs 8,002 221 Unallocated Costs 0 ( 221) 2nd Allocation 8,002 0 Page 91 Schedule 6.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- EDP COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .3 - Costs Allocated By Activity 06/27/2013 11:19:35 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 UNALLOWED For Department 107-CENTRAL SVCS Total For 070 107-CENTRAL SVCS Total Allocated 73,049 0 Page 92 Schedule 6.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:36 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 107-CENTRAL SVCS Activity - COMMO Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 101-BD & CONSULT 4 3.5714 495 495 495 105-AUDITOR/CONTROLLER 5 4.4643 619 619 619 110-TREAS/TAX COLLECTOR 3 2.6786 371 371 50 421 104-COUNTY CLERK 2 1.7857 247 247 33 280 113-COUNTY ASSESSOR 4 3.5714 495 495 66 561 141-COUNTY COUNSEL 1 0.8929 124 124 17 141 146-DISTRICT ATTORNEY 4 3.5714 495 495 66 561 149-COUNTY SHERIFF 19 16.9643 2,351 2,351 315 2,666 158-PROBATION DEPT 3 2.6786 371 371 50 421 159/163-FIRE 4 3.5714 495 495 66 561 165-FIRE/EMS 1 0.8929 124 124 17 141 167-BUILDING DEPT 3 2.6786 371 371 50 421 175 CDA 12 10.7143 1,485 1,485 199 1,684 176-PLANNING DEPT 1 0.8929 124 124 17 141 186-WELFARE DEPT 25 22.3212 3,091 3,091 410 3,501 193/194-COUNTY LIBRARY 7 6.2500 866 866 116 982 195/196-CO PARKS 1 0.8929 124 124 17 141 198-MUSEUM 2 1.7857 247 247 33 280 (120) HEALTH DEPT 1 0.8929 124 124 17 141 (121) MENTAL HEALTH 4 3.5714 495 495 66 561 (122) DRUGS & ALCOHOL 1 0.8929 124 124 17 141 (219/220) ROAD DEPT 4 3.5714 495 495 66 561 (276) WATER SHED COORD 1 0.8929 124 124 17 141 SubTotal [PHONE REDACTED] 13,857 13,857 1,705 15,562 Total [PHONE REDACTED] 13,857 13,857 1,705 15,562 Page 93 Schedule 6.4.1 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations For Department 107-CENTRAL SVCS Allocation Basis: NUMBER OF PHONES Allocation Source: COUNTY WORKSHEET-AUDITOR Page 94 Schedule 6.4.1 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:37 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 107-CENTRAL SVCS Activity - POSTAGE/COPIES Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 101-BD & CONSULT 114 0.4410 197 -114 83 83 103-PERSONNEL 442 1.7113 763 -443 320 320 105-AUDITOR/CONTROLLER 2,484 9.6054 4,281 -2,485 1,796 1,796 107-CENTRAL SVCS 9,742 37.6611 16,780 -9,743 7,037 7,037 110-TREAS/TAX COLLECTOR 2,665 10.3035 4,592 -2,665 1,927 1,115 3,042 104-COUNTY CLERK 872 3.3730 1,503 -873 630 366 996 113-COUNTY ASSESSOR 255 0.9875 440 -255 185 107 292 116-ELECTIONS 2,620 10.1310 4,515 -2,621 1,894 1,098 2,992 138-GRAND JURY 42 0.1624 72 -42 30 18 48 146-DISTRICT ATTORNEY 509 1.9714 879 -510 369 214 583 149-COUNTY SHERIFF 1,239 4.7907 2,135 -1,239 896 519 1,415 158-PROBATION DEPT 65 0.2527 113 -65 48 27 75 159/163-FIRE 0 -42 -42 -42 165-FIRE/EMS 42 0.1624 72 72 18 90 175 CDA 500 1.9336 862 -500 362 210 572 179-LOCAL AGENCY FORMATION 5 0.0224 10 -6 4 2 6 186-WELFARE DEPT 1,443 5.5784 2,486 -1,443 1,043 605 1,648 193/194-COUNTY LIBRARY 600 2.3218 1,035 -601 434 252 686 (120) HEALTH DEPT 775 2.9989 1,336 -776 560 325 885 (121) MENTAL HEALTH 252 0.9742 434 -252 182 106 288 (122) DRUGS & ALCOHOL 249 0.9638 430 -249 181 104 285 (151) TOBACCO 592 2.2900 1,021 -592 429 248 677 214 PARKING/RECORDS MGMT 146 0.5648 252 -146 106 61 167 (273) BT EMERGENCY PREP 21 0.0826 37 -21 16 9 25 (310) MPUD 185 0.7161 319 -185 134 78 212 SubTotal 25,[PHONE REDACTED] 44,564 -25,868 18,696 5,482 24,178 Direct Billed 25,868 25,868 25,868 Total 25,[PHONE REDACTED] 44,564 44,564 5,482 50,046 Page 95 Schedule 6.4.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations For Department 107-CENTRAL SVCS Allocation Basis: COSTS ABATED Allocation Source: Auditor's Office Page 96 Schedule 6.4.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:37 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 107-CENTRAL SVCS Activity - AUDIT/COST PLAN Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 132-RISK MGMT 48,017 0.2311 112 112 112 101-BD & CONSULT 358,450 1.7251 840 840 840 103-PERSONNEL 89,729 0.4318 210 210 210 105-AUDITOR/CONTROLLER 287,264 1.3825 673 673 673 107-CENTRAL SVCS 161,690 0.7782 379 379 379 109-INFORMATION TECHNOLOGY 91,725 0.4414 215 215 28 243 110-TREAS/TAX COLLECTOR 293,951 1.4147 688 688 89 777 119-BUILDINGS & GROUNDS 397,604 1.9135 931 931 120 1,051 104-COUNTY CLERK 210,460 1.0129 493 493 64 557 113-COUNTY ASSESSOR 294,312 1.4164 689 689 89 778 116-ELECTIONS 23,533 0.1133 55 55 7 62 126-CHAMBER OF COMMERCE 60,000 0.2888 141 141 18 159 133-RETIRED BENEFITS 280,837 1.3516 658 658 85 743 134-SURVEYOR/ENGR 6,852 0.0330 16 16 2 18 138-GRAND JURY 8,883 0.0428 21 21 3 24 141-COUNTY COUNSEL 275,139 1.3241 644 644 83 727 145 GRANT VERTICAL PROSECUTION 3,902 0.0188 9 9 1 10 146-DISTRICT ATTORNEY 246,119 1.1845 576 576 74 650 147-PUBLIC DEFENDER 53,480 0.2574 125 125 16 141 292 ANTI DRUG ABUSE 89,659 0.4315 210 210 27 237 149-COUNTY SHERIFF 1,540,245 7.4126 3,607 3,607 465 4,072 294-VICTIM WITNESS 54,505 0.2623 128 128 16 144 158-PROBATION DEPT 90,913 0.4375 213 213 27 240 159/163-FIRE 41,822 0.2013 98 98 13 111 160/164 EMERGENCY SERVICES 67,263 0.3237 158 158 20 178 165-FIRE/EMS 189,839 0.9136 445 445 57 502 166 KIRKWOOD EMS 204 0.0010 168 BV EMS 9,740 0.0469 23 23 3 26 Page 97 Schedule 6.4.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:37 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 107-CENTRAL SVCS Activity - AUDIT/COST PLAN Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 167-BUILDING DEPT 170,508 0.8206 399 399 51 450 170 AGRICULTURAL COMMISSION 13,727 0.0661 32 32 4 36 175 CDA 434,945 2.0932 1,019 1,019 131 1,150 176-PLANNING DEPT 103,313 0.4972 242 242 31 273 179-LOCAL AGENCY FORMATION 1,063 0.0051 2 2 2 182-LOCAL HEALTH DEPT 21,864 0.1052 51 51 7 58 185-SOLID WASTE 17,355 0.0835 41 41 5 46 186-WELFARE DEPT 1,306,242 6.2864 3,059 3,059 394 3,453 187 SOCIAL SERVICES ASSISTANCE 109,450 0.5267 256 256 33 289 193/194-COUNTY LIBRARY 226,054 1.0879 529 529 68 597 195/196-CO PARKS 14,499 0.0698 34 34 4 38 198-MUSEUM 30,709 0.1478 72 72 9 81 (115) COURT SERVICES 28,578 0.1375 67 67 9 76 (120) HEALTH DEPT 448,688 2.1594 1,051 1,051 135 1,186 (121) MENTAL HEALTH 404,132 1.9449 947 947 122 1,069 (122) DRUGS & ALCOHOL 434,406 2.0906 1,017 1,017 131 1,148 (151) TOBACCO 180,568 0.8690 423 423 55 478 (219/220) ROAD DEPT 2,097,772 10.0958 4,913 4,913 633 5,546 214 PARKING/RECORDS MGMT 7,104 0.0342 17 17 2 19 (330) FISH & GAME 57,649 0.2774 135 135 17 152 (276) WATER SHED COORD 44,365 0.2135 104 104 13 117 (273) BT EMERGENCY PREP 130,025 0.6258 305 305 39 344 (240) AIRPORT 4,451 0.0214 10 10 1 11 (290) COPS GRANT 92,275 0.4441 216 216 28 244 (291) OTHER STATE GRANTS 85,421 0.4111 200 200 26 226 (295) LAW ENFORCEMENT AB443 645,100 3.1046 1,511 1,511 195 1,706 (310) MPUD 70,389 0.3388 165 165 21 186 221 CO ROAD IMPROVEMENT FD 60,242 0.2899 141 141 18 159 Page 98 Schedule 6.4.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:37 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 107-CENTRAL SVCS Activity - AUDIT/COST PLAN Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 (340) CSA #1 140,870 0.6780 330 330 43 373 216 FEDERAL COPS TECH GRANT 762,849 3.6713 1,787 1,787 230 2,017 218 IECGP 2010 GRANT 245,058 1.1794 574 574 74 648 (361/370) CO TRANSIT 242,221 1.1657 567 567 73 640 (400'S) SCHOOLS 53,864 0.2592 126 126 16 142 215 STATE OES 1,051,728 5.0616 2,463 2,463 317 2,780 293 OHV GRANT FUND 27,944 0.1345 65 65 8 73 341 BV PUBLIC SAFETY 208,087 1.0014 487 487 63 550 (500) OTHER TRUST & AGENCY 2,823 0.0136 7 7 1 8 375 STUPD MITIGATION 74,994 0.3609 176 176 23 199 376 YOUTH OFFENDER BLOCK 96,738 0.4656 227 227 29 256 377 MENTAL HEALTH SVCS ACT 373,564 1.7978 875 875 113 988 260 CAPITAL OUTLAY 437,540 2.1057 1,025 1,025 132 1,157 261 HAWKINS PEAK 2,828,145 13.6106 6,624 6,624 859 7,483 263 MARKLEEVILLE PIPELINE 680,596 3.2754 1,594 1,594 205 1,799 267 LEVIATHAN PEAK PROJ 352,622 1.6970 826 826 106 932 297 FEDERAL ANTI-DRUG 148,140 0.7129 347 347 45 392 298 FEDERAL CAL-MMET 61,006 0.2936 143 143 18 161 271 GRANTS CLEARING 229,246 1.1033 537 537 69 606 272 SAMSHA GRANT 10,000 0.0481 23 23 3 26 274 HPP 125,713 0.6050 294 294 38 332 275 HPP-H1N1 26,144 0.1258 61 61 8 69 296 COPS (FEDERAL) 72,453 0.3487 170 170 22 192 311 ASSESSORS SPEC REV 5,998 0.0289 14 14 2 16 312 RECORDERS SPEC REV 3,359 0.0162 8 8 1 9 SubTotal 20,778,[PHONE REDACTED] 48,665 48,665 5,987 54,652 Total 20,778,[PHONE REDACTED] 48,665 48,665 5,987 54,652 Page 99 Schedule 6.4.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations For Department 107-CENTRAL SVCS Allocation Basis: RELATIVE BUDGET SIZE ($000) Allocation Source: APPROVED BUDGET Page 100 Schedule 6.4.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:38 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 107-CENTRAL SVCS Activity - EDP Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 105-AUDITOR/CONTROLLER 40 40.0000 26,019 26,019 26,019 110-TREAS/TAX COLLECTOR 35 35.0000 22,766 22,766 4,668 27,434 113-COUNTY ASSESSOR 25 25.0000 16,262 16,262 3,334 19,596 SubTotal [PHONE REDACTED] 65,047 65,047 8,002 73,049 Total [PHONE REDACTED] 65,047 65,047 8,002 73,049 Allocation Basis: PERCENT OF USAGE Allocation Source: EDP Page 101 Schedule 6.4.4 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .5 - Allocation Summary 06/27/2013 11:19:39 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 EDP AUDIT/COST PLAN POSTAGE/COPIES COMMO For Department 107-CENTRAL SVCS Receiving Department 132-RISK MGMT 112 0 0 112 0 101-BD & CONSULT 1,418 495 83 840 0 103-PERSONNEL 530 0 320 210 0 105-AUDITOR/CONTROLLE 29,107 619 1,796 673 26,019 107-CENTRAL SVCS 7,416 0 7,037 379 0 109-INFORMATION 243 0 0 243 0 110-TREAS/TAX 31,674 421 3,042 777 27,434 119-BUILDINGS & 1,051 0 0 1,051 0 104-COUNTY CLERK 1,833 280 996 557 0 113-COUNTY ASSESSOR 21,227 561 292 778 19,596 116-ELECTIONS 3,054 0 2,992 62 0 126-CHAMBER OF 159 0 0 159 0 133-RETIRED BENEFITS 743 0 0 743 0 134-SURVEYOR/ENGR 18 0 0 18 0 138-GRAND JURY 72 0 48 24 0 141-COUNTY COUNSEL 868 141 0 727 0 145 GRANT VERTICAL 10 0 0 10 0 146-DISTRICT ATTORNEY 1,794 561 583 650 0 147-PUBLIC DEFENDER 141 0 0 141 0 292 ANTI DRUG ABUSE 237 0 0 237 0 149-COUNTY SHERIFF 8,153 2,666 1,415 4,072 0 294-VICTIM WITNESS 144 0 0 144 0 158-PROBATION DEPT 736 421 75 240 0 159/163-FIRE 630 561 ( 42) 111 0 160/164 EMERGENCY 178 0 0 178 0 165-FIRE/EMS 733 141 90 502 0 168 BV EMS 26 0 0 26 0 167-BUILDING DEPT 871 421 0 450 0 170 AGRICULTURAL 36 0 0 36 0 175 CDA 3,406 1,684 572 1,150 0 176-PLANNING DEPT 414 141 0 273 0 179-LOCAL AGENCY 8 0 6 2 0 182-LOCAL HEALTH DEPT 58 0 0 58 0 185-SOLID WASTE 46 0 0 46 0 186-WELFARE DEPT 8,602 3,501 1,648 3,453 0 187 SOCIAL SERVICES 289 0 0 289 0 Page 102 Schedule 6.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .5 - Allocation Summary 06/27/2013 11:19:39 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 EDP AUDIT/COST PLAN POSTAGE/COPIES COMMO For Department 107-CENTRAL SVCS Receiving Department 193/194-COUNTY LIBRARY 2,265 982 686 597 0 195/196-CO PARKS 179 141 0 38 0 198-MUSEUM 361 280 0 81 0 (115) COURT SERVICES 76 0 0 76 0 (120) HEALTH DEPT 2,212 141 885 1,186 0 (121) MENTAL HEALTH 1,918 561 288 1,069 0 (122) DRUGS & ALCOHOL 1,574 141 285 1,148 0 (151) TOBACCO 1,155 0 677 478 0 (219/220) ROAD DEPT 6,107 561 0 5,546 0 214 PARKING/RECORDS 186 0 167 19 0 (330) FISH & GAME 152 0 0 152 0 (276) WATER SHED COORD 258 141 0 117 0 (273) BT EMERGENCY 369 0 25 344 0 (240) AIRPORT 11 0 0 11 0 (290) COPS GRANT 244 0 0 244 0 (291) OTHER STATE 226 0 0 226 0 (295) LAW ENFORCEMENT 1,706 0 0 1,706 0 (310) MPUD 398 0 212 186 0 221 CO ROAD 159 0 0 159 0 (340) CSA #1 373 0 0 373 0 216 FEDERAL COPS TECH 2,017 0 0 2,017 0 218 IECGP 2010 GRANT 648 0 0 648 0 (361/370) CO TRANSIT 640 0 0 640 0 (400'S) SCHOOLS 142 0 0 142 0 215 STATE OES 2,780 0 0 2,780 0 293 OHV GRANT FUND 73 0 0 73 0 341 BV PUBLIC SAFETY 550 0 0 550 0 (500) OTHER TRUST & 8 0 0 8 0 375 STUPD MITIGATION 199 0 0 199 0 376 YOUTH OFFENDER 256 0 0 256 0 377 MENTAL HEALTH SVCS 988 0 0 988 0 260 CAPITAL OUTLAY 1,157 0 0 1,157 0 261 HAWKINS PEAK 7,483 0 0 7,483 0 263 MARKLEEVILLE 1,799 0 0 1,799 0 267 LEVIATHAN PEAK PROJ 932 0 0 932 0 297 FEDERAL ANTI-DRUG 392 0 0 392 0 Page 103 Schedule 6.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .5 - Allocation Summary 06/27/2013 11:19:39 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 EDP AUDIT/COST PLAN POSTAGE/COPIES COMMO For Department 107-CENTRAL SVCS Receiving Department 298 FEDERAL CAL-MMET 161 0 0 161 0 271 GRANTS CLEARING 606 0 0 606 0 272 SAMSHA GRANT 26 0 0 26 0 274 HPP 332 0 0 332 0 275 HPP-H1N1 69 0 0 69 0 296 COPS (FEDERAL) 192 0 0 192 0 311 ASSESSORS SPEC REV 16 0 0 16 0 312 RECORDERS SPEC 9 0 0 9 0 Direct Billed 25,868 0 25,868 0 0 Total 193,309 15,562 50,046 54,652 73,049 Page 104 Schedule 6.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- © MAXIMUS Consulting Services, Inc. COST PLAN FOR USE IN THE 2013/2014 FISCAL YEAR Schedule 7.1 Fiscal 2011/12 COUNTY OF ALPINE, CALIFORNIA TREASURER-TAX COLLECTOR NATURE AND EXTENT OF SERVICES The Treasurer-Tax Collector's Office is responsible for: the County banking, Special District, and School District funds. Other activities include warrant and deposit permit reconciliation, receiving payments, and tax collection. Only the cost of warrant and transfer processing is allocated in this plan. The cost is allocated based on the departmental total of Payroll, Auditor, Welfare, and Trust and Agency Warrants. The breakdown of salary across the two functions was based on time records. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .2 - Costs To Be Allocated 06/27/2013 11:19:40 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 110-TREAS/TAX COLLECTOR 1st Allocation Total Sub-Total 2nd Allocation Expenditures Per Financial Statement: 293,951 293,951 FIXED ASSETS 0 Total Deductions: 0 0 BUILDING USE ALLOWANCE 376 376 132-RISK MGMT 581 57 638 101-BD & CONSULT 1,246 247 1,493 103-PERSONNEL 2,381 287 2,668 105-AUDITOR/CONTROLLER 4,649 843 5,492 107-CENTRAL SVCS 25,752 5,922 31,674 110-TREAS/TAX COLLECTOR 1,544 1,544 119-BUILDINGS & GROUNDS 12,600 12,600 Total Allocated Additions: 34,985 21,500 56,485 56,485 Total To Be Allocated: 328,936 21,500 350,436 Page 106 Schedule 7.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .3 - Costs Allocated By Activity 06/27/2013 11:19:40 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 General & Admin WARRANT PROCESS UNALLOWED For Department 110-TREAS/TAX COLLECTOR Wages & Benefits SALARIES & WAGES 194,058 32,776 71,375 89,907 FRINGE BENEFITS 84,999 14,356 31,263 39,380 Other Expense & Cost MEMBERSHIPS 325 0 0 325 TRANS & TRAVEL 2,646 0 0 2,646 OTHER SVCS & SUPP 11,923 2,014 4,385 5,524 FIXED ASSETS 0 0 0 0 * Departmental Totals Total Expenditures 293,951 49,146 107,023 137,782 Deductions Total Deductions 0 0 0 0 Functional Cost 293,951 49,146 107,023 137,782 Allocation Step 1 Inbound- All Others 34,985 34,985 0 0 Reallocate Admin Costs ( 84,131) 37,232 46,899 Unallocated Costs ( 184,681) 0 0 ( 184,681) 1st Allocation 144,255 0 144,255 0 Allocation Step 2 Inbound- All Others 21,500 21,500 0 0 Reallocate Admin Costs ( 21,500) 9,515 11,985 Unallocated Costs ( 11,985) 0 0 ( 11,985) 2nd Allocation 9,515 0 9,515 0 Total For 080 110-TREAS/TAX COLLECTOR Total Allocated 153,770 0 153,770 0 Page 107 Schedule 7.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. * - Indicates Disallowed Expenditure ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:41 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 110-TREAS/TAX COLLECTOR Activity - WARRANT PROCESS Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 132-RISK MGMT 39 0.4971 717 717 717 101-BD & CONSULT 75 0.9559 1,379 1,379 1,379 103-PERSONNEL 61 0.7775 1,122 1,122 1,122 105-AUDITOR/CONTROLLER 56 0.7137 1,030 1,030 1,030 107-CENTRAL SVCS 142 1.8098 2,611 2,611 2,611 109-INFORMATION TECHNOLOGY 30 0.3824 552 552 39 591 110-TREAS/TAX COLLECTOR 84 1.0706 1,544 1,544 1,544 119-BUILDINGS & GROUNDS 331 4.2187 6,086 6,086 426 6,512 104-COUNTY CLERK 65 0.8284 1,195 1,195 84 1,279 113-COUNTY ASSESSOR 40 0.5098 735 735 52 787 116-ELECTIONS 44 0.5608 809 809 57 866 126-CHAMBER OF COMMERCE 3 0.0382 55 55 4 59 133-RETIRED BENEFITS 108 1.3765 1,986 1,986 139 2,125 134-SURVEYOR/ENGR 6 0.0765 110 110 8 118 138-GRAND JURY 5 0.0637 92 92 6 98 141-COUNTY COUNSEL 31 0.3951 570 570 40 610 145 GRANT VERTICAL PROSECUTION 6 0.0765 110 110 8 118 146-DISTRICT ATTORNEY 142 1.8098 2,611 2,611 183 2,794 147-PUBLIC DEFENDER 13 0.1657 239 239 17 256 292 ANTI DRUG ABUSE 49 0.6245 901 901 63 964 149-COUNTY SHERIFF 322 4.1040 5,920 5,920 415 6,335 294-VICTIM WITNESS 62 0.7902 1,140 1,140 80 1,220 158-PROBATION DEPT 73 0.9304 1,342 1,342 94 1,436 159/163-FIRE 1 0.0127 18 18 1 19 160/164 EMERGENCY SERVICES 62 0.7902 1,140 1,140 80 1,220 165-FIRE/EMS 261 3.3265 4,799 4,799 336 5,135 166 KIRKWOOD EMS 3 0.0382 55 55 4 59 168 BV EMS 9 0.1147 165 165 12 177 Page 108 Schedule 7.4.1 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:41 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 110-TREAS/TAX COLLECTOR Activity - WARRANT PROCESS Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 167-BUILDING DEPT 47 0.5990 864 864 61 925 170 AGRICULTURAL COMMISSION 1 0.0127 18 18 1 19 175 CDA 146 1.8608 2,684 2,684 188 2,872 176-PLANNING DEPT 17 0.2167 313 313 22 335 179-LOCAL AGENCY FORMATION 2 0.0255 37 37 3 40 185-SOLID WASTE 2 0.0255 37 37 3 40 186-WELFARE DEPT 427 5.4423 7,851 7,851 550 8,401 187 SOCIAL SERVICES ASSISTANCE 75 0.9559 1,379 1,379 97 1,476 193/194-COUNTY LIBRARY 145 1.8481 2,666 2,666 187 2,853 195/196-CO PARKS 34 0.4333 625 625 44 669 198-MUSEUM 38 0.4843 699 699 49 748 (115) COURT SERVICES 1 0.0127 18 18 1 19 (120) HEALTH DEPT 333 4.2442 6,122 6,122 429 6,551 (121) MENTAL HEALTH 263 3.3520 4,835 4,835 339 5,174 (122) DRUGS & ALCOHOL 227 2.8932 4,174 4,174 292 4,466 (151) TOBACCO 157 2.0010 2,887 2,887 202 3,089 (219/220) ROAD DEPT 479 6.1050 8,807 8,807 617 9,424 214 PARKING/RECORDS MGMT 9 0.1147 165 165 12 177 (330) FISH & GAME 10 0.1275 184 184 13 197 (276) WATER SHED COORD 29 0.3696 533 533 37 570 (273) BT EMERGENCY PREP 224 2.8550 4,118 4,118 288 4,406 (240) AIRPORT 2 0.0255 37 37 3 40 (290) COPS GRANT 8 0.1020 147 147 10 157 (291) OTHER STATE GRANTS 23 0.2931 423 423 30 453 (295) LAW ENFORCEMENT AB443 36 0.4588 662 662 46 708 (310) MPUD 71 0.9049 1,305 1,305 91 1,396 221 CO ROAD IMPROVEMENT FD 28 0.3569 515 515 36 551 (340) CSA #1 32 0.4079 588 588 41 629 Page 109 Schedule 7.4.1 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:41 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 110-TREAS/TAX COLLECTOR Activity - WARRANT PROCESS Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 (361/370) CO TRANSIT 67 0.8539 1,232 1,232 86 1,318 (400'S) SCHOOLS 1,461 18.6214 26,862 26,862 1,877 28,739 215 STATE OES 23 0.2931 423 423 30 453 293 OHV GRANT FUND 25 0.3186 460 460 32 492 341 BV PUBLIC SAFETY 27 0.3441 496 496 35 531 (500) OTHER TRUST & AGENCY 697 8.8835 12,815 12,815 898 13,713 375 STUPD MITIGATION 2 0.0255 37 37 3 40 376 YOUTH OFFENDER BLOCK 24 0.3059 441 441 31 472 377 MENTAL HEALTH SVCS ACT 270 3.4412 4,964 4,964 348 5,312 260 CAPITAL OUTLAY 61 0.7775 1,122 1,122 79 1,201 261 HAWKINS PEAK 48 0.6118 883 883 62 945 263 MARKLEEVILLE PIPELINE 9 0.1147 165 165 12 177 267 LEVIATHAN PEAK PROJ 15 0.1912 276 276 19 295 297 FEDERAL ANTI-DRUG 18 0.2294 331 331 23 354 298 FEDERAL CAL-MMET 8 0.1020 147 147 10 157 271 GRANTS CLEARING 24 0.3059 441 441 31 472 272 SAMSHA GRANT 5 0.0637 92 92 6 98 274 HPP 19 0.2422 349 349 24 373 296 COPS (FEDERAL) 25 0.3186 460 460 32 492 311 ASSESSORS SPEC REV 24 0.3059 441 441 31 472 312 RECORDERS SPEC REV 5 0.0637 92 92 6 98 SubTotal 7,[PHONE REDACTED] 144,255 144,255 9,515 153,770 Total 7,[PHONE REDACTED] 144,255 144,255 9,515 153,770 Page 110 Schedule 7.4.1 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations For Department 110-TREAS/TAX COLLECTOR Allocation Basis: NUMBER OF NON-PAYROLL WARRANTS Allocation Source: County Worksheet Page 111 Schedule 7.4.1 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .5 - Allocation Summary 06/27/2013 11:19:42 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 WARRANT PROCESS For Department 110-TREAS/TAX COLLECTOR Receiving Department 132-RISK MGMT 717 717 101-BD & CONSULT 1,379 1,379 103-PERSONNEL 1,122 1,122 105-AUDITOR/CONTROLLE 1,030 1,030 107-CENTRAL SVCS 2,611 2,611 109-INFORMATION 591 591 110-TREAS/TAX 1,544 1,544 119-BUILDINGS & 6,512 6,512 104-COUNTY CLERK 1,279 1,279 113-COUNTY ASSESSOR 787 787 116-ELECTIONS 866 866 126-CHAMBER OF 59 59 133-RETIRED BENEFITS 2,125 2,125 134-SURVEYOR/ENGR 118 118 138-GRAND JURY 98 98 141-COUNTY COUNSEL 610 610 145 GRANT VERTICAL 118 118 146-DISTRICT ATTORNEY 2,794 2,794 147-PUBLIC DEFENDER 256 256 292 ANTI DRUG ABUSE 964 964 149-COUNTY SHERIFF 6,335 6,335 294-VICTIM WITNESS 1,220 1,220 158-PROBATION DEPT 1,436 1,436 159/163-FIRE 19 19 160/164 EMERGENCY 1,220 1,220 165-FIRE/EMS 5,135 5,135 166 KIRKWOOD EMS 59 59 168 BV EMS 177 177 167-BUILDING DEPT 925 925 170 AGRICULTURAL 19 19 175 CDA 2,872 2,872 176-PLANNING DEPT 335 335 179-LOCAL AGENCY 40 40 185-SOLID WASTE 40 40 186-WELFARE DEPT 8,401 8,401 187 SOCIAL SERVICES 1,476 1,476 Page 112 Schedule 7.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .5 - Allocation Summary 06/27/2013 11:19:42 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 WARRANT PROCESS For Department 110-TREAS/TAX COLLECTOR Receiving Department 193/194-COUNTY LIBRARY 2,853 2,853 195/196-CO PARKS 669 669 198-MUSEUM 748 748 (115) COURT SERVICES 19 19 (120) HEALTH DEPT 6,551 6,551 (121) MENTAL HEALTH 5,174 5,174 (122) DRUGS & ALCOHOL 4,466 4,466 (151) TOBACCO 3,089 3,089 (219/220) ROAD DEPT 9,424 9,424 214 PARKING/RECORDS 177 177 (330) FISH & GAME 197 197 (276) WATER SHED COORD 570 570 (273) BT EMERGENCY 4,406 4,406 (240) AIRPORT 40 40 (290) COPS GRANT 157 157 (291) OTHER STATE 453 453 (295) LAW ENFORCEMENT 708 708 (310) MPUD 1,396 1,396 221 CO ROAD 551 551 (340) CSA #1 629 629 (361/370) CO TRANSIT 1,318 1,318 (400'S) SCHOOLS 28,739 28,739 215 STATE OES 453 453 293 OHV GRANT FUND 492 492 341 BV PUBLIC SAFETY 531 531 (500) OTHER TRUST & 13,713 13,713 375 STUPD MITIGATION 40 40 376 YOUTH OFFENDER 472 472 377 MENTAL HEALTH SVCS 5,312 5,312 260 CAPITAL OUTLAY 1,201 1,201 261 HAWKINS PEAK 945 945 263 MARKLEEVILLE 177 177 267 LEVIATHAN PEAK PROJ 295 295 297 FEDERAL ANTI-DRUG 354 354 298 FEDERAL CAL-MMET 157 157 271 GRANTS CLEARING 472 472 Page 113 Schedule 7.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .5 - Allocation Summary 06/27/2013 11:19:42 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 WARRANT PROCESS For Department 110-TREAS/TAX COLLECTOR Receiving Department 272 SAMSHA GRANT 98 98 274 HPP 373 373 296 COPS (FEDERAL) 492 492 311 ASSESSORS SPEC REV 472 472 312 RECORDERS SPEC 98 98 Direct Billed 0 0 Total 153,770 153,770 Page 114 Schedule 7.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- © MAXIMUS Consulting Services, Inc. COST PLAN FOR USE IN THE 2013/2014 FISCAL YEAR Schedule 8.1 Fiscal 2011/12 COUNTY OF ALPINE, CALIFORNIA BUILDINGS & GROUNDS NATURE AND EXTENT OF SERVICES The Buildings and Grounds Department provides maintenance and custodial services to departments that are occupied in County buildings. The costs associated with this department have been identified and are then further allocated based upon the square footage serviced. Five functions have been created: Courthouse, Library, Admin Building, Janitorial Services, and B & G Services. The first three functions: Courthouse, Library, and Admin Building allocated the costs associated with Utility and Maintenance structure based on the applicable buildings and then to the appropriate department based on square footage. Function four Janitorial Services are allocated based on the total square footage cleaned by department. The last function, B & G Services, are the remaining general costs associated with the Buildings and Grounds department that is not directly identified to a particular building or department but instead a county-wide cost; the allocated costs of this function are allocated based on the total square footage occupied. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .2 - Costs To Be Allocated 06/27/2013 11:19:42 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 119-BUILDINGS & GROUNDS 1st Allocation Total Sub-Total 2nd Allocation Expenditures Per Financial Statement: 397,604 397,604 132-RISK MGMT 372 36 408 101-BD & CONSULT 1,200 236 1,436 103-PERSONNEL 1,905 229 2,134 105-AUDITOR/CONTROLLER 8,518 1,513 10,031 107-CENTRAL SVCS 931 120 1,051 110-TREAS/TAX COLLECTOR 6,086 426 6,512 Total Allocated Additions: 19,012 2,560 21,572 21,572 Misc Revenue ( 18,470) Total Departmental Cost Adjustments: ( 18,470) ( 18,470) Total To Be Allocated: 398,146 2,560 400,706 Page 116 Schedule 8.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .3 - Costs Allocated By Activity 06/27/2013 11:19:43 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 General & Admin COURTHOUSE LIBRARY For Department 119-BUILDINGS & GROUNDS ADMIN BUILDING Wages & Benefits SALARIES & WAGES 81,068 0 3,372 4,572 10,263 FRINGE BENEFITS 26,094 0 1,086 1,472 3,304 Other Expense & Cost MAINT STRUCTURES 20,782 0 3,847 5,220 11,715 ROAD ADMIN COST 14,045 0 0 0 0 JANITORIAL SVCS 40,080 0 0 0 0 OTHER SVCS & SUPP 91,561 0 0 0 0 UTILITIES 123,974 0 22,948 31,142 69,884 Departmental Totals Total Expenditures 397,604 0 31,253 42,406 95,166 Deductions Total Deductions 0 0 0 0 0 Cost Adjustments Misc Revenue ( 18,470) ( 18,470) 0 0 0 Functional Cost 379,134 ( 18,470) 31,253 42,406 95,166 Allocation Step 1 Inbound- All Others 19,012 19,012 0 0 0 Reallocate Admin Costs ( 542) 23 31 69 1st Allocation 398,146 0 31,276 42,437 95,235 Allocation Step 2 Inbound- All Others 2,560 2,560 0 0 0 Reallocate Admin Costs ( 2,560) 106 144 324 2nd Allocation 2,560 0 106 144 324 Total For 090 119-BUILDINGS & GROUNDS Total Allocated 400,706 0 31,382 42,581 95,559 Page 117 Schedule 8.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. * - Indicates Disallowed Expenditure ---PAGE BREAK--- JANITORIAL SVCS COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .3 - Costs Allocated By Activity 06/27/2013 11:19:43 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 B&G SERVICES For Department 119-BUILDINGS & GROUNDS Wages & Benefits SALARIES & WAGES 0 62,861 FRINGE BENEFITS 0 20,232 Other Expense & Cost MAINT STRUCTURES 0 0 ROAD ADMIN COST 0 14,045 JANITORIAL SVCS 40,080 0 OTHER SVCS & SUPP 0 91,561 UTILITIES 0 0 Departmental Totals Total Expenditures 40,080 188,699 Deductions Total Deductions 0 0 Cost Adjustments Misc Revenue 0 0 Functional Cost 40,080 188,699 Allocation Step 1 Inbound- All Others 0 0 Reallocate Admin Costs 0 419 1st Allocation 40,080 189,118 Allocation Step 2 Inbound- All Others 0 0 Reallocate Admin Costs 0 1,986 2nd Allocation 0 1,986 Total For 090 119-BUILDINGS & GROUNDS Total Allocated 40,080 191,104 Page 118 Schedule 8.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:44 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 119-BUILDINGS & GROUNDS Activity - COURTHOUSE Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 149-COUNTY SHERIFF 2,335 93.8882 29,364 29,364 100 29,464 158-PROBATION DEPT 152 6.1118 1,912 1,912 6 1,918 SubTotal 2,[PHONE REDACTED] 31,276 31,276 106 31,382 Total 2,[PHONE REDACTED] 31,276 31,276 106 31,382 Allocation Basis: SQUARE FEET Allocation Source: BUILDINGS Page 119 Schedule 8.4.1 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:45 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 119-BUILDINGS & GROUNDS Activity - LIBRARY Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 193/194-COUNTY LIBRARY [PHONE REDACTED] 42,437 42,437 144 42,581 SubTotal [PHONE REDACTED] 42,437 42,437 144 42,581 Total [PHONE REDACTED] 42,437 42,437 144 42,581 Allocation Basis: SQUARE FEET Allocation Source: County Records Page 120 Schedule 8.4.2 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:45 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 119-BUILDINGS & GROUNDS Activity - ADMIN BUILDING Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 101-BD & CONSULT 1,560 29.9022 28,477 28,477 28,477 103-PERSONNEL 200 3.8336 3,651 3,651 3,651 105-AUDITOR/CONTROLLER 590 11.3092 10,770 10,770 10,770 107-CENTRAL SVCS 420 8.0506 7,667 7,667 7,667 110-TREAS/TAX COLLECTOR 490 9.3924 8,945 8,945 8,945 104-COUNTY CLERK 749 14.3569 13,673 13,673 124 13,797 113-COUNTY ASSESSOR 1,208 23.1551 22,052 22,052 200 22,252 SubTotal 5,[PHONE REDACTED] 95,235 95,235 324 95,559 Total 5,[PHONE REDACTED] 95,235 95,235 324 95,559 Allocation Basis: SQUARE FEET Allocation Source: County Records Page 121 Schedule 8.4.3 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:46 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 119-BUILDINGS & GROUNDS Activity - JANITORIAL SVCS Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 101-BD & CONSULT 1,560 5.0780 2,035 2,035 2,035 103-PERSONNEL 200 0.6510 261 261 261 105-AUDITOR/CONTROLLER 590 1.9205 770 770 770 107-CENTRAL SVCS 420 1.3671 548 548 548 110-TREAS/TAX COLLECTOR 490 1.5950 639 639 639 104-COUNTY CLERK 749 2.4381 977 977 977 113-COUNTY ASSESSOR 1,208 3.9322 1,576 1,576 1,576 146-DISTRICT ATTORNEY 750 2.4413 978 978 978 149-COUNTY SHERIFF 2,335 7.6007 3,046 3,046 3,046 158-PROBATION DEPT 152 0.4948 198 198 198 167-BUILDING DEPT 690 2.2460 900 900 900 176-PLANNING DEPT 338 1.1002 441 441 441 186-WELFARE DEPT 4,183 13.6161 5,457 5,457 5,457 193/194-COUNTY LIBRARY 4,200 13.6714 5,480 5,480 5,480 195/196-CO PARKS 4,210 13.7039 5,493 5,493 5,493 198-MUSEUM 4,097 13.3362 5,345 5,345 5,345 (120) HEALTH DEPT 1,863 6.0643 2,431 2,431 2,431 (121) MENTAL HEALTH 338 1.1002 441 441 441 (122) DRUGS & ALCOHOL 718 2.3372 937 937 937 (219/220) ROAD DEPT 1,630 5.3058 2,127 2,127 2,127 SubTotal 30,[PHONE REDACTED] 40,080 40,080 40,080 Total 30,[PHONE REDACTED] 40,080 40,080 40,080 Allocation Basis: SQUARE FOOTAGE CLEANED Allocation Source: AUDITOR CONTROLLER Page 122 Schedule 8.4.4 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .4 - Detail Activity Allocations 06/27/2013 11:19:46 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 For Department 119-BUILDINGS & GROUNDS Activity - B&G SERVICES Receiving Department Allocation Units Allocation Step1 Direct Billed Gross Allocation Allocation Percentage Total Allocation Allocation Step2 101-BD & CONSULT 1,560 5.0780 9,603 9,603 9,603 103-PERSONNEL 200 0.6510 1,231 1,231 1,231 105-AUDITOR/CONTROLLER 590 1.9205 3,632 3,632 3,632 107-CENTRAL SVCS 420 1.3671 2,586 2,586 2,586 110-TREAS/TAX COLLECTOR 490 1.5950 3,016 3,016 3,016 104-COUNTY CLERK 749 2.4381 4,611 4,611 54 4,665 113-COUNTY ASSESSOR 1,208 3.9322 7,436 7,436 87 7,523 146-DISTRICT ATTORNEY 750 2.4413 4,617 4,617 54 4,671 149-COUNTY SHERIFF 2,335 7.6007 14,374 14,374 169 14,543 158-PROBATION DEPT 152 0.4948 936 936 11 947 167-BUILDING DEPT 690 2.2460 4,248 4,248 50 4,298 176-PLANNING DEPT 338 1.1002 2,081 2,081 24 2,105 186-WELFARE DEPT 4,183 13.6161 25,750 25,750 303 26,053 193/194-COUNTY LIBRARY 4,200 13.6714 25,855 25,855 304 26,159 195/196-CO PARKS 4,210 13.7039 25,917 25,917 305 26,222 198-MUSEUM 4,097 13.3362 25,221 25,221 296 25,517 (120) HEALTH DEPT 1,863 6.0643 11,469 11,469 135 11,604 (121) MENTAL HEALTH 338 1.1002 2,081 2,081 24 2,105 (122) DRUGS & ALCOHOL 718 2.3372 4,420 4,420 52 4,472 (219/220) ROAD DEPT 1,630 5.3058 10,034 10,034 118 10,152 SubTotal 30,[PHONE REDACTED] 189,118 189,118 1,986 191,104 Total 30,[PHONE REDACTED] 189,118 189,118 1,986 191,104 Allocation Basis: TOTAL SQUARE FOOTAGE OCCUPIED Allocation Source: AUDITOR CONTROLLER Page 123 Schedule 8.4.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC. ---PAGE BREAK--- Total COUNTY OF ALPINE, CALIFORNIA OMB A-87 COST ALLOCATION PLAN BASED ON FY 2011-12 ACTUALS FOR USE IN FY 2013-14 Schedule .5 - Allocation Summary 06/27/2013 11:19:47 AM MaxCars - Cost Allocation Module ALPINE COUNTY, CALIFORNIA 2012 Version 1.0023-1 JANITORIAL SVCS ADMIN BUILDING LIBRARY COURTHOUSE For Department 119-BUILDINGS & GROUNDS Receiving Department B&G SERVICES 101-BD & CONSULT 40,115 0 0 28,477 2,035 9,603 103-PERSONNEL 5,143 0 0 3,651 261 1,231 105-AUDITOR/CONTROLLE 15,172 0 0 10,770 770 3,632 107-CENTRAL SVCS 10,801 0 0 7,667 548 2,586 110-TREAS/TAX 12,600 0 0 8,945 639 3,016 104-COUNTY CLERK 19,439 0 0 13,797 977 4,665 113-COUNTY ASSESSOR 31,351 0 0 22,252 1,576 7,523 146-DISTRICT ATTORNEY 5,649 0 0 0 978 4,671 149-COUNTY SHERIFF 47,053 29,464 0 0 3,046 14,543 158-PROBATION DEPT 3,063 1,918 0 0 198 947 167-BUILDING DEPT 5,198 0 0 0 900 4,298 176-PLANNING DEPT 2,546 0 0 0 441 2,105 186-WELFARE DEPT 31,510 0 0 0 5,457 26,053 193/194-COUNTY LIBRARY 74,220 0 42,581 0 5,480 26,159 195/196-CO PARKS 31,715 0 0 0 5,493 26,222 198-MUSEUM 30,862 0 0 0 5,345 25,517 (120) HEALTH DEPT 14,035 0 0 0 2,431 11,604 (121) MENTAL HEALTH 2,546 0 0 0 441 2,105 (122) DRUGS & ALCOHOL 5,409 0 0 0 937 4,472 (219/220) ROAD DEPT 12,279 0 0 0 2,127 10,152 Direct Billed 0 0 0 0 0 0 Total 400,706 31,382 42,581 95,559 40,080 191,104 Page 124 Schedule 8.5 All Monetary Values Are $ Dollars Report Output Prepared By MAXIMUS MAXCars © 2013 MAXIMUS, INC.