Choco Corp. has two divisions: Roaster Division and Chocolatier Division. Both are profit centers, where divisional managers are evaluated on divisional income. For many years, the manager of the Roaster department has been envious of the Chocolatier Division's profit. The Roaster Division processes the harvested cocao beans and transfers them to the Chocolatier Division The manager of the Roaster department decla red, "Their profit is five times mine, and they wouldn't have any profit if they didn't use my cocoa beans. Can we share in the profit more equally?" You have decided to examine the transfer pricing arrangement currently in effect in order to identify a transfer price that may be agreeable to the two divisional managers. Instruetions There are four parts to this problem. Use Excel to perform the following. a. Prepare comparative contribution margin income statements for the two divisions that reflect the current price at which Roaster transfers units to Chocolatier. Calculate the operating income difference between the two divisions. b. Copy and paste your income comparative income statements from part a into the part b space. Use Excel's Solver tool ar trial and error to determine the transfer price that results in both divisions generating the same contribution margin. c. Create two stacked column charts that illustrate sales, variable costs, and contribution margin, Part B Work: Part CChart (B) chart legend, axes labels, and properly formatted axes in the chart. d. Explain what you leam from the two charts. Will the two division managers be pleased with the changed transfer price? Part D Discilssion Choco Corp. has two divisions: Roaster Division and Chocolatier Division. Both are profit centers, where divisional managers are evaluated on divisional income. For many years, the manager of the Roaster department has been envious of the Chocolatier Division's profit. The Roaster Division processes the harvested cocao beans and transfers them to the Chocolatier Division The manager of the Roaster department decla red, "Their profit is five times mine, and they wouldn't have any profit if they didn't use my cocoa beans. Can we share in the profit more equally?" You have decided to examine the transfer pricing arrangement currently in effect in order to identify a transfer price that may be agreeable to the two divisional managers. Instruetions There are four parts to this problem. Use Excel to perform the following. a. Prepare comparative contribution margin income statements for the two divisions that reflect the current price at which Roaster transfers units to Chocolatier. Calculate the operating income difference between the two divisions. b. Copy and paste your income comparative income statements from part a into the part b space. Use Excel's Solver tool ar trial and error to determine the transfer price that results in both divisions generating the same contribution margin. c. Create two stacked column charts that illustrate sales, variable costs, and contribution margin, Part B Work: Part CChart (B) chart legend, axes labels, and properly formatted axes in the chart. d. Explain what you leam from the two charts. Will the two division managers be pleased with the changed transfer price? Part D Discilssion