Algorithm for forecast
I have captured the approach I am going to take to arrive at a solution. There will be a stored procedure (SP) to calculate the forecast. The SP will accept three parameters. I have made few assumptions as the source of availability is not confirmed. If I get more data I could arrive at more accurate solution.