As sales manager, Wyatt Short was given the following static budget report for selling expenses in...

Transcribed Image Text:

As sales manager, Wyatt Short was given the following static budget report for selling expenses in the Winter Sports Department of WT Outdoor Company for the month of November. WT Outdoor Company Winter Sports Department Budget Report For the Month Ended November 30, 2020 Difference Favorable F Budget Actual Unfavorable U Sales in units 4,000 4,400 400 F Variable expenses Sales commissions $120,000 $124,600 $4,600 U Advertising expense 40,000 42,400 2,400 U Travel expense 192,000 204,600 12,600 U Demonstration models given out 92,000 79,600 12,400 F Total variable 444,000 451,200 7,200 U Fixed expenses Rent 8,000 8,000 -0- Sales salaries 59,700 59,700 -0- Office salaries 40,400 40,400 -0- Depreciation - vans (sales staff) 2,300 2,900 600 U Total fixed 110,400 111,000 600 U Total expenses $554,400 $562,200 $7,800 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, Wyatt 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. Wyatt 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. (a) > Advertising Expense Depreciation - Auto (Sales Staff) Fixed Expenses Iget data to help Wyatt. (Round per unit answers to 2 decimal places, e.g. 15.25.) Prepare a budget report based on flexible budget data to help Wyatt. (Round per unit answers to 2 WT Outdoor Company Winter Sports Department Flexible Budget Report WT Outdoor Company Winter Sports Department Flexible Budget Report Free Demonstration Models Per Unit Budget Actu idget Actual Office Salaries Rent Sales Commissions Sales in Units Sales Salaries Total Expenses Total Fixed Total Variable Travel Expense Variable Expenses $ $ $ $ $ $ $ $ Differenc Favorable Unfavorab Neither Favor nor Unfavora As sales manager, Wyatt Short was given the following static budget report for selling expenses in the Winter Sports Department of WT Outdoor Company for the month of November. WT Outdoor Company Winter Sports Department Budget Report For the Month Ended November 30, 2020 Difference Favorable F Budget Actual Unfavorable U Sales in units 4,000 4,400 400 F Variable expenses Sales commissions $120,000 $124,600 $4,600 U Advertising expense 40,000 42,400 2,400 U Travel expense 192,000 204,600 12,600 U Demonstration models given out 92,000 79,600 12,400 F Total variable 444,000 451,200 7,200 U Fixed expenses Rent 8,000 8,000 -0- Sales salaries 59,700 59,700 -0- Office salaries 40,400 40,400 -0- Depreciation - vans (sales staff) 2,300 2,900 600 U Total fixed 110,400 111,000 600 U Total expenses $554,400 $562,200 $7,800 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, Wyatt 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. Wyatt 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. (a) > Advertising Expense Depreciation - Auto (Sales Staff) Fixed Expenses Iget data to help Wyatt. (Round per unit answers to 2 decimal places, e.g. 15.25.) Prepare a budget report based on flexible budget data to help Wyatt. (Round per unit answers to 2 WT Outdoor Company Winter Sports Department Flexible Budget Report WT Outdoor Company Winter Sports Department Flexible Budget Report Free Demonstration Models Per Unit Budget Actu idget Actual Office Salaries Rent Sales Commissions Sales in Units Sales Salaries Total Expenses Total Fixed Total Variable Travel Expense Variable Expenses $ $ $ $ $ $ $ $ Differenc Favorable Unfavorab Neither Favor nor Unfavora