Docstoc

Startup Annual Budget

Document Sample
Startup Annual Budget Powered By Docstoc
					Instructions & notes for completing the Budget

MS Excel version 3 format should be used

Budget Summary worksheet
The budget summary includes all costs for both the startup and operating periods.
The length of the startup period is estimated by the provider in number of months since this phase is usually less than one year.
The 3 operating periods are assumed for this RFP to be full annual periods.

The startup capital, personnel costs, and purchased personnel totals need to be detailed in the worksheets B,C, & D.
           The personnel and purchased personnel totals are linked to the detailed worksheets.

All other costs are to be entered directly into the budget worksheet
Under the budget assumption column, add a brief explanation of the expense calculation

Administrative charges need to be on a % basis - do not input $$ for this item

Capital Items worksheet
For renovations or any other significant capital item (e.g. phone system), please add a brief explanation of cost assumption at bottom of worksheet

Staffing & Fringes
The positions listed and salaries are listed as a guide -If you plan on staffing the facility differently or will have additional staff not listed, please add them.




                                                                                                       D:\Docstoc\Working\pdf\1515dff8-fdab-4cfe-98d7-664cdc511883.xls
                                                              D:\Docstoc\Working\pdf\1515dff8-fdab-4cfe-98d7-664cdc511883.xls1515dff8-fdab-4cfe-98d7-664cdc511883.xls
BUDGET SUBMISSION

Notes: Cells highlighted in yellow need data input if applicable to your budget
       If an expense item in your budget is not listed below, add it.
      Include brief explanation for each expense under budget assumption column - for example, facility rent = "50,000/yr", electric/gas = $1,000/month
Startup Phase is the period from the start of the contract up to the first day of billable services.
                             Estimated startup phase is:                           months


Operating Phase assumes (3) annual periods                                     Data is for Illustration Only; enter your data

                                                                                                      Operating Phase
                                                          Startup Phase             Operating            Operating              Operating
                                                        Capital & Expenses          Expenses             Expenses               Expenses
                                                                                      Yr 1                  Yr 2                  Yr 3                       Budget Assumptions

Expenses
Startup Capital Items
Building Renovations                                                                            $0                      $0                   $0 Details to be provided on worksheet Exhibit B - Capital Items
Office furniture
Office equipment
Other

  Total                                                                   $0                      0                     $0                   $0

Personnel & staffing Costs
Staff Salaries & Fringes -                                            $2,150                $8,006                $8,006                $8,006 Details to be provided on worksheet Exhibit C - Staffing & Fringes
Purchased Personnel ( Consultants)                                        $0                $3,900                $7,800                    $0 Details to be provided on worksheet Exhibit D- Staffing & Fringes
Staff Recruiting (Want Ads)
Staff Security Checks & Drug testing
Staff Training
Other
  Total                                                               $2,150               $11,906               $15,806                $8,006

Occupancy Expenses
Facility Rent
Electric & Gas
Water & Sewer
Trash Removal
Maintenance Contracts(Lawn, Snow, Insect)
Insurance
Housekeeping ( Office cleaning)
Bldg & Office repairs
other
  Total Occupancy                                                         $0                    $0                      $0                   $0

Other Program Costs
Data Communications(Telephone & Internet)
Advertising
Postage
Office & computer Supplies
Program Supplies
Medical Supplies
Licenses & Registrations
Dues & subscriptions
Staff travel
Lease expense - vehicles
Other
  Total Program                                                           $0                    $0                      $0                   $0

Total Expenses Before Administrative Charge                           $2,150               $11,906                 $8,006                $8,006

Plus:Administrative Expense Charge
                                                                                                                                                                 D:\Docstoc\Working\pdf\1515dff8-fdab-4cfe-98d7-664cdc511883.xls
    Administratative Rate                                               10%                   10%                   10%                     10%
                                                                                                                                                                                                                8/22/20115:11 PM
    Administrative Expenses                                             $215                $1,191                  $801                    $801

Equals:Total Project Expenses                                         $2,365               $13,096                 $8,806                $8,806
EXHIBIT B                                                                                 Data is for Illustration Only; enter your data
Capital Items
PENNSYLVANIA HEALTHCHOICES



Note: The capital items listed below are examples of the types of purchases that may be needed. If there are additional capital items not listed, please add them.
       If some do not apply, then leave it blank
Cells highlighted in yellow are for input of data

                                                                                                                                            Operating Phase

                                                         Startup Phase                                    Year 1                                      Year 2                                        Year 3

Estimated Building Renovations Cost                                         $150,000                                            $0                                           $0                                          $0

