Case Studies


Customer Satisfaction through Lemon Solution

H. Dipak & Co.

Business challenge confronted by H. Dipak & Co. :

H. Dipak & Co. (HD) is a leading importer, manufacturer and exporter of diamonds having its sales & marketing office at Mumbai and manufacturing units at Mumbai & Navsari. HD is one of the pioneers in the Gem & Jewellery Industry.

The diamond industry is changing dramatically since last few years. The industry is getting consolidated. The survival of medium and small size firms has became difficult. The prices of the rough depicts increasing trend without commensurate increase or growth in the price of polished diamonds. As against these, cost of manufacturing and overheads are increasing due to technological upgradations and increase in labour and legal compliance costs. Competition in international market too is escalating due to emergence of other manufacturing locations such as China & Botswana.

The above scenario requires drastic innovation and strategic changes to survive and grow. Production technologies, human resources, infrastructure, rough supplies and most other factors are now taken for granted and are no longer competitive advantages. The only possible competitive advantage lies in the use of Information Technology effectively since the use of IT still lags as compared to other industries and there are immense possibilities in this area. The focus needs to shift from the traditional concept of stock tracking to Decision Support Systems and further to Business Intelligence.

The real challenges for HD before implementing DiasoftTM were as follows:
  • Department wise stock tracking and stock management was very difficult and cumbersome
  • Cross tally of book stock with actual physical stock at the end of the day took a lot of time and effort
  • Knowing live real time details of stock on hand, stock under process, stock with processors and stock with each internal department was not possible
  • Tracking the performance of workers and machines involved in production of diamonds was not possible
  • Value wise tracking was not possible
  • Analysis of rough performance, expected dates and types of polished coming out of the manufacturing system, wages and cost calculations etc was not possible


Initiatives of Lemon Technologies:

Lemon Technologies (LT) has developed a high-tech integrated software with following features to address the needs, requirements and intricacies of firms operating in Gem & Jewellery Industry.
  • Formulation of a comprehensive stock tracking software (DiaSoftTM) that can be integrated with payroll software for processing of wages in respect of workers working on piece rate basis.
  • Development of cutting edge software to track each and every movement of stock as well as depicting live situation of stock.
  • Software with numerous reporting abilities to generate multiple reports in scientific formats acceptable to Tax authorities, Insurance Surveyors and management as part of an effective MIS.
  • Built-in Decision Support System to check the accuracy of decisions taken manually as well to counter support production staff in decision making that leads to maximize the value of diamond.
  • Bar code system of stock tracking to avoid manual efforts in data entry.
  • Qualitative features to take care of productivity aspects like loss, breakage, yield, value as per rapaport price etc.
  • Multi location stock accounting and reporting.
  • Real time stock reconciliation.
  • Security & Authentication.
  • Prediction & result analysis.
  • Load balancing and inventory control.

Value delivered:

Solution provided to HD in the form of software can be recognized as follows:
  • Fully Computerized Stock Tracking & Management System: With the implementation of “ DiaSoft ”, HD has attained substantial operational efficiency and administrative convenience within the functioning of stock accounting and management. Stock lying with internal departments, processors, other offices, factories and H.O. can be viewed and reconciled online. It includes the feature of load balancing and inventory level controlling to ensure that no department/ processor is over stocked or under stock out situation and stock movement is smooth. It minimizes the risk attached with excess stock at one department. E.g. If the maximum limit of inventory for department X is set as 5000 carats and that limit is attained, the software would get locked and stop issuing further material to this department unless the stock level is reduced. It also identifies those departments where the stock can be issued to balance load amongst various departments.
  • Better Reporting: With the implementation of software, multiple stock reports are generated in scientific format that are acceptable to Tax authorities, Insurance Company as well as DTC. Format of reports are self explanatory and considered very essential from an internal control point of view. Formats of reports have been designed after considering numbers of aspects peculiar to Gem & Jewellery Industry. E.g. Generation of outstanding report date wise, lot wise, department/ cutter wise. Rough and Polish stock on hand, with internal departments, with processors, with factories/ branch offices, in transit, with H.O. etc.
  • Pipeline Management: Stock movement throughout the pipeline is tracked on line from rough inward to polish outward. Software tracks stock under each process. The sophistication includes issue of diamonds to workers through software. At any point of time, backward and forward movements of diamonds can be tracked. Software includes the features of merging and sorting of lots as per the requirements. E.g. Tracing of polished diamonds exported with rough invoice, passing through various processes, lotting, sub-lotting, merging and sorting with other diamonds, results obtained etc.
  • Operational Efficiency: With the help of Barcode system for stock identification and tracking, immense operational efficiency is achieved at HD in the form of human efforts and time of operators in data entry. As per the Barcode system, a unique barcode sticker is affixed on each packet of diamond and with the help of Barcode reader, automatic data entry is made in computer. During any stage, with the help of barcode reader, the backward and forward movement of stock can be tracked.
  • Decision Support System: The unique feature of the software is its decision support ability. The software contains many technical concepts that support some productive decisions like estimation of selling price with the help of rapaport, identification and tracing of process cycle days, past performance track of marker, machine operators, processors, workers etc, performance tracking of laser and planner machines. E.g. software identifies the department/ worker/ processor/ machine to which diamonds should be issued for better output and results taking into consideration its past performance, numbers of mistakes, percentage of loss breakage etc., yield obtained against expectations and many mores.
  • Security related aspects: HD has succeeded to strengthen the security over data with the help of “DiaSoft”. The software’s inbuilt security features checks the identity of users at each phase i.e. data entry, master update, change of stored data, report viewing etc. It maintains the log of users with details like date, time of login and logout, reports and menus accessed etc. E.g. user XYZ has accessed Rough Stock Report on 1st April at 10 a.m.

List of other clients:
  • SHEETAL MFG. CO.
  • J.B.DIAMONDS
  • K.GIRDHARLAL INTERNATIONAL LTD.
  • JEWELEX INDIA PVT. LTD.
  • ANKIT GEMS
  • SUPER GEMS INDIA PVT. LTD.
  • GEMIS GEMS (CHINA)
  • RATNA RAJ
  • KETAN BROTHERS