Please help me with question (d)

Please help me with (d) and observations for (c) and (d)

Ratchet Company uses budgets in controlling costs. The August 2022 budget report for the company's Assembling epartment is as follows. The monthly budget amounts in the report were based on an expected production of 60,000 units per month or 720,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 58,000 units were produced. Instructions (a) State the total monthly budgeted cost formula. (b) Prepare a budget report for August using flexible budget data. Why does this report provide a better basis for evaluating performance than the report based on static budget data? (c) In September, 64,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. Assume that the number of units produced in September changed to 68,000 . Revise the flexible budget report for September assuming (1) each variable cost was 12% higher than its actual cost in August and (s) fixed costs remain the same in September as in August. September as in August. State the total monthly budgeted cost formula. Fixed cost in Total + variable cost of 2.85 per Unit Prepare a budget report for August using flexible budget data. Why does this report provide a better basis for evaluating performance than the report based on static budget data? \begin{tabular}{|c|c|c|c|c|c|} \hline & & Budget at & Actual Costs & & \\ \hline Units & & 58,000 units & 58,000 units & B/(W) & F/U \\ \hline & & & & & \\ \hline \multicolumn{6}{|c|}{ Variable costs } \\ \hline \multicolumn{2}{|c|}{ Direct materials } & $46,400 & $47,000 & $600 & U \\ \hline \multicolumn{2}{|c|}{ Direct labor } & 52,200 & 51,200 & 1,000 & F \\ \hline \multicolumn{2}{|c|}{ Indirect materials } & 23,200 & 24,200 & 1,000 & U \\ \hline \multicolumn{2}{|c|}{ Indirect labor } & 17,400 & 17,500 & -100 & U \\ \hline \multirow{2}{*}{\multicolumn{2}{|c|}{ Maintenance }} & 14,500 & 14,900 & -400 & U \\ \hline & & 11,600 & 12,400 & -800 & U \\ \hline \multicolumn{2}{|c|}{ Total variable } & 165,300 & 167,200 & 1,900 & U \\ \hline \multicolumn{6}{|l|}{ Fixed costs } \\ \hline Rent & & 12,000 & 12,000 & 8 & \\ \hline \multicolumn{2}{|c|}{ Supervision } & 17,000 & 17,000 & 8 & - \\ \hline \multicolumn{2}{|c|}{ Depreciation } & 6,000 & 6,000 & 0 & \\ \hline \multirow{2}{*}{\multicolumn{2}{|c|}{ Total fixed }} & 35,000 & 35,000 & 0 & \\ \hline & & & & & \\ \hline Total costs & & $200,300 & $202,200 & $1,900 & U \\ \hline \end{tabular} Observations: A flexible budget report provides better basis for evaluating the Assembly Department's performance as it uses the same actitivity level as the actual results with the budget is compared. In September, 64,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. A B c D E F G H I J K Observations: (d) Assume that the number of units produced in September changed to 68,000. Revise the flexible budget report for September assuming (1) each variable cost was 12% higher than its actual cost in August and (s) fixed costs remain the same in September as in August. RATCHET COMPANY Assembling department Flexible budget Report For the Month Ended September 30, 2022 \begin{tabular}{|l|c|c|c|c|} \hline \multicolumn{6}{|c|}{ Budget at } & Actual Costs & & \\ \hline Units & 68,000 units & 68,000 units & B/(W) & F/U \\ \hline \end{tabular}