Posting Example: Moving average price 1

Procedure Stock Stock value V price

1
Begin. inventory: 100 PC at 2.00 100 200.- 2.00
2
Goods receipt: 100 PC at 3.00 200 500.- 2.50
3
Invoice receipt: 100 PC at 4.00 200 600.- 3.00
4
Goods issue: 150 PC at 3.00 50 150.- 3.00

Stock Stock
Stock Coverage GR/IR Account

1 200,- 450,- 4 3 2
300,- 300,-
2 300,- If the invoice receipt is
3 100,- for 100 units, the stock
coverage
is 200 units:
Consumption all differences  stock Vendor

4 450,-
400,- 3
ok
 Posting Example: Moving average price 2

Procedure Stock Stock Value V Price

1
2 Begin. inventory: 100 200.- 2.00
3 Goods receipt: 100 PC at 3.00 200 500.- 2.50
4 Goods issue: 150 PC at 2.50 50 125.- 2.50
Invoice receipt: 100 PC at 4.00 50 175.- 3.50

Stock
Stock Shortage GR/IR account

1 200.- 3 375.- With a delayed invoice receipt 4 2

Of 100 units: 300.- 300.-
2 300.-
a shortage of 50 units
4 50.-  price differences despite MAP

Price difference Consumption Vendor

4 50.- 3 375.-
400.- 4
 Posting Example: Moving average price 3

Procedure Stock Stock Value V Price

Begin. inventory: 100 200.- 2.00

Goods receipt: 100 PC at 2.20 200 Δ 80.- 420.- 2.10
Goods receipt: 100 PC at 2.40 300 in stock 660.- 2.20
Goods issue: 200 PC at 2.20 100 220.- 2.20
Invoice receipt: 100 PC at 3.00 100 300.- 3.00
Invoice receipt: 100 PC at 3.00 100 Δ 60.- 360.- 3.60
in stock

Stock Coverage
Even though all
With multiple delayed receipts between
invoice receipts: 2.- and 3.- were
Danger of Incorrect Valuation! valuated!
Characteristics of Price Control V

Moving average price

+ The stock value is adjusted each time goods are received

+ Real-time price fluctations are posted to stock

+ Price difference postings only take place in exceptional cases

- Price fluctuations cannot be adjusted to the finished products of

higher levels (S price)

- Only recommended for raw materials or goods procured externally

(real-time price for goods receipt known)

- False entries with severe consequences (compounded errors)

- Danger of incorrect valuations with delayed invoice receipt

 Posting Example: Standard Price

Procedure Stock Stock Value Standard Price

1 Initial situation: 100 200.- 2.00

2 Goods receipt: 100 at 2.40 200 400.- 2.00
3 Invoice receipt: 100 at 2.20200 400.- 2.00

Stock GR/IR account

1 200.- 3 2
240.- 240.-
2 200.-

Price difference Vendor

2 40.- 20.- 3
220.- 3
Characteristics of Price Control S

Standard Price
+ All stock postings take place at the standard price
+ Prices remain constant throughout at least one period
+ Price fluctuations do not debit/credit the cost objects (e.g. orders)
 consistant controlling with the standard price as a bench mark

+ Calculation of the standard prices with cost component splits

+ Recommended for all material types
- Price differences cannot be subsequently adjusted to the ending
inventories or the consumed products (sales, production
withdrawals)
Costing Methodology

Valuation Method by Material:

Finished Goods Standard w/ ML

Intermediates Standard w/ ML

Raw Material Moving Average Actual

Packaging Moving Average Actual

 Valuation Area

Organizational unit dividing up a company for the

purpose of valuating stocks in a standardized and
consistent manner.
• Level at which material value is managed.

• The valuation area may is defined:

- by plant
 Product Cost Flow

MAT Manufacturing Cost MM: RM

Cost Cost Cost
Center X Center 1 Center2
CO-
CCA BOM
CO-
Cost Cost PC
Center Y Center 3
Routing

Act1
Production
Production
Cost Center
Act2 orders

VAR.

VAR..
.
CO-
PA Cost F. Goods
VAR...
Object Inventor
y
 Product Cost Flow

Plant Cost
View Sales & Mktg. View
Mfg. Cost Center
Process Order PA
Utilities
BOM Product Unit Cost (Profitability Analysis)
Salaries (Cost Component View) (SAP Value Fields)
Supplies Raw Mat’l 1 Cost of Goods Sold
Maintenance Raw Mat’l 2 Cost of Goods Mfg.
Depreciation Pkg Mat’l Raw Mat’l 1 Costs
Raw Mat’l 1 & 2 Costs
Training Raw Mat’l 2 Costs
Pkg. Mat’l Costs
Routing Pkg. Mat’l Costs
Direct (Activity Types)
Conversion Routing
Mach. Hrs.
Insur. & Taxes or Mach. Hr. Costs
Costs to Produce
Laboratory/QC lbs. Lab Tests Costs
Product testing costs
Waste Treatment Produced Mach. Setup Costs
Change Over costs
Shops & Stores Lab tests (setup costs)
General Services Setup Hrs. Fixed & Variable Cost Fixed & Variable Cost
Indirect Three Views Available:
Conversion 1. Cost Component
Total Product Cost 2. Cost Element
3. Cost Itemization
Product Costing At A Grp

