Flexible Budget Report 2 Requirements below) As manager ohn was even the following static budget report in the chatting department of Phem Company for the month of October DUNHAM COMPANY Clothing Department Static Budget Report Month Ended October 31, 2020 Actual Variance 7.900 U, For N/A 3.100 Favourable Budget 9 Sales in Units 11,000 10 Vanable 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 17 Rent 16 Fixed costs 18 Sales salaries 1,200 1,200 N/A 1,000 1.000 N/A 19 Office salaries 20 Depreciation vehicles 21 Total fixed costs 22 Total costs 700 700 N/A 400 400 N/A 3,300 $12.100 3,300 N/A $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.