Income Statement of an Egg - Excel by scc55619

VIEWS: 20 PAGES: 7

More Info
									                                   TOWN OF CLIFTON
                                        Income Statement
BUDGET MARKUP                                                                                       FYE 1106                     FYE 1006 YEAR TO 03-31             FYE 0906       FYE 0806    FYE0706
REVENUES:
Taxes & Permits Revenues:
  ABC Tax                                                                                                    $110                                                           $110    $222         $222
  ARB Permits (AVERAGE FYE 0906-0706)                                                                        $160                                            $100           $100    $290          $95
  BPOL                                                                                                    $18,000                                         $18,716        $15,148 $18,702      $20,827
  Cox & Verizon PEG Franchise Revenue & State Communication Sales and Use Tax( AVE FYE 0906-0706)          $5,700                                          $5,472         $5,933  $5,731       $5,444
  Motor Vehicle Tags(AVE FYE 0906-0706)                                                                    $4,500                                          $3,600         $4,597  $4,230       $4,854
  No. Va. Cigarette Tax( AVE FYE 0906-0706)                                                                $3,000                                          $1,896         $2,857  $2,928       $3,238
  Railroad Tax                                                                                             $1,500                                          $1,556         $1,423  $1,284       $1,194
  Sales Tax ($12139/9X12=$15185) (AVERAGE FYE 0906-0706=$23750-)                                          $15,185                                         $12,139        $22,138 $24,722      $24,391
  Meals Tax 2%                                                                                                 $0                NONE                            NONE        NONE        NONE
  Use Permits (AVE FYE 0906-0706)                                                                            $800                                           $325        $850      $1,300         $425
  Utility Consumption Tax( AVE FYE 0960-07096)                                                             $1,200                                           $925      $1,208      $1,100       $1,284
  Other Income (AVE FYE 0906-0706)                                                                           $700                                           $243      $1,029          $0       $1,200
TOTAL TAXES & PERMITS:                                                                                              $50,855
Town Facilities Rentals:
  Community Hall (AVERAGE FYE 0906-0706) ($16950+$20219+$13949=$17000)                                    $17,000                                          $9,580      $16,950     $20,219      $13,949
  Pink House ($1800X12=$21600-)                                                                           $21,600                                          $4,200 NONE         NONE        NONE
TOTAL FACILITIES RENTALS:                                                                                           $21,600
Other Revenues:
  Beautification Committee
    Homes Tour                                                                                             $5,000
    Beautification of Clifton Streetscape & Citizen Adoption                                                   $0
  Total Beautification Committee                                                                                     $5,000                              $4,567           $3,597      $5,800      $7,579
    CBA- Event Revenue                                                                                               $1,500      CLIFTON DAY & KIDS FESTIVAL              $1,965 NONE        NONE
    Wine Festival (NET)                                                                                             $20,000                                -$55          $18,093     $23,066 NONE
  Communication Committee                                                                                                $0
  Council for the Arts Committee
    Music Concert                                                                                          $1,500
    Calendar Sales                                                                                         $3,000                                          $1,621
    Art Show & Sale                                                                                          $500                                            $400
  Total Council for the Arts Committee                                                                               $5,000                                $2,021
  Environmental Comiittee
    Earth & Arbor Day Event                                                                                    $0
    Match for Environmental Grants                                                                             $0
  Total Environmental Committee                                                                                          $0
    Finance Committee                                                                                                    $0
    Haunted Trail Event (AVERAGE FYR-0906-0706)                                                                     $13,200                                $9,186        -$4,417       $13,766 NONE
  Historic Preservation Committee
    Historic Event in Town & Clifton Day Commemorative Cover                                               $1,000
    Historic Site Map/Booklet                                                                              $1,000
  Total Historic Preservation Committee                                                                              $2,000                                               $2,100        $3,138 NONE
    Interest Income                                                                                                    $650                                $2,363        $12,234       $18,697      $19,808
    Special Projects Committee                                                                                           $0
  Town Parks Committee                                                                                                   $0
    Property Rental-Park/Square/Gazebo                                                                     $2,675                                           $175           $950         $1,625 NONE
  Total Town Parks Committee                                                                                         $2,675
    Traffic, Parking and Safety Committee                                                                                $0
    Welcoming & Sunshine Committee                                                                                       $0
  Clifton Business Coalition
    CBC Membership Dues                                                                                    $2,660
    Scarecrow Contest                                                                                        $500
    Spring Egg Hunt                                                                                          $150
    Celebrate Clifton Gala                                                                                $12,000       Page 1
    Oktoberfest                                                                                            $8,000
  Total Clifton Business Coalition                                                                                  $23,310                                $3,029         $3,083        $5,632 NONE
  Other income               $0      $279
