January 2018
Intermediate to advanced
480 pages
236h 9m
English
The sales and operations plan in Figure 10.3 does not show much on the supply options used in the operations plan or their cost implications. Here we discuss using spreadsheets that do just that. Supplement D, “Linear Programming,” describes using the transportation method for production planning. Both spreadsheets and linear programming could be used on the side as a planner develops prospective plans in step 3 of the S&OP process.
Various spreadsheets can be used, including ones that you develop on your own. Here we work with the Sales and Operations Planning with Spreadsheets Solver in OM Explorer.
Figure 10.4 shows a plan for a manufacturer, which uses all supply ...
Read now
Unlock full access