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) 27,000 Revenue ($4.00q) $ 108,000 Expenses: Raw materials ($2.30q) 62,100 Wages and salaries ($6,200 + $0.20q) 11,600 Utilities ($1,900 + $0.05q) 3,250 Facility rent ($3,500) 3,500 Insurance ($2,800) 2,800 Miscellaneous ($300 + $0.10q) 3,000 Total expense 86,250 Net operating income $ 21,750 In July, 28,000 actually meals were 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) 28,000 Revenue ($4.00q) $ 112,000 Expenses: Raw materials ($2.30q) 64,400 Wages and salaries ($6,200+ $0.20q) 11,800 Utilities ($1,900 + $0.05q) 3,300 Facility rent ($3,500) 3,500 Insurance ($2,800) 2,800 Miscellaneous ($300 + $0.10q) 3,100 Total expense 88,900 Net operating income $ 23,100 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.)

Answer 1

Solution:

Activity Variances - Flight Café
For the month ended July 31
Particulars	Flexible Budget	Planning Budget	Variances	Fav. / Unfav.
Activity	28000	27000
Revenue	$112,000.00	$108,000.00	$4,000.00	F
Expenses:
Raw materials	$64,400.00	$62,100.00	$2,300.00	U
Wages & Salaries	$11,800.00	$11,600.00	$200.00	U
Utilities	$3,300.00	$3,250.00	$50.00	U
Facility rent	$3,500.00	$3,500.00	$0.00	None
Insurance	$2,800.00	$2,800.00	$0.00	None
Miscellenous	$3,100.00	$3,000.00	$100.00	U
Total Expenses	$88,900.00	$86,250.00	$2,650.00	U
Net Operating Income	$23,100.00	$21,750.00	$1,350.00	F