Exercise 10-9 As sales manager, Joe Batista was given the following static budge
ID: 2572893 • Letter: E
Question
Exercise 10-9
As sales manager, Joe Batista was given the following static budget report for selling expenses in the Clothing Department of Soria Company for the month of October.
SORIA COMPANY
Clothing Department
Budget Report
For the Month Ended October 31, 2017
Difference
Budget
Actual
Favorable
Unfavorable
Neither Favorable
nor Unfavorable
8,200
11,000
2,800
$1,804
$2,750
$946
820
990
170
3,772
4,950
1,178
1,968
1,320
648
8,364
10,010
1,646
1,300
1,300
–0–
1,300
1,300
–0–
800
800
–0–
400
400
–0–
3,800
3,800
–0–
$12,164
$13,810
$1,646
As a result of this budget report, Joe 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. Joe 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 Joe. (List variable costs before fixed costs. Do not leave any answer field blank. Enter 0 for amounts.)
SORIA COMPANY
Selling Expense Flexible Budget Report
Clothing Department
For the Month Ended October 31, 2017
Difference
Budget
Actual
Favorable
Unfavorable
Neither Favorable
nor Unfavorable
SORIA COMPANY
Clothing Department
Budget Report
For the Month Ended October 31, 2017
Difference
Budget
Actual
Favorable
Unfavorable
Neither Favorable
nor Unfavorable
8,200
11,000
2,800
Favorable Variable expenses Sales commissions$1,804
$2,750
$946
Unfavorable Advertising expense820
990
170
Unfavorable Travel expense3,772
4,950
1,178
Unfavorable Free samples given out1,968
1,320
648
Favorable Total variable8,364
10,010
1,646
Unfavorable Fixed expenses Rent1,300
1,300
–0–
Neither Favorable nor Unfavorable Sales salaries1,300
1,300
–0–
Neither Favorable nor Unfavorable Office salaries800
800
–0–
Neither Favorable nor Unfavorable Depreciation—autos (sales staff)400
400
–0–
Neither Favorable nor Unfavorable Total fixed3,800
3,800
–0–
Neither Favorable nor Unfavorable Total expenses$12,164
$13,810
$1,646
UnfavorableExplanation / Answer
flexible Actual Difference budget budget Sales in units 11,000 11,000 variable expenses Sales commissions 2420 2,750 330 U Advertising expense 1100 990 110 F travel expense 5060 4,950 110 F free samples given 2640 1,320 1,320 F total variable expense 11220 10,010 1,210 F Fixed expense Rent 1,300 1,300 0 N Sales salaries 1,300 1,300 0 N office salaries 800 800 0 N Depreciation-auto 400 400 0 N total fixed expense 3,800 3,800 0 N total expense 15,020 13,810 1,210 F
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.