Product Cost Planning

Quantity
structure
in PP Adjust costing
created master data/
parameters
Activity
type
planning Execute costing
completed
run

Overhead Not OK
cost
planning
completed

Standard
Review
Yes for
Plan prices Cost
Approval
of raw Calculated
materials
were
entered

OK

Automatic Standard
Mark Standard Release price hase
Cost Estimate of been
Standard Price released
Product Costing At A Grp

Product Cost Allocation - Simultaneous Costing

Cost
estimate
has been
released

Manufacturi
ng order
has been
released
Product cost
Simultaneous
are
Costing
Yes
Cost object allocated
has been
created
Product Costing At A Grp

Period End Closing Product Costing

Product Revaluation
cost are activity types at
allocated actual prices

Calculation of
WIP

Yes

Periodic
Varaiance
calculation

PE Product
Settle cost
Costing has
object
been done
Product Costing At A Grp

Material Ledger/Actual Costing

GL Postings

Material
M,aster
Revaluate Updates
Stock
Allocation of
MM Goods Follow up Costs
Material Price Price Update in
Movements to Finished/Semi
Determination Finished
Actual Costing
Recorded
Products
Provisional GL Postings &
Posting Reversal

Material
M,aster
Updates
Product Cost Planning: Overview

Functions of Product Cost Planning:

 Product Cost Planning with reference to cost object
 Product cost planning with quantity structure – with structures
provided by PP (Production Planning) module
 Determination of the cost of goods manufactured
 Product Cost Planning supplies information for other
modules:
 Update of prices in a material master
 Update of the cost of good sold with the detailed structure of
cost component (grouped cost elements)
 Standard (material) cost estimate as the base for calculation
of production variances
Product Costing: Overview
Create Cost estimate with quantity structure

Standard
StandardCost
Cost Estimate
Estimate Mark cost estimate with quantity structure
(once
(onceaayear)
year)
Release cost estimate with quantity structure

Prepare
PrepareProduct
Product Cost
Cost
Create Cost Object

Collector
Collector Preliminary Costing

Post Materials Costs

Production
ProductionCosts
Costs Debit Secondary cost

Receive
ReceiveFinished
FinishedStocks
Stocks Credit Production Output

WIP Calculation

Month
MonthEnd
EndClosing
Closing Variance Calculation

Settlement
 What is a Product Cost Estimate?

A tool for planning costs and establishing prices for

materials. It is used to calculate the cost of goods sold for
each product unit.

Cost Estimate With Quantity Structure

Utilizes a Bill of Material (BOM) and routing, I.e. Master Recipe for
costing purposes. Integrated with Production Planning (PP).

Cost Estimate WITHOUT Quantity Structure

Utilizes a material master data and activity types entered manually into cost
estimate.

Additive
You use additive costing to enable you to manually add costs that cannot
be calculated by the system to a material cost estimate.
Product Costing: Overview

Create Cost estimate with quantity

structure
Standard
StandardCost
Cost Estimate
Estimate
(once
(onceaayear)
year) Mark cost estimate with quantity structure

Release cost estimate with quantity structure

Material cost estimates with q. s.

Quantity Structure Valuation

BOM Routing Purchase price
Activity Type Price
Overhead

Costing

Costing Results
Items Cost Values Standard
Standard Cost
Cost
Elements Estimate
Estimate

::
M Material 400000 Raw materials 600 000 USD
Stock
Stock Valuation
Valuation
E Activity 943201 Production hours 610 000 USD
E Activity 943901 UT: Cooling Var. 612 000 USD
G Overhead … … USD Profit
Profit &
& Loss
Loss
Statement
Statement
Concept of Cost Roll Up

 The purpose of cost rollup is to include the cost of goods

manufactured of all the materials in a multilevel production
structure within the costs of the material located at the top of
the structure. The costs are rolled up automatically using the
costing levels.
Costing Variant

Costing Variant

Quantity Structure Valuation

Determination Variant

Quantities Prices

Cost of goods
manufactured
Costing Variant

Strategy for Determination of :

Costing Sheet transfer of - Bills of Material
the existing - Routing
cost estimates

Determination of: COSTING Defaulted dates for

- prices update VARIANT costing
in material master

Valuation control for:

- materials
- internal activities
- external activities
- subcontracting
- overheads via
costing sheet
Quantity Structure for Product Cost Planning

Quantity Structure of Product Cost Planning:-

 Material Master
 Bill of Material
 Work Center/ Resources
 Routings
 Master Recipe
 Production Version
 Procurement Alternative/ Mixing Ratios
Quantity Structure for Product Cost Planning
 Material master data  Master Recipe
 Accounting views  Recipe header
 Operations
 Costing views
 Materials list
 MRP views
 Work Centers / Resources
 BOM - Bill of Material  Basic data
 BOM type & identification  Costing
 BOM header
 Material data
 Production Version
 Validity Period
 Routing - tasks list  Production line
 Routing type & identification
 Routing header
 Operation data
