Please help me answer question 1.a,b,c

Exercise 3. ComfyCycle Inc. (27 points) Please, download Excel file "SMCS_Exercise_3.xlax" and conduct your calculations there. Please name the Excel file with your solutions as "SMCS_Exercise _3_youridnumber.xlex" and upload it. You do not have to show calculations in the boxes below the questions. ComfyCycle Inc. produces seat cushions for high-end bicycles. The company is made up of two divisions. Division Padding produces the padding for the seat cushions while Division Cover produces seat covers and sells the complete seat cushions to customers. One seat cushion requires one padding and one cover. The paddings are the main selling point of the seat cushions, due to their new and patented foam technology. Many outside manufacturers are trying to buy the paddings from the company to produce their own bicycle seats. But the final product of ComfyCycle, the seat cushions, are also very sought after by high-end bicycle manufacturers. The company cannot catch up with the demand for both. Production capacities, costs, and market price are listed below. Table 2. Operating data Operating data Division Padding Division Cover Expected market demand [unit] 300,000 200,000 Market price [( per unit] 60 100 Variable costs [( per unit] 30 20 (without paddings) Production capacity [units] 200,000 200,000 1. Up to now, the CEO decided himself what the transfer price between the two divisions is. In order to implement a more objective process, he decided that this year the divisions should use the general transfer pricing rule. (12 points) a. What amount will Division Cover pay to Division Padding to acquire the paddings it needs for the production of seats? Calculate the amount using the minimum transfer price! (4 points)b. In the second year, Division Padding increases its production capacity to 350.000 paddings. Everything else remains the same as described in table 2. Calculate the amount Division Cover will have to pay to Division Padding! (4 points) (Hint: Use the minimum transfer price again.) Open the Excel file and do your calculations there. c. Both division managers' performance is evaluated solely based on the profit of their division. Top management is now considering to let the managers negotiate transfer prices. How will the performance measure and single- supplier setting alleviate or accentuate concerns of transfer price negotiations? Briefly elaborate your answer. (4 points)Exercise 3.1 (13 points) Table 2. Operating data 4 Operating data Division Padding Division Cover Expected market demand [unit] 300,000 200,000 Market price [( per unit] 60 100 7 Variable costs [( per unit] 30 20 (without paddings) Production capacity [units] 200,000 200,000 g 10 1 Question A. 2 Transfer Price Quantity Partial Sum 3 5 Total 6 7 8 Question B. 9 Transfer Price Quantity Partial Sum 20 22 Total 23