Flexible Budget report

IL SUO Current Attempt in Progress Cheyenne Company uses budgets in controlling costs. The August 2017 buchet report for the company's Assembling Department is as follows CHEYENNE COMPANY Budget Report Assembling Department For the Month Ended August 31, 2017 Difference Favorable Manufacturing Costs Budget Actual Unfavorable Variable costs Direct materials $52,460 $51,460 $1.000 Favorable Direct labor 57.340 53.940 3.400 Favorable Indirect materials 26.840 27.140 300 Unfavorable Indirect labor 18,300 17.890 410 Favorable Utilities 15.250 15,060 190 Favorable Maintenance 6.100 6,350 250 Unfavorable Total variable 176.290 171,840 4450 Favorable Fixed costs Rent 11,000 11.000 Supervision 18.000 18.000 Depreciation 7.900 7.900 Total fixed 36.900 36.900 Total costs $213.190 S208.740 $4.450 Favorable The monthly budget amounts in the report were based on an expected production of 61,000 units per month 732.000 units per year. The Assembling Department manager is pleased with the report and expects a raise, or at least praise for a job well done. The company president, however, is unhappy with the results for August because only 59.000 units were produced. Your answer is correct. State the total monthly budgeted cost formula. (Round cost per unit to 2 decimal places, eg 1250 2.29 The formula is s - variable costs of 5 Der unit 38900 e Textbook and Media Attempts: 1 of 3 used (51) Your answer is correct Prepere a budget report for August using flexible budget data. (List variable costs before fixed costs CHEYENNE COMPANY Assembling Department Flexible Budget Report For the Month Ended August 31, 2017 Nei Budget Actual Costs no 59000 59000 erials 50740 51250 720 55460 539:40 1520 25960 1 17700 17890 1750 15060 6350 4510 1718 40 1650 11000 18000 18000 7900 7900 0 36900 1 36900 207430 208740 . 1350 e Textbook and Media Solution Attempts: 3 of 3 used a In September, 65,000 units were produced. Prepare the budget report using flexible budget data assuming (1) each variable cost was 10% higher than its actual cost in August, and (2) fixed costs were the same in September as in August (List variable costs before fed costs.) CHEYENNE COMPANY Assembling Department Flexible Budget Report Budget Actual Costs $ 5 S s $ eTextbook and Media Attempts: 0 of 3 used Submit Answer a hp In September. 65.000 units were produced. Prepare the budget report using flexible budget data, assuming (1) each variable cost was 10% higher than its actual cost in August, and (2) fixed costs were the same in September as in August. (List variable costs before fixed costs.) CHEYENNE COMPANY Assembling Department Flexible Budget Report Difference Favorable Unfavorable Neither Favorable nor Unfavorable lget Actual Costs $ S s e Textbook and Media Se forze Attempts: 0 of 3 used Submit Answer HP a hp