Answered step by step
Verified Expert Solution
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 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
please help show work in excell if possible
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