the answers can be sinply written on a piece of paper

Cost Item Yearly Yearly Yearly Monthly Actual for Variable Fixed Indirect Materials Total Budget February $ 960,000 $ 48,000 Indirect Labor $1,008,000 $ 84,000 $ 99,000 294,000 156.000 450,000 37,500 Labor Fringe Benefits 29,500 1,656,000 30,000 1.686,000 140,500 150,200 Utilities 96,000 60,000 156,000 13,000 15,200 Repairs and Maintenance 96,000 30,000 126,000 10,500 14.700 Miscellaneous 48.000 36,000 84,000 7,000 7,475 Depreciation 72,000 72.000 6.000 6,000 Property Taxes & Insurance 86,400 86,400 7 200 7200 $3,150,000 $518,400 $3,668.400 $305,700 $325.075 Your group has discovered that production during the month was 11,200 units, requiring 89,600 direct labor hours. REQUIRED: Explain to the CEO how a flexible budget would be a better tool for evaluating the performance of this plant. Create a spreadsheet to perform appropriate computations and present it to the CEO while explaining your analysis. What are possible reasons for some of the variances? Which cost areas should be investigated (assume 5% or more off of the budget is considered significant)? Which personnel related to this plant should be called in to better determine the causes of significant deviations from the budget? Cost Item Yearly Yearly Yearly Monthly Actual for Variable Fixed Indirect Materials Total Budget February $ 960,000 $ 48,000 Indirect Labor $1,008,000 $ 84,000 $ 99,000 294,000 156.000 450,000 37,500 Labor Fringe Benefits 29,500 1,656,000 30,000 1.686,000 140,500 150,200 Utilities 96,000 60,000 156,000 13,000 15,200 Repairs and Maintenance 96,000 30,000 126,000 10,500 14.700 Miscellaneous 48.000 36,000 84,000 7,000 7,475 Depreciation 72,000 72.000 6.000 6,000 Property Taxes & Insurance 86,400 86,400 7 200 7200 $3,150,000 $518,400 $3,668.400 $305,700 $325.075 Your group has discovered that production during the month was 11,200 units, requiring 89,600 direct labor hours. REQUIRED: Explain to the CEO how a flexible budget would be a better tool for evaluating the performance of this plant. Create a spreadsheet to perform appropriate computations and present it to the CEO while explaining your analysis. What are possible reasons for some of the variances? Which cost areas should be investigated (assume 5% or more off of the budget is considered significant)? Which personnel related to this plant should be called in to better determine the causes of significant deviations from the budget