The Grade only

ExcelBudgetmile2.xlsx

Sheet1

University Day Care Profit and Loss Statement Comparison for Actual and revenue and Expenses
			Budget	Actual	Variance
REVENUES			$329,194	$141,926	($187,268)
EXPENSES
Salaries:	FTES*	FTES*
	Budget	actual
Director	1	1	$32,000	$31,990	$10
Instructors	3	3	66000	66,500	($500)
Teachers	6	6	120000	114,108	$5,892
Aides	5	1.5	83,200	27,140	$56,060
Clerical	0.5	0.5	9,000	9,000	$0
Subtotals	15.5	12	310200	248738	$61,462
					$0
Fringe Benefits			68,244	54,722	$13,522
Supplies:					$0
Training			4000	2190	$1,810
Conference			1650	904	$746
Food			16000	8762	$7,238
Disposable			4200	2300	$1,900
Classroom Supplies			4800	2629	$2,171
Supplies subtotal			30650	16785	$13,865
Other expenses					$0
Field trips			1,100	602	$498
Equipment			1,000	548	$452
Laundry			500	274	$226
Contingency			4,000	2190	$1,810
Maintenance			13,000	7119	$5,881
Telephone			500	274	$226
Rent			60,000	60,000	$0
Other expenses Subtotal			80100	71007	$9,093
TOTAL EXPENSES			489,194	391,252	97,942
TOTAL REVENUE LESS EXPENSES			($160,000)	($249,326)	($89,326)
PLUS BUDGETED DEFICIT			$160,000	$160,000
VARIANCE FROM BUDGETED DEFICIT			$0	($89,326)

University Day Care Center Next Year BUDGET with 15% revenue increase and extra employees at $40,000
		Budget
REVENUES		$378,573
EXPENSES
Salaries:	FTES*
	Budget
Director	1	$32,000
Instructors	4	88000
Teachers	7	138000
Aides	5	83,200
Clerical	0.5	9,000
Subtotals	17.5	350200
Fringe Benefits		68,244
Supplies:
Training		4000
Conference		1650
Food		16000
Disposable		4200
Classroom Supplies		4800
Supplies subtotal		30650
Other expenses
Field trips		1,100
Equipment		1,000
Laundry		500
Contingency		4,000
Maintenance		13,000
Telephone		500
Rent		60,000
Other expenses Subtotal		80100
TOTAL EXPENSES		529,194
TOTAL REVENUE LESS EXPENSES		($150,621)
PLUS BUDGETED DEFICIT		$160,000
VARIANCE FROM BUDGETED DEFICIT		$9,379
the net income budget will have a positive figure as illustrated, the 15% increase in revenue is less than 40,000 increase in expenses which results in deficit of -150,621, but since Deficit has been budgeted for through $160,000, the variance would be a positive figure on the income.
			References
	O'brien, M. (1979). The Toddler Center: A Practical Guide to Day Care for One-and Two-Year-Olds.The Toddler Center: A Practical Guide to Day Care for One-and Two-Year-Olds.