Question
Fine Wine Rack is a job shop scheduling problem with necessary predecessor relationships reminiscent of MRP. However, the MRP algorithm is not the key to
Fine Wine Rack is a job shop scheduling problem with necessary predecessor relationships reminiscent of MRP. However, the MRP algorithm is not the key to completing Fine Wine Rack because Fine Wine Rack is a finite loading problem. The key to creating the schedule is understanding the precedence relationships and how activities affect inventory levels from one hour to the next. Schedule the shop for one week. Four people are working for you for 5 x 7 = 35 hours. What do you want them to do?
Table 2: Activity Codes and Vital Production Information
Activity Code No. | Description | How much does one employee produce in an hours worth of work? | What is needed to begin an hours worth of work? | Whos Qualified? | Anything else I should know? |
1 | Make twenty bottle-high verticals | 200 Verticals | Nothing. Youve got plenty of raw materials to last you the week. | Everybody | YES! You currently have 20 of these parts in stock |
2 | Make twenty four bottle-high verticals | 200 Verticals | Nothing. Youve got plenty of raw materials to last you the week. | Everybody | YES! You currently have 20 of these parts in stock. |
3 | Make double-depth horizontal pieces | 150 Horizontal Pieces | Nothing. Youve got plenty of raw materials to last you the week. | Everybody | YES! You currently have 1000 of these parts in stock. |
4 | Make single-depth horizontal pieces | 200 Horizontal Pieces | Nothing. Youve got plenty of raw materials to last you the week. | Everybody | YES! You currently have 1000 of these parts in stock. |
5 | Assemble twenty bottle high, single depth racks | 10 columns | 22 twenty bottle high verticals 420 single depth horizontal pieces | Juan and Debbie | YES! You currently have 10 columns of these racks in stock. |
6 | Assemble twenty bottle high, double depth racks | 10 columns | 22 twenty bottle high verticals 420 double depth horizontal pieces | Juan and Debbie | YES! You currently have 10 columns of these racks in stock. |
7 | Assemble twentyfour bottle high, single depth racks | 10 columns | 22 twenty four bottle high verticals 500 single depth horizontal pieces | Juan and Debbie | YES! You currently have 10 columns of these racks in stock. |
8 | Assemble twentyfour bottle high, double depth racks | 10 columns | 22 twenty four bottle high verticals 500 double depth horizontal pieces | Juan and Debbie | YES! You currently have 10 columns of these racks in stock. |
9 | Make Trim | One hours worth of trim work. | Nothing. Youve got plenty of wood in stock | Juan and Debbie | N/A |
10 | Inspecting a Cellar | One hours worth of inspection. | Whatever the cellar requires in racks must be in stock and all work on the cellars trim must be completed before inspection can begin. | Juan | Yes. Once inspection starts on a cellar, the racks required by that cellar are used and disappear from your standard stock. |
11 | Packing a Cellar | One hours worth of packing. | The cellar must be completely inspected before packing can begin. | Juan, Debbie, and Mike | N/A |
Table1 : Job Releases
Job Code Number | Job Name | 20 High, Single Depth Racks | 20 High, Double Depth Racks | 24 High, Single Depth Racks | 24 High, Double Depth Racks | Trim Work Required for job | Inspection Required for job | Packing Required for job | Promised Shipping Date |
1 | Larrochi | 0 | 0 | 30 columns | 0 | 1 hour | 1 hour | 1 hour | Friday, Week 1 |
2 | Chen | 0 | 0 | 10 columns | 40 columns | 1 hour | 1 hour | 1 hour | Monday, Week 2 |
3 | Brannan | 20 columns | 0 | 0 | 40 columns | 1 hour | 1 hour | 1 hour | Wednesday, Week 1 |
4 | Matthewson | 50 columns | 0 | 0 | 50 columns | 2 hour | 1 hour 2 | 2 hour | Friday, Week 1 |
5 | Loi | 30 columns | 40 columns | 0 | 10 columns | 1 hour | 1 hour | 1 hour | Friday, Week 1 |
6 | Bender | 50 columns | 10 columns | 10 columns | 30 columns | 2 hour | 1 hour | 2 hour | Friday, Week 2 |
7 | Myers | 10 columns | 10 columns | 0 | 0 | 1 hour | 1 hour | 1 hour | Friday, Week 1 |
8 | Berenger | 40 columns | 20 columns | 0 | 0 | 1 hour | 1 hour | 1 hour | Thursday, Week 1 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started