Data Analysis: Labor Stages and Material

Data Analysis: Labor Stages and Material

QSO 520 Milestone Two Guidelines and Rubric Overview: Data analysis is an essential part of informing business decisions and helps provide a solid rationale to gain stakeholder buy-in. Knowing what data to analyze is also important. Prompt: You will now calculate and analyze data based on information provided in the scenario to inform and support the decisions necessary to resolve the organizational challenges. Your analysis will explore the production schedule and vendor optimization by running a linear programming model and sensitivity analysis. You will submit this section as an Excel spreadsheet to show your programming. Please refer to your syllabus for instructions on how to access your case study. Specifically, you must address the critical elements listed below.

II. Data Analysis:

A. Calculate the labor stages and material requirements for each product. B. Based on the results of your calculation, develop a summary table for linear programming analysis. C. Next, calculate the production schedule, determining what will be produced, the quantity, and when the output will be produced. D. Conduct a sensitivity analysis on the cost of the products using a decision tree. E. Generate labeled graphs to demonstrate changes, if any, in product cost.

Rubric Guidelines for Submission: Your assignment must be submitted using the provided Excel template with your calculations.

Critical Elements Proficient (100%) Needs Improvement (85%) Not Evident (0%) Value

Data Analysis: Labor Stages and Material

Requirements

Calculates the labor stages and material requirements for each product

Calculates the labor stages and material requirements for each product, but calculation contains inaccuracies

Does not calculate the labor stages and material requirements for each product

18

Data Analysis: Summary Table

Develops a summary table for linear programming analysis

Develops a summary table for linear programming analysis, but table contains inaccuracies

Does not develop a summary table for linear programming analysis

18

Data Analysis: Production Schedule

Calculates the production schedule that determines what will be produced, the quantity, and when the output will be produced

Calculates the production schedule, but calculation contains inaccuracies

Does not calculate the production schedule

18

https://learn.snhu.edu/d2l/lor/viewer/viewFile.d2lfile/93438/22287,1/
Critical Elements Proficient (100%) Needs Improvement (85%) Not Evident (0%) Value

Data Analysis: Decision Tree

Conducts a sensitivity analysis on the cost of the products using a decision tree

Conducts a sensitivity analysis on the cost of the products using a decision tree, but response contains inaccuracies

Does not conduct a sensitivity analysis on the cost of the products using a decision tree

28

Data Analysis: Labeled Bar Graphs

Generates labeled bar graphs to demonstrate changes in product cost

Generates labeled bar graphs to demonstrate changes in product cost, but graphs contain inaccuracies

Does not generate labeled bar graphs

18

Total 100%

You may also like...