Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

ACCA Financial Accounting Study Text 2020 21

Authors: Emile Woolf International

1st Edition

1848439210, 978-1848439214

More Books

Students also viewed these Accounting questions

Question

m Have you used variety in sentence structure?

Answered: 1 week ago