Quantity Structure: Material Master Data

Material Master Data:

 Material Master Data is an object in SAP that consists
all relevant data for raw materials, semi-finished and
finished products divided into views.
 Important Views relevant for product costing:
 Accounting
 Costing
 MRP
 Material cost estimates - quantity struc.

Product cost planning with quantity structure:

 Materials
 Cost Centers / Activity Types

 Primary Costs

Quantity * material price = Quantity * activity price = Cost of goods manufactured

cost of goods manufactured cost of goods manufactured due to the manually entered
due to the consumption of due to the internal activities cost elements or
raw materials. during the production mathematical operation.
process.
Quantity Structure: Production Version

 Production versions combine a specific BOM alternative

with a specific routing/recipe
 For one material, you can have several Production
versions for various validity periods and lot size ranges
 Production version facilitate different situations
Production using different resources
Production using different procedures
Quantity Structure: Procurement Alternatives

 Quantity structure determination for mixed cost estimate.

Quantity Structure: Mixing Ratios
 Quantity structure determination for mixed cost estimate
 Validity period for mixing structure

Product <FERT or HALB >

Mixed Product
Cost Estimate
Costing vs. Quantity Structure

RAW MATERIALS BILLS

OF
MATERIAL
PRODUCT
COST
ESTIMATE

ROUTING

Electricity SERVICE
COST CENTER
WORK CENTER /
Consumables RESOURCE

Maintenance

Labor Utilities Overhead PRODUCTION

ACTIVITY TYPES COST
CENTER
Depreciation
Costing Structure

Costing Structure for Product Cost Planning:-

Material Master

Cost Centers

Activity Types

Cost Elements

Cost Component Structure

Costing Structure for Product Cost Planning
 Material master data  Cost Elements
 Accounting views  Validity period
 Costing views  Category

 Cost Centers
 Validity period
 Category
 Functional area

 Activity Types
 Validity period
 Activity unit
 Allocation cost element
Costing Structure

Activity types define the type of activity that can be provided

by a cost center (work activity, production hours, and so on).

Activity Type
Activity Price Calculation

Cost center:
Planned costs: 84,000
Machine
Cost center
1PDH01 Plan activity qty: 100 h

Planned costs: 100 h

2 Calculated
430000 (salaries) 44,000
Price: 840
440000 (miscl.) 10,000
473120 (telephone) 30,000

1
Activity Price
: Calculation
Apportionment of cost center costs
to activity types according to
particular criteria
Costing Structure
Planning 3 Cost Splitting
9103000 Product
1. Assign CC 9103004 to Splitting
Utilities (Common) Structure Z9 Steam service Cost Estimate
2. Perform cost splitting
2
9103000 Product
Di rigi

91000045 - TEG
st
O

rib al
ut CE
io

Steam service
n

94 ca ity
Ro via 54 n
n

…..

39 tio
lo v
9103004

Al cti
A
1UTSTF Steam - fixed

g
in
5

ut
1UTSTV Steam – var.
….. 943954 UT: Steam fix
Product
91000060 - LLDPE

….. Activity Types Used:

1 1UTSTF Steam - fixed
4 Planned Price Calculation
Primary costs planning on all Prices for 1UTSTF are
Cost Centers. calculated.
Cost Component Structure
CO- CO- Product Cost Planning
OM PC

Primary cost elements Z9

A Grp-Primary

Raw Materials Raw Materials

Cost Centers

Utilities Utilities

Personnel Exp. Internal Personnel Exp.

Activity
Allocation
Depreciation Depreciation

Structure of primary Structure of

costs primary
costs
Product Costing: Overview

Create Cost estimate with quantity structure

Standard
StandardCost
Cost Estimate
Estimate
(once
(onceaayear)
year) Mark cost estimate with quantity
structure

Release cost estimate with quantity

structure
 Price update

 Standard price
 Only one validated standard price per product per period,
 The price represents most desired (or most likely) costs
 Only one price per product over the year (recommended)
 Determined during costing runs for Z9P1 costing variants - standard cost
estimate is populated in appropriate valuation views
 Includes variable and fix cost elements
 Base for variances calculation; which is then posted to FI and CO-PA
 Used for stock valuation of finished goods and semi-finished products
 Stored in material master data (accounting view) in Legal, Group and Profit
Center valuation views after releasing the cost estimate
 Price update

 Future price
 Future standard price
 Stored in material master data (accounting & costing view) in Legal,
Group and Profit Center valuation views after marking the cost
estimate.

 Previous price
 Replaced standard price by current one due to releasing the cost
estimate
 Stored in material master data (accounting & costing view).
Price update
Material Master Data
Analysis of Costing Results

Standard Price

Existing Std Future Current Previous

10

Future Current Previous

Marking Standard
Cost Estimate 15 10

Future Current Previous

Releasing Standard
Cost Estimate 15 10

Stock Revaluation
 Costing run

 Costing run
 You can use the costing run to process mass data. It enables you to cost, mark, and
release more than one material at the same time.
 Every processing step involved in costing with quantity structure is performed by the
