(Budget-to-actual comparison) Buzz Beverages evaluates performance in part through the use of flexible budgets. Selling expense budgets at three activity levels within the relevant range are shown below.

The following assumptions were used to develop the selling expense flexible budgets:
• The average size of the company’s sales force during the year was planned to be 100 people.
• Salespersons are paid a monthly salary plus commission on gross dollar sales.
• The travel costs have both a fixed and a variable element. The fixed portion is related to the number of salespersons, and the variable por¬ tion tends to fluctuate with gross dollars of sales.
® Sales office expense is a mixed cost with the variable portion related to the number of orders processed.
• Shipping expense is a mixed cost with the variable portion related to the number of units sold. (An order consists of 10 units.)

A sales force of 90 persons generated a total of 1,600 orders, resulting in a sales volume of 16,000 units during November. The gross dollar sales amounted to $14.9 million. The selling expenses incurred for November were as follows:

a. Explain why the selling expense flexible budget would not be appropri¬ ate for evaluating the company's November selling expense, and indicate how the flexible budget would have to be revised.

b. Determine the budgeted variable cost per salesperson and variable cost per sales order for the company.
C. Prepare a selling expense report for November that the company can use to evaluate its control over selling expenses. The report should have a line for each selling expense item showing the appropriate budgeted amount, the actual selling expense, and the monthly dollar variation.

d. Determine the actual variable cost per salesperson and variable cost per sales order processed for the company.

e. Comment on the effectiveness and efficiency of the salespersons during November.

Transcribed Image Text:

Activity Measures Unit sales volume 15,000 Dollar sales volume $15,000,000 17,500 $17,500,000 20,000 $20,000,000 Number of orders processed 1,500 1,750 Number of salespersons 100 100 2,000 100 Monthly Expenses Advertising and promotion $1,500,000 $1,500,000 $1,500,000 Administrative salaries 75,000 75,000 75,000 Sales salaries 90,000 90,000 90,000 Sales commissions Salesperson travel Sales office expense Shipping expense Total 450,000 525,000 600,000 200,000 225,000 250,000 445,000 452,500 460,000 650,000 675,000 700,000 $3,410,000 $3,542,500 $3,675,000