MA17-35. Assessing the Impact of an Incentive Plan

h. Using the information on sales and expenses for a typical store, provide an analysis of the additional store profit contributed by the plan. Assume that it costs 12% a year to carry the added inventory.

Module 17 Relevant Costs and Benefits for Decision Making are reported in Figure 1 page 17-36. Month 25 is denoted as the rollout month, the month the incen- tive plan began. Expense Analysis: You then plotted wage expense/sales, cost of goods sold/sales, and inventory turnover for the twenty stores for the 24 months preceding the plan and the first 24 months after plan implementation. After pulling out seasonal effects these monthly series are presented in Figures 2, 3 and 4. If the plan has no impact on these expenses then you would expect no dramatic change in the series around month 25. Figure 2 plots (wage expense in month t/sales in month t) Figure 3 plots (cost of goods sold in month t/sales in month t) Figure 4 plots "annual" turnover computed as (12 x cost of goods sold in month t/inventory at beginning of month t) For example, if monthly cost of sales is $100 and the annual inventory turnover ratio is 4, it suggests a monthly turnover of 0.333 with the firm holding an average inventory of $300 throughout the year. (Note that a monthly inventory turnover of .333 implies an annual turnover of 4 (from 12 x 0.333). Financial Report for Store: A typical annual income statement for a pre-plan Ladbreck store before fixed charges, taxes and incidentals looks as follows. Total Percent Sales ... . . . . ........................... 10,000,000 100 Cost of goods sold . .. . . . . . . 6,300,000 Gross profit. . . . . . . .. 3,700,000 Employee salaries. . .. . . . . . .. 800,000 Profit before fixed charges. 2,900,000 A store also has substantial charges for rent, management salaries, insurance, etc. but they are fixed with respect to the incentive plan. Exhibit 1 Wages by subset of employees in Ladbreck's fashion department Hours Actual Hourly Worked Sales Total Years of Wage in Regular for Pay Name Service Rate Quarter Pay Quarter Bonus Quarter BOB MARLEY . . . ... . . . . . . . .... 2 4.00 400 1,600 25,00 40 2,000 JIMI HENDRIX . . . .. 16 7.50 440 3,300 41,000 3,300 MILLIE SMALL. ... 24 9.99 440 4,396 40,000 O 4,396 AL GREEN. . ..... 11 6.00 400 2,40 36,000 180 2,880 BOB DYLAN . . .. . 4 5.00 100 2,000 30,000 100 2,40 JANIS JOPLIN . .. . .... 6.0 400 2,40 30,000 2,400 WILSON PICKETT .. . . . . . . . ... 16 7.50 440 3,300 50,000 700 4,000 BRUCE SPRINGSTEEN. .. 23 9.99 440 4,396 30,000 4,396 MICHIGAN & SMILEY... ... . . . 13 7.00 400 2.800 38,000 240 3,040 RICHIE FURAY... 22 9.90 400 3,960 30,000 3.960 JOHN LENNON.... 5 5.00 40 2,000 34,000 720 2,720 JULIO IGLESIAS .. 4 5.00 180 2,400 46,000 1,280 3,680 TOMMY PETTY .... 6.00 400 2.400 36,000 480 2,880 JOAN BAEZ . . ... 21 9.90 400 3,960 40,000 3,960 BB KING . . . . . . ... 8 6.00 400 2.400 38,000 640 3.040 GLADYS KNIGHT .... 14 8.00 480 3,840 46,000 36,000 o 3,840 NEIL YOUNG .... 15 8.00 480 3,840 3,840 BO DIDDLEY . .. 5.00 400 2,000 30,000 400 2,400 Figure 1 Figure 3 Percentage Change in Sales Cost of Goods Sold as a Percent of Sales 10- 75 - 73 - 71 - Percent change 67 - 65 - 63 - 61 - 57 - 12- 55- 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 37 39 41 43 45 47 9 11 13 15 17 19 21 23 25 27 29 31 33 35 Month (rollout month-25) Month (rollout month-25) Figure 2 Figure 4 Wage Expense as a Percent of Sales Inventory Turnover 12 Percent 35 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 37 39 41 43 45 47 Month (rollout month-25) Month (rollout month-25) MA17-35. Assessing the Impact of an Incentive Plan a. Suppose the goal of the firm is to now provide superior customer service by having the sales consultant identify and sell to the specific needs of the customer. What does this goal suggest about a change in managerial accounting and control systems? b. Provide an estimate of the impact of the incentive plan on sales. . Did the sales impact occur all at once, or did it occur gradually? d. What is the impact of the incentive plan on wage expense as a percent of sales? e. What is the impact of the incentive plan on cost of good sold as a percent of sales? f. What is the impact of incentive plan on inventory turnover (turnover = cost of goods sold : inventory)? [If sales go up then stores are selling more goods; therefore, more goods need to be on the floor or those goods on floor need to turn over faster.] g. What is the additional dollar amount of inventory that must be held? h. Using the information on sales and expenses for a typical store, provide an analysis of the additional store profit contributed by the plan. Assume that it costs 12% a year to carry the added inventory. . Look at Exhibit 1, which provides a partial listing of employee pay for one small department within a store. Which "type" of employee is receiving the bonus? j. Should the company keep the plan? Explain your estimate of the financial impact of the plan and also incorporate any nonfinancial information you feel is relevant in justifying your decision