ASAP. Please answer it correctly and in Excel

Weller Industries is a decentralized organization with six divisions. The company's Electrical Division produces a variety of electrical items, including an X52 electrical fitting. The Electrical Division (which is operating at capacity) sells this fitting to its regular customers for $8.70 each; the fitting has a variable manufacturing cost of $4.80. The company's Brake Division has asked the Electrical Division to supply it with a large quantity of X52 fittings for only $6.70 each. The Brake Division, which is operating at 50% of capacity, will put the fitting into a brake unit that it will produce and sell to a large commercial airline manufacturer. The cost of the brake unit being built by the Brake Division follows: Purchased parts (from outside vendors) Electrical fitting X52 Other variable costs Fixed overhead and administration Total cost per brake unit $ 23.80 6.70 14.53 8.60 $ 53.63 Although the $6.70 price for the X52 fitting represents a substantial discount from the regular $8.70 price, the manager of the Brake Division believes the price concession is necessary if his division is to get the contract for the alrplane brake units. He has heard "through the grapevine that the airplane manufacturer plans to reject his bid if it is more than $55 per brake unit. Thus, if the Brake Division is forced to pay the regular $8.70 price for the X52 fitting, it will either not get the contract or it will suffer a substantial loss at a time when it is already operating at only 50% of capacity. The manager of the Brake Division argues that the price concession is Imperative to the well-being of both his division and the company as a whole. Weller Industries uses return on Investment (ROI) to measure divisional performance. Required: 1. Assume that you are the manager of the Electrical Division. a. What is the lowest acceptable transfer price for the Electrical Division? b. Would you supply the X52 fitting to the Brake Division for $6.70 each as requested? 2. Assuming the airplane brakes can be sold for $55, what is the financial advantage (disadvantage) for the company as a whole on a per unit basis) if the Electrical Division supplies fittings to the Brake Division? 3. In principle, within what range would the transfer price lie? (For all requirements, enter your "Financial Disadvantage" amounts as a negative value and round your final answers to 2 decimal places.) 1a. Lowest acceptable transfer price 16. Would you supply the X52 fitting to the Brake Division for $6.70 each as requested? 2. Financial advantage (disadvantage) on a per unit basis 3. Range of transfer price