MRP Forecast Creation:Need Suggestion

  Hi Experts,

         We have requirement for Forecast creation as follows

 1.(1+3) month forecast, 1 month firmed and 3 month forecast

2.We have this forecast in month only but need in week

3. ie every Tuesday planner will receive weekly confirmed plan from month plan

4. So we know the week plan on every week only but others are there in month

5. Client want to run both monthly as well as weekly plan, if we do this demand will get increase. So kindly suggest me, how to handle this.

Thanks in Advance

Saravanan