TOTAL OTHER REVENUE:    $73,335
TOTAL REVENUES:        $145,790




                            Page 2
EXPENSES:
Payroll Expenses:
   Town Clerk Salary                                              $5,921
   Town Treasurer Salary                                         $11,841
   Payroll Taxes                                                  $1,359
   Payroll Miscellaneous                                              $0
TOTAL PAYROLL EXPENSES:                                                    $19,121       $9,718   $17,285   $14,528   $12,683
CONTRACTUAL EXPENSES:
Insurance                                                                  $10,000       $9,640    $7,528    $6,145    $5,760
Town Government:
    ARB                                                                        $0
     BZA                                                                       $0
   Planning Commission
     Hearings for town plan, zoning ordinances, ads and copies    $2,000
     General Consulting                                           $2,000                  $600
     General Admin Costs                                          $1,000
     Capital Plan for Town                                        $5,000
   Total Planning Commission                                               $10,000       $4,692
TOTAL GOVERNMENT:                                                          $20,000
Professional Fees:
   Accounting - Year Audit Review                                 $7,000
   Legal Fees                                                    $16,000
   Special Counsel                                                    $0
   Web site hosting/maintenance                                       $0
TOTAL PROFESSIONAL FEES:                                                   $23,000      $23,471   $14,322   $28,025   $42,616
Town Facilities:
   Ayre Square Rent                                                          $950        $1,220
  Caboose Expenses:
      Equipment                                                      $0
      Utilities:                                                   $350
      Maintenance                                                  $250
  Total Caboose Expenses:                                                    $600
   Office Equipment Expense                                           $0
   Railroad Siding Rent                                             $675                  $775
   Old Town Hall Maintenance                                      $2,500    $3,175
Subtotal - Facilities:                                                      $4,725
  Town Meeting Hall Expenses:
      Hall Maintenance                                           $11,300
      Cleaning                                                        $0                 $1,125
      Electric                                                    $8,000                 $4,989
      Equipment & Supplies                                            $0                   $783
      General Maintenance                                             $0                 $5,495
      Mgt Fee (30% of Community Hall Rentals)                     $5,100                 $1,372
      Payroll Taxes                                                 $390
      Equipment Replacement & Hall Refurishment                  $30,000
      Misc                                                        $6,000                   $750
      Cable for A/C & Heating & Monitoring                          $720                 $1,147
      Reserve                                                     $5,000
 TOTAL MEETING HALL EXPENSES                                               $66,510                $20,410   $15,268   $22,024
  Pink House Expenses:
    Maintenance                                                   $1,250
     Repairs                                                      $1,250
  Total Pink House Expenses:                                                $2,500       $9,120
TOTAL TOWN FACILITIES:                                                     $73,735
Town Services:
   Grass Mowing                                                   $5,000                 $2,400
   Trash Collections                                                $840       Page 3      $576
TOTAL TOWN SERVICES:                                                        $5,840
Utilities:
   Utilities - Gas and Electric (Gazebo, Ayre Sq. & Old Town Hall)   $500
   Utilities - Sewer (Old Town Hall)                                 $300
TOTAL UTILITIES:                                                            $800      $1,615




                                                                             Page 4
Dues & Subscriptions:
   Conference Attendance                                        $0
   Other Dues & Subscriptions                                   $0
   Va Municipal League                                        $450                  $358
TOTAL DUES & SUBSCRIPTIONS:                                             $450
Other Contractual Expenses:
Beautification Committee
  Homes Tour                                                 $2,700
  Flowers-Ayres Square                                         $500
Total Beautification Committee                                         $3,200      $2,056   $4,417   $2,711    $2,210
Citizen Recognition Fund                                                 $500
Clifton Day Expenses                                                       $0
Clifton Triangle & Barrel Maintenance                                  $1,000
Communication Committee
  Web Server Annual Maintenance with Domain Subscriptions     $600
  Web Site Updating & Configuration                           $500
  Other - Town Awards                                         $200
Total Communication Committee                                          $1,300       $719
Council for the Arts Committee
  Music Concert                                              $1,500
  Calendar Sales                                             $3,000                $2,413
  Art Show & Sale                                              $500
Total Council for the Arts Committee                                   $5,000      $2,413
Environmental Committee
  Earth & Arbor Day Event                                       $0
 Match for Environmental Grants                                 $0
