Section III Management Information System (MIS) …

1 SSeeccttiioonn IIIIII MMaannaaggeemmeenntt IInnffoorrmmaattiioonn SSyysstteemm ((MMIISS)) MMIISS FFoorrmmaattss CCoommppiilleedd bbyy:: SSppaannddaannee Compiled by Spandane Management Information System Index - Section III - MIS Formats Format No. Para No. Subject 01 3 Daily Production data 02 3 Production Register / FG Stock (Day wise) 03 4 Order Register 04 4 Bill wise collection Register 05 4 Order book / UPR 06 4 Age wise analysis of Debtors 07 5 Material Inward Register 08 5 Material Receiving & Inspection Report (MRIR) 09 5 Material Issue Report (MIR) 10 5 Stock Register Raw Material & Stores etc. 11 5 Stock Register Work In Process (WIP) 12 5 Stock Register Finished Goods (FG) 13 5 Stock Position Raw Material Stock 5 Stock Position WIP 5 Stock Position FG 15 5 Purchase Order Status Register 16 6 Cash Statement 17 6 Bank Statement 18 6 Telephone Expenses 19 6 Power 20 6 Due date Diary 21 7 Interview Checklist 22 7 Personal Data Form 23 7 Staff Appraisal 24 7 Daily Attendance Report 25 9 Insurance Policy Register Compiled by Spandane Management

2 Information System 2 Format No. Para No. Subject 26 10 Record to be kept by security staff 27 10 Visitor s Gate Pass 28 10 Record of Visitors 29 13 Profit & Loss Account 30 13 Expenses details 31 13 Capital Employed 13 Analysis of RM Stock & Production Yield (Qty) 13 Analysis of RM Stock & Production Yield (Qty) 33 13 Financial Highlights Compiled by Spandane 1 Management Information System Format No. 01 Subject Daily Production -- Process wise / Shift wise / Despatches Date A Production Process wise (Qty.)

3 Shift Remarks 1 2 3 Total 1 Process Name: Production Closing WIP 2 Process Name: Production Closing WIP 3 Process Name: Production Closing WIP 4 Process Name: Production Closing WIP 5 Process Name: Final Packing Production Closing WIP B FG Despatches (Qty.) Compiled by Spandane 2 Management Information System Format No.

4 02 Subject Production Register / FG Stock Day wise (Qty) Product: _____Month: _____Unit: _____ Dates 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Production Less-Sales + Op. Stock Cl. Stock Dates 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Total Production Less-Sales + Op.

5 Stock Cl. Stock Compiled by Spandane 3 Management Information System Format No. 03 Subject Sales Order Register Year Order Customer s Order Customer s name, Address & CUS ID No. Order details No. Date No. Date Product Quantity Rs. Expected delivery Billing details Invoice No. Date Qty billed Rs. Sales Tax /VAT No. / Form Remarks Compiled by Spandane 4 Management Information System Format No. 04 Subject Invoice wise Collection Register Month Invoice Customer Invoice value Collection Balance No.

6 Date Rs. Date Rs. Rs. Note: Separate folios should be used in respect of each month. Compiled by Spandane 5 Management Information System Format No. 05 Subject Order Book / UPR Period Unit Product Quantity Nos. Value Rs. 000 UPR Rs. UEOB beginning of the year Add: Cumulative Orders received till date. Sub-Total Less: Cumulative Orders cancelled till date.

7 Sub-Total Less: Cumulative Sales to date UEOB as at Month s Production Budget order intake for the year. Separate Report should be prepared for each Product. Compiled by Spandane 6 Management Information System Format No. 06 Subject Agewise Analysis of Debtors As on LF Customer O/S Agewise Outstanding Rs. Up to one month > 1 month up to 3 M > 3 months up to 6 M > 6 Months Compiled by Spandane 7 Management Information System Format No.

8 07 Subject Material Inward Register Period: _____ Serial Purchase Order Supplier Item LR Chalan Qty Received No. Date No. Date No. Date No. Date Qty. Purchase Bill Stock Register folio MRIR Bill no. Date Rs. PV No. No. Date Compiled by Spandane 8 Management Information System Format No. 08 Subject Material Receiving & Inspection Report (MRIR) Supplier Serial No of Material Inward register Purchase Order No. & Date MRIR No. Delivery Chalan No. & Date MRIR Date Vehicle No. Material Received on Material Inspected on Sr. No. Description Unit Quantity Stock register folio Remarks Ordered Received Inspected Accepted Rejected Rejected Material Collected by supplier on Letter issued to Supplier on to collect the Rejected Material Stores keeper Material Inspected by Works Manager Compiled by Spandane 9 Management Information System Format No.

9 09 Subject Material Issue Report (MIR) Batch No. MIR No. Issued on Sr. No. Description of Material Unit Qty. before this issue Qty. issued Balance Qty. Stock Folio Remarks Stores Keeper Receiver s Signature Authorised by Compiled by Spandane 10 Management Information System Format No. 10 Subject Stock Register Category Raw Material / Stores / Packing Material / Item description Month Quantity Unit: Date Supplier Rate MRIR Ref. MIR Ref. Receipt Issues Balance MRIR Material Receiving & Inspection Report MIR Material Issue Report Separate folio should be allotted to each item of RM etc.

10 One item with different specification should be treated as different item. Compiled by Spandane 11 Management Information System Format No. 11 Subject Stock Register Category Work In Process (WIP) Item description Period Quantity Date Batch No. MIR Ref. Receipt Issues Balance Note: Separate folio should be used in respect of each of the intermediate product produced. Compiled by Spandane 12 Management Information System Format No.