The following data were collected by Bemidji Co. for the month of June: Statie budget data: Sales Variable costs Total fixed costs Actual results: Sales Variable costs Total Fixed costs 11,250 units e 39/unit $ 27.50 per unit $ 23,625 12,300 units e $38/unit $ 29.40 per unit $ 22,575 Required: 1, 2 & 3. Prepare the static and flexible budgets and show the variances by completing the table given below. (Indicate the each variance by selecting "F" for favourable, "U" for unfavourable, and "None" for no effect (i.e., zero variance).) BEMIDJI COMPANY Static Budget Performance Report For the Month Ended June 30 Flexible Flexible Budget Variance Variance (Flexible Budget- Budget Static Budget) Actual Static B Sales (units) Revenue Variable expenses Contribution margin Fored expenses Income