BRIEF EXCEL HOMEWORK

Documentation

Bright Light
Author
Date
Purpose	Projected usage on shelter and meals program

Shelter Usage

The Bright Light
Usage Figures for 2010*
	Dec	Nov	Oct	Sep	Aug	Jul
Single Rooms (5)	118	110	112	104	106	103
Common Room 1 (15 max)	448	419	434	422	421	410
Common Room 2 (15 max)	432	436	412	431	405	411
Domestic Abuse Shelter (3)	72	87	81	52	47	54
Total Client Days	1070	1052	1039	1009	979	978
* Figures represent total occupancy for each month.
Projected Usage	Year	Client Days
	2003	10,371	13750
	2004	11,038	13750
	2005	11,311	13750
	2006	11,787	13750
	2007	12,142	13750
	2008	12,617	13750
	2009	13,246	13750
	2010	13,875	13750
	2011	14,104	13750
	2012	14,545	13750

Projected Usage

Client Days 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 10371 11038 11311 11787 12142 12617 13246 13875 14104 14545 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 13750 13750 13750 13750 13750 13750 13750 13750 13750

Year

Total Client Days

Projected

1

2

3

4

5

6

7

8

9

10

A

B

C

D

The Bright Light

Usage Figures for 2010*

Dec

Nov

Oct

Single Rooms (5)

118

110

112

Common Room 1 (15 max)

448

419

434

Common Room 2 (15 max)

432

436

412

Domestic Abuse Shelter (3)

72

87

81

Total Client Days

1070

1052

1039

* Figures represent total occupancy for each month.