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.

N/B 

Only for Prof. Dan 

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer