Midland Manufacturing Inc. has just completed its operations for August, which was a particularly busy month. They processed 24% more product than had been originally planned for the month. A report prepared by Management comparing actual costs to budgeted costs appears below. Matoika Marine Cost Control Report For the Month Ended August 31 Actual 7 Units Produced Variable costs: Marine supplies Emmission tests Other Variable Administrative supplies Total variable cost Staff salaries Rent Fixed costs: Equipment depreciation Utilities Total fixed cost Total cost Budget Variance 960 600 360 F $ 8,750 8,380 $5,250 $ 3,500 U 7,500 880 U 1,990 1,200 790 U 530 19,650 300 14,250 230 U 5,400 U 12,500 12,500 4,100 3,150 950 U 1,250 1,250 700 565 135 U 18,550 17,465 1,085 U $38,200 $31,715 $6,485 U The managing director was very unhappy with this report, claiming that her costs were higher than expected. She also pointed out that the additional costs had been fully covered by payments from suppliers. The accountant who prepared the report pointed out that actual costs were a lot higher than promised in the budget. Required: 1. Prepare a new performance report for August using the flexible budget approach. (Note: Even though some of these costs might be classified as direct costs rather than overhead, the flexible budget approach can still be used to prepare a flexible budget performance report). (Indicate the effect of each variance by selecting "F" for favourable, "U" for unfavourable, and "None" for no effect (.e. zero variance). Round "Cost Formula" answers to 2 decimal places) Matoika Marine Flexible Budget Performance Report For The Month Ended August 31 Variable costs: Actual Cost Formula (Per unit) 960 Spending or Budget Variance Flexible Budget Static Budget Activity-Level (units) 960 600 Variable costs: Medical supplies Emmission tests Other variable Expenses Administrative supplies Total variable cost Fixed costs: Staff salaries Equipment depreciation Rent Utilities Total fixed cost Total cost Flexible Budget Performance Report For The Month Ended August 31 Cost Formula (Per unit) Actual 960 Spending or Budget Variance Activity-Level (units) Flexible Budget Static Budget 960 600