Question: can you solve on excell and show your solution step by step please? (rank ordering clustering example) You are the production chief executive officer of

can you solve on excell and show your solution step by step please? (rank ordering clustering example)

You are the production chief executive officer of the Mena production company. You have 43 components to produce and the production routes are as follows: P4 P7 Components Routing Components Routing P1 M(6-7-8-10) P23 M(4-5-8-6) P2 M(2-8-9-6-16-14) P24 M(13-11-8-12) P3 M(8-11-13) P25 M(7-10) M(3) P26 M(10) P5 M(15-4-5) P27 M(8-11-12) P6 M(6-14) P28 M(9-8-2) M(3-6-16) P29 M(4-5) P8 M(5-6-8) P30 M(11-12) P9 M(5-8-11-4) P31 M(8-10) P10 M(2-9-16) P32 M(2-6-9-16) P11 M(8-12) P33 M(5-6) P12 M(6-8-10) P34 M(3-6) P13 M(6-7-10) P35 M(3-14) P14 M(4-5-6-15) P36 M(3) P15 M(5-8) P37 M(1-2-6-8-9-16) P16 M(5) P38 M(2-8-9-16) P17 M(3-6-14) P39 M(6-10) P18 M(9-16) P40 M(2-6-9) P19 M(4-15-5-8-6) P41 M(5-8-15) P20 M(8-11) P42 M(1-2-6-9-16) P21 M(4-5-8-15) P43 M(5-6-8-15) P22 M(12) Find out part families and group the machines into cells

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Canyou read the article under below and answer the following question like tell us what article you read and your reaction to the article. Your 'audience' is your peers, so can you explain reaction...

IFSM 461: Systems Analysis and Design Precision Electronic Parts, Inc. Case Study Introduction This case study will be used for a series of staged assignments. It should be thoroughly read and...

Design Layout References Mailings Review View Help Helvetica 115 - A A A BEA14 3 IU alex, A - A - et 1 Normal 1 No SpacHeading 1 Heading 2 Tube Font Paragraph yes Bluth Corporation is one of the...

See page 129- 137 on attachment for more details there are five steps to the project. Step 1: Create the loan amortization schedule for the property. Step 2: Create the depreciation schedule. Step 3:...

Please help me with the following two questions: Bluth Corporation: Redesigning Management Information Systems (MIS) Bluth Corporation is one of the oldest and most successful companies in...

Question Please help me with the following two questions: Bluth Corporation: Redesigning Management Information Systems (MIS) Bluth Corporation is one of the oldest and most successful companies in...

Please help me with the following two questions and I will rate helpful immediately Bluth Corporation: Redesigning Management Information Systems (MIS) Bluth Corporation is one of the oldest and most...

Please help me with the following two questions and I will rate helpful right away Bluth Corporation: Redesigning Management Information Systems (MIS) Bluth Corporation is one of the oldest and most...

Can you solve this rank ordering clustering problem with excel? You are the production chief executive officer of the Mena production company. You have 43 components to produce and the production...

On February 1, 2017, Strawberry Corp. factored receivables with a carrying amount of $250,000 to Shortcake Inc. Shortcake assessed a finance charge of 3% of the receivables and retained 5% of the...

What problem facts faced this company (J&E enterprises)? What are the key facts and growth strategy?

Question Content Area Which of the following errors will normally result in overstatement of Year 7 net income? a . understatement of Year 6 ending merchandise inventory b . failure to record...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...