Distributor Information System (DIS)

Module Info

This system is used to manage the distributors’ business operations. Each operations or transactions done by the distributors are stored in the SQL database. The distributors then will extract out the data to XML format and send it’s to the supplier for business analysis. Through this system, supplier enable to forecast the stock re-order level for the distributors and increase their sales performance.

We have also applications running on Palm Top or Pocket PCs to be used as input devices for the distributor system. The mobile devices are optional.

DIS is suitable for large and small distributors. One user or multiple users can use the system as it can be standalone or networked.

This system is used to manage the distributors' business operations. Each operations or transactions done by the distributors are stored in the SQL database. The distributors then will extract out the data to XML format and send it's to the supplier for business analysis. Through this system, supplier enable to forecast the stock re-order level for the distributors and increase their sales performance.

Contact Us

General Features


  • Information on daily sales orders for production planning and sales management of targets. It will improve on supply chain process
  • Increase Customer calls per Sales person if we know on the average the number of successful calls
  • Enable the ability to implement a solution integrated with the core system
  • Faster availability of information of stock requirements
  • Information for marketing on demand by customers
  • Information for sales operation in measuring orders versus deliveries and sales
  • Information for production and supply chain planning
  • Management reports to track sales activities and improve efficiency

Objectives


  • Cost-effective data collection
  • Reduce clerical cost in preparation of data
  • Improved efficiency, productivity and reduce error in keying distributor data
  • Visibility of distributor sales and inventory status
  • Assist in planning of production, warehouse and distribution functions
  • Provide information for sales and marketing
  • Monitor sales performance
  • Manage FOC and discounts given to customers

Cost Saving


  • Reduce double-handling
  • Reduce warehouse storage space
  • Reduce raw materials on hand
  • Reduce stock shortages
  • Improve sales productivity by measuring sales orders versus sales invoices
  • Reduce paperwork and improve accuracy of data such as write-offs, trade claims, FOC, etc.
  • Reduce manual reports such as sales commissions, sales reports, etc.
  • Faster delivery time as it is a pull system
  • Reduce inventory on-hand by manufacturer

Reports


  • Stock Write Off - by category by SKU
  • Sales Contributions - by sales persons by category
  • Sales Contributions - by sales persons by SKU
  • Sales Contributions - by category / selected SKU
  • Sales Contributions - by sales persons by channel
  • Sales Distributions - by sales category by channel
  • Day End Sales & Collections - by sales persons
  • Trade Claim - by category by part code
  • Trade Offer Claim - by category by part code

Current Situation


Due to infrastructure and line speed at distributor premises, we proposed to use a data collection via a distributor system called Distributor Information System (DIS) and specific data is sent via e-mail to the HQ as required. This is the most cost-effective method for both distributors and HQ.

The data from distributors can be sent to an Internet website and the data is downloaded daily or periodically from Internet to HQ.

Proposed data collection:

Sales Information:
- Customer Master - the distributor should follow HQ standard sales information naming convention
- Product Master - conversion file for HQ products and distributor product numbers if differ

Distributor Stock Status:
- The inventory will be spilt be distributors or can be consolidated to view as total by each SKU
- The inventory data will be extracted from each distributor system as agreed and required by management