Calculating Costs: Switching to Scan-Based Trading

By Regina Kwon  |  Posted 2003-03-10 Print this article Print

Margins are thinning, and competition growing. The supply chain is one place to start cutting costs.

PDF DownloadIn a typical retailer-supplier relationship, the retailer manages stock it owns--it purchases goods from suppliers and settles discrepancies in inventory, invoices and promotions periodically through the sales cycle. Scan-based trading (SBT), by contrast, leaves ownership of the goods in the hands of the supplier until they pass through checkout.

Here, a household goods company that sells $2 billion in products through supermarkets each year learns that five retail partners are adopting SBT, and decides to join them. As a result, the supplier will manage its 500-item inventory at each store, creating invoices only when an item is scanned (i.e., sold).

For this project, the partners will create a shared database to track inventory and sales. The supplier and the retailer must clean the data they collect individually so it can be easily synchronized in the database. They share their information via an intermediary that manages the shared database.

Click here to download the assumptions and the Microsoft Project 2000 file behind this planner, which are stored in a WinZip archive.

As Statistics Editor of Baseline magazine, Regina creates interactive tools, worksheets and project guides for technology managers. Before joining Ziff Davis, she worked as a technical program manager for a database company, where her projects included data management applications in XML, Java, Visual Basic and ASP. Her other experience includes running the new media department at Christie's Inc. and writing and editing for Internet World and PC Magazine. Regina received a B.A. from Yale.

Submit a Comment

Loading Comments...
eWeek eWeek

Have the latest technology news and resources emailed to you everyday.