Personnel - Related Expenses

				Year 1, 1998-1999				Year 2, 1999-2000				Year 3, 2000-2001				Year 4, 2001-2002				Year 5, 2002-2003				Other
			Starting Salary	Kellogg	Trinity	Other	Total Year 1	Kellogg	Trinity	Other	Total Year 2	Kellogg	Trinity	Other	Total Year 3	Kellogg	Trinity	Other	Total Year 4	Kellogg	Trinity	Other	Total Year 5	Office Needed (Date Needed or No)	Computer Equipment Est.	Office Furniture Est.

Building A Culture of Engagement
	Community Forum
	a	Administrative Support	$24,000	$33,000	$0	$0	$33,000	$33,990	$0	$0	$33,990	$23,010	$0	$12,000	$35,010	$0	$0	$0	$0	$0	$0	$0	$0	No	$3,000	$0

		Subtotal	$24,000	$33,000	$0	$0	$33,000	$33,990	$0	$0	$33,990	$23,010	$0	$12,000	$35,010	$0	$0	$0	$0	$0	$0	$0	$0

Ensuring Catalytic Leadership
	Academic
	b	Professor Comparative Urban Studies	$110,000	$0	$0	$0	$0	$150,000	$0	$0	$150,000	$154,500	$0	$0	$154,500	$155,500	$3,635	$0	$159,135	$0	$163,909	$0	$163,909	7/1/99	$3,000	$4,000
	b	Urban Specialist (Sr. Acad. Administrator)	$65,000	$90,000	$0	$0	$90,000	$92,700	$0	$0	$92,700	$77,300	$18,181	$0	$95,481	$0	$98,345	$0	$98,345	$0	$101,269	$0	$101,269	No	$0	$0
	b	Administrative Support	$22,000	$0	$0	$0	$0	$0	$30,000	$0	$30,000	$0	$30,900	$0	$30,900	$0	$31,827	$0	$31,827	$0	$32,782	$0	$32,782	7/1/99	$3,000	$2,000

		Subtotal	$197,000	$90,000	$0	$0	$90,000	$242,700	$30,000	$0	$272,700	$231,800	$49,081	$0	$280,881	$155,500	$133,807	$0	$289,307	$0	$297,960	$0	$297,960

	Learning Corridor Corp.
	a	Chief Education Officer	$100,000	$0	$0	$0	$0	$133,000	$0	$0	$133,000	$136,990	$0	$0	$136,990	$141,100	$0	$0	$141,100	$138,880	$0	$6,423	$145,303	7/1/99-9/1/00	$3,000	$4,000
	a	Program Dev. Coord.	$64,000	$86,450	$0	$0	$86,450	$89,044	$0	$0	$89,044	$91,715	$0	$0	$91,715	$82,791	$0	$11,675	$94,466	$0	$0	$97,300	$97,300	No	$0	$0
	b	Community Partnership Coord.	$50,000	$35,500	$0	$30,000	$65,500	$14,500	$52,965	$0	$67,465	$0	$13,518	$55,971	$69,489	$0	$0	$71,574	$71,574	$0	$0	$73,721	$73,721	No	$0	$0
	c	Administrative Support	$22,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	No	$0	$0

		Subtotal	$236,000	$121,950	$0	$30,000	$151,950	$236,544	$52,965	$0	$289,509	$228,705	$13,518	$55,971	$298,194	$223,891	$0	$83,249	$307,140	$138,880	$0	$177,444	$316,324

		Category Subtotal	$433,000	$211,950	$0	$30,000	$241,950	$479,244	$82,965	$0	$562,209	$460,505	$62,599	$55,971	$579,075	$379,391	$133,807	$83,249	$596,447	$138,880	$297,960	$177,444	$614,284

