Rock Company has been using a static budgeting for reporting their annual results. They have budgeted the following costs for the month for 40,000 machine hours: Total Budgeted variable costs: Indirect labour $ 20,000 Indirect materials $ 60,000 Maintenance & Utilities $ 16,000 Total Budgeted fixed overhead costs per month are: Supervision $ 4,000 Property taxes $ 1,000 Depreciation $ 9,000 Required: Prepare a flexible budget report by completing the table below, assuming that the company used 44,000 machine hours during August. Actual results have been provided below. Input your response in the correct box. Also indicate if the differences in the variance are Favourble (F) or Unfavourable (U) or Not Applicable (N/A) Manufacturing Overhead Budget Report (Flexible) For the Month Ended August 31, 2020 Difference Budget ??? For U Machine Hours Actual 44,000 Manufacturing Overhead Budget Report (Flexible) For the Month Ended August 31, 2020 Difference For U Budget ??? Actual 44,000 A B Machine Hours Variable overhead costs Indirect Labour Indirect Materials Maintenance & Utilities Total variable costs Fixed overhead costs Supervision Property Taxes Depreciation Total fixed costs Total costs $24,000 $67,500 $12,000 103,500 C 105,600 D E E 16,000 $96,600 4,400 1,200 9,000 14,600 $93,000 What is total indirect labour cost? (ie. what is the answer for box A? Round your answer to the nearest whole number, do not enter any decimal places, dollar signs, or commas. E.g. 1000 Answer This difference for indirect labour is What is total indirect materials cost? (i.e. what is the answer for box B?) Round your answer to the nearest whole number, do not enter any decimal places, dollar signs, or commas. E.g. 1000 Answer This difference for indirect materials is What is total maintenance and utilities cost? (i.e. what is the answer for box C?) Round your answer to the nearest whole number, do not enter any decimal places, dollar signs, or commas. E.g. 1000. Answer This difference for maintenance and utilities is What is total supervision cost? (i.e. what is the answer for box D?) Round your answer to the nearest whole number, do not enter any decimal places, dollar signs, or commas. E.g. 1000. Answer This difference for supervision costs is w . What is total property tax cost? (i.e. what is the answer for box E?) Round your answer to the nearest whole number, do not enter any decimal places, dollar signs, or commas. E.g. 1000. Answer This difference for property tax is What is the total depreciation costs (i.e. what is the answer for Box f?) Round your answer to the nearest whole number, do not enter any decimal places, dollar signs, or commas. E.g. 1000. Answer
