Section III Management Information System (MIS) 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.

2 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

3 Report 25 9 Insurance Policy Register Compiled by Spandane Management 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.

4 01 Subject Daily Production -- Process wise / Shift wise / Despatches Date A Production Process wise (Qty.) 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.)

5 Compiled by Spandane 2 Management Information System Format No. 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.

6 Stock Dates 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Total Production Less-Sales + Op. 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.

7 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. Date Rs. Date Rs. Rs. Note: Separate folios should be used in respect of each month.

8 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. Sub-Total Less: Cumulative Sales to date UEOB as at Month s Production Budget order intake for the year.

9 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.

10 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.