Quantitative Reconciliations for FG, SFG & RM

Quantity chart is the key report required for all type of reporting in MIS and Costing related requirements.
Mostly the Quantity chart is being prepared in excel sheet wth lot of manual data workings in excel files,

In SAP the closing stock report for each of the materials and for each of the period is a challanging task to prepare

Production Quantity / Consumption Quantity /Sales Quantity / Opening Stock and Closing Stock in one report is the most important and critical report

Basic Costing and Basic MM and PP module should be in place

Stock reconciliation would be very easy and comfortable with the detailed quantity chart, all the questions related to stock at the plants can be answered with this reports

Approach :
Following parts of this report :
1. Closing stock report for material and plant wise with period and fiscal years.
2. Transaction data report for capturing the material movement documents and movement type wise data
3. Separate custom table to be prepared for the storage of computed data for closing stock and Transaction data
4. All these figures of quantity chart would be reconciled with the GL Accounts

Assumptions:
Movement types need to be grouped as per the requirements of the quantity chart
It should be only for RM, PM, Semi finished and Finished goods and not for the Stores and Spares items

Sometimes due to high volume of data and complexity it might take little more time in the testing phase for the output which we generate from the SAP system

Quantity Chart with all the supporting reports and schedules., available on monthly basis

Manuals and SOP for the preparations and pre-requisites for the reports and Maintenance of the same

We have the set of standard ABAP Programs for the extraction of the Closing stock and Transaction data program with the master table for the smooth functioning of the Quantity chart

2 weeks for understanding the business process
1 week for preparing the solution documents based on the understanding and sign off
4 weeks for Realization and Testing the solutions in the DEV and Quality system of SAP
1 week for moving the TR To Production system and some amount of sample posting in Production systems
2 week of Post go live support during the execution in the production system

Quantity chart if properly analysed and reviewed on monthly basis would certainly give us lot of visibility of stock lying all across the organizations which may not be in the notice of the stores person and purchase team,

New Purchase of the material can be done after checking the quantity chart for the last month and then only new purchase order should be placed for the respective materials.

This will certainly save lot of money and resource on account of the stock value and the saving would be very high it should be upto 200 Cr on annual basis for any company with a turnover upto 5000 Cr.

8 weeks of time required for the completion of the process cost sheet, and 2 weeks of hyper care support, + 2 Functional resource and 1 ABAP resource

M1 – Project start
M2 – Solution Document sign off
M3- UAT Sign off
M4 – Project Closure

INR 9,00,000/-

9 lacs for complete piece of mind for the cost sheet is a good deal