Question

Flight Café prepares in-flight meals for airlines in its kitchen located next to a local airport....

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) 29,000
Revenue ($4.40q) $ 127,600
Expenses:
Raw materials ($1.80q) 52,200
Wages and salaries ($6,200 + $0.20q) 12,000
Utilities ($2,100 + $0.05q) 3,550
Facility rent ($3,900) 3,900
Insurance ($2,400) 2,400
Miscellaneous ($500 + $0.10q) 3,400
Total expense 77,450
Net operating income $ 50,150

In July, 30,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) 30,000
Revenue ($4.40q) $ 132,000
Expenses:
Raw materials ($1.80q) 54,000
Wages and salaries ($6,200+ $0.20q) 12,200
Utilities ($2,100 + $0.05q) 3,600
Facility rent ($3,900) 3,900
Insurance ($2,400) 2,400
Miscellaneous ($500 + $0.10q) 3,500
Total expense 79,600
Net operating income $ 52,400

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.)

Homework Answers

Answer #1

Requirement 1:

Activity Variances
For the month of July
Flexible budget Activity Variance Planning Budget
Revenue $132,000 $4,400 Favorable $127,600
Expenses:
Raw materials $54,000 $1,800 Unfavorable $52,200
Wages and salaries $12,200 $200 Unfavorable $12,000
Utilities $3,600 $50 Unfavorable $3,550
Facility rent $3,900 $0 None $3,900
Insurance $2,400 $0 None $2,400
Miscellaneous $3,500 $100 Unfavorable $3,400
Total expense $79,600 $2,150 Unfavorable $77,450
Net operating income $52,400 $2,250 Favorable $50,150

Explanation:

  • For revenues and net operating income, If Flexible budget is more than Planning budget then it is favorable. Otherwise, Unfavorable.
  • For expenses, If Planning budget is more than Flexible budget then it is favorable. Otherwise, Unfavorable
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Flight Café prepares in-flight meals for airlines in its kitchen located next to a local airport....
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) 28,000 Revenue ($4.00q) $ 112,000 Expenses: Raw materials ($1.90q) 53,200 Wages and salaries ($6,400 + $0.20q) 12,000 Utilities ($1,900 + $0.05q) 3,300 Facility rent ($3,200) 3,200 Insurance ($2,100) 2,100 Miscellaneous ($400 + $0.10q) 3,200 Total expense 77,000 Net operating income $ 35,000 In...
Flight Café prepares in-flight meals for airlines in its kitchen located next to a local airport....
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) 29,000 Revenue ($3.80q) $ 110,200 Expenses: Raw materials ($1.90q) 55,100 Wages and salaries ($6,500 + $0.20q) 12,300 Utilities ($2,100 + $0.05q) 3,550 Facility rent ($3,000) 3,000 Insurance ($2,400) 2,400 Miscellaneous ($500 + $0.10q) 3,400 Total expense 79,750 Net operating income $ 30,450 In...
Flight Café prepares in-flight meals for airlines in its kitchen located next to a local airport....
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 ($3.80q) $ 79,800 Expenses: Raw materials ($2.20q) 46,200 Wages and salaries ($6,200 + $0.20q) 10,400 Utilities ($2,100 + $0.05q) 3,150 Facility rent ($3,200) 3,200 Insurance ($2,200) 2,200 Miscellaneous ($600 + $0.10q) 2,700 Total expense 67,850 Net operating income $ 11,950 In...
Flight Café prepares in-flight meals for airlines in its kitchen located next to a local airport....
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) 26,000 Revenue ($4.00q) $ 104,000 Expenses: Raw materials ($2.00q) 52,000 Wages and salaries ($6,200 + $0.20q) 11,400 Utilities ($2,100 + $0.05q) 3,400 Facility rent ($3,300) 3,300 Insurance ($2,000) 2,000 Miscellaneous ($600 + $0.10q) 3,200 Total expense 75,300 Net operating income $ 28,700 In...
Flight Café prepares in-flight meals for airlines in its kitchen located next to a local airport....
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) 26,000 Revenue ($4.40q) $ 114,400 Expenses: Raw materials ($2.00q) 52,000 Wages and salaries ($6,500 + $0.20q) 11,700 Utilities ($2,000 + $0.05q) 3,300 Facility rent ($3,200) 3,200 Insurance ($2,400) 2,400 Miscellaneous ($300 + $0.10q) 2,900 Total expense 75,500 Net operating income $ 38,900 In...
Flight Café is a company that prepares in-flight meals for airlines in its kitchen located next...
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) 29,000   Revenue ($4.40q) $ 127,600   Expenses:       Raw materials ($2.20q) 63,800       Wages and salaries ($6,200 + $0.20q) 12,000       Utilities ($2,100 + $0.05q) 3,550       Facility rent ($3,100) 3,100       Insurance ($2,400) 2,400       Miscellaneous ($700 + $0.10q) 3,600   Total expense 88,450   Net operating...
Flight Café prepares in-flight meals for airlines in its kitchen located next to a local airport....
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.30q) $ 90,300 Expenses: Raw materials ($2.10q) 44,100 Wages and salaries ($6,100 + $0.20q) 10,300 Utilities ($2,100 + $0.05q) 3,150 Facility rent ($3,800) 3,800 Insurance ($2,600) 2,600 Miscellaneous ($300 + $0.10q) 2,400 Total expense 66,350 Net operating income $ 23,950 In...
Flight Café prepares in-flight meals for airlines in its kitchen located next to a local airport....
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) 24,000 Revenue ($4.30q) $ 103,200 Expenses: Raw materials ($1.90q) 45,600 Wages and salaries ($6,000 + $0.20q) 10,800 Utilities ($1,900 + $0.05q) 3,100 Facility rent ($3,700) 3,700 Insurance ($2,400) 2,400 Miscellaneous ($500 + $0.10q) 2,900 Total expense 68,500 Net operating income $ 34,700 In...
Flight Café prepares in-flight meals for airlines in its kitchen located next to a local airport....
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) 28,000 Revenue ($4.00q) $ 112,000 Expenses: Raw materials ($2.00q) 56,000 Wages and salaries ($6,200 + $0.20q) 11,800 Utilities ($1,900 + $0.05q) 3,300 Facility rent ($3,300) 3,300 Insurance ($3,000) 3,000 Miscellaneous ($700 + $0.10q) 3,500 Total expense 80,900 Net operating income $ 31,100 In...
Flight Café prepares in-flight meals for airlines in its kitchen located next to a local airport....
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...