Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

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

Sales in units

8,400

9,000

600

Favorable Variable expenses     Sales commissions

$2,352

$2,160

$192

Favorable     Advertising expense

1,008

720

288

Favorable     Travel expense

3,696

3,600

96

Favorable     Free samples given out

1,512

1,080

432

Favorable        Total variable

8,568

7,560

1,008

Favorable Fixed expenses      Rent

1,100

1,100

–0–

Neither Favorable nor Unfavorable      Sales salaries

1,200

1,200

–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

3,400

3,400

–0–

Neither Favorable nor Unfavorable Total expenses

$11,968

$10,960

$1,008

Favorable

Explanation / 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