Docstoc

B.2 FY10 NCNC Multiple site 6 mo budget ver Jul 24-2009

Document Sample
B.2 FY10 NCNC Multiple site 6 mo budget ver Jul 24-2009 Powered By Docstoc
					A 1 2 3 4 5 6 7 (Check One) New

B

C

D

E

F

G

H Appendix B, Page Document Date:

I 7/24/2009

HUMAN SERVICES AGENCY GRANT BUDGET SUMMARY FOR MULTIPLE SITES
Grantee's Name Grant Term

Tenderloin Housing Clinic, Inc.
Renewal ____ Modification ____ No. of Mod. HSA Funding Hartland Hotel 7/1/09-12/31/09 $283,366 $498,169 $781,535 9.5% $74,246 $0 $26,036 $881,817 HSA Funding HSA Funding HSA Funding HSA Funding HSA Funding

July 1, 2009 - Dec. 31, 2009

8 If modification, Effective Date of Mod. 9 Program: Non Care Not Cash Hotels 10 11 12 13 14 15 Budget Reference Page No.(s) Program Term Expenditures Salaries & Benefits Operating Expense Subtotal 16 Indirect Percentage (%) 17 Indirect Cost (Line 16 X Line 17) 18 Capital Expenditure 19 Subsidies 20 Total Expenditures 21 HSA Revenues 22 General Fund 23 24 25 26 27 28 29 30 TOTAL HSA REVENUES 31 Other Revenues 32 Rental Income 33 34 35 36 TOTAL OTHER REVENUES 37 GRAND TOTAL REVENUES 38 Total Number of Assisted Units 39 40 41 43 Prepared by: 44 HSA-CO Review Signature: 45 HSA #1

HSA Funding

HSA Funding Only

Jefferson Hotel Looper Hotel Mission Hotel 7/1/09-12/31/09 7/1/09-12/31/09 7/1/09-12/31/09 $275,225 $315,914 $591,139 9.5% $56,158 $6,439 $25,491 $679,226 $56,507 $171,058 $227,565 9.5% $21,619 $7,500 $14,540 $271,224 $362,604 $710,457 $1,073,060 9.5% $101,941 $8,940 $52,895 $1,236,836

Raman Hotel Seneca Hotel Vincent 7/1/09-12/31/09 7/1/09-12/31/09 7/1/09-12/31/09 $245,965 $263,348 $509,313 9.5% $48,385 $10,600 $6,528 $574,825 $383,966 $620,511 $1,004,477 9.5% $95,425 $550 $40,708 $1,141,160 $269,344 $325,741 $595,084 9.5% $56,533 $10,900 $26,767 $689,284

Total $1,876,977 $2,905,196 $4,782,173 $454,306 $44,928 $192,964 $5,474,371

$511,817

$392,726

$138,224

$591,836

$415,825

$619,660

$424,284

$3,094,371

$511,817 $370,000

$392,726 $286,500

$138,224 $133,000

$591,836 $645,000

$415,825 $159,000

$619,660 $521,500

$424,284 $265,000

$3,094,371 $808,000

$370,000 $881,817 137

$286,500 $679,226 111

$133,000 $271,224 43

$645,000 $1,236,836 248

$159,000 $574,825 85

$521,500 $1,141,160 204

$265,000 $689,284 103

$286,500 $4,785,087 931

Wynne Tang

Telephone No.: 885-3286 x111

Date:7/24/09

11/15/2007

