Spreadsheet: 45bd8eb8-eab1-45a8-8381-e8c0cb81f2c8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Directions: | Budget Spreadsheet Directions Bidders should complete the spreadsheet by filling in projections for all rows highlighted in yellow. We are hopeful but do not necessarily expect the rows highlighted in blue to change with a potential new service provider and bidders may use our assumptions from the 2013 Study if warranted. However, if the bidder determines a change in the budget projection for one of the blue rows is warranted, you may adjust the number but should also explain the reason for the change.   If you are bidding on only one portion of the contract (shelter or field services):  You only need to provide one projected budget, and may place a zero in any budget sections that do not apply to the service they are bidding on.   If you are bidding on the full contract (both shelter and field services):  Please provide separate budgets for shelter and field services. If you believe cost savings can be achieved by utilizing a single provider for the full contract, you may include a third budget that combines shelter and field services. | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EXPENDITURES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YCAS Current Budgets ¹ |  |  | Projected Budget Scenarios:                                                          KSMP Recommended Staffing Levels ² |  | Bidder Proposed Budget
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YCAS 12-13 | YCAS 13-14 ⁴ | YCAS 13-14             (Including costs not listed in YCAS budget) ⁵ | JPA Contracts with Non-Profit ⁷ | Hybrid Model            (JPA Contracts with Non-Profit for Sheltering/ Public Agency for Field Services)⁸ | Year 1 | Year 2 | Year 3
Actual From final Budget Documents |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PY |  | PY |  | PY |  | PY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FTE: 20 | FTE: 18 ⁹ | FTE: 25.3 ⁹ | FTE: 29 | FTE: 29 | FTE: | FTE: | FTE:
88/89 | 89/90 | 90/91 | 91/92 | 92/93 | 93/94 | 94/95 | 95/96 | 96/97 | 97/98 | 98/99 | 99/00 | 00/01 | 01/02 | 02/03 | 03/04 | 04/05 | 06/07 | 06/07 | 07/08 | 07/08 | 08-09 | 09-10 |  | Benefits: 38% ¹¹ | Benefits: 38% | Benefits: 38% | Benefits: 27% | Benefits: 27%; 38% | Benefits: | Benefits: | Benefits:
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 387070.1 | 384804 | 445594 | 502157 | 500700.72 | 571629 | 659959.85 | 799025 | 798486.36 | 858804.11 | 727656 | Regular Salaries | 725204 | 793909 | 793909 | 1074500 | 1111500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Additional Salaries ¹³ | 0 | 0 | 236000 | 0 | 0 | 0 | 0 | 0
0 | 8963 | 3949 | 3862 | 0 | 2512 | 10136 | 8516 | 0 | 0 | 0 | 119 | 8465.72 | 0 | 16279 | 39932 | 71961.08 | 86232 | 89908.57 | 50000 | 101979.84 | 0 | 0 | Part-Time Wages ¹⁴ | 10000 | 0 | 152400 | 116550 | 116550
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Employee Benefits | 0 | 0 | 0 | 397700 | 502700
22197 | 22434 | 17011 | 20982 | 15391 | 17441 | 27182 | 30706 | 32494 | 44739 | 36913 | 49250 | 66541.71 | 79213 | 91319 | 100772 | 127817.58 | 105044 | 72435.93 | 60000 | 70847.37 | 51286.79 | 70413 | Overtime/Standby | 53621 | 53621 | 53621 | 0 | 0 | 0 | 0 | 0
6966 | 7278 | 7094 | 7416 | 7414 | 7855 | 8087 | 7715 | 7392 | 7455 | 7088 | 6666 | 6319.5 | 6605 | 15893 | 18504 | 15500.99 | 7071 | 7095.5 | 10000 | 8832.77 | 9267.3 | 11561 | Differentials- Bilingual/Shift | 902 | 2106 | 2106 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 438.65 | 742 | 152.32 | 902 | 253.16 | 216.36 | 258 | Payoff/Vacation Buy-Back | 6000 | 6000 | 6000 | 0 | 0 | 0 | 0 | 0
1025 | 918 | 687 | 431 | 387 | 432 | 418 | 429 | 716 | 1146 | 1217 | 1426 | 868.46 | 867 | 827 | 1568 | 1524.39 | 1119 | 376.42 | 1788 | 0 | 0 | 0 | Retirement | 168035 | 191976 | 191976 | 0 | 0 | 0 | 0 | 0
3891 | 1524 | 312 | 1281 | 0 | 0 | 2691 | 834 | 6020 | 7395 | 2215 | 4977 | 674.54 | 2994 | 111 | 4128 | 8780.34 | 10 | 3445.82 | 3500 | 3726.31 | 6144.55 | 0 | OASDI | 45195 | 51846 | 51846 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16542.6 | 18966 | 30639 | 34982 | 75407.21 | 104348 | 116639.86 | 134807 | 139662.78 | 167589.48 | 149769 | Medicare Tax | 10568 | 12126 | 12126 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 29474.14 | 29743 | 35394 | 41585 | 45156.18 | 47907 | 51986.56 | 51489 | 61255.49 | 57912.72 | 62796 | Insurance- Health/Dental/Vision | 158847 | 228715 | 228715 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6893.13 | 6956 | 8277 | 9712 | 10560.7 | 11204 | 12158.15 | 12044 | 14325.85 | 13544.13 | 0 | Unemployment Insurance | 14625 | 8954 | 8954 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 41483.21 | 43765 | 65264 | 86373 | 92287.55 | 106909 | 102746.23 | 119152 | 164996.33 | 189498.9 | 139331 | Workers Compensation Insurance | 59608 | 63208 | 63208 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other Benefits | 37960 | 43176 | 43176 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 2910.97 | 2047 | 3236.55 | 2911 | 3141.86 | 3141.86 | 23908 | Additional Benefits (YCSPCA Employees)¹⁵ | 0 | 0 | 31800 | 0 | 0 | 0 | 0 | 0
34079 | 41117 | 29053 | 33972 | 23192 | 28240 | 48514 | 48200 | 46622 | 60735 | 47433 | 62438 | 564333.11 | 573913 | 709597 | 839713 | 953046.3599999999 | 1044262 | 1120141.76 | 1245618 | 1367508.12 | 1357406.2 | 1185692 | Salaries & Benefits | 1290565 | 1455637 | 1875837 | 1588750 | 1730750 | 0 | 0 | 0
0 | 0 | 30 | 14 | 14 | 14 | 28.96 | 41 | 0 | 0 | 24 | 217 | 105.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Clothing ¹⁶ | 12800 | 16400 | 16400 | 8000 | 8000
1916 | 3178 | 5018 | 4341 | 4629 | 5302 | 5273.52 | 4578 | 4422 | 5532 | 4905 | 8080 | 8913.94 | 9017 | 8770 | 10607 | 12670.35 | 11756 | 14257.82 | 13699 | 14897.21 | 15735.27 | 12371 | Communications/IT Services | 23116 | 22374 | 22374 | 23000 | 23000 | 23000 | 23000 | 23000
13327 | 17751 | 9410 | 12378 | 9079 | 7945 | 6837 | 5271 | 5610 | 7846 | 8615 | 15255 | 14015.74 | 11492 | 21788 | 18460 | 18802.71 | 17735 | 15499.09 | 16044 | 16151.27 | 19629.44 | 18121 | Public Liability | 78350 | 76379 | 76379 | 76379 | 76379 | 76379 | 76379 | 76379
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 74.7 | 0 | 10 | Shelter Food and Supplies | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000
272 | 4080 | 3484 | 4727 | 2011 | 6703 | 8563 | 7794 | 5600 | 6365 | 6860 | 6968 | 6067.49 | 12325 | 13347 | 21819 | 33587.99 | 25510 | 26805.01 | 28183 | 20774.96 | 11940.32 | 17533 | Tools and Equipment | 26939 | 16164 | 16164 | 20000 | 20000 | 20000 | 20000 | 20000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 748.85 | 426.56 | 0 | Medical, Dental, and Lab Supplies | 47500 | 35000 | 35000 | 35000 | 35000 | 35000 | 35000 | 35000
0 | 0 | 0 | 0 | 0 | 0 | 0 | 1016 | 0 | 0 | 0 | 0 | 0 | 42304 | 4700 | 4297 | 7011 | 8382 | 10457 | 0 | 29062 | 67514 | 67514 | Office Supplies ¹⁷ | 22937 | 22937 | 22937 | 25000 | 25000 | 25000 | 25000 | 25000
2424 | 2251 | 2408 | 4172 | 3574 | 3525 | 4135 | 6303 | 5515 | 7543 | 7184 | 9392 | 7676.01 | 10984 | 10738 | 8421 | 15893.43 | 13122 | 22573.3 | 15000 | 20317.51 | 25683.22 | 22581 | Household (Janitorial) | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000
296 | 104 | 1164 | 342 | 640 | 427 | 6282 | 6261 | 2407 | 6076 | 10096 | 11351 | 7836.35 | 3189 | 12272 | 37163 | 7067.75 | 20499 | 5898.96 | 18000 | 4069.67 | 13208.36 | 5000 | Maintenance- Equipment, Buildings, Vehicles | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Professional Medical Services | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 43992 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Professional Services (Contracts for Veterinarians) ¹⁸ | 144758 | 200000 | 0 | 0 | 0 | 0 | 0 | 0
16117 | 9913 | 8953 | 8479 | 8807 | 6908 | 12754 | 10151 | 11543 | 14974 | 12935 | 12926 | 17423.46 | 1592 | 974 | 136 | 845.98 | 32361 | 35482.24 | 40000 | 43808.54 | 45042.23 | 35305 | Rental/Lease- Equipment | 4200 | 4200 | 4200 | 4200 | 4200 | 4200 | 4200 | 4200
0 | 0 | 0 | 0 | 0 | 35 | 35 | 75 | 75 | 75 | 175 | 75 | 175 | 324 | 302 | 377 | 474 | 444 | 403.67 | 400 | 594 | 594 | 1050 | Memberships | 1050 | 1050 | 1050 | 1050 | 1050 | 1050 | 1050 | 1050
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 971.28 | 1713.3 | 1500 | Training Expenses | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000
0 | 0 | 45 | 90 | 14 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 6.8 | 30 | 0 |  | 0 | 0 | 0 | 100 | 0 | 0 | 100 | Transportation/Travel | 10000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Utilities ¹⁹ | 0 | 0 | 45982 | 46000 | 46000 | 46000 | 46000 | 46000
1502 | 1780 | 1231 | 1297 | 838 | 1080 | 1220 | 1197 | 1789 | 2102 | 2681 | 3640 | 2410.09 | 3487 | 4127 | 9017 | 8504.63 | 7680 | 9533.49 | 7392 | 9502.22 | 10586.69 | 7395 | Vehicle Fuel ²º | 68000 | 80000 | 80000 | 85000 | 85000 | 85000 | 85000 | 85000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]. Expenses (Credit Card Charge/ Cash Shortage) | 1600 | 1600 | 1600 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overhead Costs ²¹ | 0 | 0 | 123399 | 123399 | 123399 | 123399 | 123399 | 123399
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Legal Counsel ²² | 0 | 0 | 10395 | 10500 | 10500 | 10500 | 10500 | 10500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JPA Oversight ²³ | 0 | 0 | 0 | 5000 | 5000 | 5000 | 5000 | 5000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual Audit ²⁴ | 0 | 0 | 0 | 10000 | 10000 | 10000 | 10000 | 10000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JPA Management ²⁵ | 0 | 0 | 0 | 4800 | 4800 | 4800 | 4800 | 4800
7612 | 9231 | 5433 | 8479 | 7629 | 8397 | 9522 | 8388 | 7338 | 10894 | 9309 | 589 | 9098.78 | 15936 | 14797 | 11054 | 14010.93 | 13907 | 15078.92 | 14387 | 17620.93 | 16133.42 | 10650 |  | .
43466 | 48288 | 37176 | 44319 | 37235 | 40336 | 54650.48 | 51075 | 44299 | 61407 | 62804 | 68493 | 117721.16 | 110680 | 91815 | 121351 | 118868.77 | 151396 | 155989.5 | 153205 | 178593.14 | 228206.81 | 199130 | Services & Supplies | 518250 | 554104 | 533880 | 555328 | 555328 | 547328 | 547328 | 547328
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lease of Building ²⁶ | 0 | 0 | 61382.40000000001 | 61382.40000000001 | 61382.40000000001 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Buildings and Improvements | 0 | 0 | 61382 | 61382.40000000001 | 61382.40000000001 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Equipment - Vehicle | 42000 | 50000 | 50000 | 75000 | 75000 | 75000 | 75000 | 75000
0 | 0 | 33517 | 256 | 74338 | 19900 | 85921 | 34305 | 0 | 36031 | 18189 | 10417 | 0 | 3630 | 28881 | 12013 | 0 | 47475 | 13430.54 | 99400 | 105532.98 | 22574.44 | 8372
0 | 0 | 33517 | 256 | 74338 | 19900 | 85921 | 34305 | 0 | 36031 | 18189 | 10417 | 0 | 3630 | 28881 | 12013 | 0 | 47475 | 13430.54 | 99400 | 105532.98 | 22574.44 | 8372 | Equipment | 42000 | 50000 | 50000 | 75000 | 75000 | 75000 | 75000 | 75000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Expenditures | 1850815 | 2059741 | 2521099 | 2280460.4 | 2422460.4 | 622328 | 622328 | 622328
EXPENDITURES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REVENUES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YCAS Current Budgets |  |  | Projected Budget Scenarios:                                                          KSMP Recommended Staffing Levels ² |  | Bidder Proposed Budget
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YCAS 12-13 | YCAS 13-14 | YCAS 13-14             (Including costs not listed in YCAS budget) | JPA Contracts with Non-Profit | Hybrid Model            (JPA Contracts with Non-Profit for Sheltering/ Public Agency for Field Services) | Year 1 | Year 2 | Year 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FTE: 20 | FTE: 17 | FTE: 25.3 | FTE: 29 | FTE: 29 | FTE: | FTE: | FTE:
 |  |  |  |  |  |  |  |  | 130054 | 140299 | 151396 | 157189 | 165309 | 158447 | 179166 | 184500 | 190904 | 211708.5 | 209000 | 204228.7 | 247569 | 327051 |  | Benefits: 38% | Benefits: 38% | Benefits: 38% | Benefits: 27% | Benefits: 27%; 38% | Benefits: | Benefits: | Benefits:
 |  |  |  |  |  |  |  |  | 900 | 1100 | 1100 | 1250 | 1650 | 1750 | 1450 | 2925 | 2750 | 1600 | 2000 | 1400 | 1850 | 2700 | Animal Licenses ¹ | 290000 | 400000 | 400000 | 532637.47 | 532637
