1 of 9

Portal for Component Costing

COSTING ENGINE

1

Progress Report

3rd October 2024

Aarif Pathan

Strategic Sourcing

2 of 9

6

Objectives

Process Improvements

    • Eliminate Manual method of Costing, which is….
      • Person Dependent
      • Time Consuming
    • Implement Latest Digital Technology
      • Fast
      • Error-free
      • Without hampering current processes

Process Automation

    • Handle Costing changes in Bulk for selected Category / Material / Mill for “Rate Fluctuations”
      • Easily
      • Within few minutes
      • Error free by Reduction in Manual Touchpoint

Embedded Analytics

    • Entire History of Costing will be available in a single click

Central Governance

    • Access from Anywhere Anytime
    • Access based on Authorizations
    • Scalable and Sustainable Platform
    • All data will be Secured Centrally Maintained

3 of 9

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”

4 of 9

6

Where are we Currently…For RA Costing

    • Master Data : Admin Module
    • Individual Costing for Ring Category
    • Testing of Costing Calculations for Individual Costing
    • Bulk upload of RA Register
    • Raw Material Price Change by Excel Upload

Completed

    • Testing of Costing for Forging Route
    • Comparison by Various Routes
    • Recalculations for Change in Raw Material Prices
    • SSO (Single Sign On) for Login
    • Search Cost Sheet
    • Regular Procurement Costing
    • Dashboard and MIS
    • Transfer of Old Costing Data

In Progress

5 of 9

6

Users and Features

Admin

    • User Management
    • Master Data Management
      • Mills
      • Raw Material Prices
      • Supplier-Machine-Process-MHR Relationship
      • Category - Routes
    • Alerts / Signals Settings

Costing Team

    • RA - NPD Items costing
    • Regular Procurement Item Cost Maintenance
    • View history
    • Assessment of Impact of Master rate Change.
    • Bulk Cost Output
    • Download data for Info Records
    • View Master Data and Costing

Reports / Dashboard

    • Dashboard
    • View Master Data
    • Download data for Info Records
    • View Master Data and Costing
    • Route wise cost comparison

6 of 9

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

7 of 9

6

Few Important Things…

Configurable

    • NRB Team can Manage Users and Master Data (Admin)

    • No Dependencies on BiCS Post Go Live

    • Robust Database Architecture to cater future Enhancements

One Time Cost

    • No Hidden Costs

    • No Frequent Upgrades

    • No Renewal Fees etc

    • Unlimited Users

    • No License Cost

Secure

    • Secured Database

    • Backup

    • “Single Sign On” for eliminating unauthorized use.

Simple and Easy

    • Professional User Experience

    • Easy surfing

    • Every Category will have “Predefined Calculation Schema”

8 of 9

6

Technology Stack

User Interface

Backend / Programming

Database

9 of 9

6

Thank You