Get documents about "Startup Budget and First 6 Months Operating Expenses - Excel
Description
Startup Budget and First 6 Months Operating Expenses document sample
Document Sample
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\cbf3f5f7-477a-4582-a774-655e26178455.xls
D:\Docstoc\Working\pdf\cbf3f5f7-477a-4582-a774-655e26178455.xlscbf3f5f7-477a-4582-a774-655e26178455.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\cbf3f5f7-477a-4582-a774-655e26178455.xls
Administratative Rate 10% 10% 10% 10%
9/19/20112:46 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\cbf3f5f7-477a-4582-a774-655e26178455.xls
9/19/20112:46 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\cbf3f5f7-477a-4582-a774-655e26178455.xls
9/19/20112:46 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\cbf3f5f7-477a-4582-a774-655e26178455.xls
9/19/20112:46 PM
Related docs
Other docs by sfn55444
