As sales manager, Joe Batista was given the following static budget report for s

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

SORIA COMPANY

Clothing Department

Flexible Budget Report

For the month ended October 31, 2017

Actuals Spending Variances Flexible Budget Volume Variances Static Budget Activity Level 9,000 units 9,000 units 600 F 8,400 units $ $ $ $ $ Variable Expenses Sales Commissions 2,160 360 F 2,520 168 U 2,352 Advertising Expense 720 360 F 1,080 72 U 1,008 Travel Expense 3,600 360 F 3,960 264 U 3,696 Free Samples 1,080 540 F 1,620 108 U 1,512 Total Variable Expenses 7,560 1,620 F 9,180 612 U 8,568 Fixed Expenses Rent 1,100 N 1,100 N 1,100 Sales Salaries 1,200 N 1,200 N 1,200 Office Salaries 700 N 700 N 700 Depreciation - Autos 400 N 400 N 400 Total Fixed 3,400 N 3,400 N 3,400 Total Expenses 10,960 1,620 F 12,580 612 U 11,968

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.