IOS Instructions (1.3)
The brite-sparks inventory optimisation application (IOS) provides stand alone and pooled inventory optimisation for individual and group businesses. Collaborative pooling groups can be set-up for geographic regions, specific industry sectors or for a group of related or cooperating businesses, or service organisations.
Some American users of IOS are reporting difficulties with the following error message "ADO cannot find specific Provider". This relates to a Windows component MDAC 2.5/2.6/2.7. The provider in the error message is the Jet 4.0 Database Engine for Microsoft Access. You can update your system to the latest standards by downloading from http://www.microsoft.com/data/download.htm
Once you have completed the configuration process, an IOS activation code will be emailed to you. Enter this into the IOS activation panel and save the details. IOS will now provide access to all internal and brite-sparks website functions.
Spreading the News
Once you have completed the configuration process, you can create your own Pooling Groups through the websites My Groups option. Next, build membership of your pooling group by persuading other companies and organisations to join in, this can be very profitable for you (See more...). Note each new member will need to register on the brite-sparks site; they then in turn should download, install and configure the IOS software. These users can join your open group directly by logging into the site and searching within My Groups for your group clicking on the join icon will automatically set-up their membership. If you have created a closed user group, they can apply to join by email.
Using the System
Next, import your supplier database and component records into the program (See appendix 1 for file import details). You will need to clear the example database supplied with the application. Open Import Data and clear the existing default database. Next, import your supplier database followed by your inventory database. Concentrate on your low usage and high cost items first, these will provide the biggest savings at the outset. If you know of equivalent parts held by, your pooling partners place these details into IOS via suppliers' equivalent items.
Editing Individual Items
Menu item Spare Parts, Maintenance, Edit allows you to signal, which components you wish to exclude from pooling, and for the cautious amongst you, you can specify a minimum safety stock holding that you wish to preserve from the pooling optimisation process.
IOS Optimisation Routines
IOS will calculate a local optimised reorder level for each stock item; in some cases, it will signal that a zero stock holding is the most appropriate outcome. (The risk of failure is slight in relation to stock holding costs).
Following this local optimisation, IOS will then upload your stockholdings, stock parameters and service level requirements to the brite-sparks website. (Click on Web Services Upload all Data , note we will make this automatic in a future release). Ever30 minutes Web Server based application programs running at brite-sparks.com will calculate a pooled optimised reorder level based on the duplication of stock holdings within your designated pooling group and transmit results back to your IOS application. Download this pooled Information Web Services Download Pooled data from brite-sparks ( again this will be an automatic feature in a future release of IOS). IOS will recalculate lower reorder levels based on the duplication within the pool.
Optimised "pooled" reorder levels will start to populate the IOS data set for pooled items. This information should be used to update your stock control or computer based maintenance management system (CMM) re-order levels.
As stock changes occur or as additional members join your pooling group tighter stock reorder levels are transmitted to each local IOS module within the pool, reflecting changes in the overall pooled stock holding.
Currently IOS will not calculate a pooled reorder level less than 1, local zero stock holdings need to be agreed amongst members of a pooling group. Agreeing minimum stock holding arrangements i.e. one participant agrees to hold the only spare to service the pool will provide major savings. However, if agreement cannot be reached between pooling group members we maybe able to provide an impartial inventory holding and management service.
IOS Quick Search and other Features
Clicking the right mouse button on any part provides a drop down menu with access to quick views of replacement histories; equivalent items and spare parts search features. The search feature will undertake a lightening scan of brite-sparks databases and signal partner organisations holding these items with contact details.
Problems and Solutions
Cannot communicate via IOS to the brite-sparks website (no search or upload or download). Make sure you have Internet Explorer 5.5 or above installed on your machine with security settings set to default.
Cannot communicate via IOS to the brite-sparks website (no search feature). Uninstall the current IOS application save the download setup.exe file and Install the application from this saved file. Installing directly from WinZip memory can cause problems.
Cannot get a pooled calculation in IOS? First check that you have a pool of items in your pooling group, right click on a known duplicated component within your local spare parts stock records and check that identical components from more than one pooling group member are found on the brite-sparks site. Next, wait 30 minutes and click Web Services Download Pooling Data from brite-sparks. When the download is complete Click on Spare Parts Optimisation…wait for a few minutes as IOS re optimises the stock levels. Items duplicated within the pool will have lower reorder values and contain values in My Groups In Country and Anywhere in the stock record.
Currently brite-sparks provides a simple csv interface to IOS for the importation of stock data. If you develop a nice interface for a Stock Control System or CMM ( Computer Maintenance Management Application) let us know, upload it to the driver section of the website and we sell the downloads for you.
If you need further information please contact us at email@example.com are waiting here to help.
Currently we employ a simple CSV interface to import data from your stock control or CMM system. Layouts for CSV Import Files:
|Column 1||SupplierID Integer|
|Column 2||SupplierCode Char|
|Column 2||Company Char|
|Column 4||AddressLine1 Char|
|Column 5||AddressLine2 Char|
|Column 6||AddressLine3 Char|
|Column 7||AddressLine4 Char|
|Column 8||City Char|
|Column 9||County Char|
|Column 10||PostCode Char|
|Column 11||Country Char|
|Column 12||Telephone Char|
|Column 13||Fax Char|
|Column 14||EmailAddress Char|
|Column 15||WebSiteAddress Char|
|Column 16||AverageDeliveryTime Integer|
|Column 17||StandardDeliveryCharge Float|
|Column 1||StockID Integer|
|Column 2||PartNumber Char|
|Column 3||Description Char|
|Column 4||IntegerDescription Char|
|Column 5||BarCode Char|
|Column 6||Active Char (Y or N)|
|Column 7||ExcludeFromPooling Char (Y or N)|
|Column 8||SupplierID Integer|
|Column 9||SupplierCode Char|
|Column 10||SupplierLeadTime Integer|
|Column 11||SupplierDeliveryQuantity Integer|
|Column 12||SupplierUnitCost Float|
|Column 13||CurrentStockInHouse Integer|
|Column 14||QuantitytoPool Integer|
|Column 15||QuantityToReserve Integer|
|Column 16||CostOfFailure Float|
|Column 17||CostOfHoldingStock Float|
|Column 18||ConfidenceLimitRequired Float|
|Column 19||AverageUsage Integer|
|Column 20||AverageUsagePeriod Integer|
Points to note: