1. A certain company has found that is total sales volume vones directly and significantly with the number of salespeople has on flied. Its cost of goods sold does not vary significantly with increase in sales, but hoids steady a 65% of sales. Al company sales personnel receive a straight salary of birt 20.000 annually per person) and in addition are paid commission of 5% on sales volume they generate. In addition, each salesperson receives a travel and expense allowance of birt 12,000 per year, that bir 1,000 per month. The company now has fifteen people on its salesforce and wants to determine the optimal see of salesforce. The company determined that for each additional salesperson the annual sales volume per salesperson decreases by birr 50,000. Assuming the annul sales volume of fifteenth salesperson is bir 300.000 determine the optimal number of additional salespeople needed using incremental method 2. You are required to develop the budget for your sales district for the first son of 2021. Assume sales in June 2020 which consists of 20% of the annual sales were in 900.000 Month Share of total acasales volumes 10 September 12 October 11 November 9 December 14 Selling costs are planned at 5 percent of sales, sales commission at percent of sales branch office expenses are budgeted at bier 50,000 for the period and travel and entertainment expenses are ber 500 per week for each of the sales people, Money Salary of each salesperson is birt 30,000. the average marks ups percent of selling price, what is the budgeted profit contribution for the first seal of 2021 Assuming that the sales will be the same rate as last one? (For moich you can assume that a year has 52 weeks). 3. The owner of a business unit is concerned about the sales behavior of his product. She realize that there are many factors that may explain sales, but believes that advertising and price are the major determinants. He has collected the flowing de Sales (unit sold) 4473 2 92 35 Advertising (no. of ads) 6 11 20 Price(bir) 30 80 60 900 a) Calculate the regression equation to predict sales from advertising and price b) What sales would you predict of advertising is 20 and prices 100 4. A Computer Co. has six territories, each represented by one salesperson the extensive planning, the company determines that each territory would be expected to achieve the following percentages of total company sales for 2011 Company Sales Territory Term Territory 16 Territory 19 Territory 12 E Temery 6 These figures are used as the standard for comparing each sales representatives actual 2021 sales. The company projected sales for 2021 of $25,800,000 Required: Determine which sales representative's territory had the best performance by using the performance Index, if the actual sales for 2021 in each territory were $5,400,000 $3,200,000 $3,800,000, $2,500,000, S4,900,000, and $4,000,000, respectively 1. A certain company has found that is total sales volume vones directly and significantly with the number of salespeople has on flied. Its cost of goods sold does not vary significantly with increase in sales, but hoids steady a 65% of sales. Al company sales personnel receive a straight salary of birt 20.000 annually per person) and in addition are paid commission of 5% on sales volume they generate. In addition, each salesperson receives a travel and expense allowance of birt 12,000 per year, that bir 1,000 per month. The company now has fifteen people on its salesforce and wants to determine the optimal see of salesforce. The company determined that for each additional salesperson the annual sales volume per salesperson decreases by birr 50,000. Assuming the annul sales volume of fifteenth salesperson is bir 300.000 determine the optimal number of additional salespeople needed using incremental method 2. You are required to develop the budget for your sales district for the first son of 2021. Assume sales in June 2020 which consists of 20% of the annual sales were in 900.000 Month Share of total acasales volumes 10 September 12 October 11 November 9 December 14 Selling costs are planned at 5 percent of sales, sales commission at percent of sales branch office expenses are budgeted at bier 50,000 for the period and travel and entertainment expenses are ber 500 per week for each of the sales people, Money Salary of each salesperson is birt 30,000. the average marks ups percent of selling price, what is the budgeted profit contribution for the first seal of 2021 Assuming that the sales will be the same rate as last one? (For moich you can assume that a year has 52 weeks). 3. The owner of a business unit is concerned about the sales behavior of his product. She realize that there are many factors that may explain sales, but believes that advertising and price are the major determinants. He has collected the flowing de Sales (unit sold) 4473 2 92 35 Advertising (no. of ads) 6 11 20 Price(bir) 30 80 60 900 a) Calculate the regression equation to predict sales from advertising and price b) What sales would you predict of advertising is 20 and prices 100 4. A Computer Co. has six territories, each represented by one salesperson the extensive planning, the company determines that each territory would be expected to achieve the following percentages of total company sales for 2011 Company Sales Territory Term Territory 16 Territory 19 Territory 12 E Temery 6 These figures are used as the standard for comparing each sales representatives actual 2021 sales. The company projected sales for 2021 of $25,800,000 Required: Determine which sales representative's territory had the best performance by using the performance Index, if the actual sales for 2021 in each territory were $5,400,000 $3,200,000 $3,800,000, $2,500,000, S4,900,000, and $4,000,000, respectively
