Web Based Sales Achievement Analysis System for Milco (Pvt) Limited

Abstract

Milco is a state owned dairy company, which produces a lot of value added product from fresh milk. Today, Milco (Pvt.) Limited operates four factories and has 22 sales outlets in addition to the other franchises that are located throughout the island. Highland products today reach the furthest parts of the country through its distribution channels and franchises. Milco operates its business on the dealer model. Dealer models, is where Milco gives the distribution rights to other private companies to operate and manage it sales operation on geographical locations in Sri Lanka.This model of business requires a very efficient sales system, to keep a tab on the sales operation and to control the dealers throughout Sri Lanka. Mostly, dealerships are owned by individual people and require constant monitoring on sales to ensure, dealers are aligned with company monthly sales target and company goals. Currently the company runs on a basic VBA based application to record sales and output is only an excel file. After this the data from excel needs to be analyzed separately.This requires additional man power and the organization will not have dynamic sales data to support decision at its finger tips. So the newly developed system fills the gap of a unified, sales system throughout all dealers and making the sales data more dynamic and user friendly for both the dealers and the company. User acceptance testing was done to get the users view on the system The system is designed in a way that, Milco(Pvt)Ltd can start implementing with basic functions for dealers and slowly enhancing the system. Throughout the process, was around the shift from basic sales system to a more dynamic sales system, where involvement from the dealers is very crucial andare started realizing the benefits; which can be then turned into opportunity to enhance the system.