costing run, from the same screen.

 Costing run consists of:

 General data (organizational units, selection criteria)
 Selected materials
 Exploded BOMs
 Costing run results
 Price update results
Costing run
Costing Run Creation

Company Code
Costing variant
Dates

Partial selection
OR of materials
Selection
of
all materials BOM explosion

Execute costing run

Marking and releasing costing run results

(price update)
Product Costing: Overview

Create cost object

Prepare
Prepare Cost
Cost Object
Object
Preliminary costing

Post Materials Costs

Production
ProductionCosts
Costs Debit Secondary cost

Receive
ReceiveFinished
FinishedStocks
Stocks Credit Production Output

WIP Calculation

Month
MonthEnd
EndClosing
Closing Variance Calculation

Settlement
Cost Object Controlling: Overview

Functions of Cost Object Controlling:

 Supporting make-or-buy decisions

 Determining price floors
 Performing complex cost analysis
 Determining inventory values
Cost Object Controlling: Overview

Cost Object Controlling Scenarios:

 Product Cost by Period

 Product Cost by Period is used for recurring periodic cost
control of products that are manufactured in the same way
over a longer period of time.

 Product Cost by Order

 Product Cost by Order is mainly used to control the costs of
individual production lots.
Cost Object Controlling: Overview

 Product Cost by Order or by Period

 Full settlement (by Order)

Actual costs - Actual costs -

Actual costs = Goods receipts = Goods receipts =
Work in process Work in process Variances
Time
Releasing an Partial delivery Delivered /
order Technically
completed
 Periodic settlement ( by Period)

Actual costs - Actual costs - Actual costs -

Goods receipts = Goods receipts = Goods receipts =
Work in process + Work in process + Work in process +
Variances Variances Variances
Time
Period 1 Period 2 Period 3
Cost Object Controlling: Overview

Functions
Funkcje Product Cost by Order Product Cost by Period

Type of settlement
FULL PERIODIC
rule

WIP calculated on base WIP calculated on base

Work-in-Process of actual costs of target costs

Variance = Actual Costs - Variance = Actual Costs -

Variances
Goods Receipts Goods Receipts - WIP

Settlement Should be periodically Must be periodically

Hierarchy of
Impossible Possible
Cost Objects
Cost Object Controlling: Overview

Functions of Product Costs by Period:

 Create product cost collectors.

 Create a preliminary cost estimate for product cost
collectors.
 Calculate and analyze target costs and actual costs for
product cost collectors.
 Calculate or update the work-in-process inventory and the
finished goods inventory.
 Calculate and analyze variances for each period.
 Transfer data to: Financial Accounting, Profitability
Analysis, Profit Center Accounting and Material Ledger.
Product Costing: Overview

Create
Prepare
Prepare Cost
Cost Object
Object Product Cost Collector

Preliminary costing
Objects in Cost Object Controlling

 Product cost collectors in the following production

environments:

 In order-related production (that is, when you are using

production orders) when you want to analyze the costs by
period rather than by lot
 In process manufacturing (that is, when you are using process
orders) when you want to analyze the costs by period rather
than by lot
 In repetitive manufacturing you always use product cost
collectors as the cost objects.
Objects in Cost Object Controlling

 Product Cost Collector

Product <FERT or HALB >

Routing Bill of Material

• Group • Usage Product Cost
• Group counter • Alternative
Collector

Production Version
• ID,
• Production line,
• Validity period.
 Objects in Cost Object Controlling

Product PROCESS ORDER 1

Product Cost
<FERT or HALB>
Collector
PROCESS ORDER 2

Master Operation Materials Production

Recipe List/Routing List/BOM Version

Operation 10 Material X
Phase A
Material Y
Operation 20

Resource
Requirements
Preliminary costing

 Costing variant PREM - preliminary costing:

 Created during product cost collector creation
 Created per each production version
 Provides split and balanced information of cost items, quantities and
prices that are planned to occur during production of a product
 Variable costs coming from BOM and routing
 Result used mainly for actual activities postings
 May be used for further analysis up to cost management
requirements
 May be changed all the time in the way of changing (updating)
Product Cost Collector; i.e. different quantity structures allowed over
the period
 Changes in BOMs take effect immediately, i.e. cost estimate update
not required
 Changes in routings take effect after cost estimate update
Preliminary costing

Product Cost Collector

Item Plan Actual

Caustic Soda 1.500

Ethylene 2.000

EDC 0.500

Materials 4.000

Internal activities 2.500

Overheads 1.500

Total 8.000
Simultaneous costing – actual costs
Confirm order
operation

Production output &

Back Flush
Product Cost Collector
Item Plan Actual

Record consumption Caustic Soda 1.500 1.800

& output
Ethylene 2.000 2.200
Record process data
EDC 0.500 0.600
& batch
characteristics Materials 4,000 4,600

Internal activities 2.500 2.800

Final Confirmation &
Back Flush Overheads 1.500

Total 8.000 7.400

Deal with Back Flush
& transaction errors

Adjust theoretical yield &

consumption to actual
Confirmation Types & Functions - Process Orders

