The following is data collected by Bees Co. for the month of June: Static budget data: Sales Variable costs Total fixed costs Actual results: Sales Variable costs Total fixed costs Required: 11,000 units @ $38/unit $27 per unit $23,100 12,000 units @$37/unit $28 per unit $22,100 Prepare the flexible budgets and show the flexible budget variances by completing the table given below. Indicate the effect of each variance by selecting "F" for favourable, "U" for unfavourable, and "None" for no effect (i.e., zero variance). Static Budget Actual Flexible Budget Flexible Budget Variance Favourable/ Unfavourable Sales (units) 11,000 I Revenue ($) 418,000 (Click to select) Variable expenses (5) 297,000 (Click to select) Fixed expenses ($) 23,100 Income ($) 97,100 (Click to select) (Click to select)