Expert System Procedures

The Supply Chain Software most commonly used by Logexsoft to develop Supply Chain Applications is the Aspen Technology SCM suite. This product is also known in the market as MIMI (Manager for Interactive Modeling Interfaces). A very commonly used modeling language in this software is an Expert System Shell. The Powerpoint Presentation shown below provides an overview of the functioning and syntax used in the Expert System.

The CHEMCOM Spreadsheet has an example of a procedure used to generate a production summary report - See worksheet tabs Production Reporting Tables, and Production Reporting Procedure.

The Procedure spreadsheet shows both the procedure and the 'trace' that is obtained when the procedure is run.

1.Review this procedure and the trace. Write few sentences explaining what the procedure is doing to demonstrate your understanding.

1.The procedure calculates the total products produces for each product for each plant. It completes this task by keeping a running total while looping through weeks.

2.Modify or create new procedures to similarly calculate the values needed to populate Output tables 2 and 3 in the Production Reporting Tables Tab.

a. RPRODSUM

IF PRODSUM = NULL /* initialize report table */

AND ?PLA IN PLA /* loop over all plants */

AND ?TIM IN TIM /* loop over time periods */

AND ?PLATABL = 'MADE?PLA' /* concatenate-get plant table */

AND WORKTAB = ?PLATABL

AND ?BLEND IN BOP /* loop over all Blend Products */

AND ?OLDPROD = PRODSUM(@,@)

AND ?PLAPROD = WORKTAB(@,@)

AND ?NEWPROD = ?OLDPROD + ?PLAPROD

AND PRODSUM(@,@) = ?NEWPROD

THEN AGGREGATE_PRODUCTION_TO_CALCULATE_PRODUCTION_SUMMARY

b. RPRODSUM

IF PRODSUM = NULL /* initialize report table */

AND ?BLEND IN BOP /* loop over all Blend Products */

AND ?TIM IN TIM /* loop over time periods */

AND ?PLATABL = 'MADE?PLA' /* concatenate-get plant table */

AND WORKTAB = ?PLATABL

AND ?PLA IN PLA /* loop over all plants */

AND ?OLDPROD = PRODSUM(@,@)

AND ?PLAPROD = WORKTAB(@,@)

AND ?NEWPROD = ?OLDPROD + ?PLAPROD

AND PRODSUM(@,@) = ?NEWPROD

THEN AGGREGATE_PRODUCTION_TO_CALCULATE_PRODUCTION_SUMMARY