Assignment help 5123

Please see the attachedMichigan, Ohio, and California and two in New York. Management is consideringmodernizing these plants to manufacture engine blocks and transmissions for a newmodel car. The cost to modernize each plant and the manufacturing capacity aftermodernization are as follows:Plant Cost[$ millions]Engine Blocks[1000s]Transmissions[1000s]Michigan 25 500 300New York 35 800 400New York 35 400 800Ohio 40 900 600California 20 200 300The projected needs are for total capacities of 900,000 engine blocks and 900,000transmissions. Management wants to determine which plants to modernize to meetprojected manufacturing needs and, at the same time, minimize the total cost ofmodernization.a) Formulate a binary (0-1 integer) programming model that could be used todetermine the optimal solution to the modernization question facing managementb) Solve the model formulated in part a) and provide a recommendation formanagement questions and requirements. Thank you!