Spreadsheets for Sales and Operations Planning
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.
Spreadsheets for a Manufacturer
Figure 10.4 shows a plan for a manufacturer, which uses all supply ...
Get Operations Management: Processes and Supply Chains, 12th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