80185 | 121275 | 122114 | 132591 | 103088 | 139998 | 137620 | 138458 | 135871 | 52011 | 51906 | 50413 | 82821.12 | 80927 | 78085 | 106953 | 110619.29 | 123115 | 122653.34 | 122000 | 128567.4 | 172149.48 | 201202 | Business Licenses - Kennels | 2700 | 2700 | 2700 | 2700 | 2700 | 2700 | 2700 | 2700
0 | 0 | 500 | 800 | 750 | 650 | 650 | 1403 | 1050 | 200 | 180 | 352 | 430 | 485 | 427 | 500 | 625 | 3798 | 390 | 700 | 6690.88 | 376 | 700 | Humane Services | 200000 | 201115 | 201115 | 201115 | 201115 | 201115 | 201115 | 201115
38431 | 41965 | 42948 | 41183 | 50186 | 49695 | 54608 | 56046 | 52911 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other Charges for Services | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700
50 | 95 | 80 | 130 | 220 | 245 | 640 | 528 | 239 | 183165 | 193485 | 203261 | 241690.12 | 248371 | 238709 | 288069 | 298669.29 |  | 336351.84 | 333700 | 340886.98 | 421944.48 | 531653
 |  |  |  |  |  |  |  |  | 423333 | 467289 | 474559 | 484068.85 | 599783 | 623774 | 755177 | 744803 | 919536 |  | 0 | -3817.8 | 0 | 0 | Fees & Charges | 493400 | 604515 | 604515 | 737152.47 | 737152 | 204515 | 204515 | 204515
