Attached file is the new template serving the following purpose.
1. Factory/Product level: FCST P&L
2. Factory/Product level: Monthly Variance Analysis , Budget vs Act (FCST), 15 Act vs 16 Act (FCST)
3. As source data for Group level Variance Analysis.
Process:
1. Fill in all yellow tab for 2016 Jan (Actual) + Feb – Dec (Budget), and 2016 Yearly Budget.
Please review it and then we can discuss during the conference.