Q4

The following data were collected by Bemidji Co. for the month of June: 11,000 units @ 38/unit $ 27.00 per unit $ 23,100 Static budget data: Sales Variable costs Total fixed costs Actual results: Sales Variable costs Total fixed costs 12,000 units @ $37/unit $ 28.80 per unit $ 22,100 Required: 1, 2 & 3. Prepare the static and flexible budgets and show the variances by each variance by selecting "F" for favourable, "U" for unfavourable, and BEMID Static Budget For the Mon Actual Flexible Budget Variance 12,900 $ 490 mmmmmmmm Sales (units) Revenue Variable expenses Contribution margin Fixed expenses 22.100 Income