Total Environmental Committee                                              $0
Haunted Trail Event                                                    $4,000
Historic Preservation Committee
  Historic Event in Town & Clifton Day Commemorative Cover    $500
  Historic Site Map/Booklet                                   $500
  Town Museum                                                 $400
  HPC Membership & Education                                  $250
  Town Logo                                                   $500
Total Historic Preservation Committee                                  $2,150       $150
Legal Advertising                                                      $1,000       $972
Mayoral Reimbursement                                                      $0
Miscellaneous Contractual Expenses                                     $1,500       $206
Printing & Publication                                                     $0       $188
Special Projects Committee                                                 $0
Town Parks Committee
  Landscape/Ground Maintenance                               $3,000
  Tree Trimming and Replacement Planting                     $2,500
   Fall Zone Mulching                                          $500
  Seasonal Porta Potties Rental & Enclosure                  $4,000
  Mgt Fee (20% of Property Rentals)                            $535
Total Town Parks Committee                                            $10,535      $5,815   $5,551   $4,582   $13,676
Traffic, Parking and Safety Committee
    Sandwich Signs for Parking & Traffic Control @ Events      $300
    Orange Safety Cones                                        $400
    Safety Vests                                               $200
    Walkie-Talkies                                             $200
    Safety Plan Printing                                       $700
    Portable Generators                                      $1,700
Total Traffic, Parking and Safety Committee                            $3,200


                                                                          Page 5
Welcoming & Sunshine Committee
    Welcome Baskets-Emergency Funds for Town Victims of Catastrophic Events/Snow Removal Project   $1,500
Total Welcoming & Sunshine Committee                                                                          $1,500      $174
Other                                                                                                         $7,500             $3,763   $12,072
Clifton Business Coalition
    Celebrat/Holidays                                                                                $750
    Scarecrow Contest                                                                                $275
   Spring Egg Hunt                                                                                   $300
   Banners (Replace Needed Banners/Hardware                                                        $2,000
Total Clifton Business Coalition                                                                              $3,325      $793
TOTAL OTHER CONTRACTUAL:                                                                                     $45,710
Commodities:
   Computer Supplies                                                                                 $700                 $706
   Copies                                                                                            $100                  $53
   License Plates                                                                                    $900                 $463
   Miscellaneous Commodities                                                                         $500                  $24
   Office Supplies                                                                                   $500                 $329
   Postage & Delivery                                                                                $500                 $470
   Miscellaneous                                                                                   $2,500                  $17
TOTAL COMMODITIES:                                                                                            $5,000             $2,020    $3,016   $3,770
TOTAL EXPENSES:                                                                                             $193,656
NET INCOME (LOSS):                                                                                          -$47,866




                                                                                                                 Page 6
                                          Town of Clifton
                                     CAPITAL/GRANT
                                 REVENUE/COST STATEMENT


REVENUES:
 Clifton Entrance Triangle CBA Contribution                                        $6,000
FEDERAL GRANTS
Federal Trans. Project -ISTEA- Flood Plain Park                       $114,956                  $6,284
     CBA Contribution for Town Match/In-kind                           $10,000
     Contribution for Town Match/In-kind                               $20,000
     Town Match/In-kind                                                 $6,991
Total Flood Plain Park Grants                                                    $151,947
Fire Programs Grant                                                                $9,000       $8,000   $8,000   $8,000   $8,000
Litter Control Grant                                                               $1,000                $1,056   $1,000   $1,000
SAFETEA-LU Grant-Various Projects                                                $146,462       $7,300
TOTAL REVENUES:                                                                  $314,409
COSTS:
   Special Projects Committee
      Development of Streetscape Phase 1                               $56,000
      Development of Streetscape Phase 2                               $85,000
      Town of Clifton Flood Plain Park                                $134,956
   Total Special Projects Committee                                              $275,956      $12,410
   Pink House Front Porch                                                          $6,800
   Town Parks Committee
      New Victorina bench                                                $750
   Total Parks Committee                                                             $750                $2,760
Total Committee CIP Projects                                                     $283,506
Fire Program - FCFD                                                                $9,000       $8,000   $8,000   $8,000   $8,000
Litter Control                                                                     $1,000                    $0       $0       $0
Clifton Entrance Triangle                                                         $10,000
RR Siding Parking Facility                                                        $25,000
Temporay Storage Container (rr Box Car) or 8X8X20 Storage Container                $4,000
TOTAL COSTS                                                                      $332,506
NET REVENUES/(COST)                                                              -$18,097




                                                                                      Page 7

								
To top