Tally ERP 9 for Dairy Tally Solutions Pvt

Tally. ERP 9 for Dairy © Tally Solutions Pvt. Ltd. All Rights Reserved

Agenda • Dairy Business – An Overview • Structure of Dairy Operations • Tally. ERP 9 for Dairy • Business Process Flow • Primary Requirement • Tally. ERP 9 – Fitment © Tally Solutions Pvt. Ltd. All Rights Reserved 2

Structure of Dairy Operations Procurement Management Dairy Management Accounts Receivables & Payables Milk Quality Management Sales & Distribution © Tally Solutions Pvt. Ltd. All Rights Reserved MIS Reports Incentive Management 3

Dairy – An Overview © Tally Solutions Pvt. Ltd. All Rights Reserved 4

Dairy – Procurement Management Dairy Management Accounts Receivables & Payables Milk Quality Management Sales & Distribution © Tally Solutions Pvt. Ltd. All Rights Reserved MIS Reports Incentive Management 5

Process Flow – Procurement Management © Tally Solutions Pvt. Ltd. All Rights Reserved 6

Primary Requirement – Procurement Management Category / Module Procurement Management Major Requirement Explanation Single procurement Individual farmer wise milk will be procured in morning or evening sessions and categorized as buffalo or cow milk. Multi procurement/ Route wise collection Information of route wise collection of milk can be collected. The procured milk details can be altered whenever the corrections are needed. Procurement return Milk is returned if it becomes sour or gets spoiled in some of the cases. Purchase route creation Purchase routes and the supervisor for each route are to be created along with number of trips made in a day, time taken and distance Price tables (SNF , FAT % based) Price table is created as per the SNF and FAT content in the milk. These price tables keep changing and these tables can be automatically created. Farmer payment Farmer details are collected and payment can be made for a week/month/specific period. There should be an option to pay advance to the farmer. © Tally Solutions Pvt. Ltd. All Rights Reserved 7

Tally. ERP 9 Fitment – Procurement Management SL No. Requirement Part of Tally. ERP 9 Part of Solution 1 Collection center management Yes 2 Supervisor details Yes 3 Purchase route Yes 4 Village details Yes 5 Farmer details Yes 6 Pricelist based on SNF and FAT % Yes 7 Collection center with address, contact details Yes 8 Collection center alteration Yes 9 Liter to KG conversion Yes 10 Purchase route management Yes 11 Supervisor creation for purchase routes Yes 12 Village creation along with route Yes © Tally Solutions Pvt. Ltd. All Rights Reserved Contd. . 8

Tally. ERP 9 Fitment – Procurement Management SL No. Requirement Part of Tally. ERP 9 Part of Solution 13 Farmer details, contact details Yes 14 Agent details, code Yes 15 Farmer bank details Yes 16 Automatic creation of price list Yes 17 Truck sheet shift Yes 18 Truck route Yes 19 Truck sheet farmer wise Yes 20 Truck sheet agent wise Yes 21 Truck sheet samiti wise (collection wise) Yes 22 Driver information Yes 23 Milk truck information Yes 24 Procurement invoices © Tally Solutions Pvt. Ltd. All Rights Reserved Yes Contd. . 9

Tally. ERP 9 Fitment – Procurement Management SL No. Requirement Part of Tally. ERP 9 Part of Solution 25 Godown management Yes 26 Actual and billed quantity Yes 27 Farmer wise milk info Yes 28 Batch bifurcation (morning/evening) Yes 29 Automatic purchase invoice 30 Milk grade (Buffalo and cow) Yes 31 Procurement returns Yes 32 Advance payments to farmers Yes © Tally Solutions Pvt. Ltd. All Rights Reserved Yes 10

Dairy – Milk Quality Management Procurement Management Dairy Management Accounts Receivables & Payables Milk Quality Management Sales & Distribution © Tally Solutions Pvt. Ltd. All Rights Reserved MIS Reports Incentive Management 11