Confirmation types


 Individual
Individual order confirmation
confirmation

 Collective
Collective confirmation
confirmation

 Milestone confirmation
Milestone confirmation
 Progress confirmation
 Order confirmation
 Confirmation with reference

Confirmation functions

 Output
Confirmgoods receiptmovement
with goods
 Defaults for remaining time
 Backflush components
Check operation sequence
 Check delivery tolerances

 Backflush
Plant data collection interface
 utilities
Backflushing
 Reduce
Reducecapacity
capacityrequirements
requirements

 Determine actual costs
Determine actual costs
Final Confirmation & Technical Completion

 Final Confirmation is made when every operation in the order

has been completed
 Technical confirmation is the order is prematurely terminated.
Technical confirmation prevents further activities being
posted to the order.
 Both the above confirmation can be settled.
Failed Transactions and Corrections

 Incorrect or missing data for components and activities

prevents processing of the back flush transaction
 These errors must be corrected before postings can be made
for materials and activities
 When the errors have been eliminated, the theoretical yield
and consumption may be adjusted and the results recorded
Actual costs

 Production Order
Step 1 – Created and release
- Maintenance of Master Data
Status - RELEASED

STATUS- CREATED
STATUS - RELEASED
This status allows for actual postings
Actual costs

 Production Order
Step 2 – Goods Issue to Order
- Actual Postings
Status – GOODS MOVEMENT POSTED
Raw
Materials Order
FI Consumed
400000

1.100,- 400000 + 1.100

100 * 11 = 1.100,-
Inventory
quantity * price = cost
Raw
Materials
119400

1.100,-
Actual costs

 Production Order
Step 3 – Direct activity allocation
- Actual Postings
Status - RELEASED

Order

400000 + 1.100
943201 + 7.500
Cost Center / Activity

150 * 50 = 7.500
943201 - 7.500,- quantity * price = cost
Actual costs

 Production Order
Step 4 – Goods Receipt from Order into Warehouse
- Actual Postings
Status – PARTIALLY DELIVERED

Production Order
FI Output
462001
400000 + 1.100 462001 - 5.000
943201 + 7.500
5.000,-

Finished
Products
119430

5.000,- 100 * 50 = 5.000,-

quantity * price = value of the goods receipts
from order
Actual costs - Summary

 The results from the output receipts, plus material & resource
consumptions, update the stock records and provide
valuation of production according to standard cost approach.
Product Costing: Overview

WIP
Calculation
Month
MonthEnd
EndClosing
Closing
Variance
Calculation

Settlement
Period and year-end closing

 Production Order
Step 5 – Work-in-Process Calculation
- Period-end closing
Status – RESULTS ANALYSIS CARRIED OUT

Order

400000 + 1.100 462001 - 5.000,-

943201 + 7.500

WIP Report:

Work-in-Process
8.600 - 5.000 = 3.600
Period and year-end closing

 Production Order
Step 6 – Settlement
of - Period-end closing
Status – RESULTS ANALYSIS CARRIED OUT
Work In
Progress Order
FI (WIP)
462201 400000 + 1.100 462001 - 5.000,-
943201 + 7.500
3.600

Work In
Progress
(WIP)
119460
WIP is being updated on the
order as statistical value for
3.600
information purposes.
Period and year-end closing

 Production Order – new period

Step 9 – Repetition of the steps from 3 to 7
- Actual Postings
Status – PARTIALLY DELIVERED

Order

400000 + 1.100 462001 - 5.000,-

943201 + 7.500 462001 - 7.000,-
400000 + 5.000,-

As a result of the actual

postings in the new period
there is a new balance on the
order.
Period and year-end closing

 Production Order – period 2

Step 7 – Work-in-Process Calculation (variant 1)
- Period-end closing
Status – PARTIALLY DELIVERED

Order

400000 + 1.100 462001 - 5.000,-

943201 + 7.500 462001 - 7.000,-

400000 + 5.000
WIP Report (cumulated):
Work-in-Process
13.600 - 12.000 = 1.600
Work-in-Process
in previous period
8.600 - 5.000 = 3.600
Cumulative: 2.000
Period and year-end closing

 Production Order – Period 2

Step 11 – Settlement (variant 1)
- Period-end closing
Status – RESULTS ANALYSIS CARRIED

Work In
Progress Order
FI (WIP)
119460 400000 + 1.100 462001 - 5.000
943201 + 7.500 462001 - 7.000
1.600
400000 + 5.000
Work In
Progress
(WIP)
462201
As WIP is reported as
1.600 cumulative value.
 Period and year-end closing

 Production Order – period 2

Step 12 – Calculation of Variances and Settlement (variant 2)
- Period-end closing
Status – TECHNICALLY COMPLETED
Price
Difference -
Production Order
FI Difference
464018
400000 + 1.100 462001 - 5.000
1.600 943201 + 7.500 462001 - 7.000

400000 + 5.000
Production
Output WIP WIP
462001 462201 119460 As a result of a posting the
balance of the order was
1.600 3.600 3.600 posted to production
Negative variance: difference account and
Actuals > Plan. cumulated WIP was
reversed.
Period and year-end closing

