We started to think about prediction (of quantities) about a year ago. For now we use it for a some services (e.g. storage, server, workstations ...) - guess where!? Exactly, in Excel :-D
For now we use 4 different calculation types and choose the most accurate when we have the results. Unfortunately is Excel on it's limits, a lot of manual doing and long calculation times are not avoidable. So we will start soon to build our predictive engine with R.