Strategic Material & Supply Chain MIS

Developing dynamic Strategic MIS Framework for Material & Supply Chain function.

Material & Supply Chain efficiency is integral to Sustainable Profit Growth Framework (SPGF). ?Material is an important cost in manufacturing & project companies and can go up to 90% of total cost. ?Strategic Material & Supply Chain Management has primarily four objectives:

?a. Improving Material Quality and Customer Satisfaction

b. Reducing Material Cost

c. Ease of Material Availability

d. Improving overall Material Management System

?Keeping above objectives in mind following Class of Strategic MIS Reports need to be generated for Material & Supply Chain:

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

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

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

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

?e.???? 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

?

Strategic MIS & Audit : Compilation of above Strategic MIS Reports forms a basis for conducting Operational & Cost Audit for Material & Supply Chain function.

This article is part of publication?Strategic MIS (Total Management Controls, Reports & Systems Manual). ?All rights are reserved with author

#strategic MIS #systems #cost #profit #planning #sustainable profit growth

?