Question

Flight Café prepares in-flight meals for airlines in its kitchen located next to a local airport. The company’s planning budget for July appears below:

Flight Café
Planning Budget
For the Month Ended July 31
Budgeted meals (q)		21,000
Revenue ($4.00q)	$	84,000
Expenses:
Raw materials ($2.30q)		48,300
Wages and salaries ($6,400 + $0.20q)		10,600
Utilities ($2,000 + $0.05q)		3,050
Facility rent ($3,000)		3,000
Insurance ($2,400)		2,400
Miscellaneous ($400 + $0.10q)		2,500
Total expense		69,850
Net operating income	$	14,150

In July, 22,000 meals were actually served. The company’s flexible budget for this level of activity appears below:

Flight Café
Flexible Budget
For the Month Ended July 31
Budgeted meals (q)		22,000
Revenue ($4.00q)	$	88,000
Expenses:
Raw materials ($2.30q)		50,600
Wages and salaries ($6,400+ $0.20q)		10,800
Utilities ($2,000 + $0.05q)		3,100
Facility rent ($3,000)		3,000
Insurance ($2,400)		2,400
Miscellaneous ($400 + $0.10q)		2,600
Total expense		72,500
Net operating income	$	15,500

Required:

1. Calculate the company’s activity variances for July. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)

Flight Café Activity Variances For the Month Ended July 31 Revenue Expenses: Raw materials Wages and salaries Utilities Facility rent Insurance Miscellaneous Total expense Net operating income

Answer 1

Flight Care
Activity Variances
For the month ended July 31
	$
Revenue	4,000.00	F
Expenses:
Raw materials	2,300.00	U
Wages and Salaries	200.00	U
Utilities	50.00	U
Facility Rent	-	-
Insurance	-	-
Miscellaneous	100.00	U
Total Expense	2,650.00	U
Net Operating Income	1,350.00	F
Explanations
Flight Care
Activity Variances
For the month ended July 31
	Planning Budget	Flexible Budget	Activity Variances
	($)	($)
Meals (q)	21,000.00	22,000.00
Revenue ($4.00*q)	84,000.00	88,000.00	4,000.00	F
Expenses:
Raw materials ($2.30q)	48,300.00	50,600.00	2,300.00	U
Wages and Salaries [6400+(0.20*q)]	10,600.00	10,800.00	200.00	U
Utilities ($2000 + $0.05q)	3,050.00	3,100.00	50.00	U
Facility Rent	3,000.00	3,000.00	-
Insurance	2,400.00	2,400.00	-
Miscellaneous ($400 + $0.10q)	2,500.00	2,600.00	100.00	U
Total Expense	69,850.00	72,500.00	2,650.00	U
Net Operating Income	14,150.00	15,500.00	1,350.00	F
(Revenue - Expenses)