As sales manager, Joe Batista was given the following static budget report for s
ID: 2581093 • Letter: A
Question
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,400
9,000
600
$2,352
$2,160
$192
1,008
720
288
3,696
3,600
96
1,512
1,080
432
8,568
7,560
1,008
1,100
1,100
–0–
1,200
1,200
–0–
700
700
–0–
400
400
–0–
3,400
3,400
–0–
$11,968
$10,960
$1,008
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,400
9,000
600
Favorable Variable expenses Sales commissions$2,352
$2,160
$192
Favorable Advertising expense1,008
720
288
Favorable Travel expense3,696
3,600
96
Favorable Free samples given out1,512
1,080
432
Favorable Total variable8,568
7,560
1,008
Favorable Fixed expenses Rent1,100
1,100
–0–
Neither Favorable nor Unfavorable Sales salaries1,200
1,200
–0–
Neither Favorable nor Unfavorable Office salaries700
700
–0–
Neither Favorable nor Unfavorable Depreciation—autos (sales staff)400
400
–0–
Neither Favorable nor Unfavorable Total fixed3,400
3,400
–0–
Neither Favorable nor Unfavorable Total expenses$11,968
$10,960
$1,008
FavorableExplanation / Answer
Budget Actual Sales in units 9000 9000 Variable expenses Sales commissions 2520 2160 360 Unfavorable Advertising expense 1080 720 360 Unfavorable Travel expense 3960 3600 360 Unfavorable Free samples given out 1620 1080 540 Unfavorable Total Variable Costs 9180 7560 1620 Unfavorable Fixed expenses Rent 1100 1100 0 Neither Favorable nor Unfavorable Sales salaries 1200 1200 0 Neither Favorable nor Unfavorable Office salaries 700 700 0 Neither Favorable nor Unfavorable Depreciation—autos (sales staff) 400 400 0 Neither Favorable nor Unfavorable Total fixed costs 3400 3400 0 Neither Favorable nor Unfavorable Total expenses 12580 10960 1620 Unfavorable
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.