Systems Functionality

Sample Project

Proactive Order Selection / On Time Shipments

The Client
The client is a leading Canadian hard goods retailer with several hundred retail stores and multiple warehouse/distribution facilities.

The Need
The client was undertaking a company wide project that would design, develop and implement multi-channel, multi-facility demand fulfillment capability by enhancing its supply chain capabilities and improving related processes and systems.

The client required a new system build that would enable select pick reserved orders to be scheduled outbound from the warehouse to ensure every store order arrived at the intended store on or prior to the due date. The system enhancement needed to identify store order lines that could/would be scheduled in future planning cycles based on ship windows, predefined parameters, and business rules.

The system enhancement had to contain functionality that would allow for automatic selection of store orders as they related to a production plan based on pre-established business rules. The system enhancement would also have to consider the priority of each pick-reserved order based on established business rules. Those rules would include current & future scheduling opportunities for each store and a hierarchy of priority orders. The most logical shipping window would be selected based on the business rules.

The Situation
The current systems did not provide a production plan and a relationship to the actual orders being placed by the stores. Therefore, only through manual intervention/review could it be determined if physical orders could be accommodated by each facility. The system enhancement in conjunction with the ERP system will complete all the planning stages, which would allow the warehouse facility to execute the plan instead of the warehouse facility doing a combination of planning and execution.

The Solution
The solution lay in analyzing the business processes that were to be employed. That included a combination of current business practices, refined business practices and new business practices. The business logic had to consider current systems and systems in the building stage so that system logic could be integrated correctly.

Formal documentation that included business objectives, business rules, context, data models, definitions and paths, and system functions had to be developed that would allow the developers to proceed with system development, testing, and implementation.

The Result
The system enhancements were designed, built, tested and implemented on schedule and to the client’s satisfaction.