The following data were collected by Bemidji Co. for the month of June Static budget data: Sales Variable costs Total fixed costs Actual results: Sales Variable costs Total fixed costs 1e, see units 36/unit $ 26.00 per unit $ 22, ese 11,400 units @ $35/unit $ 27.60 per unit $ 21,150 Required: 1, 2 & 3. Prepare the static and flexible budgets and show the 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).) BEMIDJI COMPANY Static Budget Perfomance Report For the Month Ended June 30 Flexible Budget Variance Flexible Variance (Flexible Budget Budget Static Budget) Actual Static Budget = (units) nue le expenses pution margin xpenses