This task must be performed on D2 with the template Template Fixed Costs Reconciliation CCCC_September 2015.xlsx

  1. PRG costs to be filled by the controller

  2. Updated from BFC 

  3. Difference between PRG & BFC => To be explained by the controller

  4. Updated from BFC. Non-proportional cost absorbed should be equal to FC Period + Depr Period 

  5. Updated from BFC. 

  6. Stock Effect

  7. If after point F, there are still a discrepancy (Threshold >20), Costing process expert team should be contacted  

Analysis of the stock effect is done with PF2 - Z1K_CONS_ESTO - Report consumption and final stock with the template Template for Z1k_CONS_ESTO.xlsx

1. Export the report Z1K_CONS_ESTO in excel and copy data in the tab CCCC ESTO

2. Refresh the pivot table in the tab Stocking Pivot to get the stock effect.

 

Analysis of the stock effect

Stock Effect Fixed costs

= (2) Final inventory (Manufact. Activities + Packaging Activities) – (1) Beginning Inventory (Manufact. Activities + Packaging Activities) 

Stock Effect Depreciation

= (2) Final inventory (Depreciation) – (1) Beginning Inventory (Depreciation)