Primary Requirement – Milk Quality Management Category / Module Milk Quality Management Major Requirement Explanation Milk quality and statistics in the order Details like temperature, quantity in litres, quantity in kilograms, LR, CLR, Fat, SNF and prices need to be recorded while procurement. Price lists based on quality parameters Procurement price is decided based on the quality parameters of the milk. The payments are made based on this standard price table. © Tally Solutions Pvt. Ltd. All Rights Reserved 12

Tally. ERP 9 Fitment – Milk Quality Management SL No. Requirement Part of Tally. ERP 9 Part of Solution 1 SNF factor (SNF Table) Yes 2 Capture fat percentage Yes 3 Capture temperature of milk Yes 4 Milk solid information Yes 5 CLR factor, LR factor Yes 6 Price lists based on quality Yes 7 Pasteurization Yes 8 Milk byproducts Yes 9 Milk delivery time tracking Yes 10 Milk rejection parameter Yes 11 Auto SNF calculation Yes 12 Milk units (Cans/jars/tins/litres) © Tally Solutions Pvt. Ltd. All Rights Reserved Yes 13

Dairy – Sales & Distribution Procurement Management Dairy Management Accounts Receivables & Payables Milk Quality Management Sales & Distribution © Tally Solutions Pvt. Ltd. All Rights Reserved MIS Reports Incentive Management 14

Process Flow – Sales & Distribution © Tally Solutions Pvt. Ltd. All Rights Reserved 15

Primary Requirement – Sales & Distribution Category / Module Sales & Distribution Major Requirement Explanation Crates management Crates issue and tracking of empty crates is a major requirement. Milk crates management becomes key when the distribution is large and to several retailers. Sale route management Purchase routes and the supervisor for each route are to be created along with number of trips made in a day, time taken and distance. Sales order management Sales orders need to be created as per the routes and the as per the customer preferences. The customer specific items could be preselected while creating the sales order. Sales returns Several times the milk products get spoiled, the packaging gets damaged or some of the unsold items are returned to the godown. The sales return is done against a sales order with proper order tracking. © Tally Solutions Pvt. Ltd. All Rights Reserved 16

Tally. ERP 9 Fitment – Sales & Distribution SL No. Requirement Part of Tally. ERP 9 Part of Solution 1 Milk products management Yes 2 Product categorization Yes 3 Milk selling units Yes 4 Milk sales account creation Yes 5 Marketing executive details, contact details Yes 6 Sales route creation Yes 7 Number of kilometers per trip Yes 8 Time taken per trip Yes 9 Number of trips in a day Yes 10 Customer creation 11 Customer wise product list Yes 12 Customer wise transport incentive Yes © Tally Solutions Pvt. Ltd. All Rights Reserved Yes Contd. . 17

Tally. ERP 9 Fitment – Sales & Distribution SL No. Requirement Part of Tally. ERP 9 Part of Solution 13 Dairy sales order Yes 14 Dairy sales return Yes 15 Route wise sales order Yes 16 Automatic incentive calculation Yes 17 Sales voucher 18 Product sales return 19 Bill wise tracking of sales order – Reference number 20 Automatic posting of sales orders Yes 21 Automatic posting of sales returns Yes 22 Crates management Yes 23 Empty crates issue and return Yes 24 Scrap/leak management Yes © Tally Solutions Pvt. Ltd. All Rights Reserved Yes Yes Contd. . 18

Tally. ERP 9 Fitment – Sales & Distribution SL No. Requirement Part of Tally. ERP 9 Part of Solution 25 Packaging management Yes 26 Discounts Yes 27 Marketing executive commissions Yes 28 Order short closure Yes 29 Refunds management Yes 30 Dispatch management Yes © Tally Solutions Pvt. Ltd. All Rights Reserved 19

Dairy – Incentive Management Procurement Management Dairy Management Accounts Receivables & Payables Milk Quality Management Sales & Distribution © Tally Solutions Pvt. Ltd. All Rights Reserved MIS Reports Incentive Management 20

