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.00q) 54,000 Wages and salaries ($6,200 + $0.20q) 11,600 Utilities ($2,100 + $0.05q) 3,450 Facility rent ($3,500) 3,500 Insurance ($2,000) 2,000 Miscellaneous ($700 + $0.10q) 3,400 Total expense 77,950 Net operating income $ 30,050 In July, 28,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) 28,000 Revenue ($4.00q) $ 112,000 Expenses: Raw materials ($2.00q) 56,000 Wages and salaries ($6,200+ $0.20q) 11,800 Utilities ($2,100 + $0.05q) 3,500 Facility rent ($3,500) 3,500 Insurance ($2,000) 2,000 Miscellaneous ($700 + $0.10q) 3,500 Total expense 80,300 Net operating income $ 31,700 Required: 1. Calculate the company’s activity variances for July. (Ind
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
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.00q) | 54,000 |
| Wages and salaries ($6,200 + $0.20q) | 11,600 |
| Utilities ($2,100 + $0.05q) | 3,450 |
| Facility rent ($3,500) | 3,500 |
| Insurance ($2,000) | 2,000 |
| Miscellaneous ($700 + $0.10q) | 3,400 |
| Total expense | 77,950 |
| Net operating income | $ 30,050 |
In July, 28,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) | 28,000 |
|---|---|
| Revenue ($4.00q) | $ 112,000 |
| Expenses: | |
| Raw materials ($2.00q) | 56,000 |
| Wages and salaries ($6,200+ $0.20q) | 11,800 |
| Utilities ($2,100 + $0.05q) | 3,500 |
| Facility rent ($3,500) | 3,500 |
| Insurance ($2,000) | 2,000 |
| Miscellaneous ($700 + $0.10q) | 3,500 |
| Total expense | 80,300 |
| Net operating income | $ 31,700 |
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.)
Step by step
Solved in 3 steps
