Course College	Course Dept	Student Net Dollars	Course Credit Hours	Course Enrollment	Course SCCH		Course FTE	Course Count	END OF YR BUDGET COSTS	Benefits Costs 27.7 %	Overall Net Dollars K - (X + Y)	Notes
AS	AS College Total	$34,653,092.75	4,249.79	25,738.00	74,807.62		4,709.92	1,505.50	$12,343,784.84	$3,055,620.33	$19,253,687.58
AS	BIOL	$1,901,995.57	217.50	1,672.00	4,159.00		260.06	102.00	$918,635.24	$241,861.50	$741,498.83
AS	CHEM	$1,050,291.21	128.38	1,084.00	2,488.98		155.64	61.00	$616,445.91	$145,925.77	$287,919.53	Chem Hygiene included (not in Delaware)
AS	CLST	$447,539.31	78.00	346.00	1,038.00		64.92	26.00	$139,199.18	$38,142.80	$270,197.33
AS	CMMN: UNDG	$2,667,991.63	388.80	1,982.00	5,940.80		371.54	130.00	$1,049,025.70	$248,627.00	$1,370,338.93
AS	CMMN: GRAD	$95,063.82	66.00	63.00	195.00		16.25	20.00	$1,923.46		$93,140.36
AS	DRSP	$839,922.89	204.26	793.00	2,033.99		127.25	74.00	$489,726.12	$114,197.23	$235,999.54
AS	EDUC: UNDG	$539,896.82	108.00	462.00	1,396.00		87.31	32.00	$634,771.07	$161,467.37	-$256,341.62
AS	EDUC: GRAD	$417,708.72	115.00	369.00	1,106.00		92.17	37.00	$2,977.97		$414,730.75
AS	ENGL	$3,655,151.81	436.90	2,496.00	7,448.90		465.81	148.00	$1,448,331.03	$316,745.05	$1,890,075.73
AS	ENGL: LIEP	$33,488.85	6.00	13.00	39.00		2.44	2.00			$33,488.85
AS	HIST	$3,910,700.82	303.00	2,569.00	7,701.00		481.43	102.00	$933,112.91	$245,432.07	$2,732,155.84
AS	HONS	$43,208.60	55.00	107.00	137.00		8.67	30.00	$27,794.17	$3,243.64	$12,170.79
AS	MATH: MATH	$2,160,204.86	201.00	1,350.00	4,196.00		262.33	67.00	$1,032,644.31	$260,728.12	$866,832.43
AS	MATH: COSC	$492,196.08	85.00	411.00	1,228.00		76.77	30.00			$492,196.08
AS	MFL	$2,113,343.55	305.00	1,510.00	4,529.00		283.17	102.00	$720,030.11	$176,087.03	$1,217,226.41
AS	PHIL	$3,775,494.21	316.00	2,617.00	7,849.00		490.71	105.50	$957,810.73	$259,991.86	$2,557,691.62
AS	PHYS	$617,763.21	89.00	586.00	1,468.00		91.82	35.50	$358,076.35	$87,063.66	$172,623.20
AS	POLS	$1,122,645.76	141.00	810.00	2,426.00		151.68	48.00	$443,053.26	$121,744.29	$557,848.21	un staff f/t included (not in Delaware)
AS	PSYC	$2,224,629.18	231.90	1,791.00	4,948.00		309.28	100.00	$601,681.76	$156,633.08	$1,466,314.34
AS	RELS: UNDG	$3,846,794.85	297.00	2,759.00	8,277.00		517.48	96.50	$860,839.82	$213,660.81	$2,772,294.22
AS	RELS: GRAD	$94,992.78	30.00	85.00	255.00		21.25	10.00	$5,199.71		$89,793.07
AS	SOCI	$1,336,714.92	130.05	1,013.00	3,140.95		196.32	43.00	$397,802.13	$99,157.24	$839,755.55	Srvc Lrng included (not in Delaware)
AS	VISA	$1,247,800.99	308.00	836.00	2,765.00		172.99	101.00	$632,826.10	$150,301.06	$464,673.83
AS	WS	$17,552.31	9.00	14.00	42.00		2.63	3.00	$71,877.80	$14,610.74	-$68,936.23
BA	BA College Total	$7,063,458.37	1,056.00	5,750.50	17,064.50	1.00	1,090.20	343.50	$3,204,954.58	$636,076.43	$3,222,427.36	SBD included (not in Delaware)
BA	CBA ACCT Total	$834,448.65	135.00	1,023.00	3,069.00	0.18	191.87	45.00	$576,401.63	$114,396.47	$143,650.55
BA	CBA BA Total	$1,411,258.57	206.00	1,102.00	3,302.00	0.19	206.53	69.50	$620,162.33	$123,081.51	$668,014.74
BA	CBA DECS Total	$501,356.91	33.00	370.00	1,110.00	0.07	69.40	11.00	$208,473.71	$41,375.07	$251,508.13
BA	CBA ECON Total	$776,495.79	66.00	590.00	1,770.00	0.10	110.65	21.50	$332,431.05	$65,976.46	$378,088.28
BA	CBA FIN Total	$469,451.01	90.00	381.00	1,143.00	0.07	71.50	29.00	$214,671.57	$42,605.14	$212,174.30
BA	CBA INTB Total	$145,419.21	54.00	100.00	300.00	0.02	18.79	11.50	$56,344.25	$11,182.45	$77,892.51
BA	CBA LGST Total	$322,833.44	28.00	250.00	748.00	0.04	46.77	9.50	$140,484.98	$27,881.58	$154,466.88
BA	CBA MGT Total	$930,731.40	132.00	680.00	2,040.00	0.12	127.61	40.50	$383,140.87	$76,040.66	$471,549.87
BA	CBA MKT Total	$883,449.06	210.00	693.00	2,079.00	0.12	130.08	67.00	$390,465.62	$77,494.38	$415,489.06
BA	CBA MUBZ Total	$138,068.66	15.00	132.50	397.50	0.02	24.85	5.00	$74,656.13	$14,816.75	$48,595.79
BA	CBAG ACCT Total	$31,967.58	3.00	16.00	48.00	0.00	4.00	1.00	$9,015.08	$1,789.19	$21,163.31
BA	CBAG BA Total	$233,506.72	25.00	157.00	391.00	0.02	32.58	12.00	$73,435.33	$14,574.46	$145,496.93
BA	CBAG DECS Total	$9,157.02	2.00	8.00	16.00	0.00	1.33	1.00	$3,005.03	$596.40	$5,555.60
BA	CBAG ECON Total	$36,802.84	4.00	29.00	58.00	0.00	4.83	2.00	$10,893.22	$2,161.94	$23,747.68
BA	CBAG FIN Total	$88,622.40	14.00	56.00	149.00	0.01	12.42	5.00	$27,984.31	$5,553.95	$55,084.14
BA	CBAG MGT Total	$161,830.71	19.00	109.00	290.00	0.02	24.16	7.00	$54,466.10	$10,809.70	$96,554.90
BA	CBAG MKT Total	$88,058.40	20.00	54.00	154.00	0.01	12.83	6.00	$28,923.38	$5,740.32	$53,394.70
CC	CC College Total	$3,857,427.51	1,474.97	4,421.00	13,169.63		878.41	495.00	$3,284,457.80	$549,436.16	$23,533.55
CC	CITY ALL OTHER	$1,014,565.98	198.00	1,198.00	3,594.00	0.92	224.75	66.00	$722,641.72	$156,588.49	$135,335.77	ACCT: 11471 City College Instruction	CITY COLLEGE INST
CC	CITY CISC Total	$77,872.70	39.20	108.00	325.00	0.08	20.32	13.00	$65,347.40	$14,160.06	-$1,634.76
CC	CITY CRJU UNDG Total	$495,474.33	63.00	464.00	1,389.00	0.61	86.82	22.00	$326.10		$495,148.23	ACCT: 11475 Criminal Justice BCJ	CRIMINAL JUSTICE BCJ
CC	CITY CRJU GRAD Total	$183,808.53	33.00	157.00	471.00	0.21	39.25	11.00	$104,697.32	$14,526.64	$64,584.57	ACCT: 11478 Masters Crim Justice	MASTERS CRIM JUSTICE
CC	CITY CRJU FRSC Total	$155,833.32	27.00	135.00	405.00	0.18	25.32	9.00			$155,833.32
CC	CITY NURS Total	$164,758.40	55.91	178.00	585.79		36.61	17.00	$304,416.00	$76,835.17	-$216,492.77	ACCT: 11480 Nursing	NURSING
CC	CITY NURS GRAD Total	$381,767.33	70.00	423.00	1,110.00		92.50	27.00	$171,157.12	$34,588.09	$176,022.12	ACCT: 11481 MSN Program	MSN PROGRAM
CC	NURS BRLA Total	$16,225.00	7.00	17.00	59.00		3.69	2.00	$103,863.73	$18,815.80	-$106,454.53	ACCT: 11474 Nursing - BSN EXT	NURSING-BSN EXT
CC CCO	CCO LIM Total	$93,834.01	85.00	152.00	436.00	0.12	27.30	30.00	$1,187,101.10	$170,897.80	-$1,264,164.89	ACCT: 11479 LIM	LIM
CC CCX	CCX LIMX Total	$741,574.71	705.00	1,085.00	3,255.00	0.88	203.79	235.00			$741,574.71
CC COLN	COLN NURS GRAD Total	$228,789.85	31.00	194.00	583.00		48.58	10.00	$286,996.28	$22,591.81	-$80,798.24	ACCT: 11482 Health Care Systems Mgt	HEALTH CARE SYSTEMS MANAGEMENT
CC SP	HIST Total	$7,070.02	7.00	4.00	10.00		0.63	3.00			$7,070.02
CC SP	LIEP Total	$68,901.00	60.00	42.00	126.00		7.92	20.00	$156,313.65	$24,567.96	-$111,980.61	ACCT: 11635 Intensive English	INTENSIVE ENGLISH
CC OCLP	OCLP Total	$97,606.77	39.00	120.00	360.00		22.54	13.00			$97,606.77
CC OCLP	OCLP CRJU Total	$825.00	3.00	1.00	3.00		0.25	1.00			$825.00
CC OCLP	OCLP NURS Total	$99,906.56	33.61	112.00	363.84	0.79	30.31	10.00	$181,597.38	$15,864.34	-$97,555.16	ACCT: 11477 Off-Campus Learning Nursing	OFF-CAMPUS LEARNING-NURSING
CC OCLP	OCLP NURS GRAD Total	$28,614.00	18.25	31.00	94.00	0.21	7.83	6.00			$28,614.00
MU	MU College Total	$3,016,531.47	859.27	4,965.50	8,911.29	1.00	565.27	456.00	$2,311,070.82	$480,919.65	$224,541.00	un staff f/t included (not in Delaware)
MU	MUED Total	$99,958.48	52.00	194.00	386.00	0.04	24.50	22.00	$100,105.97	$20,831.44	-$20,978.93
MU	MUSC GRAD Total	$55,039.03	133.00	122.00	278.00	0.03	23.15	60.00	$72,097.05	$15,002.95	-$32,060.97
MU	MUSC MUBZ Total	$91,041.44	23.00	387.50	562.50	0.06	35.18	9.00	$145,879.81	$30,356.69	-$85,195.07
MU	MUSC MUEN Total	$401,344.01	45.00	1,150.00	1,150.00	0.13	71.94	45.00	$298,243.18	$62,062.57	$41,038.26
MU	MUSC MUGN Total	$1,043,538.39	121.00	887.00	2,380.00	0.27	148.81	51.00	$617,233.71	$128,442.54	$297,862.14
MU	MUSC MUHL Total	$205,711.32	30.00	226.00	581.00	0.07	36.34	12.00	$150,677.64	$31,355.09	$23,678.59
MU	MUSC MUJZ Total	$32,891.08	14.00	52.00	104.00	0.01	6.52	7.00	$26,971.56	$5,612.62	$306.91
MU	MUSC MUPC Total	$153,460.73	41.00	787.00	889.00	0.10	55.59	35.00	$230,554.94	$47,977.07	-$125,071.28
MU	MUSC MUPD Total	$13,849.60	7.00	18.00	31.00	0.00	1.95	5.00	$8,039.60	$1,672.99	$4,137.01
MU	MUSC MUPR Total	$359,971.21	240.27	612.00	1,033.79	0.12	64.74	143.00	$268,105.06	$55,791.02	$36,075.14
MU	MUSC MUTH Total	$489,365.77	103.00	405.00	1,300.00	0.15	81.33	38.00	$337,144.46	$70,157.69	$82,063.62
MU	MUTY UNDG Total	$49,836.31	21.00	83.00	134.00	0.02	8.40	13.00	$34,751.81	$7,231.64	$7,852.86
MU	MUTY GRAD Total	$20,524.10	29.00	42.00	82.00	0.01	6.82	16.00	$21,266.04	$4,425.33	-$5,167.27
LAW	LAW College Total	$15,231,498.62	754.30	8,046.00	21,343.75	1.00	1,524.28	331.00	$4,561,434.80	$1,180,064.53	$9,489,999.29	ACCT: 11441 Law Instr & 12444 Pov. Law Clinic	law instructional/Poverty Law Clinic
LAW	LAW Total	$10,111,424.48	626.30	5,601.00	14,162.75	0.66	1,011.33	286.00	$3,026,762.43	$783,037.61	$6,301,624.44
LAW	LAW CIV Total	$3,599,240.23	91.00	1,675.00	4,944.00	0.23	353.16	32.00	$1,056,596.60	$273,346.48	$2,269,297.15
LAW	LAW COM Total	$1,520,833.91	37.00	770.00	2,237.00	0.10	159.79	13.00	$478,075.77	$123,680.44	$919,077.71
SP	SP College Total	$27,079.65	24.00	16.00	52.00		3.25	7.00			$27,079.65
SP	SPEC PONTLEVOY Total	$27,079.65	24.00	16.00	52.00		3.25	7.00			$27,079.65
		$63,849,088.37	8,418.33	48,937.00	135,348.79		8,771.33	3,138.00	$25,705,702.84	$5,902,117.10	$32,241,268.43
	The question this report addresses is what are the net dollars(defined below) generated by college by department using the course and enrollment files in the student information system (SIS) and the data warehouse?
	While developing the response to the question, concerns emerged regarding the overall net dollars generated for an entire year for Music and City College.
	The methodology: A per credit hour charge was calculated for each student for each term using the billing and financial aid tables in the data warehouse and applied to the course information generated in SIS.
	The Net Dollars Formula: [Tuition + Room + Res. Hall Fee + Board ] - [LU Scholarship + LU Grant/Discount + Teacher Religious Discount + Reduction for Early Scholars/Reflective Age]
	The Per Credit Hour Charge = Net Dollars / Student's Total Credit Hours for the term
	Room and board charges were included in determining the per credit hour figure because tuition/room/board is combined in the data warehouse.
	The net dollar figure was divided by the total credit hours taken by each student for each term. This per credit hour charge was applied to each course taken by the student for each term and
	a net dollar figure was generated for each of the student's courses. The course net dollar figure for each student was totalled for each course for each term and is presented with 04F and 05S combined.
	FTE students = full-time equivalent students. Student course credit hours are divided by 16 for undergraduate by 12 for graduate and by 14 for law.