Simple inventory forecasting functionality based on a user input sales forecast of a assembled products

At the moment to work out when i might need to order i have to make a spreadsheet that allows me to enter my expected sales of assembled products and based on this work out when i will run out of BoM components. This involves copying and pasting of data that is already in dear and a simple calculation. It would be great if Dear had the functionality to do this to remove the user input error risk. I think this would be a simple add-in and would be heavily used by most of the Dear user base. 

To be clear this is not a request for actual forecasting functionality just a request to enable user forecasting to be done in Dear itself. Simple, but very effective.