MIS 665 Full Course Assignments GCU

MIS 665 Full Course Assignments GCU

MIS 665 Topic 1 Forecasting Techniques

The purpose of this assignment is to use predictive analytics techniques and the graphs and charts associated with these techniques to forecast outcomes and make business decisions.

Using specified data files, chapter example files, and templates from the “Topic 1 Student Data, Template, and Example Files” topic material, complete Chapter 12 Problems 28, 30, 34, 46, 60, 62 (b through e), and 63 from the textbook. Use the Palisade DecisionTools Excel software to complete these problems where requested and applicable. Problem 60 should be completed using only Excel.

To receive full credit on the assignment, complete the following.

1. Ensure that the Palisade software output is included with your submission.
2. Ensure that Excel files include the associated cell functions and/or formulas if functions and/or formulas are used.
3. Include a written response to all narrative questions presented in the problem by placing it in the associated Excel file.
4. Place each problem in its own Excel file. Ensure that your first and last name are in your Excel file names.

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.

You are not required to submit this assignment to LopesWrite.

 

MIS 665 Topic 2 Simulation Problems

The purpose of the assignment is to gather the information needed to set up problems, run simulations, and interpret the results to solve the problems.

Using specified data files, chapter example files, and templates from the “Topic 2 Student Data, Template, and Example Files” topic material, complete Chapter 15, Problems 2, 7, 9, 32 (parts a and b only), 33, and 35 from the textbook. Use the Palisade DecisionTools Excel software to complete these problems where requested and applicable. Problem 2 only requires the use of Microsoft Excel; however, you may optionally use the Palisade DecisionTools Excel software to generate the histogram.

Use the Palisade DecisionTools Excel software to complete the rest of the problems and ensure that all Palisade software output is included in your files. Unless otherwise stated, run simulations with 1,000 trials. Use 500 trials if the software will not allow you to run 1,000 trials. Ensure that only one Excel file is open when running a simulation.

To receive full credit on the assignment, complete the following.

1. Ensure that the Palisade software output is included with your submission.
2. Ensure that Excel files include the associated cell functions and/or formulas if functions and/or formulas are used.
3. Include a written response to all narrative questions presented in the problem by placing it in the associated Excel file.
4. Include screenshots of all simulation distribution results for output variables.
5. Place each problem in its own Excel file. Ensure that your first and last name are in your Excel file names.

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.

You are not required to submit this assignment to LopesWrite.

 

MIS 665 Topic 3 Benchmark Simulation and Risk Analysis Case Study

The purpose of this assignment is to use analytics techniques to analyze a case problem.

Part 1

Read Case Study Case 15.2 “Ebony Bath Soap” from the textbook, and then complete the following items.

1. For Questions 1 and 2 of the case, use the Palisade DecisionTools Excel software to set up a simulation model and run a simulation with 500 trials for the case. Ensure that all Palisade software output is included in your files and that only one Excel file is open when running a simulation. Use the “Topic 3 Case Study Template” file as a starting point. Hint: The RiskSimtable function was be helpful for running the simulations.
2. Respond to Question 3 as written in the problem. Ignore the confidence interval portion of the question.
3. Respond to Question 4 as written in the problem.

To receive full credit on the assignment, complete the following.

1. Ensure that the Palisade software output is included with your submission.
2. Ensure that Excel files include the associated cell functions and/or formulas if functions and/or formulas are used.
3. Include a written response to all narrative questions presented in the problem by placing it in the associated Excel file.
4. Include screenshots of all simulation distribution results for output variables.
5. Place each problem in its own Excel file. Ensure that your first and last name are in your Excel file names.

Part 2

In a 500-750-word summary to company management, address the following. Include relevant charts and graphs within your summary, as needed.

1. Describe the case specific business requirements and how they can be communicated across all levels of the organization.
2. Based on the simulation results, discuss the Annual Cost output statistical distributions. Assume that your audience as minimal background in statistics.
3. Discuss which Annual Cost output probability distribution has the most dispersion, and explain why this is so.
4. Explain the descriptive, predictive, and prescriptive analytics that have been used to formulate the solutions to the business needs.
5. Based on the Annual Cost output statistical distributions and other information gleaned from your analysis, discuss the specific prescribed course of action you would recommend to company management and justify your recommendations. Include discussion of how the proposed analytics solutions can optimize organizational performance and effectiveness.

While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.

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

You are required to submit this assignment to LopesWrite. Refer to the LopesWrite Technical Support articles for assistance.

 

Benchmark Information

This benchmark assignment assesses the following programmatic competencies:

MS Business Analytics

2.1: Interpret and communicate business requirements across levels of an organization.

2.3: Formulate solutions to business needs using descriptive, predictive, and prescriptive analytics.

2.5: Evaluate analytics-based solutions to optimize organizational performance and effectiveness.

 

MIS 665 Topic 4 Linear Optimization Part 1

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

