E21 N/A 5 6 1 2 3 4 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 Clothing Department Static Budget Report 7 8 Month Ended October 31, 2020 Actual Budget Variance 9 Sales in Units 11,000 7,900 U, F or N/A 3,100 Favourable 10 Variable Costs 11 Sales commissions $2,970 $1,896 1,074 Unfavourable 12 Advertising expense 770 1,106 335 Favourable 13 Travel expense 3,850 3318 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 20 Depreciation-vehicles 1,000 1,000 N/A 700 700 HILL N/A 400 400 N/A 21 Total fixed costs 3,300 3,300 N/A m Formula Sheet Part1-MCQ Part2-MCQ-Calc Flexible Budget Report Calculation Mode: Automatic Workbook Statistics + F G M