I need help on part 4!! I added photos of everything for better understanding of the problem but I only need question 4. Thanks!

management team Read the requirements. retailers for $4.25 each. Durant's management team wants to earn a 10% return on investment on the division's assets. 1a. What is Division A's target full product cost? 1b. Given the division's current costs, will Division A be able to achieve its target profit? Begin by calculating Division A's current full product cost. Division A's current full product costs are its target full product cost, therefore Division A be able to acheive its target profit. Begin by calculating Division A's new target fixed cost. Will this decrease in variable costs allow the company to achieve its target profit? Since the company's actual fixed costs are the new target fixed cost amount, Division A be able to achieve its target profit without having to take any other cost cutting measures. Begin by calculating the cost-plus price per unit. (Round your answer to the nearest cent.) 1. Division A of Durant, Inc. has $5,400,000 in assets. Its yearly fixed costs are $761,500, and the variable costs of its product line are $1.90 per unit. The division's volume is currently 550,000 units. Competitors offer a similar product, at the same quality, to retailers for $4.25 each. Durant's management team wants to earn a 10% return on investment on the division's assets. a. What is Division A's target full product cost? b. Given the division's current costs, will Division A be able to achieve its target profit? c. Assume Division A has identified ways to cut its variable costs to $1.75 per unit. What is its new target fixed cost? Will this decrease in variable costs allow the division to achieve its target profit? d. Division A is considering an aggressive advertising campaign strategy to differentiate its product from its competitors. The division does not expect volume to be affected, but it hopes to gain more control over pricing. If Division A has to spend $105,000 next year to advertise and its variable costs continue to be $1.75 per unit, what will its cost-plus price be? Do you think Division A will be able to sell its product at the cost-plus price? Why or why not? 2. The division manager of Division B received the following operating income data for the past year: Requirements The manager of the division is surprised that the T205 product line is not profitable. The division accountant estimates that dropping the T205 product line will decrease fixed cost of goods sold by $76,000 and decrease fixed selling and administrative expenses by $12,000. a. Prepare a differential analysis to show whether Division B should drop the T205 product line. b. What is your recommendation to the manager of Division B ? 3. Division C also produces two product lines. Because the division can sell all of the product it can produce, Durantis expanding the plant and needs to decide which product line to emphasize. To make this decision, the division accountant assembled the following data: After expansion, the factory will have a production capacity of 4,500machine hours per month. The plant can manufacture either 28 units of K707s or 58 units of G582s per machine hour. a. Identify the constraining factor for Division C. b. Prepare an analysis to show which product line to emphasize. 4. Division D is considering two possible expansion plans. Plan A would expand a current product line at a cost of $8,500,000Expected annual net cash inflows are $1,600,000 with zero residual value at the end of 10 years. Under Plan B, Division D would begin producing a new product at a cost of $8,100,000 This plan is expected to generate net cash inflows of $1,070,000 per year for 10years, the estimated useful life of the product line. Estimated residual value for Plan B is $1,300,000 Division D uses straight-line depreciation and requires an annual return of 9%. a. Compute the payback, the ARR, the NPV, and the profitability index for both plans. b. Compute the estimated IRR of Plan A. c. Use Excel to verify the NPV calculations in Requirement 4(a) and the actual IRR for the two plans. How does the IRR of each plan compare with the company's required rate of return? d. Division D must rank the plans and make a recommendation to Duranttp management team for the best plan. Which expansion plan should Division D choose? Why? 4a. Compute the payback, the ARR, the NPV, and the profitability index for both plans. Begin by calculating the payback for both plans. (Round your answers to one decimal place, X.X.) Calculate the ARR (accounting rate of return) for both plans. (Round your answers to the nearest tenth percent, X.X\%.) or a minus sign for a negative net present value.) (Click the icon to view Present Value of $1 table.) (Click the icon to view Present Value of Ordinary Annuity of $1 table.) (Click the icon to view Future Value of $1 table.) (Click the icon to view Future Value of Ordinary Annuity of $1 table.) (Click the icon to view Present Value of $1 table.) (Click the icon to view Present Value of Ordinary Annuity of $1 table.) (Click the icon to view Future Value of $1 table.) (Click the icon to view Future Value of Ordinary Annuity of $1 table.) (Click the icon to view Present Value of $1 table.) (Click the icon to view Present Value of Ordinary Annuity of $1 table.) (Click the icon to view Future Value of $1 table.) (Click the icon to view Future Value of Ordinary Annuity of $1 table.) management team Read the requirements. retailers for $4.25 each. Durant's management team wants to earn a 10% return on investment on the division's assets. 1a. What is Division A's target full product cost? 1b. Given the division's current costs, will Division A be able to achieve its target profit? Begin by calculating Division A's current full product cost. Division A's current full product costs are its target full product cost, therefore Division A be able to acheive its target profit. Begin by calculating Division A's new target fixed cost. Will this decrease in variable costs allow the company to achieve its target profit? Since the company's actual fixed costs are the new target fixed cost amount, Division A be able to achieve its target profit without having to take any other cost cutting measures. Begin by calculating the cost-plus price per unit. (Round your answer to the nearest cent.) 1. Division A of Durant, Inc. has $5,400,000 in assets. Its yearly fixed costs are $761,500, and the variable costs of its product line are $1.90 per unit. The division's volume is currently 550,000 units. Competitors offer a similar product, at the same quality, to retailers for $4.25 each. Durant's management team wants to earn a 10% return on investment on the division's assets. a. What is Division A's target full product cost? b. Given the division's current costs, will Division A be able to achieve its target profit? c. Assume Division A has identified ways to cut its variable costs to $1.75 per unit. What is its new target fixed cost? Will this decrease in variable costs allow the division to achieve its target profit? d. Division A is considering an aggressive advertising campaign strategy to differentiate its product from its competitors. The division does not expect volume to be affected, but it hopes to gain more control over pricing. If Division A has to spend $105,000 next year to advertise and its variable costs continue to be $1.75 per unit, what will its cost-plus price be? Do you think Division A will be able to sell its product at the cost-plus price? Why or why not? 2. The division manager of Division B received the following operating income data for the past year: Requirements The manager of the division is surprised that the T205 product line is not profitable. The division accountant estimates that dropping the T205 product line will decrease fixed cost of goods sold by $76,000 and decrease fixed selling and administrative expenses by $12,000. a. Prepare a differential analysis to show whether Division B should drop the T205 product line. b. What is your recommendation to the manager of Division B ? 3. Division C also produces two product lines. Because the division can sell all of the product it can produce, Durantis expanding the plant and needs to decide which product line to emphasize. To make this decision, the division accountant assembled the following data: After expansion, the factory will have a production capacity of 4,500machine hours per month. The plant can manufacture either 28 units of K707s or 58 units of G582s per machine hour. a. Identify the constraining factor for Division C. b. Prepare an analysis to show which product line to emphasize. 4. Division D is considering two possible expansion plans. Plan A would expand a current product line at a cost of $8,500,000Expected annual net cash inflows are $1,600,000 with zero residual value at the end of 10 years. Under Plan B, Division D would begin producing a new product at a cost of $8,100,000 This plan is expected to generate net cash inflows of $1,070,000 per year for 10years, the estimated useful life of the product line. Estimated residual value for Plan B is $1,300,000 Division D uses straight-line depreciation and requires an annual return of 9%. a. Compute the payback, the ARR, the NPV, and the profitability index for both plans. b. Compute the estimated IRR of Plan A. c. Use Excel to verify the NPV calculations in Requirement 4(a) and the actual IRR for the two plans. How does the IRR of each plan compare with the company's required rate of return? d. Division D must rank the plans and make a recommendation to Duranttp management team for the best plan. Which expansion plan should Division D choose? Why? 4a. Compute the payback, the ARR, the NPV, and the profitability index for both plans. Begin by calculating the payback for both plans. (Round your answers to one decimal place, X.X.) Calculate the ARR (accounting rate of return) for both plans. (Round your answers to the nearest tenth percent, X.X\%.) or a minus sign for a negative net present value.) (Click the icon to view Present Value of $1 table.) (Click the icon to view Present Value of Ordinary Annuity of $1 table.) (Click the icon to view Future Value of $1 table.) (Click the icon to view Future Value of Ordinary Annuity of $1 table.) (Click the icon to view Present Value of $1 table.) (Click the icon to view Present Value of Ordinary Annuity of $1 table.) (Click the icon to view Future Value of $1 table.) (Click the icon to view Future Value of Ordinary Annuity of $1 table.) (Click the icon to view Present Value of $1 table.) (Click the icon to view Present Value of Ordinary Annuity of $1 table.) (Click the icon to view Future Value of $1 table.) (Click the icon to view Future Value of Ordinary Annuity of $1 table.)