Data
Revenue			$16.50	q
Cost of ingredients			$6.25	q
Wages and salaries	$10,400
Utilities	$800	+	$0.20	q
Rent	$2,200
Miscellaneous	$600	+	$0.80	q
Actual results:
Revenue	$27,920
Cost of ingredients	$11,110
Wages and salaries	$10,130
Utilities	$1,080
Rent	$2,200
Miscellaneous	$2,240
Planning budget activity	1,800	meals served
Actual activity	1,700	meals served
Enter a formula into each of the shadded below
Review Problem: Variance Analysis Using a Flexible Budget
Construct a flexible budget performance report
		Revenue
		and
	Actual	Spending	Flexible	Activity	Planning
	Results	Variances	Budget	Variances	Budget
Meals served	1,700		1,700		1,800
Revenue	$ 27,920
Expenses:
Cost of ingredients	11,110
Wages and salaries	10,130
Utilities	1,080
Rent	2,200
Miscellaneous	2,240
Total expenses	26,760
Net operating income	$ 1,160