Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


 


Status
colourGreen
titleSTEP 1

Once a year, when the control IAC 01.09 is completed and uploaded in WP1WP2

  • Copy the result of the sheet "2d-Activity TOTAL" and paste the result in the tab "IAC 01.09"

 

 



 

 




Status
colourGreen
titleStep 2

Update the sheet "CC variance" and enter:

  • the list of production cost centers 
  • the column "normal capacity (year)"
  • the column "Budget (month)" - usually it is equal to the column "Normal capacity (month)"
  • the column "standard capacity (h) (year)"

 


 

 




Status
colourGreen
titleStep 3

Each month, you have to update the actual costs & hours. 

The price variance & the absorption variance will be automatically calculated  


 

 




Status
colourBlue
titleStep 4

Step 4 Description

 

 

 

 

For the monthly update use the transaction S_ALR_87013611 

Enter 

  1. the controlling area
  2. the period
  3. the group of production cost centers


Image Added




Status
colourBlue
titleStep 5

Step 5 Description

 

 

 

 
  1. Production cost centers
  2. Actual fixed costs
  3. Plan costs from IAC 01.09 (local currency)
  4. Actual hour
  5.  Normal capacity from IAC 01.09 (h)


Image Added




Status
colourBlue
titleStep 6

Step 6 Description

 

 

 

 

Report the actual costs of each cost center per activity 

Image Added

Image Added

Report the actual hours of each cost center per activity 

Image Added




Status
colourBlue
titleStep 7

Step 7 Description

 

 

 

 

Status
colourBlue
titleStep 8

Step 8 Description

 

Once the file is completed, the price & absorption variance can be reported in the variance analysis template


Image Added

Viewtracker
hidetrue

 

 

 

Status
colourBlue
titleStep 9

Step 9 Description

 

 

 

viewtracker