This is something that many media houses that have a large quantity of video and audio assets, will have.
I’m intrigued by your multi-tiered approach. The assets some here some there, some in multiple places, is typical, and it will all get sorted over time.
But one question I have, since you’re making projections for the future. How are you going to afford to pay for the ‘holding costs’ that most cloud services charge per month which over many years and many TBs quickly run into six figures (in $$). Plus with some providers, there are ‘egress fees’, so you pay to get your own data back.
The question actually is, are the assets worth these costs? Do they return these investments?
Maybe they are.
About projecting future data requirements, the ‘formula’ you have, seems fine. Although data estimation is tricky. One cannot accurately predict how much (more or less) data you’ll create, going forward. And, with new formats coming out all the time, one cannot predict how small (or large) future assets will be. Back in the day, archives were 10-bit dpx. then came ProRes and files shrunk, but more files were created. Now we have J2k, JPEG-XS, HEVC, so you may have to factor that in.
The other thing some people have begun to consider is ‘data audit’, ‘data pruning’, ‘data mining’. To make the data stored and archived, richer and more usable. But that’s a whole new story.
Neil