I reviewed your financial presentation template file and did some amendments. Now the details and the budget column in PL Cognos shows the same numbers down to Gross margin. Please have a look to the material usage details (tab Gross margin) as I have included IC sales. However I had to enter strange material usage rates for IC sales to achieve the same total material usage as in the PL Cognos. Maybe you distributed the material usage of IC sales on the product groups. If yes please enter the right rates in order to have a sound base for budget discussion. Further there is a gap between PL Cognos and the details of personnel cost.
It would be great if you could do the necessary amendments and update the presentations before the budget meeting starts.
I received also a finance presentation template file for the MU. The figures are ok down to Gross margin, but the fix cost are wrong. How do I have to read this file?