1. Objective and Scope

1.1. Objective of this Operation

This document aims to give instructions on how to prepare the Analysis File from the Future Standard Cost Estimate to be sent to the Controllers and Front Office (change Front Office)Local Accounting team.

Controllers analyze the costs previously in SAP to correct any errors before closing if needed, validate the material prices and validate the significant variances of Antecip. Reval and %Var. costing/MM.
Costing run calculates the standard cost estimate for the next period based on end-month figures of the closing period. After calculation, SBS Service Center NAM Finance Operations team sends detailed reports to the controllers and front office Local Accounting team to support their analysis so they can identify the major changes, anticipate possible issues to correct before closing and justify high variances when needed. The reports are sent in different moments of the month for each purpose – as further explained in this document. Target is having the minimum level of errors as possible. 

First the material's price is analyzed and the first errors identified. Then, when it’s near to closure, the variances are daily reported and treated while the errors corrections are still monitored. On D-1 after all remaining variances are properly justified and the errors are all corrected, the prices are marked and set up for every material movement of the next period.

1.2. Scope

This procedure applies to company 7424 - Solvay USA Inc. - All Plants.

2. Definitions

See Finance Glossary:

• FRA
• GCCO
• NAM
• RCOM
• ROPM
• SCE
• SC T-CO

3. Tasks description

3.1. Responsibilities

Reports Preparation: SBS Service Center NAM Team

Analysis, Variances Justification and Corrections: Plant Controllers/FRAs

Validation: NAM SBS RtR (change RtR) RCOM

3.2. Periodicity

The reports must be sent on following days:

• D+10
  Sample report to Controllers to have a preview of the material's price and a report to have a preview of the errors.
  
  
• D+11
  Sample report to Controllers to have a preview of the material's price. Errors report are sent separately by plant, indicating a correction proposal for each error.
  
  
• D-5 to D-1
  On these days it's also sent a report to Controllers to analyze the %Var. costing/MM over 10% or below -10%, and Anticip. reval. over 50k or below -50K. The list of errors is sent to the plants separately between “Errors to be fixed”, “Errors to be ignored” and “Errors to be deleted”.

2. Definitions

See Finance Glossary:

• FRA
• GCCO
• NAM
• SCE
• SU MAC

3. Tasks description

3.1. Responsibilities

Reports Preparation: SBS Finance Operations

Analysis, Variances Justification and Corrections: Plant Controllers/FRAs

Support: Service Unit Management Accounting (SUMAC)

3.2. I

(please confirm the title)

Produce the Costing Run Report

3.2.1. I Prepare the Costing Run Results

This report needs to be sent on D+10, D+11 and from D-5 to D-1.

 1) Download the macro 7424 - SCE Insert the date on cell B2 - Always use the first day of the next month of the current month;

Image Removed

Click on Image Removed and select layout /FILIPESCE
 

Image Removed

Image Removed

Image Added

2) Save the file in your Desktop with the name SCE;

3)  Click on "Run" button to run the macro (do it with WP1 system opened).

Image Added

4) The macro will open 2 new excel files:

• The first one is named with the date: close the excel and reopen to get the correct format (it is saves in your desktop);
• The second one is "Book", which contains the report.
  
  After open again the first excel file, copy the information below from 1st excel file and paste as values in the 2nd excel file Book:
• Lot Size
• PER
• Total Stock
  
  After that, close the 1st excel file.

3) In the excel file Book, insert a new column in A and name it as "GBU";

Take one report from previous month in .... and copy the tab "PC materials" to Book excel file. This file contains the information of profit center and GBU per material and plant;

In Book excel file, make a vlookup to get the "COMBO MATPLANT" column in tab "PC Materials" and bring the information in column "FC Enterprise description" 

4) Make a filter in column N "Anticip. reval." per red color. Verify if all information in column J "%Var. costing/MM" is red as well. If not, paint it with red.

5) Make a filter in column J "%Var. costing/MM" per red color and verify if there is any "N/A" in column GBU.

If yes, you need to include the information of material, plant, COMBO MATPLANT and the "FC Enterprise description" in tab "PC materials".

To get the "FC Enterprise description", use the transaction ZWFAI052 and insert the information below:

Controlling Area: Z028

Current Date: today date

material and plant and execute

Image Added

You need to copy the profit center and paste on column C in tab "PC materials"

Image Added

And copy the market and paste in column I in tab "PC materials":

Image Added

With this, the column A in tab "Report" needs to be without "N/A".

6) Save it with name "7424 - SCE (D-Number of the day or D+Number of the day)  Costing Run Results - MMMM/YY"

3.2.2. I produce

the %Var. costing/MM and the Anticip. reval. report 

(please confirm the title)

This report is only from D-5 to D-1.

