Fine Wine Rack Output Assignment

Create a work schedule for 4 employees to meet all of the orders as close to the scheduled date as possible. Make sure there are enough parts in stock to assemble then ship out the parts. Photos attached.

Table 1: Fine Wine Rack Job Releases Job Code Number Job Name Trim Work Required Inspection Required 20 High Single Depth Racks 40 columns 20 High, Double Depth Racks 10 columns 24 High, Single Depth Racks 0 columns 24 High, Double Depth Racks 0 columns Packing Required for job Promised Shipping Date for job for job Larrochi 1 hour 1 hour 1 hour 2 Chen 40 columns 0 columns 10 columns 20 columns 1 hour 1 hour 1 hour 3 Brannan 0 columns O columns 20 columns 30 columns 1 hour 1 hour 1 hour 4 Matthewson 0 columns 30 columns O columns 40 columns 2 hour 1 hour 2 hour Friday, Week 1 Monday, Week 2 Wednesday, Week 1 Friday, Week 1 Friday, Week 1 Friday, Week 2 Friday, Week 1 Thursday, Week 1 5 Loi 0 columns 0 columns 10 columns 20 columns 1 hour 1 hour 1 hour Bender 60 columns 10 columns 10 columns O columns 2 hour 1 hour 2 hour 7 Myers 10 columns 10 columns 10 columns 0 columns 1 hour 1 hour 1 hour 8 Berenger 0 columns 50 columns 0 columns 50 columns 1 hour 1 hour 1 hour Who's Qualified? Anything else I should know? Everybody YES! You currently have 20 of these parts in stock. YES! You currently have 20 of these parts in stock. Everybody Everybody YES! You currently have 1000 of these parts in stock. Everybody YES! You currently have 1000 of these parts in stock Juan and Debbie YES! You currently have 10 columns of these racks in stock. Table 2: Activity Codes and Vital Production Information Activity Description How much does one What is needed to begin Code employee produce in an an hour's worth of No. hour's worth of work? work? 1 Make twenty- 200 Verticals Nothing. You've got bottle-high plenty of raw materials verticals to last you the week. 2 Make 200 Verticals Nothing. You've got twentyfour- plenty of raw materials bottle-high to last you the week. verticals 3 Make double- 150 Horizontal Pieces Nothing. You've got depth plenty of raw materials horizontal to last you the week. pieces 4 Make single- 200 Horizontal Pieces Nothing. You've got depth plenty of raw materials horizontal to last you the week. pieces 5 Assemble 10 columns 22 twenty bottle high twenty bottle verticals high, single 420 single depth depth racks horizontal pieces 6 Assemble 10 columns 22 twenty bottle high twenty bottle verticals high, double 420 double depth depth racks horizontal pieces 7 Assemble 10 columns 22 twenty four bottle twentyfour high verticals bottle high, 500 single depth single depth horizontal pieces racks 8 Assemble 10 columns 22 twenty four bottle twentyfour high verticals bottle high, 500 double depth double depth horizontal pieces racks 9 Make Trim One hour's worth of Nothing. You've got trim work. plenty of wood in stock. 10 Inspecting a One hour's worth of Whatever the cellar Cellar inspection. requires in racks must be in stock and all work on the cellar's trim must be completed before inspection can begin. 11 Packing a One hour's worth of The cellar must be Cellar packing completely inspected before packing can begin. Juan and Debbie YES! You currently have 10 columns of these racks in stock. Juan and Debbie YES! You currently have 10 columns of these racks in stock. Juan and Debbie YES! You currently have 10 columns of these racks in stock. No Juan and Debbie Juan Yes. Once inspection starts on a cellar, the racks required by that cellar are "used" and disappear from your standard stock. No. Juan, Debbie, and Mike Remember: Only Activity Codes 9, 10 and 11 need Job Codes also. 7 ON 9 9 JUAN Hour 1 Hour 2 Hour 3 Hour 4 Hour 5 Hour 6 Hour 7 Monday Activity Codel 1 31 51 9 10 Job Code 1 Tuesday Activity Codel 91 9 7 10 Job Code 3 4 31 Wednesday Activity Code 31 31 61 61 8 8 Job Code Thursday Activity Codel 10 11 Job Code 7 7 Friday Activity Code 31 31 31 31 Job Code O) 000 00WOO 11 3 10 8 6 00 5 3 Hour 5 Hour 6 Hour 7 5 5 6 01 9 31 8 8 81 9 DEBBIE Hour 1 Hour 2 Hour 3 Hour 4 Monday Activity Code 2 4 Job Code Tuesday Activity Code 31 Job Code Wednesday Activity Code 6 6 Job Code Thursday Activity Code 9 31 3 Job Code Friday Activity Code Job Code O O O O 8 8 8 81 3 6 11 9 101 O NO no Hour 3 Hour 4 Hour 5 Hour 6 Hour 7 21 2 2 11 7 31 3 1 MIKE Hour 1 Hour 2 Monday Activity Code Job Code Tuesday Activity Code 2 Job Code Wednesday Activity Code 3 Job Code Thursday Activity Code 11 Job Code Friday Activity Code Job Code 3 31 3 3 31 3 8 4 31 3 3 3 3 Hour 3 Hour 4 51 Hour 5 Hour 6 Hour 7 4 4 4 2 21 31 3 3 STAN Hour 1 Hour 2 Monday Activity Code 2) Job Code Tuesday Activity Code 20 Job Code Wednesday Activity Code 3 Job Code Thursday Activity Code 3 Job Code Friday Activity Code Job Code 31 31 31 3 31 31 3 8 3 Table 1: Fine Wine Rack Job Releases Job Code Number Job Name Trim Work Required Inspection Required 20 High Single Depth Racks 40 columns 20 High, Double Depth Racks 10 columns 24 High, Single Depth Racks 0 columns 24 High, Double Depth Racks 0 columns Packing Required for job Promised Shipping Date for job for job Larrochi 1 hour 1 hour 1 hour 2 Chen 40 columns 0 columns 10 columns 20 columns 1 hour 1 hour 1 hour 3 Brannan 0 columns O columns 20 columns 30 columns 1 hour 1 hour 1 hour 4 Matthewson 0 columns 30 columns O columns 40 columns 2 hour 1 hour 2 hour Friday, Week 1 Monday, Week 2 Wednesday, Week 1 Friday, Week 1 Friday, Week 1 Friday, Week 2 Friday, Week 1 Thursday, Week 1 5 Loi 0 columns 0 columns 10 columns 20 columns 1 hour 1 hour 1 hour Bender 60 columns 10 columns 10 columns O columns 2 hour 1 hour 2 hour 7 Myers 10 columns 10 columns 10 columns 0 columns 1 hour 1 hour 1 hour 8 Berenger 0 columns 50 columns 0 columns 50 columns 1 hour 1 hour 1 hour Who's Qualified? Anything else I should know? Everybody YES! You currently have 20 of these parts in stock. YES! You currently have 20 of these parts in stock. Everybody Everybody YES! You currently have 1000 of these parts in stock. Everybody YES! You currently have 1000 of these parts in stock Juan and Debbie YES! You currently have 10 columns of these racks in stock. Table 2: Activity Codes and Vital Production Information Activity Description How much does one What is needed to begin Code employee produce in an an hour's worth of No. hour's worth of work? work? 1 Make twenty- 200 Verticals Nothing. You've got bottle-high plenty of raw materials verticals to last you the week. 2 Make 200 Verticals Nothing. You've got twentyfour- plenty of raw materials bottle-high to last you the week. verticals 3 Make double- 150 Horizontal Pieces Nothing. You've got depth plenty of raw materials horizontal to last you the week. pieces 4 Make single- 200 Horizontal Pieces Nothing. You've got depth plenty of raw materials horizontal to last you the week. pieces 5 Assemble 10 columns 22 twenty bottle high twenty bottle verticals high, single 420 single depth depth racks horizontal pieces 6 Assemble 10 columns 22 twenty bottle high twenty bottle verticals high, double 420 double depth depth racks horizontal pieces 7 Assemble 10 columns 22 twenty four bottle twentyfour high verticals bottle high, 500 single depth single depth horizontal pieces racks 8 Assemble 10 columns 22 twenty four bottle twentyfour high verticals bottle high, 500 double depth double depth horizontal pieces racks 9 Make Trim One hour's worth of Nothing. You've got trim work. plenty of wood in stock. 10 Inspecting a One hour's worth of Whatever the cellar Cellar inspection. requires in racks must be in stock and all work on the cellar's trim must be completed before inspection can begin. 11 Packing a One hour's worth of The cellar must be Cellar packing completely inspected before packing can begin. Juan and Debbie YES! You currently have 10 columns of these racks in stock. Juan and Debbie YES! You currently have 10 columns of these racks in stock. Juan and Debbie YES! You currently have 10 columns of these racks in stock. No Juan and Debbie Juan Yes. Once inspection starts on a cellar, the racks required by that cellar are "used" and disappear from your standard stock. No. Juan, Debbie, and Mike Remember: Only Activity Codes 9, 10 and 11 need Job Codes also. 7 ON 9 9 JUAN Hour 1 Hour 2 Hour 3 Hour 4 Hour 5 Hour 6 Hour 7 Monday Activity Codel 1 31 51 9 10 Job Code 1 Tuesday Activity Codel 91 9 7 10 Job Code 3 4 31 Wednesday Activity Code 31 31 61 61 8 8 Job Code Thursday Activity Codel 10 11 Job Code 7 7 Friday Activity Code 31 31 31 31 Job Code O) 000 00WOO 11 3 10 8 6 00 5 3 Hour 5 Hour 6 Hour 7 5 5 6 01 9 31 8 8 81 9 DEBBIE Hour 1 Hour 2 Hour 3 Hour 4 Monday Activity Code 2 4 Job Code Tuesday Activity Code 31 Job Code Wednesday Activity Code 6 6 Job Code Thursday Activity Code 9 31 3 Job Code Friday Activity Code Job Code O O O O 8 8 8 81 3 6 11 9 101 O NO no Hour 3 Hour 4 Hour 5 Hour 6 Hour 7 21 2 2 11 7 31 3 1 MIKE Hour 1 Hour 2 Monday Activity Code Job Code Tuesday Activity Code 2 Job Code Wednesday Activity Code 3 Job Code Thursday Activity Code 11 Job Code Friday Activity Code Job Code 3 31 3 3 31 3 8 4 31 3 3 3 3 Hour 3 Hour 4 51 Hour 5 Hour 6 Hour 7 4 4 4 2 21 31 3 3 STAN Hour 1 Hour 2 Monday Activity Code 2) Job Code Tuesday Activity Code 20 Job Code Wednesday Activity Code 3 Job Code Thursday Activity Code 3 Job Code Friday Activity Code Job Code 31 31 31 3 31 31 3 8 3