Industry Segment : Industry
We are making efforts to see that these start in every company. The benefits are attached.
MD / CEO / Plant head must get
Every day
- Executive summary of all SO, PO, MRR and Invoices for the day
- Pending Sales order Register
- Pending Purchase Order Register
- Snapshot Report of Collection and Payments
EVERY MONDAY
See these reports and discuss their CAPA
For each row
- .. how many… Target vs Actual. .. and CAPA
- Stock Report – Paper Reels – 1 page summary – Reels and Ton in hand
- Stock Report – Paper Reels –Reels wise with Ageing 30-60-90 days columns
- Bit Reel Report .. how many… Target vs Actual. .. and CAPA
- Reels older than 90 days Report
- Stock Report – Paper Reels – Closing Stock value ( to management only )
EVERY TUESDAY
- Stock Report – Ink and Adhesive MTD with value – 4 colm
- Stock Report – Repair and Maintenance Items MTD with value – 4 colm
- All Items below Minimum level
- All Items below Reorder level
- All items above Maximum level
Benefits of These Stores Reports
- Control of the situation
- Know who is entering data and who is not
- Know stock position LIVE ( almost live)
- All people are automatically understand the importance of entering the data live / almost live, since MD will see daily. And MD will rely on them.
- Issue entries are missed in some companies for some groups… will be done, since seen. ( Example Spare Parts and Consumables )
- Stock out position happens in repair items / many items. Since people do not remember to buy in time. This will be prevented if the Minimum levels and Reorder Levels are set + Reports daily monitored
EVERY WEDNESDAY : Finance
- Debtors Outstanding Report – any 1 out of over 10 formats available – as of end of last week
- Creditors outstanding Report – any 1 out of over 10 formats available
- Staff Advance Account Trial Balance and Ledger email to MD
- Imprest Account Trial Balance and Ledger email to MD
- Debtors with Credit Balance ( Advances received ) – YTD date selection
- Creditors with Debit Balance ( Advances received ) – YTD date selection
- Non-moving Accounts
- Cash Flow of this month ( Cash only )
- Funds Flow of this month ( Cash+All Banks) ( All Sources)
EVERY THURSDAY : Sales
- Customer wise Sales Report = any 1 format
- Finished Product wise Sales Report = any 1 format
- Schedule vs Actual // Sale order vs Actual Report = any 1 format
- FG stock in hand report with value – preferably 4 colm ( Year start to date )
EVERY FRIDAY : Purchase
- Pending Purchase Requisitions ( Indents ) == PR made, and not approved
- Pending Purchase Requisitions ( Indents ) == PR approved and Po not made
- Pending Purchase Order == PO made, and not approved
- Pending Purchase Order == PO approved but material not received – any 1 format
- Purchase Schedule vs Actual Report – any 1 format
- Vendor Ratings
- Purchase Estimate for ROL(Reorder level) / MSL( Minimum stock level) items
- Delivery Date based report = Committed delivery date in PO vs actual date ( XLS report)
- Any 1 Rate Comparison Report
- Shipments received late ( after 5 pm) … if your stores works in main shift only.. people who make your stores people stay back late, lead to risk in Qnty check /Quality check
EVERY SATURDAY : Production
This area is as per your ERP configuration.
This list may be modified as relevant to you
For Packaging Plants
- Daily Production Report ( DPR )
- Down Time Report with reasons
- Wastage Report with Reasons
- Material Requirement Planning for this (balance) month, and for next month.
- Job Cards floating on the Production floor for more than 10 days, and not yet closed.
- Job Cards open , and not yet scheduled on any machine
- Job Cards with excess loss due to Ups ./ Paper allocation
- Monthly Tonnage Report = Tons produced each day
- Corrugation Output Report = Sq Metres produced & Tons produced
- Theoratical consumption vs Actual. (* under development / Testing )
Please feel free to revert for any further details/ clarifications required.
Assuring of our best services,
For Making Business Better
Consulting Arm of Finsys Infotech Limited
Sangeet Kumar Gupta
Principal Advisor, (M) = 9312608426