Primary Requirement – Incentive Management Category / Module Incentive Management Major Requirement Explanation Periodic incentive Incentives are given daily, weekly, fortnightly, monthly, 4 week month, quarterly, half yearly and yearly. The Farmer, village, route and the amount of milk on which the incentive should be given, what is the incentive per litre also needs to be tracked. Quantity based incentive for farmer tracks the milk quantity given in some specific number of days and incentives are calculated based on that. Quality based incentive Incentives are calculated based on SNF and Fat calculations. This can be calculated for a specified amount of milk or for specified number of days. Incentive payments Annual/Periodic incentives can be paid to all farmers in one shot. The incentive calculations are automatically done for each party. © Tally Solutions Pvt. Ltd. All Rights Reserved 21

Tally. ERP 9 Fitment – Incentive Management SL No. Requirement Part of Tally. ERP 9 Part of Solution 1 Incentives with route based Yes 2 Incentives with village information Yes 3 Incentives with farmer details Yes 4 Incentive per litre calculations Yes 5 Periodic incentives – monthly, weekly, annual etc. Yes 6 Quantity based incentives Yes 7 SNF/FAT based incentives Yes 8 Incentive payment for specific dates Yes 9 Automated payment vouchers Yes 10 Farmer payment vouchers 11 Total incentive calculations Yes 12 Incentive reports Yes © Tally Solutions Pvt. Ltd. All Rights Reserved Yes Contd. . 22

Tally. ERP 9 Fitment – Incentive Management SL No. Requirement Part of Tally. ERP 9 Part of Solution 13 Procurement incentive chart Yes 14 Sales incentive chart Yes 15 Overall incentive schemes management Yes 16 Route based incentives Yes 17 Special incentives Yes 18 Product wise incentives Yes © Tally Solutions Pvt. Ltd. All Rights Reserved 23

Dairy – Accounts : Receivables & Payables Procurement Management Dairy Management Accounts Receivables & Payables Milk Quality Management Sales & Distribution © Tally Solutions Pvt. Ltd. All Rights Reserved MIS Reports Incentive Management 24

Primary Requirement – Accounts : Receivables & Payables Category / Module Accounts : Receivables & Payables Major Requirement Explanation Statement of accounts Balance sheet, profit and loss statements in schedule VI format, trial balance are needed for the management to track the profitability and expenses. VAT on processed milk products Milk, curd, butter milk sales are exempt under income tax act. At present the sales tax/VAT on milk products such as flavoured milk, UHT milk, yoghurt, etc. is applicable and varies a lot from state to state. The statutory reports are important. Auditing – direct and remote Auditing is an important factor. Dairies can get their accounts audited remotely. Branch management More than one branches are found in different cities, states. It is important to track the profitability individually and as a group of dairy units/collection centers. Remote access and SMS All the dairy details can be accessed from anywhere, at anytime. Details are retrievable from mobile phones. © Tally Solutions Pvt. Ltd. All Rights Reserved 25

Tally. ERP 9 Fitment – Accounts : Receivables & Payables SL No. Requirement Part of Tally. ERP 9 1 Balance sheet – Schedule VI Yes 2 Profit and loss statement – Schedule VI Yes 3 Daily receipts and payments Yes 4 Multiple payment mode handling Yes 5 Stock summery report Yes 6 Branch wise reports 7 Staff database handling Yes 8 Outstanding receivable and payable Yes 9 Trial balance Yes 10 Multiple cheque payment option Yes 11 Reminder letter, e-mails 12 Company grouping (branch companies) © Tally Solutions Pvt. Ltd. All Rights Reserved Part of Solution Yes Yes Contd. . 26

Tally. ERP 9 Fitment – Accounts : Receivables & Payables SL No. Requirement Part of Tally. ERP 9 13 Payroll management for company drivers and staff Yes 14 Employee attendance and leaves Yes 15 Supervisor wise tracking 16 VAT on processed dairy products Yes 17 Branch transfer management Yes 18 Branch synchronization Yes 19 Branch-wise revenue management Yes 20 Branch-wise cost tracking Yes 21 Cash flow, fund flow statements Yes 22 Ageing analysis of receivables, debtor wise Yes 23 Scenario management Yes 24 Ratio analysis Yes © Tally Solutions Pvt. Ltd. All Rights Reserved Part of Solution Yes Contd. . 27

