Operations Management assignment

profileMaldiyvormbn
Excellforextracredit.xlsx
Home>Business & Finance homework help>Operations Management homework help>Operations Management assignment

Sheet1

Date & Shift Source Plan Nb Shift Ave per Shift Total per Week Status
Wk01 (3 working days) EDI 1264 3 shifts Rework 1,428 G
Wk02 640 3 shifts 170 2,117 G
Wk03 1156 3 shifts 158 2,206 G
Wk04 1120 3 shifts 181 1,984 G
Wk05 1056 3 shifts 185 2,089 G
Wk06 1176 3 shifts 158 1,895 G
Wk07 1100 3 shifts 174 2,083 G
Wk08 876 3 shifts 181 1,879 G
Wk09 872 3 shifts 170 2,041 G
Wk10 1180 2 shifts 171 1,371 G
Wk11 760 2 shifts 174 1,415 G
Wk12 1028 2 shifts 183 994 G
Wk13 1080 2 shifts 175 1,053 G
Wk14 (4working days) 1264 2 shifts Rework 784 Y
Wk15 Production Planning 1225 7 shifts a week 167 1,148 Y
Wk15 Production Planning 1225 7 shifts a week 167 1,148 Y
Wk16 1225 7 shifts a week 190 1,345 G
Wk17 1400 8 shifts a week 192 1,538 G
Wk18 (1 bank holiday) 1050 6 shifts a week 165 1,040 Y
Wk19 (2 bank holiday) 1050 6 shifts a week 173 1,038 Y
Wk20 1575 9 shifts a week 175 1,575 G
Wk21 1225 7 shifts a week 171 1,133 Y
Wk22 1575 9 shifts a week 169 1,521 Y
Wk23 1750 10 shifts a week 174 1,740 Y
Wk24 1050 6 shifts a week 177 1,064 G
Wk25 1750 10 shifts a week 175 1,752 G
Wk26 1400 8 shifts a week 178 1,550 G
Wk27 1225 7 shifts a week 178 1,282 G
Wk28 1575 9 shifts a week 178 1,679 G
Wk29 1575 9 shifts a week 178 1,600 G
Wk30 1575 9 shifts a week 164 1,432 Y
Wk31 1400 8 shifts a week 159 1,210 Y
Wk32 1575 9 shifts a week 172 1,544 Y
Wk33 1575 9 shifts a week 181 1,513 Y
Wk34 1575 9 shifts a week 190 1,726 G
Wk35 1400 8 shifts a week 174 1,394 Y
Wk36 2100 12 shifts a week 174 1,500 R
Wk37 2625 15 shifts a week 175 2,620 G
Wk38 2450 14 shifts a week 173 2,425 G
Wk39 1925 11 shifts a week 173 1,875 G
Wk40 2275 13 shifts a week 173 2,297 G
Wk41 1925 11 shifts a week 137 1,506 Y
Wk42 1925 11 shifts a week 162 1,951 G