The folder The template below is used to save the G Drive file that highlight the amounts greater than 10% or below -10% for "%Var. costing/MM", and greater than 50K or below -50K for "Anticip. Reval.". It will be automatically highlighted in red, column I and M.

Folder File: 7424 - Costing Run Issues Control

Template File: 7424 - Costing Run Variances - Template  

Tab Summary Anticip. Reval: Lists materials with high anticipate reval and plant;
Tabs by day: Used by controllers to justify the variances on price change over 10%

The comments will be automatically transferred from one day to another, which means that if there is a comment in a price variance in D-4, it will be automatically copied to D-3 until D-1. → Just double check if all rows are with formulas.

In

1) On D-5

copy this file in the folder "

, take the file 7424 - Costing Run

- Variances",

Variances - Template (template) or make a copy from last month from folder 7424 - Costing Run Issues Control and name it as "7424 - Costing Run Variances – Month"

;

2) In the excel file created in step 3.2.1, filter the column N "Anticip. reval." by red color and copy the material, plant and COMBO MATPLANT and paste in G Drive file tab "Summary Anticip. Reval";

3) Copy the information in excel file tab "Report" from A to V without filter and paste in the G Drive tab D-5 or the day corresponded that you are preparing the report;

4) In the G Drive file, select the columns from G to V and format > number automatic:

Image Added

5) Select again the columns from G to V and press "Ctrl+H" to find the "." and replace per nothing;

6) Select the columns from G to V and press "Ctrl+H" to find "," and replace per "."; 

7) Select columns from J to P and go to format > number > number again;

Image Added

8) Select columns from S to V and go to format > number > number again;

9) With this, the tab "Summary Anticip. Reval" will be populated automatically on D-5, D-4 and etc:

Image Added

10) After that, check the column comments in all tabs to see if the formula is in all lines that have information.

3.2.3. I produce the costing run errors report

Image Removed

Image Removed

(please link to the path)

(please confirm the title)

Corrections Guide: 

7424 - Costing Run list of Errors & Warnings

The report can be prepared using the macro attached 7424 - Cost Run Error or manually as showed shown below.

 

1) Go to transaction CK40N and extract all the error messages clicking on the log of the three steps below of costing run:
Selection
Struct. Explosion
Costing

Image Modified

 
 IMPORTANT:

Exclude all message type “I” – Information

 

 

Image Modified
 

 Classify

2) Classify the errors as following:

- Errors

• • Errors to be fixed:

Message type E
“No Price…”
“Blocked…”
“Production Version…”
Cost estimate for material XXXXXX contains errors -> Planned Price 
Material XXXX in plant XXXX has material status Z0 : Blocked for all
Material XXXX in plant XXXX w/o cost comp split: price acc to val strategy

- Errors

• • Errors to be ignored:
    “Cost Center x, activity type y: Activity price differs….”
    “Routing x either does not exists or contains no operations”
    

- Errors

• • 
    
  • Errors to be deleted:
    “Deletion indicator…”
    “Material x in plant y has no accounting data”
    “No suitable or valid production version found”
    Material XXXX in plant XXXX: No cost est. exists -> raw mat. cost estimate

Upload the D11 errors report on Google Drive link below by plant and notify the corresponding plant controllers and RCOM.
https://drive.google.com/drive/folders/0BzJjTiQz5SQEY0N5Xzh2R2NRUGs (name the file and link it)

3.3. I Produce The Commercial Price Report on D-5

THIS IS ONLY FOR D-5
You can use the macro attached 7424 - Commercial Price or follow the instructions below manually:

1) Go to transaction SQ00

Click on Image Added then select “COSTING”

Image Added

Select the query: Z_ARTICLE

Image Added

And run with variant: 7424_COMM HA and Execute.

Image Added

2) Once the reporting is generated, select the plant column and sort in ascending order: 

Image Added

Extract the report by clicking on

List → export → Spreadsheet

Image Added

3) Save as “7424 – Commercial Price – Month”.

3.4. I send all the reports

Create a ticket via Freshdesk tool and insert the link for G Drive file, the excel file, the costing run errors and the commercial price report D-5 (this last one only in D-5).

D+10 and D+11: excel file, the costing run errors;

From D-5 to D-1: G Drive file, the excel file, the costing run errors

Only on D-5: commercial price report

The list of errors is sent to the plants separately between “Errors to be fixed”, “Errors to be ignored” and “Errors to be deleted”.

3.6. I send all the reports

When all the reports are done, send them to: 

• Plant Controllers/FRAs
• Business Controllers and Finance Directors/GCCOs
• NAM SBS RtR (change RtR) ROPM
• NAM SBS RtR (change RtR) RCOM
• Local SC T-CO Member

• Local SBS SU MAC Team
• Local SBS Finance Operations Team Leader and Team if necessary.

End of document.