Question

Flight Café is a company that prepares in-flight meals for airlines in its kitchen located next to the local airport. The company's planning budget for July appears below: Flight Café Planning Budget For the Month Ended July 31 Budgeted meals (q) Revenue ($3.00g) Expenses: Raw materials ($2.20q) Wages and salaries ($8,300 + $0.20g) Utilities ($2,100 + $0.05g) Facility rent ($3,600) Insurance ($2,600) Miscellaneous ($900 + $0.10q) Total expense 21,000 $81,900 48,200 10,500 3,150 3,600 2,600 3,000 69,050 $ 12,850 Net operating income 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 (g) Revenue ($3.90g) 22,000 $ 85,800 Expenses: Raw materials ($2.20g) Wages and salaries ($6,300 + $0.20g) Utilities ($2,100 + $0.05g) Facility rent ($3,600) Insurance ($2,600) 48,400 10,700 3.200 3,800 2,600 3,100 Miscellaneous ($900 + $0.10g) Total expense 71,600 $ 14,200 Net operating income Required: 1. Compute 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 café variance
	flexible	planned	Activity variance
Revenue	85800	81900	3900	F
Expenses:
Raw materials	48400	46200	2200	U
Wages & Salary	10700	10500	200	U
Utilities	3200	3150	50	U
Factory Rent	3600	3600	0	NONE
Insurance	2600	2600	0	NONE
Miscellaneous	3100	3000	100	U
Total Expenses	71600	69050	2550	U
Net operating income	14200	12850	1350	F
Activity variance = flexible - planned