Office Furniture                                   Qty       Ea Cost        Total              Qty       Ea Cost        Total            Qty         Ea Cost         Total             Qty         Ea Cost       Total
               desks                                8         $490          $3,920              0           $0           $0               0             $0            $0                0             $0          $0
               desk chair                                                     $0                                         $0                                           $0                                          $0
               area rug                                                       $0                                         $0                                           $0                                          $0
               file cabinet                                                   $0                                         $0                                           $0                                          $0
               sofa                                                           $0                                         $0                                           $0                                          $0
               tables                                                         $0                                         $0                                           $0                                          $0
               lamps                                                          $0                                         $0                                           $0                                          $0
               bookcase                                                       $0                                         $0                                           $0                                          $0
               other
                                                                            $3,920                                        $0                                           $0                                         $0

Office & IT Equipment
               Copiers                             2          $6,200       $12,400              0            $0           $0              2              $0            $0               2             $0          $0
               PC's                                10         $1,000       $10,000              0            $0           $0              10             $0            $0               10            $0          $0
               Printers                                                      $0                                           $0                                           $0                                         $0
               Server                                                        $0                                           $0                                           $0                                         $0
               Phone System                                                  $0                                           $0                                           $0                                         $0
               cell phones                                                   $0                                           $0                                           $0                                         $0
               telephones                                                    $0                                           $0                                           $0                                         $0
               other                                                         $0                                           $0                                           $0                                         $0
                                                                           $22,400                                        $0                                           $0                                         $0

Other




                Total Startup Capital                                     $176,320                                        $0                                           $0                                         $0




                                                                                                                                               D:\Docstoc\Working\pdf\1515dff8-fdab-4cfe-98d7-664cdc511883.xls
                                                                                                                                                                                              8/22/20115:11 PM
EXHIBIT C                                                                                        Data is for Illustration Only; enter your data
Staffing Expenses & Fringes
PENNSYLVANIA HEALTHCHOICES


                                                     Startup Phase                                             Year 1                                                   Year 2                                                   Year 3

                                                       Annual       # of mos                                     Annual       # of mos                                    Annual       # of mos                                    Annual       # of mos
                                                     Salary for    budgeted        Startup                     Salary for    budgeted        Startup                    Salary for    budgeted        Startup                    Salary for    budgeted        Startup
                                        F.T.E.'s      Position      to startup     1/1-6/30       F.T.E.'s      Position      to startup     1/1-6/30      F.T.E.'s      Position      to startup     1/1-6/30      F.T.E.'s      Position      to startup     1/1-6/30
staff
Supervisor/Coach                               1.0        $3,000               5        $1,250           1.0        $3,000              12        $3,000          1.0        $3,000              12        $3,000          1.0        $3,000              12        $3,000
Facilitators                                   4.0        $3,000               4        $4,000           4.0        $3,000              12       $12,000          4.0        $3,000              12       $12,000          4.0        $3,000              12       $12,000
Family Support Persons                         1.0        $3,000               2          $500           1.0        $3,000              12        $3,000          1.0        $3,000              12        $3,000          1.0        $3,000              12        $3,000
Youth Support Persons                          1.0        $3,000               2          $500           1.0        $3,000              12        $3,000          1.0        $3,000              12        $3,000          1.0        $3,000              12        $3,000
Clerical Support                               2.0        $3,000               2        $1,000           2.0        $3,000              12        $6,000          2.0        $3,000              12        $6,000          2.0        $3,000              12        $6,000
Other                                          1.0        $3,000                                         1.0        $3,000                                        1.0        $3,000                                        1.0        $3,000



   Total salaries                                                                       $7,250                                                   $27,000                                                  $27,000                                                  $27,000
fringe benefits - (A)                                                                   29.65%                                                    29.65%                                                   29.65%                                                   29.65%


total salaries & benefits                                                               $2,150                                                    $8,006                                                   $8,006                                                   $8,006




(A) Fringe Benefits Rate
FICA.                         7.65%
S.U.I.                        1.50%
Worker Comp                   2.00%
Pension                       5.00%
Health Insurance            15.00%
Other


                            29.65%    assume the same fringe rate will be used for all periods




                                                                                                                                                                        D:\Docstoc\Working\pdf\1515dff8-fdab-4cfe-98d7-664cdc511883.xls
                                                                                                                                                                                                                       8/22/20115:11 PM
EXHIBIT D
Purchased Personnel                                                               Data is for Illustration Only; enter your data
PENNSYLVANIA HEALTHCHOICES


                              Year 1                                   Year 2                                      Year 3
                                                   Total                                     Total                                       Total
                   # hrs per # hrs per   Hourly   Annual    # hrs per # hrs per   Hourly    Annual      # hrs per # hrs per   Hourly    Annual
        Position     week      year       rate     Cost       week      year       rate      Cost         week      year       rate      Cost

Other                    15        390      $10    $3,900         15        780       $10    $7,800           15        780       $10    $7,800
Other




                                                   $3,900                                    $7,800                                      $7,800




                                                                                   D:\Docstoc\Working\pdf\1515dff8-fdab-4cfe-98d7-664cdc511883.xls
                                                                                                                                  8/22/20115:11 PM

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:4
posted:8/22/2011
language:English
pages:5
Description: Startup Annual Budget document sample