17-9 Marks The following is data collected by Bees Co. for the month of June: 12 Static budget data: Sales Variable costs Total fixed costs Actual results: Sales Variable costs Total fixed costs 11,000 units @ $38/unit $27 per unit $23,100 12,000 units @ $37/unit $28 per unit $22,100 Required: 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). Flexible Static Budget Flexible Actual Budget Budget Variance Favourable/ Unfavourable Sales (units) 11,000 Revenue ($) 418,000 Variable expenses ($) 297,000 Fixed expenses ($) 23,100 Income ($) 97,100 (Click to select) (Click to select) (Click to select) (Click to select) L