The following data were collected by Bemidji Co. for the month of June Static budget data: Sales Variable costs Total fixed costs Actual resultat Sales Variable costs Total fixed costs 10,000 units 34/unit $ 25.00 per unit $ 21,00 10,000 units 533/unit $26.40 per unit $ 20,200 Required: 1,26 3. Prepare the static and flexible budgets and show the variances by completing the table given below. (Indicate the effect of och variance by selecting "F" for favourable. "U" for unfavourable, and "None" for no effect fi... zero variance)) BEMIDJI COMPANY Static Budget Performance Report For the Month Ended June 30 Flexible Flexible Budget Variance Sales Volume Variance Budget Actual Static Budget Static Variance Sales (units) Revenge Variable expenses Contribution margin 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 (ie, zero variance).) BEMIDJI COMPANY Static Budget Performance Report For the Month Ended June 30 Flexible Flexible Budget Variance Budget Salas Volume Variance Actual Static Budget Static Variance Sales (units) Revenue Variable expenses Contribution margin Fixed expenses Income 4. This part of the question is not part of your Connect assignment