The following summary data are from a performance report for Hyland company for June, during which 9,600 units were produced. The budget reflects the company's normal capacity of 10,000\units and use the info to answer A and B in an excel spreadsheet format while showing the formula to get the right numbers.

r 11 Flexible Budgets, Segment Reporting, and Performance Analysis Budget Actual Costs (10,000 Units) (9,600 Units) Variances $105,000 210,000 72,000 54,000 $102,600 207,900 73,800 54,300 $438,600 $2.400 F 2,100F 1,800U 300 u $2.400F Fixed overhead.. Total a. What is the general implication of the performance report? Why might Hyland question the sig- b. Revise the performance report using flexible budgeting and comment on the general implicain de- nificance of the report? of the revised report. 22 Assiqning Trocnble ived Exnenses Selected data for Colony Company, which operates