title

Download the file 

IAC 01.09 Costing model.xlsx

There are 6 sheets in the form that must be completed :

Fill the tab : read me first

  1. Enter the plant code, description, year, currency & GBU
  2. Use this code to name the file. This will help to retrieve your file
  3. Each time you finish one step of the process, enter OK. 




 

 

 

 

Fill the tab : 1-Cost centers with the transaction ZWFA119

  1. Enter the controlling area
  2. Enter the plant code
  3. Enter the current date
  4. Execute 

 

 

Select the Layout 

  1. Select Layout by clicking on 
  2. Click on /COST MODEL

  1. Company code
  2. Cost center (Code & description)
  3. Profit center (Code & description)
    1. GBU (comes with the profit center)
  4. Responsible code of the cost center 
    1. Position of the responsible
    2. First name & last name of the responsible

 

 

Upload the file in excel

  1. List >> Export >> Local File
  2. Click on Spreadsheet
  3. and click enter 

  1. Enter the path & the file name

  2. Generate

 

 

Open the excel file & copy paste the data in the standard template 

 

Fill the columns K to O

1

Active: the cost center is used.

To be blocked: the cost center can be blocked

2

Correct: the profit center is correct

To be updated: the profit is not correct and must be updated

3

Correct: the responsible is correct

To be updated: the responsible must be updated

4

Group ENTRP

5

Comments: can be used to comment the previous choices

 

 

Fill the tab : 2a-Activity budget 

  1. Enter the list of fixed cost centers PPPP-1 & PPPP-2
  2. Enter the group of cost elements
  3. Cost element to be used in RCS
  4. Enter the Budget & the Additional CNP

 

 

Fill the tab : 2a-Activity hours 

  1. Enter the list of direct production cost centers PPPP-1
  2. Enter activities
  3. Enter forecasted hours that decrease the capacity available and the number of production lines in a cost center 
  4. = nb of prod line x (365*24-(t2+t3)-other constraints)

 

 

Fill the tab : 2a-Activity cycles

  1. Enter direct production cost centers PPPP-1
  2. Enter the list of fixed cost centers PPPP-1 & PPPP-2
  3. Enter allocation keys

 

 

Fill the tab : 2a-Activity TOTAL

Rates are calculated