Fill This Form To Receive Instant Help
Fill This Form To Receive Instant Help
Homework answers / question archive / The following report compares the planning budget to the actual operating results for the month of November Dickel Corporation Comparison of Actual Results to Planning Budget For the Month nded November 30 Metal Result Planning Budget Variances Customer served 39,000 39,000 seven (53
The following report compares the planning budget to the actual operating results for the month of November Dickel Corporation Comparison of Actual Results to Planning Budget For the Month nded November 30 Metal Result Planning Budget Variances Customer served 39,000 39,000 seven (53.600) 5140,000 5136.000 2,200 Expenses Wages and salaries (523,800 + 51.289) 73, 720 72.440 1,280 Supplies (50.689) 23, 240 25,840 2.600 Insurance 55,700) 5.700 5,700 0 None Miscellaneous expense 54,700 50.379) 16.160 19.260 2,600 Total expense 118, 820 122,240 3.2017 Net operating income $21.180 $ 14,060 $7.520 Required: Prepare the company's flexible budget performance report for November Label each variance as favorable (1) 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.)
Bickel Corporation Flexible Budget Performance Report For the Month Ended November 30 Revenue Actual and Flexible Results Spending Budget Variances 39,000 39,000 Activity Variances Planning Budget 38,000 Customers served Revenue Expenses: Wages and salaries Supplies Insurance Miscellaneous expense Total expense Net operating income
a
| Bickel Corporation | |||||||
| Flexible Budget Performance Report | |||||||
| For the month Ended November 30 | |||||||
| Actual Results | Revenue and Spending variances | Flexible Budget | Activity Variances | Planning Budget | |||
| Customers served | 39,000 | 39,000 | 38,000 | ||||
| Revenue | $140,000 | $400 | U | $140,400 | $3,600 | F | $136,800 |
| Expenses: | |||||||
| Wages and salaries | $73,720 | $0 | None | $73,720 | $1,280 | U | $72,440 |
| Supplies | $23,240 | $3,280 | F | $26,520 | $680 | U | $25,840 |
| Insurance | $5,700 | $0 | None | $5,700 | $0 | None | $5,700 |
| Misllaneous expenses | $16,160 | $2,970 | F | $19,130 | $370 | U | $18,760 |
| Total expenses | $118,820 | $6,250 | F | $125,070 | $2,330 | U | $122,740 |
| Net operating income | $21,180 | $5,850 | F | $15,330 | $1,270 | F | $14,060 |
Calculation of Flexible Budget :
Revenue = 136,800/ 38,000= $ 3.6
= 39,000 x $ 3.6 = 140,400
Expenses :
Wages and salaries = ( 23,800 + 39,000 X 1.28) = $ 73,720
Supplies = ( 0.68 x 39,000) = $ 26,520
Insurance = 5,700
Miscellaneous expense = ( 4,700 + 0.37 x 39,000) = $ 19,130
Revenue & Spending Variance = Actual Results - Flexible Budget
Activity Variance = Flexible Budget - Planning Budget
