Bickel Corporation uses customers served as its measure of activity. The following report compares the planning budget to the actual operating results for the month of November: Bickel Corporation Comparison of Actual Results to Planning Budget For the Month Ended November 30 Actual Results Planning Budget Variances Customers served 44,000 43,000 Revenue ($3.60q) $ 158,100 $ 154,800 $ 3,300 F Expenses: Wages and salaries ($24,300 + $1.33q) 82,820 81,490 1,330 U Supplies ($0.73q) 29,790 31,390 1,600 F Insurance ($6,200) 6,200 6,200 0 None Miscellaneous expense ($5,200 + $0.42q) 23,100 23,260 160 F Total expense 141,910 142,340 430 F Net operating income $ 16,190 $ 12,460 $ 3,730 F Required: Prepare the company's flexible budget performance report for November. Label each variance as favorable (F) or unfavorable (U). (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.)
Flexible budget performance report
Actual | Revenue and spending variance | Flexible budget | Volume variance | Static budget | |
Customers served | 44000 | 44000 | 43000 | ||
Revenue | 158100 | 300 U | 158400 | 3600 F | 154800 |
Expense | |||||
Wages and salaries | 82820 | 0 None | 82820 | 1330 U | 81490 |
Supplies | 29790 | 2330 F | 32120 | 730 U | 31390 |
Insurance | 6200 | 0 None | 6200 | 0 None | 6200 |
Miscellaneous expense | 23100 | 580 F | 23680 | 420 U | 23260 |
Total expense | 141910 | 2910 F | 144820 | 2480 U | 142340 |
Net operating income | 16190 | 2610 F | 13580 | 1120 F | 12460 |
Get Answers For Free
Most questions answered within 1 hours.