14 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. Customers served Revenue ($3.600) Expenses Bickel Corporation Comparison of Actual Results to Planning Budget For the Month Ended November 30 Actual Results Planning Budget Variances 26,000 508,500 93,600 5,100 0 49,300 54,200 4,900 13,800 13,000 6,000. 6,100 13,300 15,300 800 100 F 3,000 F $1,400 30.600 7,100 $5,000 PROR $2,100 F Magen and salaries ($23,000 $1.20) Supplies (50.50) Insurance (8 6,100) Miscellaneous expense (54,900 $0.40g) Total expense Het operating income 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 (ie, zero variance). Input all amounts as positive values.) 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 24,800 24,800 26,000 Ravenue Expenses Mr Check my work 14 Miscellaneous expense (34, yue +$0.404) Total expense Net operating income Required: 32,300 81,400 13,300 88,600 3,000 7,200 $ 7,100 $ 5,000 $2,100 F 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 (l.e., zero variance). Input all amounts as positive values.) 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 24,800 24,800 26,000 Revenue Expenses Wages and salaries Supplies Insurance Miscellaneous expense Total expense Net operating income