Docstoc

xlsx file

Document Sample
xlsx file Powered By Docstoc
					                                                               Data 172 Personnel Exp. Project


                                                                    CASCADIA COUNTY
                                                                   BUDGET WORKSHEET
          PROJECT LEVEL - EXPENDITURE

       390 HOUSING SERVICES

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

                            Personal Services

  51105       Wages and salaries                               $1,340,985    $1,603,792   $1,577,135   $1,448,834   $1,575,628    $821,933    $1,753,849
  51110       Temporary salaries                                $122,965      $138,243     $112,260       $63,327           $0     $22,557            $0
  51115       Overtime and other pay                                $379          $777         $998        $4,032           $0       $943             $0
  51125       FICA                                              $110,480      $131,552     $127,984     $114,513     $118,912      $62,455     $132,169
  51130       Workers compensation                                 $4,720        $8,062       $7,674       $9,012      $12,002      $6,475       $14,784
  51135       Employer paid work day tax                           $1,136        $1,358       $1,189        $978        $1,054       $478         $1,058
  51140       Pers contribution                                 $162,757      $194,003     $181,275     $214,822     $249,716     $120,967     $280,244
  51141       Pers reserve                                             $0       $50,806      $98,569        $318            $0          $0            $0
  51150       Health insurance                                  $225,474      $307,697     $338,276     $290,605     $336,192     $170,755     $388,944
  51155       Life and long term disability insurance              $4,481        $2,371       $2,208       $2,089       $2,215      $1,163        $3,592
  51160       Unemployment insurance                               $3,407        $3,694       $3,559       $6,727       $6,800      $3,669        $8,029
  51165       Tri-Met tax                                          $8,358        $9,990       $9,690       $8,744       $9,938      $4,957       $11,504
  51175       Automobile allowance                                 $4,296        $4,331       $4,296       $4,296       $4,260      $2,130        $4,260
  51180       Other employee allowances                            $1,304        $1,310       $1,305       $1,431       $1,300       $798         $1,300
  51199       Misc Personal Services                                   $0            $0           $0           $0      $90,263          $0       $72,040

                                     Personal Services Total   $1,990,742    $2,457,986   $2,466,418   $2,169,728   $2,408,280   $1,219,280   $2,671,773


                          Materials and Supplies

  51205       Supplies-office, general                             $4,093       $2,441         $254         $301         $517         $819         $566
  51210       Supplies- general                                         $0      $1,877          $79           $0           $0           $0           $0
  51215       Supplies-computer                                        $30       $628          $842          $96         $237           $0           $0
  51220       Supplies-food                                          $119        $464          $136           $0           $0           $0           $0
  51255       Supplies-parts, equipment                                 $0      $2,088
  51270       Postage and freight                                  $1,782       $2,630       $1,650        $845         $828         $660        $1,639
  51275       Books, subscriptions, and publications               $3,096       $2,598       $4,154       $2,522       $3,433       $2,174       $3,433
  51280       Services -contract, government, other professional services
                                                                   $6,450           $0          $20           $0           $0           $0           $0
                                                               Data 172 Personnel Exp. Project


                                                                    CASCADIA COUNTY
                                                                   BUDGET WORKSHEET
          PROJECT LEVEL - EXPENDITURE

       390 HOUSING SERVICES

                                                                 FY I          FY II         FY III        FY IV          FY V      FY V          FY VI
