View Policies Current Attempt in Progress As sales manager, Joe Batista was given the following static budget report for selling expenses in the Clothing Department of Bramble Company for the month of October. BRAMBLE COMPANY Clothing Department Budget Report For the Month Ended October 31, 2022 Difference Favorable Unfavorable Neither Favorable nor Unfavorable Budget Actual Sales in units 6,720 8.400 1,680 Favorable Variable expenses Sales commissions $2,016 $2,184 $168 Unfavorable Advertising expense 672 714 42 Unfavorable Travel expense 3,024 3,444 420 Unfavorable Free samples given out 1,344 1,176 168 Favorable Total variable 7,056 7,518 462 Unfavorable Fixed expenses Rent 1,260 1,260 -O- Neither Favorable nor Unfavorable Sales salaries 1,008 1,008 -O- Neither Favorable nor Unfavorable Office salaries 672 672 -0- Neither Favorable nor Unfavorable Denreciation autoregler staff 120 Neither Evorable nor Infavorable Travel expense 3,024 3,444 420 Unfavorable Free samples given out 1,344 1,176 168 Favorable Total variable 7,056 7,518 462 Unfavorable Fixed expenses Rent 1.260 1,260 -0- Neither Favorable nor Unfavorable Sales salaries 1,008 1,008 -0- Neither Favorable nor Unfavorable Office salaries 672 672 -O- Neither Favorable nor Unfavorable Depreciation-autos (sales staff) 420 420 -O- Neither Favorable nor Unfavorable Total fixed 3,360 3,360 -0- Neither Favorable nor Unfavorable Total expenses $10,416 $10,878 $462 Unfavorable As a result 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 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 variable expenses before fixed expenses.) BRAMBLE COMPANY Selling Expense Flexible Budget Report Clothing Department For the Month Ended October 31, 2022 Budget Actual Sales in Units 8,400 8,400 Variable Expenses Sales Commissions $ $ $ Advertising Expense Travel Expense Free Samples Total Variable Expenses Total Fixed Expenses Fixed Expenses Rent Sales Salaries Office Salaries Depreciation-Sales Staff Autos Total Fixed Expenses A $