A 1 2 3 4 Program Name: 5 (Same as Line 9 on HSA #1) 6 7 8 9 10 11

B

C

D

E

F

G

H

I

J

K

L

M

Salaries & Benefits Detail
HSA Funding 7/1/09-12/31/09 Agency Totals Annual Full TimeSalary Total % for FTE FTE $24,674 $19,427 $36,672 $92,299 $27,359 $16,975 $24,740 $20,524 $27,777 $92,655 $27,359 $18,106 $22,241 $19,266 $13,406 $13,406 $25,893 $19,450 $18,750 $55,923 $91,878 $34,598 $31,707 $22,173 $20,520 $18,155 $98,798 $13,680 $15,386 $25,880 $21,353 $17,094 $56,302 $99,870 $40,766 $33,326 $22,916 $20,000 $27,777 $92,548 $27,086 $16,322 100% 100% 200% 640% 200% 100% 100% 100% 150% 650% 200% 100% 100% 100% 100% 100% 100% 100% 100% 300% 650% 250% 200% 100% 100% 100% 700% 100% 100% 100% 100% 100% 300% 720% 250% 200% 100% 100% 150% 650% 200% 100% Hartland Hotel 7/1/09-12/31/09 For HSA Program Adjusted FTE 100% 100% 200% 640% 200% 100% 100% 100% 150% 650% 200% 100% 100% 40% 50% 50% 100% 100% 100% 300% 650% 250% 200% 100% 100% 100% 700% 100% 100% 100% 100% 100% 300% 720% 250% 200% 100% 100% 150% 650% 200% 100% HSA Funding Jefferson Hotel 7/1/09-12/31/09 HSA Funding Looper Hotel 7/1/09-12/31/09 HSA Funding Mission Hotel 7/1/09-12/31/09 HSA Funding Raman Hotel 7/1/09-12/31/09 HSA Funding Seneca Hotel 7/1/09-12/31/09 HSA Funding Vincent 7/1/09-12/31/09 HSA Funding Only TOTAL

12

POSITION TITLE

% FTE 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 40% 50% 50% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100%

Budgeted Salary $24,674 $19,427 $36,672 $92,299 $27,359 $16,975

Budgeted Salary

Budgeted Salary

Budgeted Salary

Budgeted Salary

Budgeted Salary

Budgeted Salary $24,674 $19,427 $36,672 $92,299 $27,359 $16,975

13 General Manager 14 Assistant Manager 15 Case Manager 16 Desk Clerks 17 Janitors 18 Maintenance Worker 19 General Manager 20 Assistant Manager 21 Case Manager 22 Desk Clerks 23 Janitors 24 Maintenance Worker 25 General Manager 26 Case Manager 27 Desk Clerks 28 Janitors 29 General Manager 30 Assistant Manager I 31 Assistant Manager II 32 Case Manager 33 Desk Clerks 34 Janitors 35 Maintenance Worker 36 General Manager 37 Assistant Manager 38 Case Manager 39 Desk Clerks 40 Janitors 41 Maintenance Worker 42 General Manager 43 Assistant Manager I 44 Assistant Manager II 45 Case Manager 46 Desk Clerks 47 Janitors 48 Maintenance Worker 49 General Manager 50 Assistant Manager 51 Case Manager 52 Desk Clerks 53 Janitors 54 Maintenance Worker 55

$24,740 $20,524 $27,777 $92,655 $27,359 $18,106 $22,241 $7,707 $6,703 $6,703 $25,893 $19,450 $18,750 $55,923 $91,878 $34,598 $31,707 $22,173 $20,520 $18,155 $98,798 $13,680 $15,386 $25,880 $21,353 $17,094 $56,302 $99,870 $40,766 $33,326 $22,916 $20,000 $27,777 $92,548 $27,086 $16,322

$24,740 $20,524 $27,777 $92,655 $27,359 $18,106 $22,241 $7,707 $6,703 $6,703 $25,893 $19,450 $18,750 $55,923 $91,878 $34,598 $31,707 $22,173 $20,520 $18,155 $98,798 $13,680 $15,386 $25,880 $21,353 $17,094 $56,302 $99,870 $40,766 $33,326 $22,916 $20,000 $27,777 $92,548 $27,086 $16,322

56 Less projected 2% salary savings due to staff turnover 57 58 TOTALS 59 60 FRINGE BENEFIT RATE 61 EMPLOYEE FRINGE BENEFITS 62 63 64 TOTAL SALARIES & BENEFITS 65 HSA #2 $0 90.10 33% 40.40 88.50

($4,348)

($4,223)

($867)

($5,564)

($3,774)

($5,892)

($4,133)

($28,801) $0

$213,057

$206,936

$42,486

$272,635

$184,936

$288,696

$202,514

$1,411,261

$70,309

$68,289

$14,021

$89,969

$61,029

$95,270

$66,830

$465,716

$283,366

$275,225

$56,507

$362,604

$245,965

$383,966

$269,344

$1,876,977
11/15/2007

A 1 2 3

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

4 Program Name: 5 (Same as Line 9 on HSA #1) 6 7 8 9 10 11 12 Expenditure Category 13 Rental of Property

Operating Expense Detail

HSA Funding Hartland Hotel TERM 7/1/09-12/31/09 $370,230 $82,677 $1,904 $27,400 $250 $6,291 $670 $660

HSA Funding Jefferson Hotel 7/1/09-12/31/09 $226,507 $56,180 $1,662 $22,000 $200 $3,803 $650 $413

HSA Funding Looper Hotel 7/1/09-12/31/09 $135,499 $24,027 $598 $7,525 $50 $1,838 $120 $500

HSA Funding Mission Hotel 7/1/09-12/31/09 $525,863 $112,385 $2,861 $49,200 $250 $9,988 $850 $2,100

HSA Funding Raman Hotel 7/1/09-12/31/09 $185,675 $45,615 $1,446 $21,250 $150 $2,745 $600 $330

HSA Funding Seneca Hotel 7/1/09-12/31/09 $462,123 $99,530 $2,751 $40,800 $250 $8,808 $885 $825

HSA Funding Vincent 7/1/09-12/31/09 $227,830 $62,641 $1,749 $25,750 $200 $4,096 $650 $413

HSA Funding Only TOTAL 7/1/09-12/31/09 $2,133,725 $483,053 $12,969 $193,925 $1,350 $37,569 $4,425 $5,240 $0 $0 $0 $0 $0 $0

14 Utilities(Elec, Water, Gas, Phone, Scavenger) 15 Office Supplies, Postage 16 Building Maintenance Supplies and Repair 17 Printing and Reproduction 18 Insurance 19 Staff Training 20 Staff Travel-(Local & Out of Town) 21 Rental of Equipment 22 CONSULTANT/SUBCONTRACTOR DESCRIPTIVE TITLE 23 24 25 26 27 28 OTHER 29 Community Events 30 Elevator / Lift 31 32 33 34 35 TOTAL OPERATING EXPENSE 36 37 HSA #3

$2,088 $6,000

$1,750 $2,750

$903 $0

$2,960 $4,000

$1,788 $3,750

$2,540 $2,000

$1,663 $750

$13,690 $19,250

$0 $498,169 $315,914 $171,058 $710,457 $263,348 $620,511 $325,741 $2,905,196

$255,878

$178,814

$71,119

$369,187

$155,345

$316,777

$195,821

11/15/2007

A 1 2 3 4 Program Name: 5 (Same as Line 9 on HSA #1) 6 7 8 9 10 11 E Q U I P M E N T 12 13 14 15 16 17 18 19 20 21 TOTAL EQUIPMENT COST 22 23 R E M O D E L I N G 24 Description: 25 No.

B

C

D

E

F

G

H Appendix B, Page Document Date:

I

J 7/24/09

Capital Expenditure Detail
(Equipment and Remodeling Cost) Hartland Hotel Jefferson Hotel Looper Hotel Mission Hotel TERM ITEM/DESCRIPTION 5,589 300 550 550 600 900 550 300 1,650 600 900 Raman Hotel Seneca Hotel Vincent HSA Funding Only TOTAL

HSA Funding HSA Funding HSA Funding HSA Funding HSA Funding HSA Funding HSA Funding 7/1/09-12/31/09 7/1/09-12/31/09 7/1/09-12/31/09 7/1/09-12/31/09 7/1/09-12/31/09 7/1/09-12/31/09 7/1/09-12/31/09

1.0 Add cameras to 2nd & 3rd floor & extra DVR (1/2 cost) 0.5 Workstation to replace out of warantee machine (1/2 cost) 1.0 Multifunction printer (1/2 cost) 1.0 Workstation to replace out of warantee machine (1/2 cost) 1.5 Workstation to replace out of warantee machine (1/2 cost)

0 0 0 6,439 0 550 600 550 900 9,039

0 0 7,500 7,500 890 10,000 10,000 35,000 890 0 0 0 0 7,500 8,390 10,000 0 10,000 35,890

26 Replace worn carpets in certain parts of the common area 27 Replace boiler (heater) thermostat 28 29 30 TOTAL REMODELING COST 31 32 TOTAL CAPITAL EXPENDITURE 33 (Equipment and Remodeling Cost) 34 HSA #4 0 6,439

7,500

8,940

10,600

550

10,900

44,928

11/15/2007


				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:850
posted:9/15/2009
language:English
pages:4