Prepare a budget report based on flexible budget data to help Hank.

As sales manager, Hank Short was given the following static budget report for selling expenses in the Winter Sports Department of Jennings Outdoor Company for the month of November. Jennings Outdoor Company Winter Sports Department Budget Report For the Month Ended November 30, 2020 Budget 4,100 Actual 4.600 Difference Favorable F Unfavorable U 500 F $127,100 $135,500 36,900 39,700 188,600 206,000 98,400 88.900 451,000 470,100 $8,400 V 2,800 U 17,400 U 9,500 F 19,100 U Sales in units Variable expenses Sales commissions Advertising expense Travel expense Demonstration models given out Total variable Fixed expenses Rent Sales salaries Office salaries Depreciation - vans (sales staff) Total fixed Total expenses 6,900 6,900 60,300 60,300 40,300 40,300 2,300 2,700 * 109,800 110,200 $560,800 $580,300 -O- 400 U 400 U $19,500 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, Hank 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. Hank 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. Prepare a budget report based on flexible budget data to help Hank. (Round per unit answers to 2 decimal places, eg. 15.25.) Jennings Outdoor Company Winter Sports Department Flexible Budget Report Difference Favorable Unfavorable Neither Favorable Per Unit Budget Actual nor Unfavorable Sales in Units 4600 4600 Variable Expenses Sales Commissions 135500 Advertising Expense 39700 Travel Expense 206000 Free Demonstration Models 88900 Total Variable 470100 Fixed Expenses Rent 6900 Sales Salaries 60300 Office Salaries 40300 Depreciation - Auto (Sales Staff) 2700 Total Fixed 110200 Total Expenses 580300