xls file

							                                                                        410 Pub. Health Org. Exp.


                                                                                CASCADIA COUNTY
                                                                               BUDGET WORKSHEET
        ORGANIZATION UNIT - EXPENDITURE

        410 PUBLIC HEALTH

                                                                     FY I           FY II       FY III         FY IV         FY V         FY V           FY VI
Object Code                     Description                         Actual         Actual       Actual         Actual       Adopted       YTD          Requested

                             Personal Services

51105         Wages and salaries                                    $4,255,519     $4,665,345     $5,101,244   $5,208,662    $5,704,171   $2,946,306     $6,012,347
51110         Temporary salaries                                      $362,316       $516,802       $408,980     $533,296      $407,296     $280,490       $567,939
51115         Overtime and other pay                                   $54,327        $45,648        $37,498      $50,584       $73,947      $26,771        $85,262
51125         FICA                                                    $355,015       $395,855       $418,584     $437,701      $462,426     $245,955       $500,049
51130         Workers compensation                                     $28,605        $33,484        $26,147      $31,935       $26,052      $15,763        $28,854
51135         Employer paid work day tax                                $3,607         $3,831         $3,773       $3,655        $4,032       $1,764         $3,879
51140         Pers contribution                                       $502,397       $607,492       $574,733     $815,123      $909,863     $439,819       $944,622
51141         Pers reserve                                                  $0       $158,417       $312,359         $647            $0           $0             $0
51145         Pers pick up                                                  $0            $21             $0          $31            $0           $0             $0
51150         Health insurance                                        $739,400       $831,559     $1,042,989     $966,616    $1,165,142     $551,911     $1,273,406
51155         Life and long term disability insurance                  $13,478         $6,842         $7,223       $7,344        $8,569       $4,096        $13,536
51160         Unemployment insurance                                   $11,615        $11,321        $12,406      $28,417       $25,941      $15,365        $29,391
51165         Tri-Met tax                                              $26,826        $29,992        $31,720      $33,574       $38,410      $19,124        $42,975
51199         Misc Personal Services                                        $0             $0             $0           $0      $335,122           $0       $269,457

                                        Personal Services Total     $6,353,105     $7,306,609     $7,977,656   $8,117,585    $9,160,971   $4,547,364     $9,771,717


                           Materials and Supplies

51205         Supplies-office, general                                  $23,244      $17,942           $145          $19        $9,975          $41         $14,150
51210         Supplies- general                                         $58,195     $103,762       $122,477     $145,340      $146,789      $94,297        $201,455
51215         Supplies-computer                                               $0        $341         $1,005      $27,067            $0      $17,639          $1,500
51220         Supplies-food                                                   $2          $0             $0           $0            $0           $0              $0
51230         Supplies-automotive                                             $0      $2,750            $39           $0            $0           $0              $0
51240         Supplies-medical, general                                 $64,535     $112,635        $93,079     $113,921       $71,500      $45,420         $67,700
51245         Supplies-medical, medication                             $205,200     $228,669       $208,778     $287,560      $254,270     $191,196      $1,094,020
51270         Postage and freight                                       $30,261      $31,270        $52,607      $55,628       $59,895      $28,666         $64,655
51275         Books, subscriptions, and publications                    $51,513      $39,070        $27,078      $19,045       $26,032       $5,322         $21,125
51280                                                                  $244,914
              Services -contract, government, other professional services            $18,677           $175         $242            $0           $0              $0
51285         Services -professional services                          $841,909     $732,354       $538,366     $694,636      $844,978     $145,574        $683,993
51295         Advertising and public notice                             $28,775      $11,855        $10,198      $13,683       $23,950       $8,228         $26,600
51300         Printing and duplicating                                  $57,055      $49,463        $34,798      $35,478      $155,200          $42        $137,170
51305         Communications-services                                     $3,827     $13,722        $12,740      $15,829       $12,905      $11,412         $43,948
51310         Utilities                                                 $10,646      $16,836        $14,797      $13,898       $22,000      $14,462         $23,600
51315         Repair & maint services-automotive                              $0          $0            $19           $0            $0           $0              $0
51320         Repair & maint services-general                             $1,010      $2,476         $2,782       $3,194        $3,130       $3,235          $3,995
51330         Repair & maint services-computer hardware                       $0          $0           $149           $0            $0           $0              $0
51335         Repair & maint services-computer software                       $0         $73             $0       $1,445            $0           $0              $0
51340         Lease and rentals - space                                $101,192     $111,107       $110,671     $117,717      $105,595      $85,056        $112,176
51345         Lease and rentals - equipment                               $1,097        $812           $506       $1,142          $280         $550            $550
                                                                       410 Pub. Health Org. Exp.


                                                                              CASCADIA COUNTY
                                                                             BUDGET WORKSHEET
        ORGANIZATION UNIT - EXPENDITURE

        410 PUBLIC HEALTH

                                                                     FY I         FY II       FY III         FY IV         FY V         FY V         FY VI
