Versions Compared

Key

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


 


Status
colourGreen
titleSTEP 01

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 

 

 

Image Removed

 

 

  • result in the tab "IAC 01.09"



Image Added




Status
colour
Blue
Green
titleStep
1

 

 

 

Status
colourBlue
titleStep 2

Step 2 Description

 

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)"


Image Added




Status
colourGreen

 

 

 

Status
colourBlue
titleStep 3

Step 3 Description

 

 

 

 

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

The price variance & the absorption variance will be automatically calculated 


Image Added




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