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 9,75e units @ 33/unit $24.50 per unit $ 20,475 10,5ee units @ $32/unit $ 25.80 per unit $ 19,725 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 (l.e.. zero variance)) BEMIDJI COMPANY Static Budget Performance Report For the Month Ended June 30 Flexible Flexible Dudget Variance Budget Sales Volume Vanance Actual Static Budget Static Variance Sales (units) Revenue Variable expenses Contribution margan Fixed expenses Income 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 effectievero variance)) DEMIDJI COMPANY Stane Budget Performance Report For the Month Ended Juhe 30 Fubie Budget Variance Flexible Ses Volume Variance Budget Actual the Budget Stevana Salut) Revenge Variable expenses Contribution margin Fixed expenses income U None BEMIDJI COMPANY Stane Budget Performance Report For the Month Ended June 30 Flexible Budget Varance Flexible Budget Ses Volume Varance Actual Static Budget State Variante se expenses ution margin expenses U None Static Budget Performance Report For the Month Ended June 30 Flexible Flexible Budget variance Budget Sales Volume Varance Actual Suite Budget Statie Vance None