O'Reilly logo

Operations Management: Processes and Supply Chains, 12th Edition by Larry P. Ritzman, Manoj K. Malhotra, Lee J. Krajewski

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required