
f48a81c65af00e04ea612559b7eecc47.ppt
- Количество слайдов: 129
HARRISONS MALAYALAM LIMITED
HARRISONS MALAYALAM LIMITED 2
PACKET SALES (1. 1) HARRISONS MALAYALAM LIMITED 3
DOCUMENTS USED Forms: 1. Consolidated Order from the Area Sales Manager / Sales Development Officer 2. Invoice (Tally and Excel) 3. Gate Pass generated at Warehouse (Manual & MS Word) Reports: 1. 2. 3. 4. 5. 6. 7. 8. Sales Register by HO Sales Register by Area Sales Manager Dealer wise, Super Stockiest wise Sales Pending Payment Report Stock Transfer Report Daily Sales Report (Sales Rep and Sales Officer) Weekly Sales Pattern HARRISONS MALAYALAM LIMITED 4
PACKET SALES – GAP IDENTIFICATION Requirements Customization In almost all the cases, the Invoice is The flow to be modified in AX, such a way prepared only after confirming the Payment. that, after receiving payment, the Invoice should be prepared. In some cases, the Manager’s permission is sought for release of Invoice without receiving Payment. So need both the provisions. Free replacement for sales return items is required. For Sales return items, the system should allow to release the items, without Invoice. HARRISONS MALAYALAM LIMITED 5
Export Sales HARRISONS MALAYALAM LIMITED 6
Export Sales HARRISONS MALAYALAM LIMITED 7
DOCUMENTS USED Forms: üQuotations (in case of CAD Customers) üSales Contract üPre Shipment Invoice üBlend Report üFinal Invoice (Along with Statutory Documents) Reports: üEstate wise Sales Realization üDaily Cash Flow statement üSales Tax returns üMonthly returns to Tea Board, Rubber Board, RBI, ECGE & Insurance üTDS Report (Transporters and Professional services – Inspection agencies) üCreditors payment report (Packing Items & Transporters) üPending Order Statement üExport Packing Credit Statement üTea Purchase Report üBank Reconciliation üCosting Details required for Blending & Packing HARRISONS MALAYALAM LIMITED 8
GAP ANALYSIS Requirements Separate Serial Number for Export is needed. Customization Need to give a separate Sales Order Number Sequence In sales contract (Sales Order), negotiation history Separate Sub-form required to add the negotiation is to be captured. history Blend Master to be maintained for all the varieties Blend Master to be editable and should be available with reference to a variety. Link between the Sales Order (Export) and the Blend Master. In Sales Order (Export), the Blend Master to be linked each Order. When preparing a Sales Picking List Registration, Separate Invoice Sequence number is to be if the material is selected from Bought Stock and attached for the different items (bought and own Own Stock, then they need separate Invoice Crop), Number. The method of Payment should be captured A system to capture the Payment details and separately and it should be linked with the Invoice periodic monitoring of the expiry and the link amount and the expiry details also. between the value and Invoice Amount. Payment details like: BG, LC, Advance etc. HARRISONS MALAYALAM LIMITED 9
GAP ANALYSIS Requirements Pre-shipment Invoice to be prepared for all the Sales Order. Customization The Posting Confirmation can be modified as a Pre-Shipment Invoice as per HML’s Format. Customer Type to be captured at the time of SO CAD – ECGC Registration to be captured. Preparation itself (CAD / CIF / RUSSIAN). CIF – Insurance details to be captured. Based on the Customer Type the details like RUSSIAN – RBI Approval details to be captured. Insurance, ECGC registration, RBI approval to be captured. HARRISONS MALAYALAM LIMITED 10
BLEND MASTER • Blend Master (draft) is a selection of varieties from the existing stock. • Among the available batch number of the variety the stock is selected in certain percentages. • The Stocks are verified and sample blend is made. • Blend is tested for the expected taste and for other criteria. • Blend is ok then Final blend is prepared, and the Master if Finalized. • If the blend is not ok, then new selection of batch numbers or varieties are made in the existing draft blend master. • The new blend is made as per the modified blend master and is checked for quality. • After quality is passed, the modified blend is made as Master Blend Sheet. • A continuous serial number is maintained for every Blend Master. HARRISONS MALAYALAM LIMITED 11
AUCTION SALES HARRISONS MALAYALAM LIMITED 12
AUCTION SALES Forms: • Stock Status Entry Form • Offered / Catalogue / Private Sales / Ex-Auction Sales / Sold. • De-Selection option Entry form for the un-auctioned Stock. • Sample Stock Entry for the Offered / Private Sales / Ex-Auction Sales / Sold • Sales Contract Entry (Sales Order) Form • Delivery Order data to be captured from Broker and to be fed in to the system automatically by uploading the data. • Gate Pass Preparation • Payment receipt Form HARRISONS MALAYALAM LIMITED 13
AUCTION SALES Reports: • Un-Offered Stock Report – Daily. • Offered Stock Report – Daily / Weekly. • Out-Listed Statement • Sales Register • Samples Report. • Stock Report with Status – Offered, Sold and Not Lifted etc. • Offer withdrawal report. • Sales Summary Report – Consolidated Variety wise / Grade Wise / Broker wise / Estate wise / Invoice wise / Buyer wise / Location wise Report. • Tea History. HARRISONS MALAYALAM LIMITED 14
GAP ANALYSIS – AUCTION SALES Requirement Customization required Stock Status editing is required Separate Status selection Form is required to capture this Data against each Batch Number of Stock from various estates. The Status are : Offered, Sold, Catalogue, Private Sales, Ex-Auction Sales, Out-Listed. OR this can be handled through a Transfer Journal by keeping a separate warehouse for each and every status. Samples taken from the batches to be marked. Against the selected batch number the sample taken is marked (A Check box may be used) Delivery Order downloading from Broker’s data. Downloading mechanism required to convert the broker’s data into Invoice. Stock Picking including Sample bags. Stock to be selected based on the delivery order given by Broker (Sample bags) Delivery due date to be entered as per the Broker’s instruction. The Prompt Date (Delivery Date) to be monitored to calculate the Excess Rent from the buyer. Broker commission to be adjusted against their outstanding. Provision required to adjust the Broker Commission and Tax if any against the buyer’s (broker) payment. HARRISONS MALAYALAM LIMITED 15
Bulk Sales HARRISONS MALAYALAM LIMITED 16
Consignment Sales HARRISONS MALAYALAM LIMITED 17
BULK / CONSIGNMENT SALES – GAP ANALYSIS Requirement Customization required Invoice is to be raised only after confirmation of Payment receipt. Flow is to be changed after receipt of Payment, the Invoice option to be enabled. Link to be established. Forward contract letter to be generated. The contract or sales order can be converted as Forward Contract Letter. Collection letter is to be generated. The Picking List can be converted as Collection Letter. In case of Consignment Sales, it is only transfer of goods. In transfer Journal we can maintain, or a separate SO Need to generate a Sales Invoice without value. Sequence can be maintained and can be tracked. After receipt of the Invoice from the Consignee, the actual accounting is to be carried out. The invoice (dummy) to be raised only after receiving the actual Invoice from Consignee. HARRISONS MALAYALAM LIMITED 18
Common to all type of Tea Sales Separate Document Number is required to various type of Sales Orders viz. , Direct, Export, Bulk, Consignee, Auction, Packet, Depot etc. As done for GTL, the Sales Order Sequence to be selected before generating the Sales Order. Only after receipt of Payment, the system should allow to prepare Gate Pass / Invoice. System to be modified to track this. Finished goods dispatched from own crop and bought crop to be identified with a different Invoice numbers. Customization to be done, for single SO, with multiple Invoice Sequence Numbers. Finished goods dispatched from Tamil Nadu Estates and Kerala Estates to be identified with a different Invoice Numbers apart from bought and own crops. Customization to be done, for a single So, with multiple Invoice Sequence Numbers with respect to State wise Estates and Crop. Samples taken to be accounted at the time of Invoicing only. The stock will be knocked off only at the time of Invoicing. Provision to be given to identify the Sample bags, and the sample quantity to be knocked off only at the time of Invoicing. 19
WAREHOUSE MANAGEMENT HARRISONS MALAYALAM LIMITED 20
GAP ANALYSIS - WAREHOUSE Requirement Customization Stock transferred through Transfer Note from Estate to HO warehouse should be editable and the quality parameters to be entered and should be available along with the stock. The Stock editing option is required after posting, and the provision to enter other parameters (Quality) is also required The Quality parameters or modified quantity should be available for source warehouse. Material Receipt Note is to be prepared for the received stock through Transfer Note. A report to be generated for the receipt of the Stock, and another separate report required with the Quality parameters. Stock receipts are stored in warehouses, and the location and bin no details should also be entered along with the received stock. Provision required to enter the Location and Bin details against the received stocks. Tea is stored in rented warehouses also. The stock is to be When the Transfer Note or Delivery Challan is prepared updated while making transactions there also. While the stock should automatically deducted from the Rented receipt, the Location no only is to be entered. Bin is not warehouse. applicable. The Internal transfer within the warehouse is to be allowed with out affecting the location. The internal transfer of stock within the warehouse to be carried out but, the stock will be physically available at the same location, only the stock is moved virtually with in the warehouse location. HARRISONS MALAYALAM LIMITED 21
STOCK ARRIVAL AT WAREHOUSE FROM COIMBATORE HARRISONS MALAYALAM LIMITED 22
DISPATCHES FROM WAREHOUSE HARRISONS MALAYALAM LIMITED 23
ADVERTISEMENT ACTIVITIES HARRISONS MALAYALAM LIMITED 24
PURCHASE OPERATION HARRISONS MALAYALAM LIMITED 25
GAP ANALYSIS Requirements Customization Indent should have the previous purchase order rate with po reference. Customization to be done. Stock of the indent item to be displayed from the respective warehouse and also overall stock separately. Customization to be done. RFQ – Request for Quotation is to be generated for selected vendors. A unique RFQ No to be generated. Customization to be done. Registering of Quotation against the RFQ No. and comparison to be Customization to be done. Auto downloading of data from vendor’s database with respect to Registering Quotations. Customization to be done. Auto generation of Purchase Order for the selected vendor after comparison. Customization to be done. Transportation cost or other expenses to be added to the cost of the material which will be known only after realization of the bill. Provision is already available. To be checked. The valuation is to be effected only after the material has been accepted. When the stock is in Quarantine the cost will be null. Customization to be done. HARRISONS MALAYALAM LIMITED 26
RUBBER ESTATE WORKERS PAY ROLL HARRISONS MALAYALAM LIMITED 27
RUBBER ESTATE GROUP OFFICE INVENTORY HARRISONS MALAYALAM LIMITED 28
GAP ANALYSIS – LATEX RECEIPT AND DESPATCH TO FACTORY Requirement Customization Latex collected at various estates and are forwarded to the Movement Journal to be generated at the respective estate respective factories. and then it has to be transferred to the respective Factories through a transfer journal. The DRC is calculated on the basis of instrument, and is recorded. Which is to be incorporated in the Movement Journal. The Field DRC (separate field) to be entered with the stock of the Latex in the movement journal. And it should be available for transfer journal also. The material transferred through the transfer journal should have a additional field called Factory DRC, which is to be captured at the factory while making Transfer Inward. Provision required to enter the Factory DRC value (separate field), and it should be reflected to the sending estate (warehouse). The actual dry weight that is volume * Factory DRC to be taken into account in Factory Inventory. Latex received at estates thro stock transfer should be identified by a batch number. Allotment of Batch number provision is required for the transferred materials at the destination warehouse / factory. 29
LATEX RECEIPT AT CL FACTORY HARRISONS MALAYALAM LIMITED 30
Forms and Reports Forms: Reports: • Daily Latex and FC Collection from Field, entry form with other details (attendance of Tappers) • Consolidated monthly Rubber Crop Advice based on Yield. • Field DRC Entry form. • The Stock updating register • Stock Transfer Register • Receipt Register at Factory • Monthly Crop Detail Report with Field weight and Factory weight comparisons. • Monthly Field Detail Report with actual and budget comparison. • Daily Latex and FC receipt report. • Factory DRC Entry Form. • Actual Yield Calculation based on the Factory DRC Percentage. • Attendance entry for other workers. HARRISONS MALAYALAM LIMITED 31
CENEX PRODUCTION AND PACKING HARRISONS MALAYALAM LIMITED 32
Forms and Reports – Cenex Production Forms: Reports: • Daily Stock receipt and issue register for Production. • Daily/Monthly Latex and Cenex Stock report • Material Consumption entry • Daily/Monthly Bye product stock report (Skim, Sludge, PRR) • Cenex Output Entry • Cenex parameters Capturing Form • Daily consumption report of chemicals and other materials for production. • Cenex stock updating in Barrels (Packing Entry) with batch and serial numbers own and bought separately. • Daily Cenex parameters monitoring report. • Bye Product Stock Updating form. HARRISONS MALAYALAM LIMITED 33
CENEX SALES HARRISONS MALAYALAM LIMITED 34
SKIM DISPOSAL FROM CL FACTORY HARRISONS MALAYALAM LIMITED 35
SLUDGE DISPOSAL FROM CL FACTORY HARRISONS MALAYALAM LIMITED 36
DISPOSAL OF PIT RECOVERY RUBBER (PRR) HARRISONS MALAYALAM LIMITED 37
RUBBER ESTATE FIELD ACTIVITIES üWeeding (Manual & Chemical) üLining üPest & Diseases üPitting üTree Sanitations üFilling and Manuring üRoads and Drains up-keeping üTerracing üFencing and Boundaries üPlanting and Manuring üSpraying üMucuna Planting üRubber Field Watchers üTree Census üRain guarding üIn-Filling üMarking & Blocking üMother bush Nursery üManuring üRubber Kote application üManure Mixing üPueraria Seed Sowing üStimulant Application üWind damage details Details • The above activities are done either daily, weekly, monthly, quarterly or annual. • Various parameters are captured viz. , No of workers, No of supervisors, No of man-days, Area covered, chemical consumption etc. HARRISONS MALAYALAM LIMITED 38
SKIM PROCESSING & PRODUCTION HARRISONS MALAYALAM LIMITED 39
OTHER SKIM FACTORY ACTIVITIES HARRISONS MALAYALAM LIMITED 40
RUBBER SALES (SKIM FACTORY) HARRISONS MALAYALAM LIMITED 41
ISSUES IN RUBBER ESTATE ACTIVITIES v Some of the Estate Operations are being given on contracts v Presently it is being handled manually v System is required to handle these issues on a systematic manner v Details like: Work done, Pending work, amount paid, Pending amount, Date of commencement and Date of Finish etc needs to be tracked. HARRISONS MALAYALAM LIMITED 42
TSR FACTORY RUBBER PROCESSING HARRISONS MALAYALAM LIMITED 43
TSR RUBBER FACTORY SALES PROCESSING HARRISONS MALAYALAM LIMITED 44
GENERAL FACTORY ACTIVITIES HARRISONS MALAYALAM LIMITED 45
FACTORY LATEX COLLECTION HARRISONS MALAYALAM LIMITED 46
BARREL ACCOUNTING IN RUBBER FACTORY HARRISONS MALAYALAM LIMITED 47
RUBBER SALES – Head Office HARRISONS MALAYALAM LIMITED 48
RUBBER - SALES Reports: Reports Forms: Forms • Allocation Sheet • Agent & Grade wise Report • Agent Intimation Letter (Customer Order) • Estate & Grade wise Report • Invoice • Buyer wise Summary / Detail • Delivery Challan • Bill wise Sales Report • Debit Note (Insurance) • Category wise Sales Report • Credit Note (Brokerage) • Monthly broker wise Commission Report. • Grade wise Report HARRISONS MALAYALAM LIMITED 49
GAP ANALYSIS Requirement Customization required Daily Market price for all the rubbers to be updated in the system based on the Malayalam Manorama News paper. Separate Form is required to capture this Data. Provision required to reserve the Stock to a particular Buyer or Agent, once the Stock is allotted to him. A separate mechanism is required to capture / record the status of the stock when it has been allotted to a buyer / agent. Provision required to prepare Allocation Sheet with the current stock and the next week production. The Stock of the forth coming week production to be taken into account based on the weekly production if needed estate wise. The Rate for the stocks referred in the Allocation Sheet The rates for other varieties are calculated based on the should be automatically calculated based on a percentage RSS 4 and RSS 5 prices entered in the system referred by of the RSS 4 and RSS 5 prices of that days’ price. Malayalam Manorama. The premium of increase or decrease will be given. Collection of respective Statutory Forms and their numbers are to be captured and report needs to be prepared on pending forms on a particular date. During Sales Order / Invoicing the necessary forms required to be captured and after receipt the date of receipt to be entered. In summary reports, the DRC of the Stock of each and every variety is required to calculate the actual yield. Report need to be generated along with the variety and its DRC Percentage to arrive the actual yield. HARRISONS MALAYALAM LIMITED 50
GAP ANALYSIS Requirement Customization required Separate Sales Order Sequence Number is required for Own Crop Sales and Bought Crop Sales. Selection is required while preparing Sales Order ‘Own Crop’ / ‘Bought Crop’. Invoice Number sequence is to be different for different Sales order Sequence. Based on the Sales Order sequence / Type, the Invoice Number should pick the appropriate Serial Number. Invoice should have the Batch Number, Barrel Nos. / Bale Nos. Barrel Nos. and Bales Nos. to be captured and to be printed as a range. HARRISONS MALAYALAM LIMITED 51
Rubber Sales Requirements • Daily Market price for all the rubbers to be updated in the system based on the Malayalam Manorama News paper. Separate Form is required to capture this Data. • In summary reports, the DRC of the Stock of each and every variety is required to calculate the actual yield. • Provision required to prepare Allocation Sheet with the current stock and the stock of next weeks production. The Stock of the forth coming weeks production to be taken into account based on the weekly production if needed. • The Rate for the stocks referred in the Allocation Sheet should be automatically calculated based on a percentage of the RSS 4 and RSS 5 prices of that days’ price. The rates for other varieties are calculated based on the RSS 4 and RSS 5 prices entered in the system referred by Malayalam Manorama. The percentage of increase or decrease will be given. • Collection of respective Statutory Forms and their numbers are to be captured and report needs to be prepared on pending forms on a particular date. During Sales Order / Invoicing the necessary forms required to be captured and after receipt the date of receipt to be entered. • Provision required to reserve the Stock to a particular Buyer or Agent, once the Stock is allotted to him. A separate mechanism is required to capture / record the status of the stock when it has been allotted to a buyer / agent. HARRISONS MALAYALAM LIMITED 52
RUBBER - BOUGHT OPERATIONS HARRISONS MALAYALAM LIMITED 53
MEDICAL ACTIVITIES HARRISONS MALAYALAM LIMITED 54
ENGINEERING ACTIVITIES-CIVIL HARRISONS MALAYALAM LIMITED 55
ENGINEERING ACTIVITIES-CIVIL - Execution HARRISONS MALAYALAM LIMITED 56
ENGINEERING PROJECTS – BILLING HARRISONS MALAYALAM LIMITED 57
OTHER ENGINEERING ACTIVITIES Ø Labour bills are processed based on the work done, in progress works statement from the Site supervisor on a monthly basis. Ø Comparison statement is generated on a monthly basis between the Planned work and Actual work against the dead line. Ø Monthly Fund utilization and monthly billing statements are compared with the budgeted Project cost. Ø Aging analysis on payment is prepared and followed up based on Project. Ø Monthly Stock statements are prepared. Ø Works done Statement, Work in Progress Statement. Ø Consumption statement break up (job wise). HARRISONS MALAYALAM LIMITED 58
PAY ROLL PROCESSING HARRISONS MALAYALAM LIMITED 59
INVENTORY OPERATIONS HARRISONS MALAYALAM LIMITED 60
INVENTORY OPERATIONS Ø Stock statement is prepared and are forwarded to the respective sub-stores. Ø Sub-Stores acknowledge the stock after reconciling their stock. Ø Expenses incurred during the receipt of the material (like Loading & Unloading) are accounted in the same MRR and the cost is added to the Material cost. Ø Material cost is altered and it affects all the previous transactions according to the new cost of the material. HARRISONS MALAYALAM LIMITED 61
ORTHODOX FACTORY GREEN LEAF ARRIVAL HARRISONS MALAYALAM LIMITED 62
ORTHODOX TEA PROCESSING HARRISONS MALAYALAM LIMITED 63
PACKING AND INVOICING HARRISONS MALAYALAM LIMITED 64
OTHER FACTORY ACTIVITIES Ø Fuel Consumption Details: Ø Electricity Consumption reading. Ø Generator Reading Ø Diesel Consumption Ø Fire wood and other fuel monitoring and registering Ø Muster Roll activities Ø Incentive and Overtime Calculation Ø Regular wage and attendance calculation Ø Night Shift and Washing allowance calculation HARRISONS MALAYALAM LIMITED 65
DOCUMENTS Ø Documents Used: Øo Green Leaf Arrival Record Øo Withering Trough Log book Øo Roller details data Øo Dryer parameter Log book Øo Density Calculation register Øo Inventory Register Øo Bin Card Øo Invoice Copy Øo Gate Pass. o Quality Report (SAILV) HARRISONS MALAYALAM LIMITED 66
CTC FACTORY GREEN LEAF ARRIVAL HARRISONS MALAYALAM LIMITED 67
CTC RACTORY – TEA PROCESSING HARRISONS MALAYALAM LIMITED 68
CTC TEA PACKING & INVOICING HARRISONS MALAYALAM LIMITED 69
OTHER ACTIVITIES IN CTC FACTORY Fuel Consumption Details on Daily basis EB Reading Details Generator Reading Details Diesel Consumption Fire Wood Consumption Muster Roll Regular Wage Attendance Register Incentive/Overtime Calculation Register Night Shift Allowance Register Washing Allowance Register & etc Work Shop Activities Milling of shredder blades are taken after certain kg of Green Leaf is processed. Record on milling of shredder is maintained HARRISONS MALAYALAM LIMITED 70
FINANCE & ACCOUNTS ACTIVITIES HARRISONS MALAYALAM LIMITED 71
OTHER CROPS – TEA ESTATE HARRISONS MALAYALAM LIMITED 72
LEGAL DEPARTMENT HARRISONS MALAYALAM LIMITED 73
LEGAL DEPARTMENT REQUIREMENT Ø LEGAL PROCEEDING NEEDS TO BE TRACKED Ø Case No, Hearing Date, Outcome of Hearing, Court fee etc. Ø TRACKING OF BILLS REQUIRED Ø Case No, Bill Date, Amount, Method of payment, So far paid, Payment for, Cheque / DD details etc. Ø PROVISION REQUIRED TO TRACK ESTATE DETALS ALSO S. No. Case # Date of Filing Name of the Party Estate Details Lawyer detail Payment Dt of Payment for Method of Payment Bill No Name of Court HARRISONS MALAYALAM LIMITED 74
TRADE MARK REGISTRATION Ø TRADE MARKS ARE IDENTIFIED AND FILED FOR REGISTRATION Ø OFFICIAL NUMBER IS MAINTAINED FOR EACH AND EVERY GRADE ØPAYMENT DETAILS ARE MAINTAINED AGAINST EACH GRADE AND THE STATUS ARE MAINTAINED. S. No. Name of the Trade Mark Date of Application Official Number Date of Registration Amou nt paid Details of Payment Method of Payment Date of Payment HARRISONS MALAYALAM LIMITED 75
HR RECRUITMENT & SELECTION HARRISONS MALAYALAM LIMITED 76
TRAINING & DEVELOPEMNT ACTIVITIES HARRISONS MALAYALAM LIMITED 77
STAFF SALARY CALCULATION HARRISONS MALAYALAM LIMITED 78
OTHER HR ACTIVITIES Ø EMPLOYEE HISTORY Ø TRACEABILITY OF RECORDS OF CANDIDATES APPLIED FOR JOB Ø BASED ON Date of Birth AND Date of Joining, THE EMPLOYEE SERVICE RECORDS REPORTS TO BE GENERATED. Ø KEEP TRACK OF EMPLOYEE TRAINING PROGRAMS Ø MEDICAL INSURANCE AND MEDICAL ALLOWANCES Ø VARIOUS REPORTS REGARDING Ø TRANSFERS Ø EMPLOYEE ADDITION, AND DELETION DETAILS Ø EMPLOYEE DEPARTMENT WISE GRADE WISE STATUS HARRISONS MALAYALAM LIMITED 79
COIMBATORE FACTORY ACTIVITIES HARRISONS MALAYALAM LIMITED 80
TEA ARRIVAL AT COIMBATORE ` Factory - Coimbatore HARRISONS MALAYALAM LIMITED 81
DISPATCHES Factory - Coimbatore HARRISONS MALAYALAM LIMITED 82
AUCTION SALES Factory - Coimbatore HARRISONS MALAYALAM LIMITED 83
INTERNAL TRANSFER Factory - Coimbatore HARRISONS MALAYALAM LIMITED 84
CONSIGNMENT SALES Factory - Coimbatore HARRISONS MALAYALAM LIMITED 85
DIRECT SALES Factory - Coimbatore HARRISONS MALAYALAM LIMITED 86
BLENDING PROCESS Factory - Coimbatore HARRISONS MALAYALAM LIMITED 87
INVENTORY MANAGEMENT Factory - Coimbatore HARRISONS MALAYALAM LIMITED 88
EXECUTIVE - SALARY PROCESSING HARRISONS MALAYALAM LIMITED 89
STAFF – SALARY PROCESSING HARRISONS MALAYALAM LIMITED 90
PAYROLL AND OTHER ACTIVITIES HARRISONS MALAYALAM LIMITED 91
FIXED ASSET MANAGEMENT HARRISONS MALAYALAM LIMITED 92
DISPOSAL OF FIXED ASSET HARRISONS MALAYALAM LIMITED 93
TRANSFER OF FIXED ASSET HARRISONS MALAYALAM LIMITED 94
SALES TAX / VAT Taxation HARRISONS MALAYALAM LIMITED 95
SERVICE TAX 25% of total bill value of transports services rendered from out side attracts service tax. Taxation HARRISONS MALAYALAM LIMITED 96
TDS @ HO Taxation HARRISONS MALAYALAM LIMITED 97
FRINGE BENEFIT TAX Taxation HARRISONS MALAYALAM LIMITED 98
VENDOR PAYMENT PROCESSING Accounts/Finance HARRISONS MALAYALAM LIMITED 99
TREE SALES Accounts/Finance HARRISONS MALAYALAM LIMITED 100
CONSOLIDATION OF ESTATE-TRIAL BALANCES Monthly / Quarterly basis • Trial balance of each estate is captured from Net Harvest Application • The Estate expenses are consolidated and are charged in HO account by means of reallocation. • The consolidated expenses are arrived in to Schedule VI format. Accounts/Finance HARRISONS MALAYALAM LIMITED 101
SCRAP SALES - ACCOUNTING Accounts/Finance HARRISONS MALAYALAM LIMITED 102
ACCOUNTING - ENGINEERING General Activities Allot Job Order number for all finalized Tenders. Update the Engineering Job register Issue Order Acceptance Letter Preparation of Detailed Specification ( budget) Arrangement of Preliminary requirement. Payment of Preliminary expenses Sub Contracting Activities Receive Quotations from Subcontractors Obtain approval from GM Engineering Preparation of Work Order HARRISONS MALAYALAM LIMITED 103
ACCOUNTING - ENGINEERING Payment Activities Labour Bill • Work done, WIP, Work done but not paid reports are received from the Site supervisors. • Bills from Subcontractor’s are received on a monthly basis. • Technical department prepares Invoice based on Sub contractor’s Bill. • Cross verification of Bills and Invoice with budget. • Payment is made after deducting retention money. Material bill through Work order • Preparation of Work order by Technical department based on approved prices. • Cross verification of Work order with Budget and obtain approval from GM Engineering. • If prices exceed budget, obtain approval from Vice President-Finance • Based on supply of material Weekly Advance payment made to Sub contractor. • Receives bill from subcontractor on fortnight basis, cross verification is done with site stock register and the bill is accounted. • Material bills are settled on monthly basis. HARRISONS MALAYALAM LIMITED 104
ACCOUNTING - ENGINEERING Material bill through Purchase order • Purchase orders are raised for the materials. • Materials are received at Site and the stock register is updated. • MRR and Bills are forwarded to Materials and is verified with the PO and Stock register. • Payment for Fabrication and for other connected jobs will be paid on the basis of certification of Job-in-charge and if required by project manager. HARRISONS MALAYALAM LIMITED 105
ACCOUNTING - ENGINEERING Receipts Sales Income • Based on percentage of work done, Technical department raises invoice and forward it to the client and a copy to finance for information. • Obtain client Certification on the Invoice raised by Technical Department. • Based on client certification Finance department prepares Tax Invoice and books the Income & Tax payable. Other Income • Income from sale of Scarp and damaged fixed asset are monitored by Finance department. HARRISONS MALAYALAM LIMITED 106
ACCOUNTING - ENGINEERING Reports • Daily Cash flow statement prepared based on receipts and payments • Statement of service tax payable on Monthly basis. • Statement of Vat payable on Monthly basis. HARRISONS MALAYALAM LIMITED 107
General MIS Reports Rubber and Tea Periodicity of reporting Monthly, Quarterly, Half Yearly and Yearly Method of reporting Estates wise Group wise Consolidation of All Estates. Types of Reports Field Expenditure comparison Factory expenditure comparison. HARRISONS MALAYALAM LIMITED 108
General MIS Reports Parameters used for Variance Analysis • Man days • Field cost per Kg • Field cost per Hectare • Factory cost per Kg • Factory cost per Hectare Method of presentation Used • Account Head wise HARRISONS MALAYALAM LIMITED 109
MIS –RUBBER Reports on Estates Data Collection • Data received from each estate on daily basis on account of Daily crop and rain fall etc. • A consolidated statement received on month wise after adjusting the final crop. Reports • Statement of Total quantity produced and purchased on each month. • Statement of Variance between Budgeted and actual figures on month wise, upto date wise and the same month in the previous year. • Statement of yield per hectare on monthly basis. • Statement of yield per man days. • Calculation of Latex percentage and FC percentage in the Total crop. • Statement of DRC percentage calculation on monthly basis. • Calculation of Labour Productivity. HARRISONS MALAYALAM LIMITED 110
MIS –RUBBER Report on Factory Data collection. • Crop Advice from each Factory and estates for own Crop and purchase on monthly basis. Reports. • Separate monthly report on Production from own Crop and bought latex is generated factory wise. • Statement of Grade wise production for each month. • Statement of summary of all Grade wise production on monthly basis. • Statement of cost of manufacture for each factory. • Statement of FC purchase on monthly basis. • Statement of Cenex purchase on monthly basis. HARRISONS MALAYALAM LIMITED 111
PLANT TISSUE CULTURE HARRISONS MALAYALAM LIMITED 112
PTC - Production • Multiplication • Shooting • Rooting P. T. C HARRISONS MALAYALAM LIMITED 113
PTC - Production P. T. C HARRISONS MALAYALAM LIMITED 114
Production Process P. T. C HARRISONS MALAYALAM LIMITED 115
Sales / Dispatch Details P. T. C HARRISONS MALAYALAM LIMITED 116
Inventory Activities P. T. C HARRISONS MALAYALAM LIMITED 117
Reports - PTC • Daily Receipt / Issue Details • Location Report • Rejection Report • Daily Stock Report • Sales / Dispatch Report All the reports are generated based on: • Date / Day Wise • Clone Wise • Location Wise • Stage Wise • Operator Wise • Inoculation Date wise P. T. C HARRISONS MALAYALAM LIMITED 118
DAIRY FARMING 1. Introduction Data 2. Observation Program 3. History Data (Ailment Data) 4. Milking Data 5. Breeding History HARRISONS MALAYALAM LIMITED 119
Cow – Introduction Data The Data observed at the time of inception are: • Transit Insurance • Doctors Details and Certificate on Cow • Cow Identification Number • Name and Address of the Seller • Breed (Type) • Age of the Cow (As per seller and as per Doctors Certificate) • Number of Lactation (as per seller and as per Doctors Certificate) • Calving Date (as per seller and as per Doctors Certificate) • Sex of the Calf • Lactation yield • Body weight HARRISONS MALAYALAM LIMITED 120
Cow - Observation Program The Cows bought from outside are put into Observation (Quarantine) for a stipulated period and the following details are observed. • Quarantine Period (No. of days) • Average yield observed (Liters / Day) • Vaccination Program – Intervals • Body weight • Cow Identification Number HARRISONS MALAYALAM LIMITED 121
Cow History In case, if a cow is gone for treatment on some ailment, then the details are recorded and monitored. • Date of ailment reported. • Reported by. • Signs reported. • Diagnosis / Treatment recommendations • Test Results (if any) • Details of Treatment given • Recovery Time / Next Checkup date • Current Status HARRISONS MALAYALAM LIMITED 122
Milking Details The milking data on each and every cow is observed on a daily basis, and the graph on yield is also arrived based on the data. • Cow ID No • Daily yield (with break up of no. of milking maximum 4 times) • Weekly yield (auto based on daily yield) • Monthly yield (auto based on daily yield) • Lactation yield • Graph Details based on the observed Data. HARRISONS MALAYALAM LIMITED 123
Cow - Breeding 1. Date of Calving 2. Calving type (Normal, Aborted, Still birth, Cesarian) 3. Sex of the calf 4. Expected Heat Date 5. Missed Heat 6. Insemination date 7. Semen / Bull variety reference 8. Cow Status Interval (Semen not present again go to step 6) 9. Expected Calving Date 10. Dry Off 11. Step up Date (Preparation of Calving) – Maternity 12. Actual Calving Date HARRISONS MALAYALAM LIMITED 124
Progress on ERP - ABS • Purchase Cycle – Complete cycle is completed after incorporating the modifications. • Rubber Sales – Rubber Sales is configured, subject to • Factory projection, Base minimum, Number of days crop to be given by HML. • Rubber Production – Production module is in progress. • Will be ready for demo by next week. • Tea Production – Tea production is in progress. • Tea Sales – Tea Sales is in connection with Tea Production. – Priority in on Tea Production and progress in on that. Will be ready for demo by next week. • Finance & Accounts – This module is linked with all other modules. Simultaneously working on this modules. 125
DATA Required from HML • Vendor Master – The Address of Vendors are required. • Customer Master – The Address of Customers are required. • Chart of Accounts – Chart of Accounts need to be finalized. • Rubber Sales – The forward projection formula is required. • Financial Dimensions – The Rubber Estate Dimension need to be finalized. 126
SUPPORT REQUIRED FROM HML • Involving/Exposing HML IT personnel in customization. • ABS will support in implementing these modules. 127
Financial Module • Budget module needs explanation • Fixed Asset module Pay Roll • Pay Roll module 128
Thank you HARRISONS MALAYALAM LIMITED 129