5 Exercise 24.7 Departmental contribution report LO P3 1.42 points Below are departmental Income statements for a guitar manufacturer. The manufacturer is considering eliminating its electric guitar department since it has a net loss. The company classifies advertising, rent, and utilities expenses as indirect. eBook Electric $84,400 47.250 37,150 Hire WHOLESALE GUITARS Departmental Income Statements For Year Ended December 31, 2017 Acoustic Sales $101,6ee Cost of goods sold 45,175 Gross profit 56,425 Operating expenses Advertising expense 4,975 Depreciation expense-equipment 10,138 Salaries expense 19.6ee Supplies expense 1.960 Rent expense 7,645 Utilities expense 3,015 Total operating expenses 46,725 Net income (loss) $ 9,700 Print 4,320 8,510 17,000 1,730 6,038 2,620 40, 210 $(3,6) 1. Prepare a departmental contribution report that shows each department's contribution to overhead. WHOLESALE GUITARS Income Statement Showing Departmental Contribution to Overhead For Year Ended December 31, 2017 Acoustic Dept. Electric Dept. Combined Direct expenses Total direct expenses Departmental contributions to overhead Indirect expenses Total indirect expenses 2 Based on contribution to overhead, should the electric guitar department be eliminated? O No Yes 6 Part 1 of 2 Required information Use the following information for the Exercises below. [The following information applies to the questions displayed below.] Megamart, a retailer of consumer goods, provides the following information on two of its departments (each considered an investment center). 1.42 points Investment Center Electronics Sporting goods Sales Income $41,000,000 $2,624,000 18,600,000 1,860,000 Average Invested Assets $16,400,000 12,400,000 eBook Hint Exercise 24-10 Computing return on investment and residual income; investing decision LO A1 Print 1. Compute return on investment for each department. Using return on investment, which department is most efficient at using assets to generate returns for the company? 2. Assume a target income level of 12% of average invested assets. Compute residual income for each department. Which department generated the most residual income for the company? 3. Assume the Electronics department is presented with a new investment opportunity that will yield a 15% return on investment. Should the new investment opportunity be accepted? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Compute return on investment for each department. Using return on investment, which department is most efficient at using assets to generate returns for the company? Return on Investment Choose Numerator: 1 Choose Denominator: = Return on Investment Return on Investment = Electronics Sporting Goods Which department is most efficient at using assets to generate returns for the company? Required 1 Required 2 > 7 ! Part 2 of 2 Required information Use the following information for the Exercises below. (The following information applies to the questions displayed below.] Megamart, a retailer of consumer goods, provides the following information on two of its departments (each considered an investment center). 1.48 points Investment Center Electronics Sporting goods Sales Income $41,600,000 $2,624,000 18,600,000 1,860,000 Average Invested Assets $16,400,000 12,400,000 eBook Hint Exercise 24-11 Computing margin and turnover; department efficiency LO A2 Print Compute profit margin and investment turnover for each department. Which department generates the most net income per dollar of sales? Which department is most efficient at generating sales from average invested assets? Complete this question by entering your answers in the tabs below. Profit Margin Investment Turnover Compute profit margin for each department. Which department generates the most net income per dollar of sales? Profit Margin Profit Margin Profit Margin Choose Numerator: 1 Choose Denominator: Investment 1 Center Electronics 1 Sporting Goods Which department generates the most net income per dollar of sales?