Distributor Information System (DIS) aims to provide information on distributor inventory and sales when a company sells and transfers goods to distributor premises.
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.
.: Objectives ::
.: 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.
:: 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
.: Sample 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
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
:: Requirements :.
. Server - Pentium IV minimum, 40 Gig Harddisk
. Database - MS SQL 2000
. M@ERP system
. Dial-up communications
. Operating system - Windows Advance Server
2000 or NT 4.0
. Client/Workstation - Windows 98,Windows Me,
Windows XP
. Internet website for data collection from
distributors
Minimum hardware requirement for DIS
- DIS Server
- Intel Pentium III Processor or faster
- At least 18 GB space SCSI Hard Disk
- 512 MB RAM or more
- IDE CD-ROM Drive
- 100 Base Network Card
- DIS Client/Workstation
- Intel Pentium II Processor or faster
- 1GB Hard Disk blank space
- 256 RAM or more
- IDE CD-ROM Drive
- 100 Base Network Card
- DIS Networking
- 100 Base Switch
- DIS Compatible OS
- Windows 95 ,98, ME, 2000
- Windows NT 4.0 Server
- Windows 2000 Advance Server
- DIS Database
- MS SQL2000 or Ms SQL 7.0