Object Code                      Description                    Actual        Actual        Actual         Actual        Adopted    YTD         Requested
   51285      Services -professional services                    $21,729            $0           $60                $0         $0          $0          $0
   51295      Advertising and public notice                        $376         $1,300          $293                $0         $0          $0          $0
   51300      Printing and duplicating                                $0          ($81)         ($12)               $0         $0          $0          $0
   51320      Repair & maint services-general                      $903          $867
   51345      Lease and rentals - equipment                           $0         $142             $0          $210          $519         $0            $0
   51350      Dues and membership                                $12,158       $11,594        $8,918         $9,648       $12,217    $7,983       $12,645
   51355      Training and education                             $20,479        $5,252        $2,034         $2,383           $74     $689         $1,712
   51360      Travel expense                                      $8,437        $3,420        $1,170          $847         $1,439    $1,861        $4,608
   51365      Private mileage                                      $162          $207          $451           $923         $1,291     $868         $1,801
   51390      Permits, licenses and fees                              $0            $0            $0             $0            $0       $20            $0
   51420      Insurance                                           $4,074        $5,772        $7,842         $7,829            $0    $3,876        $8,023
   51460      Office Supplies- Internal                          $19,964       $24,130       $16,547        $16,213       $16,377   $10,096       $19,631
   51465      Postage and freight- Internal                      $34,597       $43,446       $41,491        $37,574       $30,529   $13,559       $29,368
   51470      Mail Messenger Services- Internal                   $6,543        $6,826        $8,242        $10,051        $9,696    $4,848       $10,051
   51475      Printing- Internal                                 $11,894       $14,151        $6,514         $2,503        $4,208    $2,569        $2,857
   51480      Photocopy machine- Internal                        $28,873       $29,548       $25,417        $18,276       $19,585    $7,875       $16,543
   51495      Telephone monthly- internal                        $14,927       $16,224            $0             $0            $0        $0            $0
   51500      Telephone long-distance- Internal                    $784             $0            $0             $0            $0        $0            $0
   51505      Telecom equipment install- Internal                 $2,121            $0            $0          $437             $0        $0            $0
   51510      Telecom Cellular Air Time- Internal                $12,457       $16,602       $13,856        $10,242        $8,825    $5,326       $10,028
   51520      Facilities charges- Internal                        $1,794            $0            $0             $0            $0        $0            $0
   51525      Fleet -Internal (non-capital)                       $2,005        $1,331         $285           $284          $369        $54            $0
   51535      Software licenses                                       $0            $0            $0             $0            $0     $250          $621
   51550      Other materials and services                       $22,798        $3,550        $4,129         $4,217        $5,375    $1,925        $2,551
   51555      Inventory Issued Default Account                       $17         $130            $54             $0            $0        $0            $0


                                Materials and Supplies Total    $242,662      $197,137      $144,426       $125,401      $115,519   $65,452      $126,077


                       Miscellaneous Expenditures

  52130       Other Special Expenditures                                 $0            $0             $0   $223,200            $0          $0          $0
                                                            Data 172 Personnel Exp. Project


                                                                 CASCADIA COUNTY
                                                                BUDGET WORKSHEET
           PROJECT LEVEL - EXPENDITURE

        390 HOUSING SERVICES

                                                              FY I         FY II        FY III         FY IV          FY V          FY V          FY VI
Object Code                Description                       Actual       Actual       Actual          Actual        Adopted        YTD         Requested
   57146    Data processing- no chargeback                     $2,000       $3,920               $0             $0          $0             $0          $0
   59010    Contingency                                            $0           $0               $0             $0          $0             $0      $1,075

                         Miscellaneous Expenditures Total      $2,000       $3,920               $0    $223,200             $0             $0      $1,075


                          Interfund Expenses

   53010     Interdpt chg-indirect charges                   $220,826     $266,000     $337,289        $335,981       $361,811     $241,207      $370,879
   53015     Interdpt chg-legal services                      $14,139       $3,474       $9,842          $4,428         $3,586       $1,862        $2,087
   53020     Interdpt chg-prof services                         $390        $2,126
   53025     Interdpt chg-storage space -archives              $4,791       $4,877      $10,891          $9,498         $9,144       $3,506        $7,514
   53040     Interdpt chg-facilities capital                   $5,291      $11,831        $712               $0             $0           $0            $0
   53050     Interdpt chg-debt service recovery               $13,031           $0
   53055     Interdpt chg-general                            $138,674           $8       $3,530          $2,115             $0             $0          $0

                                  InterfundExpenses Total    $397,142     $288,316     $362,264        $352,022       $374,541     $246,575      $380,480

       3901 General Administration Total                    $2,632,546   $2,947,359   $2,973,108      $2,870,351     $2,898,340   $1,531,307    $3,179,405


       3902 General Maintenance

                          Personal Services

   51105     Wages and salaries                              $150,846     $278,808     $269,376        $297,892       $310,701     $174,349      $412,177
   51110     Temporary salaries                               $11,810     $133,761      $34,158              $0             $0           $0            $0
   51115     Overtime and other pay                            $1,468       $5,711      $13,245         $14,768        $14,176       $9,247       $20,138
   51125     FICA                                             $12,555      $31,999      $24,233         $23,919        $23,768      $14,045       $31,532
   51130     Workers compensation                               $527        $1,953       $1,244          $1,719         $2,471       $1,303        $3,849
   51135     Employer paid work day tax                         $132         $349         $234            $199           $217           $99         $275
   51140     Pers contribution                                $15,446      $31,657      $33,780         $38,764        $49,340      $24,797       $65,950
   51141     Pers reserve                                          $0       $9,037      $18,007             $61             $0           $0            $0
                                                               Data 172 Personnel Exp. Project


                                                                    CASCADIA COUNTY
                                                                   BUDGET WORKSHEET
          PROJECT LEVEL - EXPENDITURE

       390 HOUSING SERVICES

                                                                 FY I          FY II         FY III        FY IV          FY V      FY V          FY VI
