CY 2010 Budget Worksheets by XYrV9gO

VIEWS: 8 PAGES: 4

									                                                                                                           COUNTY FAIR
                                                                                            Accrued Revenue and Expenses - 2010
                                                                                                                                                                                              RUNNING BUDGET COMPARISON
                                                   Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected   TOTAL     BUDGETED    PROJECTED
                                                    Jan-10    Feb-10    Mar-10    Apr-10    May-10    Jun-10    Jul-10    Aug-10    Sep-10    Oct-10    Nov-10    Dec-10      2010       2010         2010     VAR $        VAR %
BEGINNING OPERATING RESERVE, ACCT 29100                   $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0
REVENUE EARNED
   State Allocation (Local Base Allocation Only)          0         0         0         0         0         0         0         0         0         0         0         0         0
   Operating Revenue
       Admissions to Grounds                              0         0         0         0         0         0         0         0         0         0         0         0         0           0           0            0
       Commercial Space                                   0         0         0         0         0         0         0         0         0         0         0         0         0           0           0            0
       Concessions                                        0         0         0         0         0         0         0         0         0         0         0         0         0           0           0            0
       Exhibits                                           0         0         0         0         0         0         0         0         0         0         0         0         0           0           0            0
       Great Western Livestock Show                       0         0         0         0         0         0         0         0         0         0         0         0         0           0           0            0
       Satellite Wagering                                 0         0         0         0         0         0         0         0         0         0         0         0         0           0           0            0
       Fair Attractions                                   0         0         0         0         0         0         0         0         0         0         0         0         0           0           0            0
       Interim Attractions                                0         0         0         0         0         0         0         0         0         0         0         0         0           0           0            0
       Miscellaneous Fair                                 0         0         0         0         0         0         0         0         0         0         0         0         0           0           0            0
       Miscellaneous Non-Fair Programs                    0         0         0         0         0         0         0         0         0         0         0         0         0           0           0            0
       Interim Revenue                                    0         0         0         0         0         0         0         0         0         0         0         0         0           0           0            0
       Prior Year Revenue Adjustment                      0         0         0         0         0         0         0         0         0         0         0         0         0           0           0            0
       Other Operating Revenue                            0         0         0         0         0         0         0         0         0         0         0         0         0           0           0            0
   TOTAL OPERATING REVENUE                                0         0         0         0         0         0         0         0         0         0         0         0         0           0           0            0
   TOTAL AVAILABLE FUNDS                                  0         0         0         0         0         0         0         0         0         0         0         0         0
EXPENSES INCURRED
   Operating Expenses
       Administration                                     0         0         0         0         0         0         0         0         0         0         0         0         0            0          0             0
       Maintenance & General Operations                   0         0         0         0         0         0         0         0         0         0         0         0         0            0          0             0
       Publicity                                          0         0         0         0         0         0         0         0         0         0         0         0         0            0          0             0
       Attendance Operations                              0         0         0         0         0         0         0         0         0         0         0         0         0            0          0             0
       Miscellaneous Fair                                 0         0         0         0         0         0         0         0         0         0         0         0         0            0          0             0
       Miscellaneous Non-Fair Programs                    0         0         0         0         0         0         0         0         0         0         0         0         0            0          0             0
       Premiums                                           0         0         0         0         0         0         0         0         0         0         0         0         0            0          0             0
       Exhibits                                           0         0         0         0         0         0         0         0         0         0         0         0         0            0          0             0
       Great Western Livestock Show                       0         0         0         0         0         0         0         0         0         0         0         0         0            0          0             0
       Satellite Wagering                                 0         0         0         0         0         0         0         0         0         0         0         0         0            0          0             0
       Fair Entertainment Expense                         0         0         0         0         0         0         0         0         0         0         0         0         0            0          0             0
       Interim Entertainment Expense                      0         0         0         0         0         0         0         0         0         0         0         0         0            0          0             0
       Equipment (Funded by Fair)                         0         0         0         0         0         0         0         0         0         0         0         0         0            0          0             0
       Prior Year Expense Adjustment                      0         0         0         0         0         0         0         0         0         0         0         0         0            0          0             0
       Cash (over/under)                                  0         0         0         0         0         0         0         0         0         0         0         0         0            0          0             0
       Depreciation Expense                               0         0         0         0         0         0         0         0         0         0         0         0         0            0          0             0
       Capital Expenditures (Funded by Fair)              0         0         0         0         0         0         0         0         0         0         0         0         0            0          0             0
   TOTAL EXPENSES INCURRED                                0         0         0         0         0         0         0         0         0         0         0         0         0            0          0             0