Using specified data files, chapter example files, and templates from the “Topic 4 Student Data, Template, and Example Files” topic material, complete Chapter 13, Problems 25 (part a), 28 (part a), 31 (part a), 32 (part a), and 37 (part a) from the textbook. Use Microsoft Excel’s Solver Add-In to complete these problems. For each of these problems, run the Solver’s Answer and Sensitivity Reports. Interpret and summarize the key results.

To receive full credit on the assignment, complete the following.

1. Ensure that all Solver settings are defined through the use of the Solver dialog box.
2. Ensure that Excel files include the associated cell functions and/or formulas if functions and/or formulas are used.
3. Include a written response to all narrative questions presented in the problem by placing it in the associated Excel file.
4. Include Answer and Sensitivity Reports interpretation and summary of key results.
5. Place each problem in its own Excel file. Ensure that your first and last name are in your Excel file names.

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.

You are not required to submit this assignment to LopesWrite.

 

MIS 665 Topic 5 Linear Optimization Part 2

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

Using specified data files, chapter example files, and templates from the “Topic 5 Student Data, Template, and Example Files” topic material, complete Chapter 14, Problems 79 (part a), 80 (part a), 81, 86 (part a), and 89 from the textbook. Use Microsoft Excel’s Solver Add-In to complete these problems. For all problems except 89, run the Solver’s Answer and Sensitivity Reports. Interpret and summarize the key results.

To receive full credit on the assignment, complete the following.

1. Ensure that all Solver settings are defined through the use of the Solver dialog box.
2. Ensure that Excel files include the associated cell functions and/or formulas if functions and/or formulas are used.
3. Include a written response to all narrative questions presented in the problem by placing it in the associated Excel file.
4. Include Answer and Sensitivity Reports interpretation and summary of key results.
5. Place each problem in its own Excel file. Ensure that your first and last name are in your Excel file names.

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.

You are not required to submit this assignment to LopesWrite.

 

MIS 665 Topic 6 Network Modeling

The purpose of this assignment is to introduce how network models can be used to solve a business problem.

Using specified data files, chapter example files, and templates from the “Topic 6 Student Data, Template, and Example Files” topic material, complete Chapter 14, Problems 15, 16, 17, 20, and 88. Use Microsoft Excel’s Solver Add-In to complete these problems. For problems 17, 20, and 88, run the Solver’s Answer and Sensitivity Reports. Interpret and summarize the key results.

To receive full credit on the assignment, complete the following.

1. Ensure that all Solver settings are defined through the use of the Solver dialog box.
2. Ensure that Excel files include the associated cell functions and/or formulas if functions and/or formulas are used.
3. Include a written response to all narrative questions presented in the problem by placing it in the associated Excel file.
4. Include Answer and Sensitivity Reports interpretation and summary of key results.
5. Place each problem in its own Excel file. Ensure that your first and last name are in your Excel file names.

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.

You are not required to submit this assignment to LopesWrite.

 

MIS 665 Topic 7 Nonlinear Optimization

The purpose of this assignment is to introduce how to find solutions to business problems using nonlinear optimization techniques.

Using specified data files, chapter example files, and templates from the “Topic 7 Student Data, Template, and Example Files” topic material, complete Chapter 14, Problems 69, 70 (ignore the SolverTable portion), 72 (ignore the SolverTable portion), and 94. Use Microsoft Excel’s Solver Add-In to complete these problems. For Problems 70, 72, and 94, run the Solver’s Answer and Sensitivity Reports. Interpret and summarize the key results.

To receive full credit on the assignment, complete the following.

1. Ensure that all Solver settings are defined through the use of the Solver dialog box.
2. Ensure that Excel files include the associated cell functions and/or formulas if functions and/or formulas are used.
3. Include a written response to all narrative questions presented in the problem by placing it in the associated Excel file.
4. Include Answer and Sensitivity Reports interpretation and summary of key results.
5. Place each problem in its own Excel file. Ensure that your first and last name are in your Excel file names.

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.

You are not required to submit this assignment to LopesWrite.

 

MIS 665 Topic 8 Decision Making Techniques

The purpose of this assignment is to show how business decisions can be made by using rigorous decision-making techniques.

Using specified data files, chapter example files, and templates from the “Topic 8 Student Data, Template, and Example Files” topic material, complete Chapter 6, Problems 2, 31 (part a), 32, and 33 from the textbook. Use Microsoft Excel to complete Problem 2. Use the Palisade DecisionTools software to complete Problems 31, 32, and 33, and ensure that all Palisade software output is included in your files. The Palisade DecisionTools Excel software needs to be used to create the decision trees.

To receive full credit on the assignment, complete the following.

1. Ensure that the Palisade software output is included with your submission.
2. Ensure that Excel files include the associated cell functions and/or formulas if functions and/or formulas are used.
3. Include a written response to all narrative questions presented in the problem by placing it in the associated Excel file.
4. Place each problem in its own Excel file. Ensure that your first and last name are in your Excel file names.

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.

You are not required to submit this assignment to LopesWrite.