Object Code                    Description                      Actual        Actual        Actual         Actual        Adopted    YTD         Requested
   51145      Pers pick up                                            $0            $0            $0          $125             $0      ($125)          $0
   51150      Health insurance                                   $23,718       $51,732       $59,446        $57,827       $69,216    $36,509     $101,232
   51155      Life and long term disability insurance              $380          $317          $316           $344          $341        $206        $746
   51160      Unemployment insurance                               $381          $895          $577          $1,283        $1,400       $739       $2,089
   51165      Tri-Met tax                                          $992         $2,508        $1,845         $1,922        $1,962     $1,110       $2,706
   51199      Misc Personal Services                                  $0            $0            $0             $0       $22,271      ($314)     $22,855

                                     Personal Services Total    $218,255      $548,727      $456,461       $438,823      $495,863   $261,965     $663,549


                       Miscellaneous Expenditures

  59010       Contingency                                                $0            $0             $0            $0         $0          $0        $906

                                         Miscellaneous Total             $0            $0             $0            $0         $0          $0        $906

      3902 General Maintenance Total                            $218,255      $548,727      $456,461       $438,823      $495,863   $261,965     $664,455


      3903 Shelter

                          Materials and Supplies

  51205       Supplies-office, general                                  $0          $0            $0             $0            $0        $42          $87
  51280       Services -contract, government, other professional services0
                                                                        $           $0            $0             $0            $0        $87        $216
  51320       Repair & maint services-general                           $0          $0            $0             $0            $0        $39           $0
  51360       Travel expense                                            $0          $0            $0             $0            $0      $356         $884
  51395       Salary Reimbursement                                $19,107      $23,746       $34,505        $33,552       $36,707     $9,319      $46,540
  51405       Benefit Reimbursement                                $7,279       $9,812       $15,569        $14,227       $17,306     $3,892      $28,613
  51406       Other Cost Reimbursement                             $7,702       $9,306        $8,107         $8,116        $9,311     $1,486       $3,039
  51420       Insurance                                                 $0          $0            $0            $63            $0      $126         $261
  51550       Other materials and services                           $212           $0            $0             $0       $11,818         $0       $4,503
                                                                 Data 172 Personnel Exp. Project




                                                                      CASCADIA COUNTY
                                                                     BUDGET WORKSHEET
          PROJECT LEVEL - EXPENDITURE

       390 HOUSING SERVICES

                                                                   FY I         FY II         FY III        FY IV          FY V      FY V          FY VI
Object Code                     Description                       Actual       Actual        Actual         Actual        Adopted    YTD         Requested
                                Materials and Supplies Total       $34,300      $42,864       $58,181        $55,958       $75,142    $15,347      $84,143

                                       InterfundExpenditures

  53015                            Interdpt chg-legal services        $138              $0       $169          $844         $1,001      $881        $1,036

              Interfund Total                                         $138              $0       $169          $844         $1,001      $881        $1,036

                       Miscellaneous Expenditures

  52020       HAP Occupied Units                                  $231,879     $415,132      $525,415       $592,502      $924,069   $412,806     $979,558
  52130       Other Special Expenditures                           ($3,005)          $0            $0             $0            $0         $0           $0
  58015       Bad debt expense                                       $150            $0            $0             $0            $0         $0           $0

              Miscellaneous Expenditures Total                      ($2,855)            $0             $0            $0         $0          $0          $0


      3903 Shelter Total                                           $31,583      $42,864       $58,350        $56,802       $76,143    $16,228      $85,179



      3904 Supported Housing

                          Materials and Supplies

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:2/23/2014
language:Unknown
pages:5