Question

Cellular First

The sales department of a cellular phone company pays its salespeople $1,500 per month plus 25 percent of each new subscriber's first month's billings. A new subscriber's first-month bill average $80. Sales people work 160 hours a month (four weeks at 40 hours per week). If salespeople work more than 160 hours per month, they receive $12 per hour for hours in excess of 160.

Sales leads for the sales department are generated in a variety of ways-- direct mailings to potential customers who then call to speak to a salesperson, lists of prospective customers purchases from outside marketing firms, and so forth. the manager of the sales department reviews potential leads and assigns them to particular salespeople who contact them. The manager of the sales department is expected to oversee the time spect by each sales person per assigned lead and to approve overtime requests to work beyond the 40 hours per week. Each new customer added requires, on average, 2 hours of salesperson time to make the sale.

Last month, the sales department was dudgeted for eight full-time salespeople. However, because of a new ad campaign, an additional salesperson was hired and over time was approved, bringing actual hours worked up to 1,580. The department added 725 new customers.

A. Prepare a performance report comparing actual performance to budgeted performance using a static budget based on eight salespeople and no budgeted overtime.

B. Prepare a performance report comparing actual performance to budgeted performance using a flexible budget based on nice salespeople selling 725 new accounts.

C. Discuss when you would expect to see the report prepared in part (a) used and when your would expect to see the report in part (b) used.

Answer 1