Tally. ERP 9 Fitment – Accounts : Receivables & Payables SL No. Requirement Part of Tally. ERP 9 Part of Solution 25 Interest calculation Yes 26 Remote auditing Yes 27 Foreign currency handling Yes 28 Budget and variance Yes 29 Bank reconciliation Yes 30 Remote access Yes 31 Security Yes 32 User access level , Authentication creation Yes 33 Automated SMS to the debtors Yes 34 Receivables summary (Route wise, distributor wise) Yes 35 Payables summary (Route wise, farmer wise) Yes © Tally Solutions Pvt. Ltd. All Rights Reserved 28

Dairy – MIS Reports Procurement Management Dairy Management Accounts Receivables & Payables Milk Quality Management Sales & Distribution © Tally Solutions Pvt. Ltd. All Rights Reserved MIS Reports Incentive Management 29

Primary Requirement – MIS Reports Category / Module MIS Reports Major Requirement Explanation Procurement report Management needs to know daily, weekly, monthly collection of milk. The days when the milk collection has been less and the days when the milk collection is best so that they can work on improving supply. Route wise milk collection also gives a good insight into the highest collection routes and lowest collection routes. Milk quality reports can be used to understand the quality of collected milk. SNF and FAT % averages along with temperature details can be a useful information. Farmer reports Farmer and village wise collection report helps in providing inputs into planning routes and the management can focus on getting more farmers in the low performing villages Incentive report This report is helpful to understand how much of procurement incentives were given to farmer/agent and how much incentives were given to the retailers. Multi-dimensional sales report This report is very important to understand the demand of the milk and milk products in market. The route wise distribution. Marketing executive effectiveness and the route wise delivery reports will help the management. © Tally Solutions Pvt. Ltd. All Rights Reserved 30

Tally. ERP 9 Fitment – MIS Reports SL No. Requirement Part of Tally. ERP 9 Part of Solution 1 Purchase route report – procurement summary Yes 2 All routes purchase report Yes 3 Farmer wise milk collection report Yes 4 Farmer wise payables report 5 Route wise average collection report 6 Debtors receivable report 7 Sales incentive route wise report Yes 8 Sales incentive farmer wise report Yes 9 Farmer payments bank wise report Yes 10 Route wise cash report Yes 11 Bank wise payment summary report Yes 12 Multi dimensional sales report Yes © Tally Solutions Pvt. Ltd. All Rights Reserved Yes Yes Contd. . 31

Tally. ERP 9 Fitment – MIS Reports SL No. Requirement Part of Tally. ERP 9 Part of Solution 13 Order sheet with item details Yes 14 Sales returns report Yes 15 Farmer wise milk quality report Yes 16 Route wise milk quality report Yes 17 Morning/evening batch wise collection report Yes 18 Farmer wise incentive report Yes 19 Route wise order sheet with item details Yes 20 Daily procurement report Yes 21 Daily sales summary Yes 22 Truck sheet summary Yes 23 Distributor wise sales calculations Yes 24 Collection center wise reports © Tally Solutions Pvt. Ltd. All Rights Reserved Contd. . 32

Tally. ERP 9 Fitment – MIS Reports SL No. Requirement Part of Tally. ERP 9 Part of Solution 25 Price chart for sales Yes 26 Crates report – Empty crates management Yes 27 Sales and collection incentives tables Yes 28 Total procurement with milk quality parameters Yes © Tally Solutions Pvt. Ltd. All Rights Reserved 33

Thank You To find out more and to send your enquiries, visit : http: //www. tallysolutions. com/website/html/solutions/segment-vertical-solutions. php © Tally Solutions Pvt. Ltd. All Rights Reserved