Please use excel and add formulas if possible.

Provo Consolidated Resources Company (PCRC) has several divisions. However, only two divisibong transfer products to other divisions. The Mining Division refines toldine, which is then transferred to the Metals Division. The toldine is processed into an alloy by the Metals Division, and the alloy is sold io customers at a price of $150 per unit. The Mining division is currently required by PCRC to transfer it total yearly output of 400.000 units of toldine to the Metals Division at total actual manufacturing con plus 10 percent. Unlimited quantities of toldine can be purchased and sold on the open market at $90 pe unit. While the Mining Division could sell all the toldine it produces at $90 per unit on the open marke, it would incur a variable selling cost of $5 per unit. Brian Jones, manager of the Mining Division, is unhappy with having to transfer the entire output of toldine to the Metals Division at 110 percent of cost. In a meeting with the management of Prowa, he said, "Why should my division be required to sell toldine to the Metals Division at less than market price? For the year just ended in May, Metals' contribution margin was over $19 million on sales of 400,000 units, while Mining's contribution was just over $5 million on the transfer of the same number of units. My division is subsidizing the profitability of the Metals Division. Werals Division." The following table shows the detailed unit cost structure for both the Mining and Metals divisions during the most recent year. 'Manufacturing-overhead cost in the Mining Dwision is 25 percent fixed and 75 percent variable. Manufacturing-overhead cost in the Metals Division is 60 percent fared and 40 percent variable. Required: 1. Explain why transfer prices based on total actual costs are not appropriate as the basis for divisional performance measurement. 2. Using the market price as the transfer price, determine the contribution margin for both the Mining Division and the Metals Division. 3. If Provo Consolidated Resources Company were to institute the use of negotiated transfer prices and allow divisions to buy and sell on the open market, determine the price range for toldine that would be acceptable to both the Mining Division and the Metals Division. Explain your answer. 4. Use the general transfer-pricing rule to compute the lowest transfer price that would be acceptable to the Mining Division. Is your answer consistent with your conclusion in requirement (3)? Explain. 5. Identify which one of the three types of transfer prices (cost-based, market-based, or negotiated) is most likely to elicit desirable management behavior at PCRC. Explain your answer. Provo Consolidated Resources Company (PCRC) has several divisions. However, only two divisibong transfer products to other divisions. The Mining Division refines toldine, which is then transferred to the Metals Division. The toldine is processed into an alloy by the Metals Division, and the alloy is sold io customers at a price of $150 per unit. The Mining division is currently required by PCRC to transfer it total yearly output of 400.000 units of toldine to the Metals Division at total actual manufacturing con plus 10 percent. Unlimited quantities of toldine can be purchased and sold on the open market at $90 pe unit. While the Mining Division could sell all the toldine it produces at $90 per unit on the open marke, it would incur a variable selling cost of $5 per unit. Brian Jones, manager of the Mining Division, is unhappy with having to transfer the entire output of toldine to the Metals Division at 110 percent of cost. In a meeting with the management of Prowa, he said, "Why should my division be required to sell toldine to the Metals Division at less than market price? For the year just ended in May, Metals' contribution margin was over $19 million on sales of 400,000 units, while Mining's contribution was just over $5 million on the transfer of the same number of units. My division is subsidizing the profitability of the Metals Division. Werals Division." The following table shows the detailed unit cost structure for both the Mining and Metals divisions during the most recent year. 'Manufacturing-overhead cost in the Mining Dwision is 25 percent fixed and 75 percent variable. Manufacturing-overhead cost in the Metals Division is 60 percent fared and 40 percent variable. Required: 1. Explain why transfer prices based on total actual costs are not appropriate as the basis for divisional performance measurement. 2. Using the market price as the transfer price, determine the contribution margin for both the Mining Division and the Metals Division. 3. If Provo Consolidated Resources Company were to institute the use of negotiated transfer prices and allow divisions to buy and sell on the open market, determine the price range for toldine that would be acceptable to both the Mining Division and the Metals Division. Explain your answer. 4. Use the general transfer-pricing rule to compute the lowest transfer price that would be acceptable to the Mining Division. Is your answer consistent with your conclusion in requirement (3)? Explain. 5. Identify which one of the three types of transfer prices (cost-based, market-based, or negotiated) is most likely to elicit desirable management behavior at PCRC. Explain your