E23.9 (LO 1, 2), E As sales manager, Joe Batista was given the following static budget report for selling Oxpenses in the Clothing Department of Soria Company for the month of October. Soria Company Clothing Department Budget Report For the Month Ended October 31, 2022 Difference Sales in units Variable expenses Budget 8,000 Actual Favorable F Unfavorable U 10,000 2,000 F Sales commissions $ 2,400 $ 2,600 $ 200 U Advertising expense 720 850 130 U Travel expense 3,600 4.100 500 U Free samples given out 1,600 1,400 200 F Total variable 8,320 8,950 630 U Fixed expenses Rent 1,500 1,500 Sales salaries 1,200 1,200 Office salaries 800 800 Depreciation-autos (sales staff) 500 500 Total fixed Total expenses 4,000 $12,320 4,000 $12,950 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. Instructions a) Prepare a budget report based on flexible budget data to help Joe. b) Should Joe have been reprimanded? Explain. Prepare flexible budget and responsibility report for manufacturing overhead. T