ENDING OPERATING RESERVE, ACCT 29100                     $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0           0           0            0




  Version 1.1
  Run date: 10/3/2012, 7:31 AM
                                                      BUDGET WORKSHEET
                                                                                                                     W-JLA

       SUMMARY OF JUNIOR LIVESTOCK AUCTION

                                                            Acct.   Actual       Budgeted       Estimated       Proposed

                                                             No.    2008          2009            2009           2010

       RESOURCES, JANUARY 1:                                25100                                           0              0



       AUCTION REVENUES:



          Percentage from Auction Sales                     47610

          Sponsorships                                      47620

          Advertising Sales                                 47630

          Reimbursements                                    47640

          Prior Year Revenue Adjustment                     47650

          Other (List)                                      47660



             TOTAL REVENUES                                 47600            0              0               0              0



        TOTAL RESOURCES AVAILABLE                                            0              0               0              0



       AUCTION EXPENDITURES:

          Jr. Livestock BBQ, lunch, dinner, etc.            57620

          Labor Costs                                       57630

          Employee Benefits                                 57631

          Payroll Taxes                                     57632

          Worker's Compensation Insurance                   57633

          Supplies & Expense                                57640

          Publicity and Marketing                           57650

          Leases and /or Rentals                            57660

          Fuel & Utilities                                  57670

          Prior Year Expense Adjustment                     57680

          Other (List)                                      57690



             TOTAL EXPENDITURES                             57600            0              0               0              0



       RESOURCES, DECEMBER 31:                              25100            0              0               0              0




       NET EFFECT                                                            0              0               0              0

       INFORMATION ONLY:

        Payment from Buyers / Payment to Sellers            25200
         (Excluding the percentage retained to offset the
                           expenses)


       Percentage retained by fair/committee                                 %              %               %              %

2010 Budget Worksheet                                                                                                          2 of 4
                                                          BUDGET WORKSHEET
                                                                                                                  W-FLSA

                                   FAIR LABOR STANDARDS ACT (FLSA) RECREATIONAL EXEMPTION



                                                      2010 Monthly Cash Receipts


                               METHOD OF DETERMINING APPLICABILITY OF RECREATIONAL EXEMPTION



DO NOT INCLUDE STATE FUNDING.



                   January

                   February

                   March

                   April

                   May

                   June

                   July

                   August

                   September

                   October projected

                   November projected

                   December projected



                   TOTAL



                   Lowest six months:                           Amount                   Highest six months:       Amount




                              TOTAL                                                               TOTAL



The total of the lowest six months divided by the total of the highest six months =                            #DIV/0!

If the result exceeds 33 1/3% or .333, your exemption is lost for 2009 and overtime should

be budgeted for temporary employees accordingly.

  2010 Budget Worksheet                                                                                             3 of 4
                                                                                                    BUDGET WORKSHEET
                                                                                                                                                                                                             W-EB

Employee Benefits and Payroll Taxes
                                                  Schedule 1A                                                                               Schedule 1B

Salaries:                             50100         52100       65105       50200       52200        54100       56100       57105       63100            64100       65100       65105       66100       66209

  Total form Sch 1A

  Total from Sch 1B



Benefits (Employer's portion): *

  Retirement Contribution                     0             0           0

  Medical Ins. Prem.

  Dental Ins. Prem.

  Vision Ins. Prem.

  Life Ins. Prem.

  Other Benefits

     TOTAL - Forward to                       0             0           0

       Appropriate Benefit Account    50310         52210       65115



Payroll Taxes (Employer's portion):

  Social Security (OASDI) @ 6.2%              0             0           0

  Hospital Ins. (HI) @ 1.45%                  0             0           0           0           0            0           0           0           0                0           0           0           0             0

  PST fees @$4.45

     TOTAL - Forward to                       0             0           0           0           0            0           0           0           0                0           0           0           0             0

            Appropriate Tax Account   50320         52220       65125       50320       52220        54120       56120       57125       63120            64120       65220       65125       66120       66229



Worker's Compensation *

  Schedule 1A & 1B                            0             0           0           0           0            0           0           0           0                0           0           0           0             0

  Volunteers

     TOTAL - Forward to                       0             0           0           0           0            0           0           0           0                0           0           0           0             0

            Appropriate WC Account    50330         52230       65135       50330       52230        54130       56130       57135       63130            64130       65230       65135       66130       66239




IMPORTANT:
The totals on this worksheet do not carry forward to budget pages.
* Contact appropriate provider (e.g. CFSA) for current rates and modify formulas as appropriate for your organization.




     2010 Budget Worksheet                                                                                                                                                                                 4 of 4

								
To top