Operations Management assignment
Maldiyvormbn
ExtraCreditAssignmentsforMGNT3020Nov52018.docxExtra Credit Assignment for MGNT 3020 Chapters 9 & 10
Name: ______________________ Date: __________________
Problem #1.
Create charts Using Excel or by hand
1. Given the data above, create a histogram of the Employee ages in the plant in five year increments.
2. Given the data above, create a pareto chart of Employee ages in the plant in five year increments.
3. On the histogram, draw and label a line showing the mean age of all employees (show calculation below the chart).
4. On the pareto chart draw and label a line showing the approximate median age of all employees (show calculation below the chart)
5. Create a second pareto chart of the years of service of the employees in the plant in five year increments.
6. Create a second histogram of the years or service of the employees in the plant in five year increments.
7. On the second histogram, draw and label a line showing the mean age of all employees (show calculation below the chart).
For all charts in Problems #1 & #2, be sure to clearly label the X & Y axis
Problem #2
Below find the 42 week production output of a plant showing:
1. The week of production
2. The number of production parts planned for the week
3. The number of shifts needed to create the actual output that week
4. The average output per shift for the week
5. The total number of parts actually produced that week
Create charts
Using Excel or by hand
1
Date &
ShiftSourcePlanNb Shift
Ave per
Shift
Total
per
WeekStatus
Wk01 (3 working days)12643 shiftsRework1,428G
Wk026403 shifts1702,117G
Wk0311563 shifts1582,206G
Wk0411203 shifts1811,984G
Wk0510563 shifts1852,089G
Wk0611763 shifts1581,895G
Wk0711003 shifts1742,083G
Wk088763 shifts1811,879G
Wk098723 shifts1702,041G
Wk1011802 shifts1711,371G
Wk117602 shifts1741,415G
Wk1210282 shifts183994G
Wk1310802 shifts1751,053G
Wk14 (4working days)12642 shiftsRework784Y
Wk15
Producti
on
12257 shifts a week1671,148Y
Wk1512257 shifts a week1671,148Y
Wk1612257 shifts a week1901,345G
Wk1714008 shifts a week1921,538G
Wk18 (1 bank holiday)10506 shifts a week1651,040Y
Wk19 (2 bank holiday)10506 shifts a week1731,038Y
Wk2015759 shifts a week1751,575G
Wk2112257 shifts a week1711,133Y
Wk2215759 shifts a week1691,521Y
Wk23175010 shifts a week1741,740Y
Wk2410506 shifts a week1771,064G
Wk25175010 shifts a week1751,752G
Wk2614008 shifts a week1781,550G
Wk2712257 shifts a week1781,282G
Wk2815759 shifts a week1781,679G
Wk2915759 shifts a week1781,600G
Wk3015759 shifts a week1641,432Y
Wk3114008 shifts a week1591,210Y
Wk3215759 shifts a week1721,544Y
Wk3315759 shifts a week1811,513Y
Wk3415759 shifts a week1901,726G
Wk3514008 shifts a week1741,394Y
Wk36210012 shifts a week1741,500R
Wk37262515 shifts a week1752,620G
Wk38245014 shifts a week1732,425G
Wk39192511 shifts a week1731,875G
Wk40227513 shifts a week1732,297G
Wk41192511 shifts a week1371,506Y
Wk42192511 shifts a week1621,951G
EDI
Producti
on
Planning
