Linear optimization – part 1 | MIS-665


The purpose of this assignment is to employ linear optimization techniques, interpret results, and determine optimal solutions for business problems.

Complete Chapter 3 Problems 4, 5, 7, 14, and 34 from the textbook, using the student data files provided in the Course Materials, as directed.

Submit the Excel outputs required for each problem. Note that Excel files are to include all Solver settings, functions, and formulas used to generate the problem solutions.

Submit a narrative to discuss the optimal solution for each problem as a Word document.

In addition, write a 250-word executive summary related to Problem 34. Summarize for management the least expensive way Sentry can manufacture and ship locks from the plants to the distributors to optimize organizational performance and effectiveness. Justify your explanation based on the linear optimization model.

Submit your executive summary and associated Microsoft Excel files to the instructor.

APA style is not required, but solid academic writing is expected.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.


Only for Prof. Dan