q6 need help on the red

As sales muruget, Joe Butbta was given the following static budget report for selling expenses in the Clothing Department of Choronne Comporm for the month of October. As a resuit of this budget report, Joe was called into the president's office and congratulated on his fine sales performance. He was reprimanded, however, for allowing his costs to get out of control. Joe knew sorrething was wrong with the performance report that he hnd been glven. However, he was not sure what to do, and comes to you for advice. (a) Prepare a budget report based on flexible budget data to help Joe: (List variable expenses before frxed expenses.) reprimanded, however, for allowing his costs to get out of control. Joe knew something was wrong with the performance report that he had been given. However, he was not sure what to do, and comes to you for advice. (a) Prepare a budget report based on flexible budget data to help Joe. (List voriable expenses before fixed expenses.) Variable Expenses Sales Commissions \$ 2288 s 477 Advertising Expense 1160 748 412 Travel Expense. 5220 3608 1612 Free Samples Total Variable Expenses Fixed Expenses \begin{tabular}{r} \\ \\ \\ \hline \end{tabular} 35891088 Rent Sales Sataries \begin{tabular}{r} \hline 1320 \\ \hline 1056 \\ \hline \end{tabular} 1320 0 Office Salaries 704 b) Depreciation-Sales Staff Autos * \begin{tabular}{|r|} \hline 704 \\ \hline 440 \\ \hline \end{tabular} 440 bi SUPF Total Fixed Expenises 3520 3520 Free Samples: Total Variable Expenses Fixed Expenses Rent 8 \begin{tabular}{r} 4320 \\ \hline \end{tabular} \begin{tabular}{r} 1320 \\ \hline \end{tabular} 0 Sales Salaries + 1056 1056 Office Salaries 704 709 Depreciation-Sales Staff Autos o Totalfoued Expenses \begin{tabular}{|c|c|} \hline & 0520 \\ \hline$ & 14985 \\ \hline \end{tabular} Total Experises