Here is the problem: Lim Company wants you to prepare a flexible budget for selling and administrative expenses. The general manager and the sales manager have met with all the department heads, who provided the following information regarding selling and administrative expenses: The company employs 30 full-time junior salespersons with a base salary of $3,600 each per month plus commissions, and 10 full-time senior salespersons with a salary of $6,000 each per month plus commissions. In addition, the company employs nine regional sales managers with a salary of $21,600 per month, none of whom is entitled to any commissions. If the sales volume exceeds $65 million per year, the company must hire 2. four more junior salespersons, each at a salary of $3,600 per month plus commissions. Sales commissions are either 10% or 5% of the selling price, depending 3. on the product sold. Typically a 10% commission applies on 60% of sales, and a 5% commission applies on the remaining sales. Salespersons' travel allowances average $1,500 per month per 4. salesperson (excluding managers). 5. Advertising expenses average $150,000 per month plus 3% of sales. 6. Selling supplies expense is estimated at 1% of sales. 7. Administrative salaries are $300,000 per month. 8. 4 Additional administrative expenses include the following: Rent-$48,000 per month Office supplies--2% of sales Other--$12,000 per month Required: Prepare an annual flexible budget for selling and administrative expenses for annual sa volume of $40 million, $50 million, $60 million, and $70 million. 4 A D Lim Company Annual Flexible Budget for Selling and Administrative Expenses G H 6 7 8 9 10 Sales Volume $10,000,000 $50,000,000 $60,000,000 $ 70,000,000 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Selling expenses: Fixed sales salaries: Junior salespersons Senior salespersons Regional managers Totalfixed sales salaries Sales commissions Travel allowances Advertising expense Selling supplies expense Total selling expense Administrative expenses Salaries expense Rent Office supplies Other Total administrative expense Total selling and administrative expense Sheet1