d (1-3); please show work.

Once 1 2 3 Exhibit 6-10 Midwest Office Products: Five Orders 4 5 $610 500 1 56.100 5.000 10 10 56.100 5,000 10 10 Price Acquisition cost Number of cartons in order Number of cartons shipped commercially Desktop delivery time thours) Manual order Number of line items in order Electronic order Payment period (months) Source: Robert S. Kaplan $634 500 1 D 4 Yes 1 No 4 56.340 5,000 10 0 4 Yes 10 No 4 No 1 Yes 1 No 10 Yes 1 Yes 10 No 4 Bo Bused on the interviews and the data in the case, estimate the following Required (1) The cost of processing cartons through the facility 4 (2) The cost of entering electronic and manual customer orders o.1x35=3.5 (3) The cost of shipping cartons on commercial carriers 6 (4) The cost per hour for desktop deliveries. Outs (b) Using this capacity cost rate information, calculate the cost and profitability of the five orders in Exhibit 6-10. What explains the variation in profitability across the five orders? (0) On the basis of your analysis, what actions should John Malone take to improve Midwest's profitability? Include suggestions for managing customer profitability, (d) Suppose that currently, Midwest processes 40,000 manual orders per year, with a total of 200,000 line items entered, and 30,000 electronic orders. (1) How much unused practical capacity does the company have? (2) If the company's efforts to encourage customers who order manually to change to electronic ordering results in 20,000 manual orders per year (100,000 line items entered) and 50,000 electronic orders, how many order entry operators will the company require? If order entry resource costs can be reduced in proportion to the number of employees, what will be the cost savings from the changes? (3) Returning to the original information in part d, if the company's process improvement efforts result in a 20% reduction in time to perform each of the three order entry activities how many order entry operators will the company require? If order entry resource costs can be reduced in proportion to the number of employees, what will be the cost savings from the process improvements? 4000x One Lood 200,000 XD 175 = 15,00 30,30* * - 3000 Chapter 6 Measuring and Managing Customer Relationships 251 Once 1 2 3 Exhibit 6-10 Midwest Office Products: Five Orders 4 5 $610 500 1 56.100 5.000 10 10 56.100 5,000 10 10 Price Acquisition cost Number of cartons in order Number of cartons shipped commercially Desktop delivery time thours) Manual order Number of line items in order Electronic order Payment period (months) Source: Robert S. Kaplan $634 500 1 D 4 Yes 1 No 4 56.340 5,000 10 0 4 Yes 10 No 4 No 1 Yes 1 No 10 Yes 1 Yes 10 No 4 Bo Bused on the interviews and the data in the case, estimate the following Required (1) The cost of processing cartons through the facility 4 (2) The cost of entering electronic and manual customer orders o.1x35=3.5 (3) The cost of shipping cartons on commercial carriers 6 (4) The cost per hour for desktop deliveries. Outs (b) Using this capacity cost rate information, calculate the cost and profitability of the five orders in Exhibit 6-10. What explains the variation in profitability across the five orders? (0) On the basis of your analysis, what actions should John Malone take to improve Midwest's profitability? Include suggestions for managing customer profitability, (d) Suppose that currently, Midwest processes 40,000 manual orders per year, with a total of 200,000 line items entered, and 30,000 electronic orders. (1) How much unused practical capacity does the company have? (2) If the company's efforts to encourage customers who order manually to change to electronic ordering results in 20,000 manual orders per year (100,000 line items entered) and 50,000 electronic orders, how many order entry operators will the company require? If order entry resource costs can be reduced in proportion to the number of employees, what will be the cost savings from the changes? (3) Returning to the original information in part d, if the company's process improvement efforts result in a 20% reduction in time to perform each of the three order entry activities how many order entry operators will the company require? If order entry resource costs can be reduced in proportion to the number of employees, what will be the cost savings from the process improvements? 4000x One Lood 200,000 XD 175 = 15,00 30,30* * - 3000 Chapter 6 Measuring and Managing Customer Relationships 251