Sir, I would appreciate if you could do it in Excel. Thank you.

Question 5 [10 marks) Scrooge McDuck Safe Limited is considering buying the hinges it uses in the manufacture of vaults from an outside vendor. Currently, Scrooge McDuck Safe Limited makes the hinges in its own manufacturing facility. Scrooge McDuck Safe Limited can buy the hinges for $1.50 each. The company uses 900,000 hinges each year. Fixed cost for Scrooge McDuck Safe Limited would not change if the company stopped making the hinges. Information about Scrooge McDuck Safe Limited's cost to manufacture the 900,000 casters follows: Per Unit Total Direct material $.50 5450.000 Direct labor .10 90,000 Variable overhead .40 360,000 Fixed overhead A 225,000 Total $1.25 $1,125,000 Required: A. Prepare a relevant cost schedule that indicates whether Scrooge McDuck Safe Limited should buy the hinges or continue to make them. B. If Scrooge purchased the hinges, management has approached you that a dial producer wishes to rent the vacant space for $150,000 to produce their dials. Does this change your decision?? 0. Give two qualitative factors would inuence your decision and explain why they would inuence you