The following data were collected by Bemidji Co. for the month of June Statie budget data: Sales Variable conte Total fixed costs Actual resultat Sales Variable costs Total fixed costs 11,250 unit. 39/unit $ 27.50 per unit $23,625 12,300 unita $38/unit $ 29.40 per unit $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 "P" for favourable, "U" for unfavourable, and "None" for no effectie, zero variance).) BEMIDUI COMPANY Static Budget Performance Report For the Month Ended June 30 Flexible Variance (Plexible fudget. Flexible budget Variance Budget State Budget Actual Sales (unit) Revenue Variable expenses Contribution margin Fixed expenses Income