Enterprises in a collaborative supply chain share information for quick and intelligent decision making. Collaborative Planning, Forecasting and Replenishment (CPFR), a business model developed by an organization called Voluntary Inter-industry Commerce Standards, defines a set of business processes to collaborate on planning, forecasting and replenishment activities to arrive at a common order. This involves sharing sales forecast, order forecast and promotion information among business partners. The Internet has paved the way for using Web Services to share this information as XML data in real time and to make it available across enterprises. Enterprises need to access this information and integrate it with the information available in their databases, Excel sheets and XML applications. This thesis discusses the development of an information architecture using XQuery (a declarative query language by W3C) for aggregating data from disparate data, and evaluates XQuery as a tool to enable information integration for supply chain collaboration. For this purpose, several CPFR scenarios are identified where two retailers share their sales forecast, order forecast and promotion forecast information with the manufacturer. A prototype application is developed which can fetch data from disparate data sources such as Web Service, XML databases and CSV files, aggregate it, and use it to identify exceptions in forecasts and calculate the key performance indicators (KPI). These KPIs are then presented as an executive dashboard using Visual FoxPro. This Dashboard presents information graphically and enables executives to track the performance of the supply chain, and hence enables them to make quick and intelligent decisions.

Library of Congress Subject Headings

Business logistics--Data processing

Publication Date


Document Type


Department, Program, or Center

Industrial and Systems Engineering (KGCOE)


Paidy, Sudhakar

Advisor/Committee Member

Esterman, Marcos


Note: imported from RIT’s Digital Media Library running on DSpace to RIT Scholar Works. Physical copy available through RIT's The Wallace Library at: HD38.5 .G68 2006


RIT – Main Campus