I created a form where I can indicate a capacity per factory, per month (form 1). It looks the following:
| Month |
Factory |
Qty |
| 01-Aug-2012 |
Factory 1 |
100000 |
| 01-Sep-2012 |
Factory 1 |
250000 |
In another form we enter volumes per week that are forecasted so far, like shown below;
| Date |
Factory |
Qty (SF) |
| 01-Aug-2012 |
Factory 1 |
90000 |
| 01-Sep-2012 |
Factory 1 |
100000 |
| 10-Sep-2012 |
Factory 1 |
50000 |
I need to build a report where I can see e.g. how much volume has been forecasted and what the capacity for that factory was. An example is reported below
| Factory |
Month |
Total forecasted |
Capacity |
| Factory 1 |
August |
90000 |
100000 |
| Factory 1 |
September |
150000 |
250000 |