Variance PA Assignment
Cost Element Group Value Field
Category lines

+
Period and year-end closing

Periodic Costs Product Cost Collector

Item Plan Actual

Caustic Soda 1.500 1.800

Revaluation
Ethylene 2.000 2.200

EDC 0.500 0.600

Materials 4,000 4,600

% Internal activities 2.500 2.800

Overheads 1.500 1.600

Overheads
Total 8.000 9.000
Period and year-end closing

Period-end closing

Process costs
Periodic
costs Revaluation

Overheads

Calculations Work-in-Process
and
analysis Scrap
Variances

Postings Settlement
FI/CO
Material Ledger: Overview

Functions of Material Ledger:

 Cost accounting using actual prices
 Storing values of stock in three different valuations
(legal valuation, valuation for reporting purposes, and
profit center valuation) in multiple currencies.
Material Ledger: Overview

Functions of Material Ledger:

 Cost accounting using actual prices
 Storing values of stock in three different valuations
(legal valuation, group valuation for reporting purposes,
and profit center valuation) in multiple currencies.
What is the Material Ledger/Actual Cost Concept?

The Material Ledger(ML) is a tool within the CO

Module that collects all transactional data for
materials whose master data is stored in the
material master. It acts as a subledger for selected
materials that captures all goods movements,
invoice values, transfers and price changes. On
the basis of this data, the material ledger
calculates and maintains the actual cost for these
materials. This actual cost can then be utilized to
valuate the material stock accounts.
Objectives of the Material Ledger

1. Actual Costing.
During the period, valuation of all goods movements is done
with the preliminary valuation price which is normally the
standard price. All variances from the preliminary valuation are
maintained in the ML. At period end, revaluation of ending
inventory can be performed with the determined actual price.
This is not mandatory. Actual prices can be calculated for
statistical purposes only.
2. Parallel currencies and/or valuations of material stocks.
All goods movements in the ledger can be maintained in 3
currencies. The values are translated into other currencies
using the historical exchange rates. Prerequisite for usage of
transfer pricing functionality.
Benefits of the Material Ledger

►Variances of Finished Goods

Variances from external procurement (purchase orders) as well
as from production activities are rolled up from raw and semi-
finished materials to the finished goods level.
►To provide support for procurement related decisions.
Detailed reporting for procurement processes and sources
possible. Make vs.. Buy, Vendor A vs.. Vendor B. Price History.
►Combines the benefits of Moving Average and Standard Price
Stable prices used for controlling purposes (standard) and actual
prices used for valuation purposes (average).
►Easy to use display and error finding by consolidating the views.
Allows quick access to detailed views of material master,
standard costs and documents
Benefits of the Material Ledger

►Relatively simple configuration and set up

►True Cost of Sales Accounting

Purchasing and production variances for unsold stocks are
inventoried.
►Contribution Margin with Actual Costs of Sales
By utilizing multi-level settlement, actual values for your cost
component split can be attained. This can be transferred to PA
Single Level Settlement
 The term single level always refers to one material and
its procurement process; which means that all values and
quantities that arise during a procurement for said
material are stored single- level
Multi - Level Settlement
The “multi-level” settlement functionality adds the
most value because it passes the lower level variance
in a production processes up to the final finished
product.
 All the manufacturing variances can be included in
the total cost to manufacture the finished products
The ML updates the Material Master
The Integrated Material Ledger Display
Material Ledger Overview
Actual Costing
Revaluation of stock at
actual prices or accrual of
variances.
Material Ledger
MATERIAL STOCK

Parallel Valuations
(Transfer Prices)
Parallel Currencies  Group
Translation at historic rates  Legal
(up to three)
 Profit Center
ML Overview – Parallel Currencies

Material Ledger
(Valuation Area / Plant)
• 10 Local currency
• 30 Group currency

Financial Accounting Controlling

(Company Code) (Controlling Area)
• 10 Local currency • 10 Local currency
• 30 Group currency • 30 Group currency
ML Overview – Parallel Curr. in A Grp (1)

Material Ledger
Valuation Area (Plant) 9100
Price control

Material
Master

Price Control
Moving average price Standard Price
(V Price) (S Price)
• Changed after every receipt • Stable for long period
• Recommended for raw and • Recommended for finished
externally procured and semi-finished
materials. products.
Price control

Moving average price

 The stock value is adjusted each time are received

 Real-time price fluctuations are posted to stock
 Price difference postings only takes place in exceptional cases

 Price fluctuations can not be adjusted to the finished products of higher levels (in
case S price)
 Only recommended for raw materials or goods procured externally (real-time price
for goods receipt known)
 False entries with severe consequences (compounded errors)
 Danger of incorrect valuations with delayed invoice receipt
Price control

Standard Price

 All stock postings takes place with the standard price

 Price remains constant by at least one period
 Price fluctuations do not debit / credit the cost object
 Consistent controlling with the standard price as a bench mark
 Estimations of the standard prices with cost component split
 Recommended for all materials types

 Price differences can not be subsequently adjusted to the ending inventories or

