1 234 Flexible Budget Report (2 Requirements below) As sales manager, John was given the following static budget report in the clothing department of Dunham Company for the month of October: DUNHAM COMPANY 5 Clothing Department Static Budget Report 67 8 Month Ended October 31, 2020 Actual Budget Variance U, For N/A 9 Sales in Units 11,000 7,900 3,100 Favourable 10 Variable Costs 11 Sales commissions $2,970 $1,896 1,074 Unfavourable 12 Advertising expense 770 1,106 336 Favourable 13 Travel expense 3,850 3,318 532 Unfavourable 14 Free samples given out 1,210 1,185 25 Unfavourable 15 Total variable costs 8,800 7,505 1,295 Unfavourable 16 Fixed costs 17 Rent 1,200 1,200 N/A 18 Sales salaries 19 Office salaries 1,000 1,000 N/A 700 700 N/A 20 Depreciation-vehicles 21 Total fixed costs 22 Total costs 400 400 N/A 3,300 3,300 N/A $12,100 $10,805 1,295 Unfavourable 23 As a result of this report, John was called into the president's office and congratulated on his fine sales 24 performance. He was reprimanded, however, for allowing his costs to get out of control. John was not 25 sure what to do and has come to you for advice. 26 Complete the 2 Requirements below: 27 1. Prepare a budget report based on flexible budget data to help John.