1. (25 points) What managerial insights about profitability per household can you extract from Exhibit 3? 2. (20 points) a) Using ABC analysis, and the information in Exhibits 2 and 4, calculate the loss per household for the six customer profiles per Exhibit 4. Round your calculations to the nearest dollar. b) What are two specific management actions for each of the six customer profiles that would substantially improve the profitability? Calculate the impact of these actions to the nearest dollar. 3. (25 points) Noting that excess capacity is charged back to active accounts, if AIMS scaled back to 3,000,000 active households and planned only a 10% excess capacity reserve for future growth, a large proportion of cost could be eliminated. Estimate how much of total cost for 1999 could be eliminated, based on facts presented in the case. 4. (30 points) What are your overall recommendations to top management based on the customer profitability information? 1. (25 points) What managerial insights about profitability per household can you extract from Exhibit 3? 2. (20 points) a) Using ABC analysis, and the information in Exhibits 2 and 4, calculate the loss per household for the six customer profiles per Exhibit 4. Round your calculations to the nearest dollar. b) What are two specific management actions for each of the six customer profiles that would substantially improve the profitability? Calculate the impact of these actions to the nearest dollar. 3. (25 points) Noting that excess capacity is charged back to active accounts, if AIMS scaled back to 3,000,000 active households and planned only a 10% excess capacity reserve for future growth, a large proportion of cost could be eliminated. Estimate how much of total cost for 1999 could be eliminated, based on facts presented in the case. 4. (30 points) What are your overall recommendations to top management based on the customer profitability information