118666 | 163335 | 165642 | 174704 | 154244 | 190588 | 193518 | 196435 | 190071 | 0 | 0 | 0 | 97368.07 | 115421 | 164057 | 0 | 0 |  |  | 317935 | 0 | 277676 | 191432 | Contracts with Agencies ² | 1111313 | 1091268 | 1091268 | 1091268 | 1091268 | 1091268 | 1091268 | 1091268
210956 | 240175 | 299032 | 336560 | 373210 | 371719 | 420209 | 417892 | 406100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yolo County Contribution ³ | 298467 | 315459 | 315459 | 315459 | 315459 | 315459 | 315459 | 315459
0 | 0 | 0 | 0 | 0 | 30800 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YCSPCA Contribution ⁴ | 0 | 0 | 135000 | 135000 | 135000 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheriff's Department Contribution ⁵ | 0 | 0 | 85200 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yolo County Contribution (Overhead) ⁶ | 0 | 0 | 123399 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yolo County Contribution (Use of Building) ⁷ | 0 | 0 | 61382.40000000001 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yolo County Contribution (Utilities) ⁸ | 0 | 0 | 45982 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Legal Counsel ⁹ | 0 | 0 | 10395 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 423333 | 467289 | 474559 | 581436.9199999999 | 715204 | 787831 | 755177 | 744803 | 919536 | 0 | 317935 | -3817.8 | 277676 | 191432
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 3726 | 2756 | 1078 | 2344.83 | 3798 | 6057.44 | 4500 | 6557.79 | 4267.69 | 4500 | Payments from Agencies | 1409780 | 1406727 | 1868085.4 | 1541727 | 1541727 | 1406727 | 1406727 | 1406727
210956 | 240175 | 299032 | 336560 | 373210 | 402519 | 420209 | 417892 | 406100 | 8611 | 1738 | 2224 | 8456.11 | 545 | 23656 | 2850 | 4531.11 | 24528 | 4065.29 | 4000 | 7219.16 | 5817.5 | 4000 | Investment Earn - Restricted | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8133 | 21587 | 7956 | 53293.96 | 27078 | 226284 | 57883 | 45911.42 | 15514 | 8482.2 | 7000 | 9639.9 | 15362.88 | 17791 | Other Income | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unclaimed Property (Trust) | 0 | 35000 | 35000 | 0 | 0 | 0 | 0 | 0
24 | 1776 | 0 | 234 | 3881 | 280 | 72 | 550 | 848 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Donations and Grants ¹º | 17000 | 5000 | 5000 | 100000 | 100000
0 | 0 | 351 | 662 | 648 | 760 | 1188 | 1868 | 2350 | 16744 | 23325 | 10180 | 61750.07 | 31349 | 252696 | 61811 | 52787.36 | 43840 | 18604.93 | 15500 | 23416.85 | 25448.07 | 26291
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other | 25500 | 48500 | 48500 | 108500 | 108500 | 8500 | 8500 | 8500
24 | 1776 | 351 | 896 | 4529 | 1040 | 1260 | 2418 | 3198 | 623242 | 684099 | 688000 | 884877.1099999999 | 994924 | 1279236 | 1105057 | 1096259.65 | 963376 | 354956.77 | 667135 | 360486.03 | 725068.5499999999 | 749376
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Revenues | 1928680 | 2059742 | 2521100.4 | 2387379.47 | 2387379 | 1619742 | 1619742 | 1619742
329646 | 405286 | 465025 | 512160 | 531983 | 594147 | 614987 | 616745 | 599369
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL EXPENDITURES AND REVENUES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YCAS Current Budgets |  |  | Projected Budget Scenarios:                                                          KSMP Recommended Staffing Levels ² |  | Bidder Proposed Budget
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YCAS 12-13 | YCAS 13-14 | YCAS 13-14             (Including costs not listed in YCAS budget) | JPA Contracts with Non-Profit | Hybrid Model            (JPA Contracts with Non-Profit for Sheltering/ Public Agency for Field Services) | Model Shelter, Field Services or Both | Model Shelter, Field Services or Both | Model Shelter, Field Services or Both
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FTE: 20 | FTE: 17 | FTE: 25.3 | FTE: 29 | FTE: 29 | FTE: | FTE: | FTE:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Benefits: 38% | Benefits: 38% | Benefits: 38% | Benefits: 27% | Benefits: 27%; 38% | Benefits: | Benefits: | Benefits:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EXPENDITURES | 1850815 | 2059741 | 2521099 | 2280460.4 | 2422460.4 | 622328 | 622328 | 622328
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REVENUES | 1928680 | 2059742 | 2521100.4 | 2387379.47 | 2387379 | 1619742 | 1619742 | 1619742
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NET AMOUNT | 77865 | 1 | 1.399999999906868 | 106919.0699999998 | -35081.39999999991 | 997414 | 997414 | 997414
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expenditures Footnotes:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1. The three brown columns display information regarding the existing YCAS budget. The first column displays the expenditures and revenues for FY 12-13, the second column displays the expenditures and revenues for FY 13-14, and the third column displays the FY 13-14 budget adding actual costs including donated labor, unpaid overhead costs, and other items not included in the YCAS budget in order to provide an actual budget for comparison purposes.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2. The three green columns display the KSMP recommended employment level (29 FTE) for each of the three scenarios.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3. The three blue columns use the current YCAS employment level (25.3 FTE) for each of the three scenarios.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4. YCAS budget for 13-14 based on information provided by the Sheriff's Finance Department.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5. There are numerous costs associated with providing animal services to Yolo County that are not reflected in the existing YCAS budget. In order to provide an accurate baseline cost for our study we have identified these costs, and included them in the third brown column. These costs include items such as donated labor from YCSPCA and the Sheriffs Department, free use of the existing shelter facility, and unpaid overhead costs. This column provides the actual cost of animal services in the County.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6. The JPA model assumes that all staff are employees of the JPA, which is governed by Yolo County, [NAME], [NAME], West Sacramento, [NAME], and Woodland.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7. This model assumes that the JPA has no employees, and contracts for all services (including field services) with a non-profit.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8. This model assumes that the JPA has no employees. Instead, the JPA contracts animal sheltering services to a non-profit and contracts with a public agency (such as the Sheriff's Department) for field services.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9. The employment level at YCAS for FY 13-14 is 18 full-time employees (according to the Sheriff's Finance Department). However, this does not include contract veterinarians, unpaid inmates working in the kennels, part-time/ extra help employees, or staff paid by Yolo County SPCA (permanently housed at YCAS). After considering all the employees involved in offering animal services to Yolo County, the actual FTE is 25.3.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10. The KSMP staffing and programming study recommends the equivalent of 29 full-time employees for YCAS. Further detail regarding the recommended staffing levels can be found in the KSMP report.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11. YCAS currently pays its 18 FTE an average of 38% of their total compensation in benefits.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12. Benefits for the JPA model are estimated at 30% based on a Bureau of Labor Statistics report stating that private employer costs for employee benefits averaged 29.7% of total compensation. SOURCE: Bureau of Labor Statistics (June 12, 2013). Employer Costs for Employee Compensation. Retrieved from http://www.bls.gov/news.release/pdf/ecec.pdf. Benefits for the JPA Contract with Non-Profit model are estimated slightly lower, at 27%.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13. The additional salaries costs for FY 13-14 represent an estimate of the salaries for the two full-time staff paid by Yolo County SPCA, as well as the cost of YCAS' contract veterinarian (previously listed in the budget under Services and Supplies).
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14. The part-time wages costs for FY 13-14 represents an estimate of the cost of replacing part-time employees currently provided by the Sheriff's Department or YCSPCA. This includes a part time (0.4) Volunteer Coordinator (paid for by the Sheriff's Department), a part-time (0.4) Program Coordinator (paid for by YCSPCA), and seven unpaid inmates working part-time as kennel workers (provided free of charge by the Sheriff's Department). In the blue and green columns the part-time wages row reflects the total cost of part-time employees included in each scenario.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15. Reflects the estimated costs of YCSPCA benefits provided to their two donated employees housed at YCAS.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16. The existing cost for clothing at YCAS includes $1,000 annually for field officers, and $600 annually for Clerks. In the new entity we have assumed that the front office staff will no longer have to wear a uniform. Therefore, we have projected the cost of providing uniforms to field officers to remain the same ($1,000 per field officer annually * 8 Field Officers= $8,000), while all other employees will be expected to wear their own clothing.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17. The cost of office supplies has been projected to increase a small amount in the green columns due to the increase in staffing.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18. YCAS budgeted $200,000 for contracts with veterinarians in FY 13-14. The initial $150,000 pays for the full-time contract veterinarian with KSMP.  The additional $50,000 pays for additional contracted hours as needed.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19. The FY 12-13 utilities bill for YCAS was $4,981.64. However, an estimated additional $1,000 has been added to all budget projections for water and sewage. Water and sewage services are shared between YCAS and the jail, with an approximate combined bill of $4,000. It is not possible to separate the cost of YCAS and the jail, so we have included an estimate of the portion that YCAS would be responsible for.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20. The cost of vehicle fuel has been projected to increase a small amount in the green columns due to the increase in staffing.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21. Reflects the cost of overhead services currently provided by Yolo County, but not included in the YCAS budget. Due to a longstanding [NAME] between the County and Sheriffs Department, these costs are not currently paid for by the Sheriff. Overhead costs include building/equipment use, the countywide audit, IT services, human resources, the CAO's office, treasurer-tax collector, auditor-controller, and general services. If a JPA is formed, all of these services will need to be provided and paid for.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22. Reflects the actual costs of County Counsel services provided to YCAS in FY 12-13, which are not currently paid for due to an MOE between the Sheriff's Department and County. If a JPA is formed, this service will need to be paid for.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23. Reflects the cost of JPA oversight services provided by the Yolo County Auditor-Controller. Estimate was provided by the Yolo County Auditor-Controller's Office.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24. If a JPA is formed the JPA will be responsible for conducting an annual independent audit. The price of an audit is estimated at $10,000, based on an estimate from the Yolo County Auditor-Controller.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25. If a JPA is formed the JPA will need to contract with an agency for JPA management services, including the management and enforcement of RFPs, MOUs, contracts. The $4,800 included in this budget is based on an estimate from the Yolo County Administrator's Office regarding what it would cost for them to provide the service. This estimate includes an estimated 60 hour of work annually, at  the CAO's staff rate of $80 per hour.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26. Currently, YCAS is housed in a building owned by Yolo County. If the governance model of YCAS changes the organization should expect to lease the building from Yolo County at a market rate. The rate used for these budget projections (as quoted by the Yolo County Administrator's Office) is $0.80 per square foot, with a total of 6,394 Sq. Ft. for the existing building and ancillary. 0.8 per sq. ft. * 6,394 sq. ft.= $5,115.2 * 12 months= $61,382.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Revenues Footnotes:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.  Revenues from animal licenses have been projected to increase for models utilizing the KSMP staffing and programming recommendations. The KSMP study projects that through increases in canvassing and collections efforts, dog license compliance can increase from 30% to 40%. Estimates were calculated by multiplying the average "per dog" license revenues ($25.69) by the estimated increase in dog licenses (5,163 dogs), then added to the existing revenue projections ($400,000). This estimate does not include a projected increase for cat licenses, although revenues from cat licenses would likely increase a small amount.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2. The agency contributions to YCAS have been projected to remain the same ( so that the Net Amount is relative to current costs for comparison purposes). This includes contracts with [NAME], West Sacramento, Winters, Woodland, and [NAME].
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3. The County's contributions to YCAS have been projected to remain the same (so that the Net Amount is relative to current costs for comparison purposes).
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4. Reflects estimated revenues associated with Yolo County SPCA's contribution of 2.4 employees to YCAS. This contribution is included as a "revenue" in order to offset the cost of these employees included in the "expenditures" portion of the budget. We have assumed that this partnership with YCSPCA will continue even if the governance model of YCAS is changed.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5. Reflects estimated revenues associated with the Yolo County Sheriff's Department's contribution of 7 part-time unpaid inmates working in the kennels, and a part-time (0.4 FTE) [NAME]. We have assumed that these contributions would not continue if the governance model of YCAS is changed.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6. Reflects the resources associated with overhead services offered to YCAS by Yolo County free of charge. These services include services such as equipment use and maintenance, the countywide audit, IT services, human resources, the CAO's office, treasurer-tax collector, auditor-controller, and general services. We have assumed that YCAS will be expected to begin paying for these services if the governance model is changed.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7. Reflects the resources associated with using the existing YCAS building, which Yolo County currently provides free of charge. If the governance model changes this will have to be paid for at a market rate. The rate used for these budget projections is $0.80 per square foot, with a total of 6,394 Sq. Ft. for the existing building and ancillary. 0.8 per sq. ft. * 6,394 sq. ft.= $5,115.2 * 12 months= $61,382.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8. Reflects the cost of utilities including electric, water, and sewage, which Yolo County currently pays for YCAS.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9. Reflects the resources associated with Yolo County providing legal counsel to YCAS free of charge. We have assumed that YCAS will be expected to begin paying for this service if the governance model is changed.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10. The KSMP staffing recommendations include a full-time Development Coordinator position. This person is projected to raise a minimum of $100,000 in grants and donations annually. However, the actual revenues will be unpredictable, and may be more or less than this estimate on any given year.