Hi everyone - greetings from Denmark!
With the amount of questions asked I will put a disclaimer up front and say that I have not - to my knowledge - found an answer to the question I am asking here. If anyone is aware of the question already having been answered somewhere else then please let me know. Otherwise... here goes!
Background
I'm working on a 5-year budget impact model focusing on medical devices. Each device is defined by (a) the cost of the item, (b) acquisition year and (c) product lifetime). Example: Device X costs 1.000 EUR and must be paid for in year 1 within the 5-year model, and it has a product lifetime of 3 years after which it must be renewed/a new one purchased. Across a 5-year time horizon this would require the payer to pay 1.000 EUR for Device X in year 1 and year 4.
Problem
So far, I've been able to produce two separate formulas; one that models the correct cost and acquisition year, but fails to include the product lifetime cycle - and vice versa - a formula producing the correct product life cycle and cost, but fails to begin the calculations at the correct acquisition year.
Question
How - if in any way - can I combine the two statements in a way that ensures that Device X is paid for at the correct acquisition year and rebought according to the product lifetime cycle?
Thank you for reading!
Bookmarks