S9-2 Evaluating Managerial Performance by Comparing Actual to Budgeted Results LO 9-1,9-2 Suppose Acore Pharmaceuticals has four sales representatives assigned to the state of Arizona. These sales reps are responsible for visiting physicians in their assigned area, introducing the company's current or upcoming products, providing samples, getting feedback about the products, and generating sales. Each sales rep is given an expense budget that includes samples of Acore's products, travel expenses related to the company vehicle that Acore provides, and entertainment expenses such as buying meals or hosting small "meet and greet" receptions. The following table includes both budgeted and actual amounts for each sales rep for the first half of the current year. As you can see, each was allotted the same amount of resources and expected to generate the same amount of sales for the six-month period. Samples Travel Entertainment Sales Sales Rep Budget Actual Budget Actual Budget Actual Budget Actual Terry $7,200 $4,200 $18,000 $28,000 $4,800 $1,900 $90,000 $ 78,000 Maria 7,200 15.500 18,000. 12,000 4,800 9.900 90,000 130,000 Samantha 7,200 2,900 18,000 18,000 4,800 4,600 90,000 43,000 Abraham 7,200 5,300 18.000 16.200 4,800 4,500 90,000 92,000 Required: 1. Calculate the expense and sales variances for each rep. Evaluate each of them and rank them in order of performance. Explain your rationale for these rankings. Suppose $100,000 in bonuses is available to be split among these sales reps. How would you allocate the money to them? 2. Now suppose that you find additional information about the territories to which Acore's Arizona reps are assigned. (If you're not familiar with Arizona, you can find a map at www.mapofarizona.net.) Samantha 7.200 2,900 18.000 18,000 4,800 4,600 90,000 43,000 : Abraham 7,200 5,300 18.000 16,200 4.800 4.500 90,000 92,000 Required: 1. Calculate the expense and sales variances for each rep. Evaluate each of them and rank them in order of performance. Explain your rationale for these rankings. Suppose $100,000 in bonuses is available to be split among these sales reps. How would you allocate the money to them? 2. Now suppose that you find additional information about the territories to which Acore's Arizona reps are assigned. (If you're not familiar with Arizona, you can find a map at www.mapofarizona.net.) Terry has the northern Arizona territory that includes everything north of Phoenix between the California and New Mexico borders. This territory encompasses a large amount of Native American reservation land as well as the Grand Canyon National Park. Flagstaff is the largest city in the territory. . Maria has the Phoenix area that includes the Phoenix metropolitan area and all suburbs (Glendale, Scottsdale, Mesa, and Sun City). Samantha's Southwestern Arizona territory includes all areas south and west of Phoenix. Yuma is the largest city in this region. Abraham's southeastern Arizona area includes everything south and east of Phoenix. Tucson is included in this territory. Does this new information change your evaluation of Acore's Arizona sales reps? If so, how? Does your allocation of the bonus money change as a result of the additional information? If so, explain how. 3. Do you need any other information to evaluate these employees' performances for the first half of the year? 4. What, if any, adjustments would you make to the budgets for the remainder of the year? 5. Do you think that Acore's policy of allocating the same amount of expenses and expected sales to the four sales reps is adequate? What factors would you use in setting budgets for next year