the consumed products (very important in the Cost of Goods Sold accounting)
Price determination control

Multiple currencies/valuations
Price control
ML can record up to 3 different
S V
V currencies / valuations. This is a
requirement for transfer price
Price determination
2 Standard Moving
Transaction based price price

3 Standard
Standard Cannot be Actual Costing
Single-/ multilevel activated
price determination price
Unit periodic manually Revaluation of stock at actual
price price
Material Master - Price control

Material
Moving average price Master Standard Price
(V Price / 2 Activity-related) (S Price / 3 Single-/multi-
level)

Material ledger Price Control

is activated
Determination
Material Master - Parallel Currencies

Material Company Code: 5200

Master Valuation Area / Plant: 5200

Legal valuation
USD
Group valuation
SAR
Profit center
valuation
SAR
Material Master - Transparency

Material
Master
Actual Values Overview

 Actual data -> Actual Costing

 Overview
 Preliminary valuation price
 Actual Costing
• Price differences
 Updating single-level variances
 Single-level price determination
 Multilevel price determination
Overview of differences
FI PA
-

Purchasing,
PRD PRF
*
Stock
Movement,
Cost (price) GL (PL) 464017 Revenue Revenue
differences
Production PRA Price Diff -Purchasing

PRU
COGS COGS
- *
GL (PL) 464018 Input price
PRY variance
Material Ledger PRF Production Variance
Cost (price)
Closing - Single differences Input quantity
Level (mater.ledg PRA variance
er)
Resource-usage
PRU variance
* Remaining input
GL (PL) 464019 variance
-
Price Diff - Good
PRV Issue Mixed-price Production
variance
Material Ledger Material
PRF
Variances
Closing - Multi ledger Output price
Level Level fr.low.level PRA variance
s price dif.
* Lot size-/fixed-
PRU GL (PL) 4640020 cost variance
Price Diff -Transfer Remaining
Postings variance

Scrap Adjustment
Material Ledger UMB to COGS
Closing - Gain/loss
Release Future from Price Diff -
from
Price revaluation GL (PL) 464021 Purchasing capitalising
Gains/Loss on
Inventory Revaluation Price Diff - Good Variances
Issue
Price Diff - Adjustment to
Transfer Postings COGS from
Material Ledger LKW Gains/Loss on
Inventory
Closing - Do not Accruals and
defer.acct(mat GL (BS) 119610 Inventory Revaluation
revaluate Stock erial ledger) ML Provisions Revaluation
Gross margin
Actual Values Overview

 Actual data -> Actual Costing

 Overview
 Preliminary valuation price
 Actual Costing
• Price differences
 Updating single-level variances
 Single-level price determination
 Multilevel price determination
Preliminary valuation price

 When Actual costing is used all materials are valuated with a

preliminary periodic unit price. This price remains constant
within a period.
 This price can be the result of a standard cost estimate, a
manual price or an actual price calculated in the previous
period.
 The advantage of this price is (as with the standard price)
that standard costs can be calculated independently without
price fluctuations hindering the controlling of the production
processes.
Actual Values Overview

 Actual data -> Actual Costing

 Overview
 Preliminary valuation price
 Actual Costing
• Price differences
 Updating single-level variances
 Single-level price determination
 Multilevel price determination
Actual Costing

 Price differences
 Stock transfers
(standard price in another plant)

 External procurement
se (purchase order or invoice value)
ri h
..a ug
. ro
 Internal production
th
(order settlement)
Actual Values Overview

 Actual data -> Actual Costing

 Overview
 Preliminary valuation price
 Actual Costing
• Price differences
 Updating single-level variances
 Single-level price determination
 Multilevel price determination
Updating Single Level Variances

 During a period, variances are incurred for this preliminary valuation

price (or standard price).
 These variances are posted from the material ledger to a price
difference account and updated for each material. Single-level
variances are the variances incurred for a material during its direct
procurement.
 For raw materials, these are, as a rule, variances from price fluctuations
in the case of external procurement from vendors.
 For semi-finished and finished products, the single-level variances
include internal cost fluctuations from production that are calculated
during order settlement.
 Single-level variances do not include price differences from materials
from lower levels of production. For example, price variances incurred
during the procurement of raw materials are not included in order
settlement, because the raw materials were assigned to the order at
preliminary valuation.
Actual Values Overview

 Actual data -> Actual Costing

 Overview
 Preliminary valuation price
 Actual Costing
• Price differences
 Updating single-level variances
 Single-level price determination
 Multilevel price determination
Single level Price determination

 At the end of the period, you can use the functions for single-
level price determination to assign the variances for each
material. In this way, cumulated price differences can be
proportionally assigned to the ending inventory and material
consumption of the period at the end of the period.
 The stock can valuated with the actual price of this period,
the periodic unit price. The price differences assigned to
consumption first remain on the price difference account.
 When you settle an order, the system allocates the price
differences incurred during a production process to the
respective materials.
Actual Values Overview

 Actual data -> Actual Costing

 Overview
 Preliminary valuation price
 Actual Costing
• Price differences
 Updating single-level variances
 Single-level price determination
 Multilevel price determination
 Multilevel Price Determination
 Multilevel material price determination can also calculate the variances
