5 The following data were collected by Bemidji Co, for the month of June. Static hudget data: Sales Variable costs Total fixed costs Actual results: Sales Variable costs Total fixed costs 11,258 units 39/unit $ 27.50 per unit $ 23,625 10 points 03:10:54 12,300 units $38/unit 5 29.48 per unit 5 22.575 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 effectie.. zero variance). BEMIDJI COMPANY Static Budget Performance Report For the Month Ended June 30 Flexible Budget Variance Flexible Sales Volume Variance Budget Actual Static Budget Static Var Sales (units) Revenue Variable expenses Contribution margin Fixed expenses Income 4. This part of the question is not part of your Connect assignment