5 10 points 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 11,750 units @ 39/unit $ 28.50 per unit $ 24,675 12,900 units @ $38/unit 8 02:43:03 Variable costs Total fixed costs $ 30.60 per unit $ 23,525 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 Performance Report For the Month Ended June 30 Actual Flexible Budget Variance Flexible Budget Sales Volume Variance 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.