that have flowed into higher levels of the production process using a
multilevel actual quantity structure .
 Thanks to the quantity structure, a type of actual bill of material, the
system knows what materials were used for the production of which
goods. The prices of the finished products can then be calculated.
 As a result, price differences, for example, of raw materials can be rolled
up to semi-finished goods and, in a next step, to the finished goods.
 The period-end closing process for multilevel material price
determination enables you to recognize the actual prices for each
material (raw materials, semi-finished products and finished products) at
the end of the period. These actual prices contain the prices incurred for
the actual quantity produced or procured for each period.
 If you wish, you can use these actual prices to revaluate your products or
raw materials.
 These procedures make it possible for you to use an actual cost system
in addition to your standard cost system, because the values of your
standard cost system (cost centers, orders) cannot be readjusted during a
subsequent allocation.
Period End Overview
 Actual Costing – Period End Closing Procedure
 Collecting price differences
• On price difference accounts or in material ledger within categories
 Period closing program
• Open new period in MM (transaction MMPV)
 Determining prices
• Single-level, later multilevel
• V price is calculated
 Making closing entry
• Must be made for each period
• Posting to prior period is no longer possible
• Reversal if required
 With revaluation
• Price differences are proportionally posted to the remaining stock -> Price
indicator ‘V’
 Without revaluation
• Price differences are proportionally posted to the accruals account -> Price
indicator ‘S’
 Marking future price
Period End Overview – Closing Entry (1)
With Revaluation
Material: ACT-LCD##
Status: Closing entry performed Locked
Price control: V (only old periods)
V price: 26.50 EUR / 100 units
Beginning inventory (BI): 1000 PC / 250 EUR
Goods receipt/purchase order : 1000 PC / 260 EUR
Invoice receipt : 1000 PC / 280 EUR Stock value :
Consumption: 1300 PC / 325 EUR 185.5 EUR
Ending inventory: 700 PC (700 PC * 26.50/100)

Material stock (119400) GR/IR allocation Vendor

250 325 260 260 280
250
CL 10.5
Material consumption
Price difference (464017) (400002) ML accrual (119610)
10 VB 325
CL 10.5
20
Period End Overview – Closing Entry (2)
Without Revaluation
Material: ACT-LCD## Locked
Status: Closing entry performed
Price control: S
S price: 25.00 EUR / 100 units
Beginning inventory (BI): 1000 PC / 250 EUR
Goods receipt/purchase order: 1000 PC / 260 EUR
Invoice receipt: 1000 PC / 280 EUR
Consumption: 1300 PC / 325 EUR Stock value:
Ending inventory: 700 PC 175 EUR

Material stock (119400) GR/IR allocation Vendor

250 325 260 260 280
250

Material consumption
Price difference (464017) ML accrual (119610)
(400002)
10 CL 10.5 325 CL 10.5
20
Period End Overview – Periodic unit price
 The periodic unit price is calculated after the end of a period. It
mirrors the actual costs of a material for the closed period.
 The system uses the cumulative inventory (the beginning inventory
plus all goods receipts) and the cumulative difference (all differences
between the standard price and the price entered for all goods receipts
and the beginning inventory) to calculate the periodic unit price.
 Material price determination must be allowed for every individual
period (through the menu option Organizational Measures or directly in
a costing run).
 The single-level material price determination includes deviating
amounts due to price differences, exchange-rate differences and
revaluation differences that have been incurred for the (single-level)
procurement of a material in this period.
 After the period has been closed, the cumulative differences are
allocated to the cumulative inventory for the closed period. From this,
the system calculates the weighted average price that can be used for
valuation of the ending inventory. With single-level price determination,
the valuation in the current period remains unchanged.
Information System Overview
Materials
to be Product Cost
costed Planning
Reports

Summarized Object
Object
Analysis List Comparisons

Detailed
Reports
 Report Selection

 The Report Tree can be used to select Reports in the Information System. The Report
Tree is the central collection point and hierarchical outline of all Reports in an
application component.
 The standard Report Tree supplied by SAP should not be changed. A personalized Report
tree can be created to which standard Reports as well as one's own creations can be
assigned.
Report

 The Report can be used to

Report

 The Report can be used to

Report

 The Report can be used to

Report

 The Report can be used to

Report

 The Report can be used to

Information System Overview
Information System Overview

Material
Ledger
Reports

Object Detailed
List Reports

Displaying
Documents
Information System Overview
Materials
to be Product Cost
costed Planning
Reports

Summarized Object
Object
Analysis List Comparisons

Detailed
Reports
 Report Selection

 The Report Tree can be used to select Reports in the Information System. The Report
Tree is the central collection point and hierarchical outline of all Reports in an
application component.
 The standard Report Tree supplied by SAP should not be changed. A personalized Report
tree can be created to which standard Reports as well as one's own creations can be
assigned.
Information System Overview
Report Output Types
 Variable output areas
Graphical report-output  HTML-header
 Navigation by drag and drop and
context menu

 Various leads columns

Object List (ALV)
 Standard ALV Functions