Refurbishment of Spare Parts

Purpose and Benefits: Purpose   Faulty repairable spares is maintained to re-use in company, the spare part will have different valuation type to represent different values  Benefits  A high value spare part or critical part will be managed with serial number. It will help to manage each piece of this spare part  Refurbishment process will help to reduce the spare parts inventory cost.  Detailed Process...

Read More

Material Purchasing & Replenishment SOP

1.0  PURPOSE: The purpose of this procedure is to provide guidelines for managing material master data, purchasing & replenishment of material for better results in any organization. This SOP guide the concerned in a respectable way for the favor of companies.. 2.0 SCOPE: This procedure covers steps involved in material creation, extension, deletion or any other action related to Material Master Data and PR (purchase requisition)...

Read More

How to Dispose-Off the Scrap Material

1.0    PURPOSE: The purpose of this procedure is to provide guidelines for removal of scrap material from company. 2.0    SCOPE: This procedure covers the responsibility and the actions required for removal of material declared as scrap in store from Generating Stations 3.0 DEFINITION: Scrap can be considered as any store item or substance, which is useless material or a broken, worn out, contaminated or spoiled...

Read More

Emergency or Off Days Warehouse Opening Closing SOP

1.0 PURPOSE: The purpose is to define the Opening and Closing of Store and to control entry into Store in emergency & off-days.. 2.0 SCOPE: This procedure covers all the activities for Store opening and closing during normal working days, off days / holidays and emergency situation during off working hours at all Generating Stations. 3.0 DEFINITION: HOD – Head of Department CCR – Central Control Room 4.0 RESPONSIBILITIES: Store...

Read More

Standard Store Operations

1.0 PURPOSE: The purpose is to define the functions relating to all activities within the main Stores and to define a method of Stores Control. 2.0 SCOPE: This procedure covers all the activities for Stores Operations at stations.  3.0 DEFINITION: Material Receipt Intimation (MRI) via email Goods Receiving Note (GRN) Debit Note  (DN) Debit Transfer Note (DTN) Credit Note (CN) Delivery Challan (DC) Dispatch Note / Gate Pass...

Read More

SOP For Capex Material/Items Returning Proedure

With the help of this SOP I will highlight the following points. 1) PURPOSE 2) SCOPE 3) DEFINITION 4) RESPONSIBILITIES 5) PROCEDURE 6) RELATED DOCUMENTS 1. PURPOSE: The purpose of this procedure is to provide guideline for handing over returnable Capex Spares to Store/Warehouse and issuance for refurbishment /repair, re-use, etc.  2. SCOPE: This procedure is applicable to all the material including:  1) Capex Spares (organization/company related) – Removed from workplace. 2)...

Read More

Detail Explanation of VLookup Usage (Advance Excel)

Let start sharing with the detail explanation of VLookup command in Advance Excel, there are many advance formulas in MS-Excel 2007, by proper using of these formulas anyone can compile many types of reports. VLookup command is very useful command, by using this command you can easily sought out your required data in specific field. I will share conditionally use of VLookup command in next post.  I will try to share my details in a easy...

Read More

Tools Management in Inventory Management

There are many most important operations in inventory management, to manage inventory in a proper way for all organization it is necessary. All companies/organizations designs SOP's (standard operating plans) for their multiple operation in different areas/sector/departments. Basically SOP's are just like tutorials, working methods or operational process and companies/organizations can bound their concerned department to work as per their SOP's.  I want to share with my friends a short introduction of Tools handling SOP. Tools management...

Read More

Re-Usable Items entry in system using VB

As I have already shared with you about “Re-Usable Items” practice, their purpose and benefits now I want to share my experience about an application for recording all transaction regarding “Re-Usable Items”. With the help of this application I never lose any record from my system and easily sought out any record, it can also help for compiling many types of reports in a second.  You can use MS-Excel too for this purpose, but there are many chances of mistakes, deletions, additions etc without your knowledge because MS-Excel is manual entry...

Read More

Re-Usable Items in Inventory Management

Today I am sharing a profitable idea in inventory management by which you can save lots of money of your companies. During my professional career I learn a practice of “Re-Usable Items” in an energy sector. I was the part of inventory management in energy sector and this “Re-Usable Item” practice save a huge amount of my company. By using this practice you can save your purchasing, searching, and space. What is “Re-Usable Items” practice? Basically this is practice is focusing on your efficiency.  For example:  “I am quoting...

Read More

SAP Material Requirement Planning (MRP) MM01

Material requirements planning (MRP) is to monitor stocks and in particular to automatically generate order proposals for purchasing or production. For this purpose you can define re-ordering levels to your stocks/material, by this SAP automatic intimate the defined user when the stock level go down from the re-ordering level. Field Name R/O/C Description MRP Type R Key that determines whether and how the material is planned. Select as follows:  - VB for stores and spares  - PD for production related...

Read More

SAP (MM) Material Creation (MM01) Ch-1

All the information your company needs to manage a material is stored in a data record in the material master. For every material that ABC used must create a material master record in the material master, This record is uniquely identified by a system generated material number. The creation / change / deletion of material master in SAP system has to be carried out with reference to the material master form. This form will contain the data...

Read More

Age Calculation in MS Excel

I have to tell you about a hidden function of Microsoft Excel, by using this function you can easily calculate the age in days, months & years. You can calculate a persons age based on their birthday and date of today. The calculation uses the DATEDIF() function. The function of DATEDIF() is not documented/covered in Excel versions i.e. (5, 7, 97), but it is available in version 2000. It is a wonder that what Microsoft...

Read More