PLEASE WRITE THE CLOSED FORM. BECAUSE I WILL SOLVE THIS QUESTION IN GAMS.

TABLE 9 Product-Resource Constraints: Plant 2 Labor Material Products (Hours/Unit) (Lb/Unit) Small 3.5 1.1 Medium 3.5 1.0 Large 4.5 1.1 Precision 4.5 Total available 5,000 TABLE 10 Product-Resource Constraints: Plant 3 Labor Products (Hours/Unit) Material (Lb./Unit) Small 3 1.1 Medium 3.5 1.1 Large 4 1.3 Precision 4.5 8.5 1.3 Total available 3,000 6,000 pounds of material is available for the entire system during the planning period. Transport has 3 major customers (RAYco, HONco, and MMCo) for its products. The maximum sales for each customer-product pair is given in Table 11. Prod- uct sales prices are given in Table 12, and the ship- ping costs from each plant to each customer are de- tailed in Table 13. Table 14 contains the production costs for each product-plant pair. All shipping from plants 1 and 2 that goes to RAYco or HONco must go through a special inspec- tion. These units are sent to a central site, inspected, and then sent to their destination. The capacity of this special inspection site is 1,500 pieces. 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 rev- enue generated from each plant. In addition, you should address the following potential issues in your recommendation: If you could get more material, how much would you like? How would you use it? What would you be willing to pay? If you could get more inspection capacity, how much would you like? How would you use it? What would you be willing to pay? 1355 CASE 4 Vision Corporation: Production Planning and Shipping Vision is a large company that produces video- capturing devices for military applications such as missiles, long-range cameras, and aerial drones. Four different types of cameras (differing mainly by lens type) are made in the three plants in the system. Each plant can produce any of the four camera types, although each plant has its own individual constraints and unit costs. These constraints cover labor and ma- chining restrictions, and the specific values are given in Tables 8-10. 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. The corpo- ration controls the material that goes into the lenses; the material requirements for each product are given in the last column of Tables 8-10. A total of 3,500 TABLE 8 Product-Resource Constraints: Plant 1 Resources Products Labar (Hours/Unit) Machine Material (Hours/Unit) (Lb./Unit) Small 3 8 1.0 Medium 3 8.5 1.1 Large 4 9 1.2 Precision 9 1.3 Total available 10,000 CASE 4 Vision Corporation: Production Planning and Shipping 4 6,000 Resources Machine (Hours/Unit) 7 7 8 9 12,500 Resources Machine (Hours/Unit) 7.5 7.5 8.5 TABLE 11 Maximum Product Sales ($) per Unit Producto RAYOO Small 200 Medium 300 Large 500 Precision 200 TABLE 12 Product Sales Price ($) per Unit Products RAYCO Small 17 Medium 18 Large 22 Precision 29 TABLE 13 Shipping Costs ($) per Unit Plant RAYCO MMca 1 1.0 1.1 2 1.2 1.0 3 1.4 1.3 TABLE 14 Production Costs ($) per Unit Plant Products 1 2 3 Small 14 13 14 Medium 16 17 15 Large 18 20 19 Precision 26 24 23 At what plant(s) would you like to add extra ma- chine hours? How much would you be willing to pay per hour? How many extra hours would you like? Marketing is trying to get RAYco to consider a 50% increase in its demand. Can we handle this with the current system or do we need more re- sources? How much more money can we make if we take on the additional demand? 1356 APPENDIX 2 Cases Customers HONO 400 300 200 400 Customers HONco 16 18 22 26 Customers HONco 1.6 1.5 1.5 MMao 200 400 300 300 MMco 16 17 23 27