Object Code                     Description                         Actual       Actual       Actual         Actual       Adopted       YTD        Requested

51350         Dues and membership                                     $15,471      $16,851        $17,448      $24,296       $23,398     $22,975       $25,842
51355         Training and education                                  $31,358      $16,439        $17,626      $19,393       $35,780      $6,908       $53,620
51360         Travel expense                                           $9,943      $12,268        $13,539      $16,526       $35,780      $7,354       $53,620
51365         Private mileage                                         $56,164      $58,749        $52,637      $49,785       $40,685     $20,478       $45,955
51385         Public information                                       $9,069       $7,737            $35           $0            $0          $0            $0
51390         Permits, licenses and fees                                   $0           $0        $22,715       $1,618        $5,600        $145        $3,960
51450         Insurance-liability and casualty internal                    $0       $7,589           $175           $0            $0        $240            $0
51460         Office Supplies- Internal                               $14,355      $21,741        $23,187      $23,779       $25,345     $21,700       $34,115
51465         Postage and freight- Internal                           $46,552      $45,826        $41,349      $42,461       $32,403     $21,727       $36,262
51470         Mail Messenger Services- Internal                        $9,521      $13,019        $13,731      $14,062       $13,444      $6,722       $13,955
51475         Printing- Internal                                      $36,549      $53,792        $48,221      $66,545       $24,385     $16,419       $27,610
51480         Photocopy machine- Internal                             $27,674      $24,543        $24,425      $21,003       $19,729     $14,407       $18,975
51495         Telephone monthly- internal                             $44,125      $45,071             $0           $0            $0          $2            $0
51500         Telephone long-distance- Internal                        $1,181           $0             $0           $0            $0          $0            $0
51505         Telecom equipment install- Internal                      $1,686          $90           $865         $965          $500        $877          $500
51510         Telecom Cellular Air Time- Internal                      $8,961       $9,527        $10,405         $196        $8,768          $0          $285
51515         Office space- Internal                                       $0      $33,097             $0           $0            $0          $0            $0
51520         Facilities charges- Internal                           $185,734       $1,311         $2,871       $1,816        $1,500          $0        $1,500
51525         Fleet -Internal (non-capital)                           $43,577      $54,777        $58,821      $73,202       $75,256     $42,592       $93,406
51535         Software licenses                                            $0       $3,309            $96         $340            $0          $0            $0
51545         Department vehicle damage deductible                     $1,163         $245         $1,000       $1,209            $0          $0            $0
51550         Other materials and services                                 $0       $1,891           $853       $6,801      $273,588          $0      $153,630
51555         Inventory Issued Default Account                             $0          $95             $0           $0            $0          $0            $0

                                    Materials and Supplies Total    $2,266,458   $1,921,781     $1,580,408   $1,909,841    $2,352,660   $833,686     $3,059,872


                                Capital Outlay

57115         Machinery and equipment over $5,000                          $0      $21,003        $12,403         $124            $0      $7,400            $0
57120         Vehicles                                                $20,249      $65,185        $37,360      $38,996       $56,500     $22,845       $16,500
57130         Furniture and fixtures-over $5,000                           $0      $84,164             $0      $25,838            $0          $0            $0
57146         Data processing- no chargeback                           $9,214      $27,062        $29,033           $0            $0          $0            $0
57155         Computer equipment- over $5,000                          $4,591      $14,540           $750           $0            $0          $0            $0

                                             Capital Outlay Total     $34,054     $211,954        $79,546      $64,958       $56,500     $30,245       $16,500


                               Other Expenses

52005         Bank Service Charge                                      $1,962       $3,026         $3,347       $3,100        $3,579      $3,895        $3,579
52010         Refunds                                                      $0           $0          ($256)          $0            $0          $0            $0
52130         Other Special Expenditures                             $176,288     $241,187       $399,487     $481,141      $349,200    $209,245      $328,537
                                                                       410 Pub. Health Org. Exp.




                                                                              CASCADIA COUNTY
                                                                             BUDGET WORKSHEET
        ORGANIZATION UNIT - EXPENDITURE

        410 PUBLIC HEALTH

                                                                     FY I         FY II       FY III        FY IV          FY V         FY V           FY VI
Object Code                      Description                        Actual       Actual       Actual        Actual        Adopted       YTD          Requested


                                            Other Expenses Total     $178,250     $244,213      $402,578      $484,241      $352,779     $213,140       $332,116


                             Interfund Expenses

53040         Interdpt chg-facilities capital                         $11,398       $8,852       $17,788        14,000          $125           $0           $125
53055         Interdpt chg-general                                       $160          $20            $4       $10,490        $1,085       $3,842           $120
53505         Intradpt chg - General                                       $1          ($2)           $1           ($3)           $0           $2             $0

                                         Interfund Expenses Total     $11,559       $8,870       $17,793       $24,487        $1,210       $3,844           $245


        410 PUBLIC HEALTH GRAND TOTAL                               $8,843,426   $9,693,427   $10,057,981   $10,601,112   $11,924,120   $5,628,279    $13,180,450