Prepare the flexible budget.

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 Customers served Variances 25,000 24,000 Revenue ($3.509) 5 87,500 $84, eee $3.See Expenses: Wages and salaries ($22,400 + $1.149) Sa, 900 49,760 1, 140 0 Supplies ($0.549) 11,660 12,960 1,300F Insurance ($4,300) 4,300 8 None Miscellaneous expense ($3,300 + $0.349) 10.160 11,460 1,300 Total expense 27. 020 78,488 1.460 Net operating income $ 10,480 $ 5,520 $ 4,960 F 4,300 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 (l.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 25,000 25,000 Activity Variances Planning Budget Customers served 24,000 contexternal browser=0&launchurahttps:253A%252F%252Fmarshall-bb blackboard.com i Saved $ 87,500 $84,000 $3.500 F evenue ($3.5092 xpenses: Wages and salaries (522,400 - $1.149) Supplies (59.549) Insurance ($4,300) Miscellaneous expense ($3,300 + $0.340) otal expense it operating income 50,900 11,660 4,380 10,160 72,620 $ 10,480 49,768 12,960 4,380 11,460 78,480 $ 5,520 1,140 1,300 F e None 1,300F 1,460 $ 4,960 F quired: pare the company's flexible budget performance report for November. Label each variance as favorable (F) or unfavorable (U) dicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (t.e., zero iance). 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 25,000 25,000 Activity Variances Planning Budget 24.000 ustomers served venue penses Wages and salaries Supplies Insurance Miscellaneous expense tal expense at operating income