Hello,

I need to create a worksheet that estimates the total amount of cash that will be needed to spend over the next 6 years for 10 production facilities accumulated.

There is a core piece of equipment that needs to be replaced after 100 000 units. however it will need spare parts at 25 000, 50 000 and 75 000 units. Therefore a cost will occur after these number of units.

Input should be:
Annual forecast for each prod. facility along with cost for replacement part.
Besides this there should be a starting value for each prod. fac. (plant 100 is at 13000 units for example)

How do I approach this problem and what would be a suitable way of presenting the output? Has someone done something similar and wants to share it?

I appreciate your help. Im sitting here feeling pretty stupid cause this would be an easy thing but I don't know where to start. My issue is how to distribute the costs over the years based on the forecast numbers entered.

Thank you very much
/Fredrik