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)		20,000
Revenue ($4.30q)	$	86,000
Expenses:
Raw materials ($1.90q)		38,000
Wages and salaries ($6,000 + $0.20q)		10,000
Utilities ($2,100 + $0.05q)		3,100
Facility rent ($3,600)		3,600
Insurance ($2,900)		2,900
Miscellaneous ($500 + $0.10q)		2,500
Total expense		60,100
Net operating income	$	25,900

In July, 21,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)		21,000
Revenue ($4.30q)	$	90,300
Expenses:
Raw materials ($1.90q)		39,900
Wages and salaries ($6,000+ $0.20q)		10,200
Utilities ($2,100 + $0.05q)		3,150
Facility rent ($3,600)		3,600
Insurance ($2,900)		2,900
Miscellaneous ($500 + $0.10q)		2,600
Total expense		62,350
Net operating income	$	27,950

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:

AK УК Flight café Activity Variances For the month ended July 31 Flexible Budget (21000 Planning Budget meals) (20000 meals) $90,300.00 $86,000.00 8 Particulars Variances Fav. / Unfav. $4,300.00 F 9 10 11 12 13 Revenue Expenses: Raw Materials Wages and salaries Utilities Facility rent Insurance Miscellaneous Total Expenses 14 $39,900.00 $10,200.00 $3,150.00 $3,600.00 $2,900.00 $2,600.00 $62,350.00 $38,000.00 $10,000.00 $3,100.00 $3,600.00 $2,900.00 $2,500.00 $60,100.00 $1,900.000 $200.000 $50.00 u $0.00 None $0.00 None $100.000 $2,250.000 18 Net Operating Income $27,950.00 $25,900.00 $2,050.00 F 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 Sheet772 Sheet778 Sheet781 Sheet782 Sheet