please help with parts 2-4 of this one long question. thank you

Donovan Davidson, majority stockholder and present of Davidson, Inc., is working with his top managers on future plans for the company. As a company is managerial accountant, you've been asked to analyze the following situations and make recommendations to the management team. For the Year December als Cold Variat Tea Costa 5 Donec Duration 1. COM261 Data Table 1 Answer 1 of 1 Done 1. a) Target full product cost: Revenue at competitor's price (Market price) (54.25. 460,000) = $1,955,000 Less: Desired profit ($4,700,000 6%) = ($282.000) Target full product cost $1,673,000 b) Total current product cost: Variable cost (460,000 $1.90) $874,000 Add: Fixed cost $808.000 $1,682,000 As the current full product cost is higher than target full product cost, Division A will not be able to achieve its target profit (as the profit will decrease). c) Target full product cost $1,673,000 Less: Variable cost (460,000 $175) (5805,000) Target fixed cost $868,000 If Division A reduces its variable cost per unit to $175, the target fixed cost should be $868,000 to achieve target profit. As the current fixed cost is $808,000 which is lower than target fixed cost Division A can achieve its target profit by reducing variable cost to $1.75 per unit. d) Cost plus pricing: Variable cost (460,000 $175) $805,000 Add: Fixed cost ($808,000 + $80,000) $888,000 Full product cost $1,693,000 Add: Desired profit (target profit) $282.000 Cost plus price $1,975,000 Number of units 460,000 Unit cost plus price $4.29 Cost plus price ($4.29 per unit) is higher than market price ($4.25 per unit). Division A can sell its product at $4.29 per unit, it advertising campaign works and effective. If division A offers better quality products than the products of its competitors, it can sell its product at $4.29 per unit as consumers will get better quality products. However, if division A continues to produce same quality products as of its competitors, it will not be able to sell its product at cost plus price. 2. The division manager of Division B received the following operating income data for the past year Click the icon to view the Division B operating income data) 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 $78,000 and decrease fixed selling and administrative expenses by 58,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 Davidson is expanding the plant and needs to decide which product line to emphasize to make this decision, the division accountant assembled the following data Click the icon to view the Division product data) After expansion, the factory will have a production capacity of 4,000 machine hours per month The plant can manufacture either 28 units of 7075 or 45 units of G582s per machine hour a. Identify the constraining factor for Division C b. Prepare an analysin to show which product line to emphasizo 4. Division D is considering two possible expansion plans Plan A would expand a current product line at a cost of $8,700,000. Expected annual net cash inflows are $1,550,000 with zero residual value at the end of 10 years. Under Plan B. Division would begin producing a new product at a cost of $8,250.000 This plan is expected to generate net cash inflows of $1,090,000 per year for 10 years, 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 10% 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 Davidson's top management team for the best plan which expansion plan should Division D choose? Why? Division B of Davidson, Inc. Income Statement For the Year Ended December 31, 2018 Product Line T205 B179 Total $ 340,000 $ 420,000 $ 760,000 Net Sales Revenue Cost of Goods Sold: Variable 40,000 280,000 48,000 64,000 88,000 344,000 Fixed 320,000 112,000 432,000 20.000 308,000 328.000 Total Cost of Goods Sold Gross Profit Selling and Administrative Expenses Variable 67,000 55,000 79.000 26,000 146,000 81.000 Fixed 122,000 105,000 227.000 Total Selling and Administrative Expenses $ (102,000) 5 203,000 $ 101,000 Operating Income (Loss) Question 1, COMP26-1 (... Part 1 of 23 Data Table Per Unit K707 G582 $ 78 $ e variable costs of its product line are $1 came quality, to retailers for $4 25 each 52 15 28 Sales price Variable costs Contribution margin Contribution margin ratio $ 50 $ 37 64.1% 71,2% ew target fixed cost? Will this decrease duct from its competitors. The division de In spend Sonnnn neyt var to adortid 1. Division A of Davidson Inc has 54,700,000 in assets. Its yearly fixed costs are 5808,000, and the variable costs of its product line are $1.90 per unit. The division's volume is currently 460.000 units Competitors offer a similar product, at the same quality, to retailers for 54.25 each Davidson's management team wants to earn a 6% 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 Ahas identified ways to cut its variable costs to S1/6 per unit. What is its new target fixed cost? Will this decrease in variable costs allow the division to achieve ita 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 $80,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, Click the icon to view the Division B operating income data) 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 $78,000 and decrease fixed selling and administrative expenses by 58,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 Calso produces two product lines. Because the division can sell all of the product it can produce, Davidson is expanding the plant and needs to decide which product line to emphasize to make this decision, the division accountant assembled the following data Click the icon to view the Division C product data) After expansion, the factory will have a production capacity of 4.000 machine hours per month The plant can manufacture either 28 units of K707s or 45 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 58 700,000 Expected annual net cash inflows are 51,550,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 250,000 This plan is expected to generate net cash inflows of $1,090 000 per year for 10 years, 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 10% 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 Davidson's top management team for the best plan which expansion plan should Division D choose? Why