Portal for Component Costing
COSTING ENGINE
1
Progress Report
3rd October 2024
Aarif Pathan
Strategic Sourcing
6
Objectives
Process Improvements
Process Automation
Embedded Analytics
Central Governance
6
What we have planned
Cost sheet Digitization for all types of Items NPD Items Regular Procurement Items
Types of Items will be covered Phase wise, like Ring, Turned Cage, Crank Pin, Planet Pins, Cages etc
Cost Elements will be driven through “Master Data”
Comparison for Alternate Processes. For example Forging / Bar / Tube
RA Register will be available with Simple Excel Upload Process
“Search” Cost Sheet History base on various parameters. .Part Code, Date, Material, RA, Size, Commodity etc
For R A Items, Provision for Re-Costing based on Change in Raw Material Prices
For Regular Procurement Items, Change in Raw Material cost or MHR, will change all the related cost sheets automatically.
Impact Analysis for change in Prices
Output in Excel format for “Bulk Updating” Info Records in SAP
Transfer Legacy Data, however it need to be provided in “Prescribed Excel Sheet Format”
6
Where are we Currently…For RA Costing
Completed
In Progress
6
Users and Features
Admin
Costing Team
Reports / Dashboard
6
Master data illustration
Raw Material Price
Material Grade
Supply Condition
Mill
Price
Validity Date
Available Sizes
MHR
Machine
MHR
Validity Date
Machine – Processes - Routes
Other Cost
Rejection
ICC
Profit
Overhead
Packing
Calculation Schema
Developed by BiCS
Based on Inputs by NRB
Can be Viewed by NRB
Can be Changed only by Developer , as per NRB Instructions
6
Few Important Things…
Configurable
One Time Cost
Secure
Simple and Easy
6
Technology Stack
User Interface
Backend / Programming
Database
6
Thank You