Here is Part B:
Clark Paints: The production department has been investigating possible ways to trim total production costs. One possibility currently being examined is to make the paint cans instead of purchasing them. The equipment needed would cost $200,000 with a disposal value of $40,000 and would be able to produce 5,500,000 cans over the life of the machinery. The production department estimates that approximately 1,100,000 cans would be needed for each of the next five years.
1. Based on the above information and using Excel, calculate the following items for this proposed equipment purchase: