Target Vs Actual & Forecast Dashboard

I need to build an excel reporting dashboard to show :
1. Target numbers
2. Actual Numbers
3. Run Rate till end of period ( Month / Quarter / Year)
3. Trends - by partners / by product / by month / by quarter etc
4. re-Forecast plan if we foresee there is change in key factors such as volume or pricing to drop at partner level. So it must be dynamic enough to assign at factor level and partner level over period level. This factor needs to be adjustable.
The output should be within the dashboard to show current performance vs plan vs reforecast.
5. Need to be able to update it easily from daily report.

Budget around USD50