1stMidtermII JAY

N ORTHEASTERN U NIVERSITY M ECHANICAL & I NDUSTRIAL ENGINEERING DEPARTMENT MIDETERM N O . ( PART II) 1 C OURSE C ODE D ATE SUPPLY CHAIN ENGINEERING Dr. César Martínez Olvera IE 7200 10/13/2023 N AME ID N UMBER G RADE JAY BHAVSAR 002790681 “I pledge to comply with the Code of Ethics of Northeastern University – Department of Mechanical & Industrial Engineering, while working in the solving of the problems present in the current homework You have the Sales information for Operations #6 and #7: Operation#6 Operation#7 Period Sales Period Sales 1 4000 1 5000 2 4000 2 6500 3 3500 3 6000 4 6000 4 4500 5 5000 5 5000 6 4000 6 6500 7 3500 7 5000 8 3000 8 5500 9 3500 9 5000 10 4000 10 5000

Use the Forecast Sheet tool of Excel, to forecast periods 11, 12, 13, and 14 (of Operations #6 and #7). Based on the obtained results, answer the following questions: 1.- Which Logistic Network offers a total fulfilled demand (see Appendix A for an example of this last), the AS-IS (without Op5GER) or the TO-BE (with Op5GER)? Support your answer with the proper information and/or analysis. Value: 30 points.

Reason why we rejected the rest because of network path asymmetry in selection of the operation locations as they are considering Germany and Brazil in the network. For 2: Op#2 – Op#5: total cost achieved 1650 For 4: Op#4 – Op#5:total cost achieved 2050 For 5: Op#5 – Op#6:total cost achieved 1540 For 6: Op#5 – Op#7:total cost achieved 1410 3.- If you could modify ONE and ONLY ONE maximum delivery capacity constraints, that is, shipments among Manufacturing Country and Operation #, or Xinputs (1 or 2), or Xoutputs (1 or 2), which one would be and why? Justify in detail your answer. Value: 10 points. XOUTPUT2 SHOULD BE MORE THAN 5017 SO THE DEMAND CAN BE FUILFILLED. Conclusion:- Even though we have increased the maximum delivery capacities for the four scenarios, we are selecting scenario #4 because of better operational