Providing the Infrastructure
	Smart Neighborhood
	a	Community Technology Specialist	$48,000	$65,950	$0	$0	$65,950	$67,929	$0	$0	$67,929	$69,966	$0	$0	$69,966	$72,065	$0	$0	$72,065	$74,227	$0	$0	$74,227	No	Purchase through Kellogg Smart Neighborhood
	a	Neighborhood Services Coordinator	$48,000	$66,950	$0	$0	$66,950	$68,959	$0	$0	$68,959	$71,027	$0	$0	$71,027	$73,158	$0	$0	$73,158	$75,353	$0	$0	$75,353	No

		Subtotal	$96,000	$132,900	$0	$0	$132,900	$136,888	$0	$0	$136,888	$140,993	$0	$0	$140,993	$145,223	$0	$0	$145,223	$149,580	$0	$0	$149,580

	Community Learning Initiative
	b	Administrative Coordinator	$24,000	$33,000	$0	$0	$33,000	$17,000	$16,990	$0	$33,990	$0	$35,010	$0	$35,010	$0	$36,060	$0	$36,060	$0	$2,142	$35,000	$37,142	No	$0	$0

	Cities Data Center
	b	Faculty/Director	$48,000	$65,000	$0	$0	$65,000	$66,950	$0	$0	$66,950	$68,959	$0	$0	$68,959	$49,091	$21,936	$0	$71,027	$0	$28,064	$45,094	$73,158	No	$3,000	$0
	c	Tech. Support Coord. (.3)	$11,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	No	$0	$0
	c	Administrative Support	$22,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	No	$0	$0

		Subtotal	$81,000	$65,000	$0	$0	$65,000	$66,950	$0	$0	$66,950	$68,959	$0	$0	$68,959	$49,091	$21,936	$0	$71,027	$0	$28,064	$45,094	$73,158

		Category Subtotal	$201,000	$230,900	$0	$0	$230,900	$220,838	$16,990	$0	$237,828	$209,952	$35,010	$0	$244,962	$194,314	$57,996	$0	$252,310	$149,580	$30,206	$80,094	$259,880
Evaluation
	d	Assessment Coordinator	$40,000	$55,000	$0	$0	$55,000	$56,650	$0	$0	$56,650	$58,350	$0	$0	$58,350	$50,000	$10,100		$60,100	$0	$39,995	$21,908	$61,903	11/1/98	$3,000	$2,500
	d	Administrative Support	$22,000	$30,000	$0	$0	$30,000	$10,000	$20,900	$0	$30,900	$0	$31,827	$0	$31,827	$0	$32,782	$0	$32,782	$0	$33,765	$0	$33,765	11/1/98	$3,000	$1,500

		Category Subtotal	$62,000	$85,000	$0	$0	$85,000	$66,650	$20,900	$0	$87,550	$58,350	$31,827	$0	$90,177	$50,000	$42,882	$0	$92,882	$0	$73,760	$21,908	$95,668

TOTAL			$720,000	$560,850	$0	$30,000	$590,850	$800,722	$120,855	$0	$921,577	$751,817	$129,436	$67,971	$949,224	$623,705	$234,685	$83,249	$941,639	$288,460	$401,926	$279,446	$969,832		$21,000	$14,000

Total minus non-hires (C)				$560,850	$0	$30,000	$590,850	$800,722	$120,855	$0	$921,577	$751,817	$129,436	$67,971	$949,224	$623,705	$234,685	$83,249	$941,639	$288,460	$401,926	$279,446	$969,832

	a	Positions that the college will have to terminate after Kellogg or they will be picked-up by other entities (ie. Learning Corridor, SINA or spin-off organization)
	b	Positions that TC will have to pick-up (or convert back to TC's budget) if other funding is not available or once funding is exhausted
	c	Positions that will be covered by existing staff at TC, new staff will not be hired to fill these positions																		Total Kellogg		$3,025,554
	d	Positions that should be pick-up by TC (after other funding is exhaused) until end of grant (5th year)																		Total Trinity		$886,902
	e	OCIR positions, for the interim, picked-up by Kellogg.																		Total Other		$460,666

Note: The projected salary for each position is an estimate. The projected salary does NOT inlcude benefits. Benefits were calculated into the expenses per year. 35% of salary was used for benefits. If a salary exceeds what is noted, the college will have to make up the difference or Kellogg funds will be depleted sooner than anticipated.

back to cover