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 Vardable costs Total fixed costs 13,250 units 45/unit $31.50 per unit $ 27,825 14,700 units 544/unit $34.20 per unit $ 26,375 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 "P" for favourable, "U" for unfavourable, and "None" for no effect (ie, zero variance): Static Budget BEMIDJI COMPANY Static Budget Performance Report For the Month Ended June 30 Actual Flexible Flexible Budget Variance Budget Sales Volume Variance 14,700 14,700 646,800 $ 14,7000 501,500 502,740 U 463,050 U 144.060 198.450 26,375 27.825 117,085 $ 170,6251 13,250 Sales (units) Revenue Variable expenses Contribution margin Fixed expenses Income $ $ $ ind flexible budgets and show the variances by completing the table given below. indicate the effect of E for favourable, "U" for unfavourable, and "None" for no effectie, tera variance) ti Vari State Budget 13,250 DEMIDJI COMPANY Static Budget Performance Report For the Month kinded June 30 Actual Flexible Budget Variance Flexible Sales Volume Variance Budget 14,700 14,700 646,800 $ 14.700 $ 661,500 502.740 U 463,050 u 144,060 tu $ 198,450 26,375 F 27 825 117,685 TU $ 170,625 $ U $ F S U