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 cells marked with a ? below
The variances should be positive numbers so use =ABS() in
your formula. For example, the formula for cell C34 should
be =ABS(E34-B34)
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	?			?			?
Revenue	?	?		?	?		?
Expenses:
Cost of ingredients	?	?		?	?		?
Wages and salaries	?	?		?	?		?
Utilities	?	?		?	?		?
Rent	?	?		?	?		?
Miscellaneous	?	?		?	?		?
Total expenses	?	?		?	?		?
Net operating income	?	?		?	?		?

A1 fi Flexible Budget Performance Report Data Revenue Cost of ingredients Wages and salaries Utilities Rent Miscellaneous 16.50 q S10,400 $800 $2,200 $600 $6.25 q $0.20 q $0.80 q 9 10 Actual results Revenue Cost of ingredients Wages and salaries Utilities Rent Miscellaneous S27,920 $11,110 10,130 $1,080 $2,200 $2,240 12 15 17 18 Planning budget activity Actual activity 1,800 meals served 1,700 meals served 20 21 Enter a formula into each of the cells marked with a? below The variances should be positive numbers so use ABS() in your formula. For example, the formula for cell C34 should be -ABS(E34-B34) 23 25 26 27 Review Problem: Variance Analysis Using a Flexible Budget Flexible Budget