EAGLES is a large company that produces lenses for cameras in military applications. Four types of lenses are made in the three plants in the system. Each plant can produce any of the four lens types, although each plant has its own individual constraints and unit costs. These constraints cover labor and machining restrictions, and the specific values are given in Tables 1-3. Note that even though the products are identical in the three plants, different production processes are used and thus the products use different amounts of resources in different plants. EAGLES has 3 major customers (CANco, SONco, and XERco) for its products. The maximum sales for each customer- product pair are given below. Maximum product sales (number of units) Customers Products CANco SONco XERco small 200 400 200 medium 300 300 400 large 500 200 300 precision 200 400 300 Product sales prices are given in Table 4, and the shipping costs from each plant to each customer are detailed in Table 5. Table 6 contains the production costs for each product-plant pair. The last row of Tables 1-3 specifies the availability of labor and hours. All shipping from plants 1 and 2 that goes to CANco or SONco must go through a special inspection. These units are sent to a central site, inspected, and then sent to their destination. This special inspection site may inspect at most 1,500 pieces. The corporation controls the material that goes in the lenses; the material requirements for each product are given in the last column of Tables 1-3. A total of 3,500 pounds of material is available for the entire system (that is, all three plants). Table 1. Product-resource constraints - Plant 1 Resources Products Labor Machine Hours/unit hours/unit lb/unit Material small 3 8 1 medium 8.5 1.1 large 4 9 1.2 precision 4 1.3 TAL 6000 10000 AVAIABLE Table 2. Product-resource constraints Plant 2 Resources Machine Hours/unit hours/unit 1lb/unit Products Labor Material small 3.5 7 1.1 medium 3.5 7 1 large 4.5 8 1.1 precision 4.5 9 1.4 TAL 5000 12500 AVAILABLE Table 3. Product-resource constraints- Plant 3 Resources Products Labor Machine Hours/unit hours/unit lb/unit Material small 7.5 1.1 3.5 medium 7.5 1.1 large 4 8.5 1.3 precision 4.5 8.5 1.3 TAL 3000 6000 AVAILABLE Table 4. Product sales price ($) per unit Customers Products CANCO SONCO XERCO small 17 16 16 medium 18 18 17 large precision 29 22 22 23 26 27 Table 5. Shipping costs ($) per unit Customers Plants CANCO SONco XERCO Plant 1 1.6 1.1 Plant 2 1.2 1.5 1 Plant 3 1.4 1.5 1.3 Table 6. Production costs (S) per unit Plants Products Plant 1 Plant 2 Plant 3 small 14 13 14 medium 16 17 15 large 18 20 19 precision 26 24 23 Your job is to determine a recommendation for the company. A recommendation must include a plan for production and shipping as well as the cost and revenue generated from each plant. In addition, you should also address the following sensitivity analysis issues in your recommendation. Note that you should address the following issues by using sensitivity analysis results as much as possible QUESTIONS a) If you could get more material, how much would you like without changing the optimal basis and what would you be willing to pay in total? b) If you could get more inspection capacity, how much would you like without changing the optimal basis? What would you be willing to pay in total? c) At what plant(s) would you like to add extra machine hours and/or extra labor hours? How much would you be wiling to pay per hour? How many extra hours would you like with this price? d) The company is planning to initiate a Research and Development Project in Plant 1 for the production of the medium products that are manufactured specifically for customer CANCO. This project will reduce the production costs of these specific products by 5%. If the cost of this R&D project is 150S, should the company initiate the project? EAGLES is a large company that produces lenses for cameras in military applications. Four types of lenses are made in the three plants in the system. Each plant can produce any of the four lens types, although each plant has its own individual constraints and unit costs. These constraints cover labor and machining restrictions, and the specific values are given in Tables 1-3. Note that even though the products are identical in the three plants, different production processes are used and thus the products use different amounts of resources in different plants. EAGLES has 3 major customers (CANco, SONco, and XERco) for its products. The maximum sales for each customer- product pair are given below. Maximum product sales (number of units) Customers Products CANco SONco XERco small 200 400 200 medium 300 300 400 large 500 200 300 precision 200 400 300 Product sales prices are given in Table 4, and the shipping costs from each plant to each customer are detailed in Table 5. Table 6 contains the production costs for each product-plant pair. The last row of Tables 1-3 specifies the availability of labor and hours. All shipping from plants 1 and 2 that goes to CANco or SONco must go through a special inspection. These units are sent to a central site, inspected, and then sent to their destination. This special inspection site may inspect at most 1,500 pieces. The corporation controls the material that goes in the lenses; the material requirements for each product are given in the last column of Tables 1-3. A total of 3,500 pounds of material is available for the entire system (that is, all three plants). Table 1. Product-resource constraints - Plant 1 Resources Products Labor Machine Hours/unit hours/unit lb/unit Material small 3 8 1 medium 8.5 1.1 large 4 9 1.2 precision 4 1.3 TAL 6000 10000 AVAIABLE Table 2. Product-resource constraints Plant 2 Resources Machine Hours/unit hours/unit 1lb/unit Products Labor Material small 3.5 7 1.1 medium 3.5 7 1 large 4.5 8 1.1 precision 4.5 9 1.4 TAL 5000 12500 AVAILABLE Table 3. Product-resource constraints- Plant 3 Resources Products Labor Machine Hours/unit hours/unit lb/unit Material small 7.5 1.1 3.5 medium 7.5 1.1 large 4 8.5 1.3 precision 4.5 8.5 1.3 TAL 3000 6000 AVAILABLE Table 4. Product sales price ($) per unit Customers Products CANCO SONCO XERCO small 17 16 16 medium 18 18 17 large precision 29 22 22 23 26 27 Table 5. Shipping costs ($) per unit Customers Plants CANCO SONco XERCO Plant 1 1.6 1.1 Plant 2 1.2 1.5 1 Plant 3 1.4 1.5 1.3 Table 6. Production costs (S) per unit Plants Products Plant 1 Plant 2 Plant 3 small 14 13 14 medium 16 17 15 large 18 20 19 precision 26 24 23 Your job is to determine a recommendation for the company. A recommendation must include a plan for production and shipping as well as the cost and revenue generated from each plant. In addition, you should also address the following sensitivity analysis issues in your recommendation. Note that you should address the following issues by using sensitivity analysis results as much as possible QUESTIONS a) If you could get more material, how much would you like without changing the optimal basis and what would you be willing to pay in total? b) If you could get more inspection capacity, how much would you like without changing the optimal basis? What would you be willing to pay in total? c) At what plant(s) would you like to add extra machine hours and/or extra labor hours? How much would you be wiling to pay per hour? How many extra hours would you like with this price? d) The company is planning to initiate a Research and Development Project in Plant 1 for the production of the medium products that are manufactured specifically for customer CANCO. This project will reduce the production costs of these specific products by 5%. If the cost of this R&D project is 150S, should the company initiate the project