Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help show work in excell if possible A manufacturing facility consists of 4 departments (A to D) and is to produce three parts (1

please help show work in excell if possible image text in transcribed
A manufacturing facility consists of 4 departments (A to D) and is to produce three parts (1 to 3). Two Material Handlings, MHI and MH2, are being considered. Given the following information, and the LP model, determine the following: (Note: XIADI refers to number of time units for Part 1, traveling from A to D using MHI) Part Routing Volume (in Thousands) Cost in S (time in min) 1 2 3 A-D-C D-B-C. A-D-B-C 10 8 12 MHI (Y1) 1006) - 8(2) 18(6) - 12(6) 6(8)- 8(6)- 14(12) MH2 (Y2) 6(14) - 6(15) 12(14) -6(12) 8(6)-6(9)- 12(16) 1 Min 100000 Y1+140000 Y210 XIADI +6 XIAD2+BXIDC#6 XIDCI 18 X2DB1 + 12X2DB2 -12X2BCI+6 X2BC2+6 XJADI +8X3AD2 +8 X3DBI - 6 XJDB2 + 14X3BCI+12X3BC2 - 72 S.T. XIADI + XIAD2 X2DB1+X2DB2 X3ADI + X3AD2 XIDCI + X1DC2 X2BCI + X2BC2

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

Auditing And Assurance Services A Systematic Approach

Authors: William Messier, Steven Glover, Douglas Prawitt

5th Edition

007333720X, 9780073337203

More Books

Students also viewed these Accounting questions

Question

What are the objectives of job evaluation ?

Answered: 1 week ago

Question

Write a note on job design.

Answered: 1 week ago

Question

Compute the derivative of f(x)cos(-4/5x)

Answered: 1 week ago

Question

Discuss the process involved in selection.

Answered: 1 week ago