Strategic Material & Supply Chain MIS

Developing Strategic Material & Supply Chain MIS

Material is an important cost in any business organization. However, in Manufacturing organizations it is prime cost where it can go up to 90% of total cost. Material Control is important function for any MIS. It has primarily four objectives:

  • Improving Material Quality and Customer Satisfaction
  • Reducing Material Cost
  • Ease of Material Availability
  • Improving overall Material Management System

Keeping above objectives in mind following Class of  MIS Reports are generated for Material:

Material Cost Reports: Purpose of these reports is to Plan, Collect and analyze information on Material Cost factors.

Material Quality Reports: Purpose of these reports is to analyze impact of Material Quality on Final Product.

Material Availability Reports: These reports analyze parameters to ensure timely and adequate availability of material for production.

Material Storage Reports: These Reports analyze parameters to check smooth and efficient working of material stores & warehouse.

Procurement Process Efficiency Reports: These reports analyze efficiency of procurement process.

Based on above classifications, key Material MIS Reports which should be generated in any organization  are as below:

A. Strategic Material MIS

  1. Macro Analysis for Material Management
  2. Bottleneck Analysis for Materials
  3. Material Content Improvement MIS
  4. Material Cost Reduction MIS
  5. Material Planning Report

B. Material Quality MIS

  1. Material Quality Improvement Report
  2. Materials Quality Related Rejections Trend
  3. Customer Quality Grievances Report
  4. Production Rejections Analysis Report
  5. Vendor Rejections Analysis Report
  6. Vendors with high Rejections Report
  7. Rejections Cost Performance Report

C. Material Storage MIS

  1. Stock Verification Discrepancy Report
  2. Physical Verification Frequency Report
  3. Stores Physical Condition MIS
  4. SRNS NOT PREPARED
  5. SRN not Accounted For
  6. Material not Returned
  7. Returnable Gate Passes Report
  8. Ageing Analysis
  9. Slow Moving Items Report
  10. Stock Loss at Stores

D. Material Lead Time MIS

  1. Indent & Purchase Order Gap Report
  2. Purchase Order to Supply Time Gap Report
  3. Time Gap for Inspection of Goods Report
  4. Time taken from gate to stores Report
  5. Time taken for issue of material Report
  6. Time taken for release of payment Report
  7. Vendor Wise Supply Delays Report
  8. Item Wise Delays Report

E. Material Price MIS

  1. Price Verification Analysis
  2. Price Composition Trend Report
  3. Foreign Exchange Fluctuation Impact MIS
  4. Price Discounts Efficiency MIS
  5. Price Reduction MIS
  6. Freight Cost Analysis MIS
  7. Demurrage Cost Analysis MIS
  8. Material Price Verification Frequency Report
  9. Adequacy of Quotations Report

F. Purchase MIS Reports

  1. Pending Purchase Orders MIS
  2. Purchase Orders Cancellation MIS
  3. Purchase Orders Revision MIS
  4. Purchase Authority Variation MIS
  5. Vendor Database MIS
  6. New Vendor Development
  7. Vendor Advances Blocked
  8. Material Vendors Ageing MIS
  9. Vendors Balance Confirmations MIS
  10. Legal Vendor Cases Status
  11. Purchase not with lowest bidder’s report
  12. Emergency Purchases MIS
  13. Pending Purchase Requisition MIS
  14. Purchase Order Variation MIS
  15. Pending Disputed Purchases
  16. Stock loss at Material Receipt
  17. Material Return MIS

G. Special Material MIS Reports

  1. Balance Sheet Analysis for Materials
  2. Material Reconciliation MIS
  3. Material Management Process Automation MIS
  4. Production Loss due to Material Availability
  5. Purchase Expenses Analysis
  6. Material Working Capital MIS
  7. Consumables & Packing Cost Analysis
  8. Goods Lost MIS
  9. Insurance Coverage of Stocks MIS
  10. Empty Containers / Bags MIS
  11.  Scrap Treatment MIS
  12. Material Shortage Analysis Report
  13. Material Standards & Ratios Analysis MIS

———————————————————–

Please watch this space for regular articles on Strategy, MIS , Systems, Costing & Audit. For Free Updates & Subscription to CSM Strategy & MIS Journal , Please send request for same in comments or Email given below.

This article is part of publication Strategic MIS. To download SMIS brochure :  https://www.csmstrategy.com/pdf/SMIS_Brochure.pdf

Download complete Product Catalog for Media, Training & Consultancy services  from : https://www.csmstrategy.com/pdf/Catalog.pdf

Call : 9818397806 / 9582497948 / 0120- 4230954.

Email : info@csmstrategy.com

Website : www.csmstrategy.com

Journal : journal.csmstrategy.com

#strategy #MIS #ERP #Systems #Costmanagement #analytics #planning #Audit #HR #Finance #Marketing #operations #Reports #profitmanagement #riskmanagement #supplychainmanagement #operationsmanagement #processimprovement #management #learning #knowledge #corporate #information