Fall 2024 IE 360 Facilities Planning and Design

Fall 2024 IE 360 Facilities Planning and Design   Homework 1 Name:  Click or tap here to enter text.               Student ID :Click or tap here to enter text.   Question 1: (60 pts) An automobile engine cylinder manufacturing company plans to manufacture four types of cylinders: a basic engine cylinder, a high technology cylinder, a sports carcylinder and a luxury car cylinder. The marketing department has determined to produce 1800, 2000, 1100 and 1500 units of the basic, high-tech, sports, and luxury models, respectively according to the demand forecast. The facility plan department wants to design a plant and decide the number of equipment to purchase.   Three machine types and three material handling systems  are available for performing the three operations and transporting products. The cylinder models require one or more of three operations,  and and the total required numbers of each type of operation are 6000, 5000 and 4000 respectively to produce the all of the demands. Finished goods are transported using either of two material handling systems  The costs of machines and  are $280,000, $220,000 and $250,000. The costs of the material handling carriers  are $90,000, $80,000 and $70,000 respectively. The available budget for equipment is $8,000,000.  The following two matrices show the operating cost. :  The cost of performing operation  on production equipment  :  The cost of handling product type  using the material handling system           The time required to perform operation  on machine  is inversely proportional to the corresponding cost, = 8/. Similarly, 代写Fall 2024 IE 360 Facilities Planning and Design    the time required to transport  on material handling system  is inversely proportional to the corresponding cost, = 1/.  Each machine is available for 700 unit time and each material handling system is available for 700 unit time.   a) Implement the integer programming model to minimize the total cost using cvxpy on python. Copy and paste your .py codes in the below box. .py code       b) What is the optimal objective value? What is the optimal quantity of each production and handling equipment? The optimal objective value: Click or tap here to enter text. The optimal solution is () = Click or tap here to enter text. Question 2: (40 pts) The following table is a partial parts list for a gate valve:  Part Name Part No. Material Size(inches) Make or Buy Body 001 Cast bronze 2.75 x 2.5 x 1.5 Make Bushing 002 Cast bronze 2.97 x 0.87 Make Stem 003 3/8 in. bar stock 0.9 x 2.1 Make Fiber Packing 004 Sillicon 2.78 x 2.5 x 1.5 Buy Cap 005 3/4 in. hex bar stock 1.8 x 0.9 Make Handle 006 Cast bronze 0.42 x 1.20 Make Nut 007 Aluminum 0.21 x 1.00 Buy The following is a set of route sheets for a subset of these parts. Part No. Operation No. Operations Machine Standard Time (min/part) 001 001-1 Cast Bench mold 3.60 001-2CleanTumble barrel0.30 001-3Machine thread Turret lathe3.00 002 002-1 Cast Bench mold 0.60 002-2CleanTumble barrel0.60 002-3Machine threadTurret lathe2.4 003 003-1 Machine all  surfaces and cut-off Automatic Screw Machine 0.30 005 005-1 Drill Automatic Screw Machine 0.30 006 006-1 Cast Bench mold 3.00 006-2CleanTumble barrel0.15 006-3Broach square holeBroach1.20   a) [30 points] One unit of each part is required to make the final product. Suppose we want to produce 500 units per hour and assume the machines are effectively 90% reliable. Fill in the table and develop a rough estimate for the number of each type of machine that will be required. Op.No. t(hours) Production  rate MachineNM=Machines Req 001-1 001-2 001-3 002-1 002-2 002-3 003-1 005-1 006-1 006-2 006-3 Estimated total Machines required: (Bench mold, Tumble Barrel, Turret Lathe, Auto Screw, Broach) = Click or tap here to enter text. b) [10 points] Given below is an assembly chart for the product. Using the route sheet above, construct an Operations Process Chart.Operations Process Chart