IrishHawg09
New Member
- Joined
- Sep 9, 2014
- Messages
- 16
Hi,
I'm working on a financial model, and I need to be able to forecast the purchase of equipment, based on rising levels of sales. For instance, we will initially need to replace the molds after production reaches 200,000 units (and then replace the molds once each additional 200,000). This will go on until year 3, where we will instead replace the molds every 800,000 units produced, and replace at the next 800,000 threshold, and so on, until infinity. I've tried using various IF statements, but can't seem to crack it. I have my monthly production totaling in a row called "Lifetime Production", which just keeps a running total of all produced units.
In a nutshell, I need to replace in years 1 & 2 at 200,000 units, and in years 3 and after at 800,000 units.
Thanks!
I'm working on a financial model, and I need to be able to forecast the purchase of equipment, based on rising levels of sales. For instance, we will initially need to replace the molds after production reaches 200,000 units (and then replace the molds once each additional 200,000). This will go on until year 3, where we will instead replace the molds every 800,000 units produced, and replace at the next 800,000 threshold, and so on, until infinity. I've tried using various IF statements, but can't seem to crack it. I have my monthly production totaling in a row called "Lifetime Production", which just keeps a running total of all produced units.
In a nutshell, I need to replace in years 1 & 2 at 200,000 units, and in years 3 and after at 800,000 units.
Thanks!