Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Put these in three tabs, one problem per tab, with a cover sheet tab in the first tab position. Use the highlighter tool to highlight
Put these in three tabs, one problem per tab, with a cover sheet tab in the first tab position. Use the highlighter tool to highlight the cells in your matrix AND type your answer to each problem (which families contain which components) in the cells below the matrix.
please explain excel work you do
F a.) The following table of products and machine routings must be used to formulate work cells. Which products and machines should form each cell? Product Machine Routing A 6, 4,2 B 7, 1.9 3. 5.9 D 6,7 E 8,2 1,5 G 1,9, 5, 3 H 8, 4,2 b.) A distribution center has performed an order analysis of product demand by their major customers for the past year. If they can identify major groupings of products and customers, they can locate the stock in the aisles of their warehouse to reduce extra travel in fulfillment picking by their associates. The following table shows the most frequently ordered SKUs (stock keeping units) by their customer IDs. Which SKUs should be slotted (placed) nearest the family of) shipping docks for which customers? Customer ID Typical SKUs in Orders 001 A, F. H 002 MN, O 003 D. E 004 BD 005 A, C, H 006 D, E, G 007 MO 008 J, K, L 009 IK 010 A, C,G 011 B, D, E, G 012 B, E, G 013 C, F, G, H 014 I, JL 015 NO B C D E F G H I J K L M N O P Q R S T U V W X Col. Value 31744 30720 H25600 1920 112 Col. Sort Row Sort 3330 Reset Row Value HORAKLDINGMUQEB 28672 T 28672 81 1 T 245761 1 1 T 24576 3 1 T 22528 1 T 3584 1 1 1 T 3584 1 1 1 T 3072 10 1 1 T 480 T 464 13 T 256 T 176 12 T 14 1 1 1 T 9 1 1 T 9 1 Part Family Blue: Machines: 1, 2, 3, 6, 8 Products: H, O, F Part Family Yellow: Machines: 5, 6, 7, 10 Products: A, KL Part Family Red: Machines: 4, 11, 12, 13 Products: D, G, I, M, N Part Family Orange: Machines: 9, 14, 15 Products: B, C, E, J Common Machines: Machine o - eitner purcnase two copies, or locate macnine 6 near both the Blue and Yellow cells and try NOT to schedule Products F & H to run at the same time as Product A BAN Col. Value 0 30720 29696 896 896 512 D384 R 112 10 DLHELGE 1 Col. Sort 1 Row Sort 1 N Row Value T 24576 2 T 24576 4 T 24576 15 T 16384 T 8192 10 T 7168 3 T 6656 T 6656 8 T 384 5 T 384 12 T 3529 T 11 T 29 13 T 166 T 11 14 1 1 1 1 1 1 Reset 1 1 30 1 1 1 1 1 1 1 1 1 1 1 1 Part Family Blue: Machines: 1, 2, 4, 10, 15 Products: A, B Part Family Yellow: Machines: 3, 7, 8 Products: D, J, M, O Part Family Red: Machines: 5, 9, 12 Products: E, G, H, L Part Family Orange: Machines: 6, 11, 13, 14 Products: C, F, I, K, N F a.) The following table of products and machine routings must be used to formulate work cells. Which products and machines should form each cell? Product Machine Routing A 6, 4,2 B 7, 1.9 3. 5.9 D 6,7 E 8,2 1,5 G 1,9, 5, 3 H 8, 4,2 b.) A distribution center has performed an order analysis of product demand by their major customers for the past year. If they can identify major groupings of products and customers, they can locate the stock in the aisles of their warehouse to reduce extra travel in fulfillment picking by their associates. The following table shows the most frequently ordered SKUs (stock keeping units) by their customer IDs. Which SKUs should be slotted (placed) nearest the family of) shipping docks for which customers? Customer ID Typical SKUs in Orders 001 A, F. H 002 MN, O 003 D. E 004 BD 005 A, C, H 006 D, E, G 007 MO 008 J, K, L 009 IK 010 A, C,G 011 B, D, E, G 012 B, E, G 013 C, F, G, H 014 I, JL 015 NO B C D E F G H I J K L M N O P Q R S T U V W X Col. Value 31744 30720 H25600 1920 112 Col. Sort Row Sort 3330 Reset Row Value HORAKLDINGMUQEB 28672 T 28672 81 1 T 245761 1 1 T 24576 3 1 T 22528 1 T 3584 1 1 1 T 3584 1 1 1 T 3072 10 1 1 T 480 T 464 13 T 256 T 176 12 T 14 1 1 1 T 9 1 1 T 9 1 Part Family Blue: Machines: 1, 2, 3, 6, 8 Products: H, O, F Part Family Yellow: Machines: 5, 6, 7, 10 Products: A, KL Part Family Red: Machines: 4, 11, 12, 13 Products: D, G, I, M, N Part Family Orange: Machines: 9, 14, 15 Products: B, C, E, J Common Machines: Machine o - eitner purcnase two copies, or locate macnine 6 near both the Blue and Yellow cells and try NOT to schedule Products F & H to run at the same time as Product A BAN Col. Value 0 30720 29696 896 896 512 D384 R 112 10 DLHELGE 1 Col. Sort 1 Row Sort 1 N Row Value T 24576 2 T 24576 4 T 24576 15 T 16384 T 8192 10 T 7168 3 T 6656 T 6656 8 T 384 5 T 384 12 T 3529 T 11 T 29 13 T 166 T 11 14 1 1 1 1 1 1 Reset 1 1 30 1 1 1 1 1 1 1 1 1 1 1 1 Part Family Blue: Machines: 1, 2, 4, 10, 15 Products: A, B Part Family Yellow: Machines: 3, 7, 8 Products: D, J, M, O Part Family Red: Machines: 5, 9, 12 Products: E, G, H, L Part Family Orange: Machines: 6, 11, 13, 14 Products: C, F, I, K, NStep 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