the number on this question arr correct i just need help with the las part and the analysis please! TIA

Mountain Sports Lld. Note bom Kek, Jhic acoountent. segmented income statement For the Year Ended Dec 31, 2021 Tisis my firu anerfat at me segmansed incorme aratemert t think its iafe to wy that ineed teip! Notes to the financial statomeats: 1. Advertising is commited to at the be ginning of the poried by management. Management has many datferent. forms of advertaing campaigns with deterent focuses as follows: 2. The company uses the straight-line method of depreciation. 3. The property taxes are set by the Cily and do not change with changes in sales velume 4. Parts and services expense varies with saies of cross country skis, mountain bikes, and acceosories. There are no parts a senice cipense for the parts 8 semice department. Ubities are the same regardiess of actuty and will not change even it a product line is dropped Interest expense is charged on the outsianding bankioans. The tolal nterest expense is 9. Income taxes are calculated for the company as a whole. The company will have to pay taxes regardiess of which product lifes it offers. Required: Part A: (25 mariss) 1) Restate the segmented incorme statement using the statement the jueior accountant prepared and the notes to the financial statements (Chapter 7 Appendix) cbeck foures bave been provided to ensere you are on the right track. If you are not arriving at the check tigures, please discuss with your aroug members to tetermine where you went wrongl see the word docament provided to yoar aroap containing the check figurest. Notes: The percentage column should be taken as a percentage of ates ifor example, cost of goods sold on for mountain bike s should be taken as a we of mountain bele tales) There may be small rounding differences where lotal amounts are off by 51 , that is obl Make sure you are using futi Excel functionality and entering formulas into ach cell, You cannot use your caiculator and input the fnal answer. 2. Which product line does the best job of turnieg sales iato pronts? (hint: see "sEG" questions in chapter 7 workbook) Mountain Elies. 3. Management has been trying to decide if any departments should be closed. Based on the segmented income statement you prepared, what are your recommendations to management? Which (if any) department should be closed? None 4. Masagement had beea coasidering closing the Parts \& Service Deportment based on the seamented income statement that the jubior accountant prepared. If this segmeat were closed, managemeat estimates that sales for both Cross Country Skis and Mountain Bikes will decrease isee percentage below). Calculate the overal decrease in iacome to the company as a whole if the parts \& service department is closed. 3. Management has been trying to decide if any departments should be closed. Based on the segmented income statement you prepared. what are your recommendations to management? Which (if any) department should be closed? None 4. Management had been considering closing the Parts \& Service Department based on the segmented income statement that the junior accountant prepared. If this segment vere closed. management estimates that sales for both Cross Country Skis and Mountain Bikes vill deerease (see percentage belov). Calculate the overall decrease in income to the company as a wole if the parts \& service department is closed. Shov all amounts as positive numbers: 5. Based on both quantitative and qualitative analysis, should the Parts \& Service Department be closed? Explain to management in a vay that they can understand. Be sure to use your answer from the previous part in your response. Do not give testbook ansvers, use question data! [2 marks] 6. Please vrite a brief memo to the junior accountant explaining the changes you made to the segmented income statement. It would be helpful to explain items you've included in your statement that Kelly did not, especially since they struggled vith traceable and common fixed costs. Iextbook definitions will not be axarded marks. Please use question data and your own vords. Even though the junior accountant has some accounting background, the ovners do not. As such, please ensure you vrite explanations in a way that both the junior aocountant and the ovners can understand. This must be vritten in a professional, business tone. (5 marks) Mountain Sports Lld. Note bom Kek, Jhic acoountent. segmented income statement For the Year Ended Dec 31, 2021 Tisis my firu anerfat at me segmansed incorme aratemert t think its iafe to wy that ineed teip! Notes to the financial statomeats: 1. Advertising is commited to at the be ginning of the poried by management. Management has many datferent. forms of advertaing campaigns with deterent focuses as follows: 2. The company uses the straight-line method of depreciation. 3. The property taxes are set by the Cily and do not change with changes in sales velume 4. Parts and services expense varies with saies of cross country skis, mountain bikes, and acceosories. There are no parts a senice cipense for the parts 8 semice department. Ubities are the same regardiess of actuty and will not change even it a product line is dropped Interest expense is charged on the outsianding bankioans. The tolal nterest expense is 9. Income taxes are calculated for the company as a whole. The company will have to pay taxes regardiess of which product lifes it offers. Required: Part A: (25 mariss) 1) Restate the segmented incorme statement using the statement the jueior accountant prepared and the notes to the financial statements (Chapter 7 Appendix) cbeck foures bave been provided to ensere you are on the right track. If you are not arriving at the check tigures, please discuss with your aroug members to tetermine where you went wrongl see the word docament provided to yoar aroap containing the check figurest. Notes: The percentage column should be taken as a percentage of ates ifor example, cost of goods sold on for mountain bike s should be taken as a we of mountain bele tales) There may be small rounding differences where lotal amounts are off by 51 , that is obl Make sure you are using futi Excel functionality and entering formulas into ach cell, You cannot use your caiculator and input the fnal answer. 2. Which product line does the best job of turnieg sales iato pronts? (hint: see "sEG" questions in chapter 7 workbook) Mountain Elies. 3. Management has been trying to decide if any departments should be closed. Based on the segmented income statement you prepared, what are your recommendations to management? Which (if any) department should be closed? None 4. Masagement had beea coasidering closing the Parts \& Service Deportment based on the seamented income statement that the jubior accountant prepared. If this segmeat were closed, managemeat estimates that sales for both Cross Country Skis and Mountain Bikes will decrease isee percentage below). Calculate the overal decrease in iacome to the company as a whole if the parts \& service department is closed. 3. Management has been trying to decide if any departments should be closed. Based on the segmented income statement you prepared. what are your recommendations to management? Which (if any) department should be closed? None 4. Management had been considering closing the Parts \& Service Department based on the segmented income statement that the junior accountant prepared. If this segment vere closed. management estimates that sales for both Cross Country Skis and Mountain Bikes vill deerease (see percentage belov). Calculate the overall decrease in income to the company as a wole if the parts \& service department is closed. Shov all amounts as positive numbers: 5. Based on both quantitative and qualitative analysis, should the Parts \& Service Department be closed? Explain to management in a vay that they can understand. Be sure to use your answer from the previous part in your response. Do not give testbook ansvers, use question data! [2 marks] 6. Please vrite a brief memo to the junior accountant explaining the changes you made to the segmented income statement. It would be helpful to explain items you've included in your statement that Kelly did not, especially since they struggled vith traceable and common fixed costs. Iextbook definitions will not be axarded marks. Please use question data and your own vords. Even though the junior accountant has some accounting background, the ovners do not. As such, please ensure you vrite explanations in a way that both the junior aocountant and the ovners can understand. This must be vritten in a professional, business tone