As sales manager, Andrew Short was given the following static budget report for selling expenses in the Winter Sports Department of AC Outdoor Company for the month of November AC Outdoor Company Winter Sports Department Budget Report For the Month Ended November 30, 2020 Difference Budget Actual Favorable E Unfavorable U Sales in units 4,000 4.500 500 F Variable expenses Sales commissions $132,000 $140,900 $8,900 U Advertising expense 40.000 43,600 3,600 U Travel expense 176,000 191.600 15,600 U Demonstration models given out 92.000 82.000 10.000 F Total variable 440,000 458 100 18.100 U Fixed expenses Rent 8.000 8.000 Sales salaries 59,600 59,600 Office salaries 39.600 39.600 66 0 Advertising expense 40,000 43,600 3,600 U Travel expense 176,000 191,600 15.600 U Demonstration models given out 92,000 82,000 10,000 F Total variable 440,000 458,100 18,100 U Fixed expenses Rent 8,000 8,000 Sales salaries 59,600 59.600 -0- Office salaries 39,600 39,600 -0- Depreciation-vans (sales staff) 2,700 3,300 Total fixed 109,900 110,500 88 600 U 600 U Total expenses $549,900 $568,600 $18,700 U "The increase in depreciation was due to a new vehicle that had to be purchased as a result of an accident driving on snowy roads on the way to visit a customer As a result of this budget report. Andrew 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, Andrew 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 Question 7 of 9 < > 0.45/3 Prepare a budget report based on flexible budget data to help Andrew. (Round per unit answers to 2 decimal places, eg 15.25) AC Outdoor Company Winter Sports Department Flexible Budget Report For the Month Ended November 30, 20 Per Unit Budget Sales In Units Variable Expenses Sales Commisalona Advertising Expe Travel Expens Free Demonstration Models Total Variati Flad Expenses Rate Offer 4600 30 138000 41400 46 211600 124200 112 $13200 7500 39800 40500 Depradation Auto als State 2800 Total Flad SOPSOC Total Exper AC Outdoor Company Winter Sports Department Flexible Budget Report Month Ed November 30, 2020 4600 Actual 4600 Difference Favorable Unfavorable Neither Favorable nor Unfavorable 138000 130700 7300 Favorable 41400 39700 1700 Favorable 211600 206200 5400 Favorable 124200 102700 21500 Favorable $15200 479300 35900 Favorable 7100 7100 59800 59800 Nalther Favorable nor Unfavorable Nalther Favorable nor Unfavorable 40100 40100 Nesher Favorable nor unfavorable 2500 3000 500 Unfavorable 109500 110000 300 Unfavorable 624700 589200 234000 Favorable