PLEASE PROVIDE LINEAR PROGRAMMING SOLUTION ALONG WITH OBJEVTIVE FUNCTION EQUATION AND SOLVEE THROUGH THE LINGO TOOL .ALSO SHARE THE OUTPUT OF LINGO TOOL

TABLE 9 Product Resource Constraints: Plant 2 Rescue Machine Houwal Labor Hours/Unl Products Material LJU Small Medium Large 3.5 3.5 4.5 4.5 5,000 7 7 8 9 1.1 1.0 1.1 1.4 Precision Total available 12.500 TABLE 10 Product-flesource Constraints: Plant 3 Resources Machine (Hours Unit Products Material LLIURE Small Medium Large Precision Total available Labor ( Hrs/UND 3 3.5 4 4.5 7.5 7.5 8.5 8.5 1.1 1.1 1.3 1.3 3,000 6,000 CASE 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 pounds of material is available for the entire system during the planning period. Transport has 3 major customers (RAYCO, HONO, 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? TABLE 8 Product-Fosource Constraints: Part 1 Resources pers/Unt) Material LJU Products Small Medium Large Precision Total available Hours/Unt) ) 3 3 4 4 8 8.5 9 9 1.0 1.1 1.2 1.3 6,000 10,000 MM TABLE 11 Maximum Product Sales ($) per Unit Costumes Products RAYCS HONO Small 200 400 Medium 300 300 Large SOO 200 Precision 200 400 200 400 300 300 TABLE 12 Product Sales Price ($) per Unit Customers HONG RAY MM Products Small Medium Large Precision 17 18 22 29 16 18 22 26 16 17 23 27 TABLE 13 Shipping Casts() per Unit Customers Plant RAYCO HONCH 1 1.0 1.6 2 1.2 1.5 3 1.4 1.5 MMC 1.1 1.0 1.3 TABLE 14 Production Costs (9) per Unit Plant 2 3 Products Small Medium Large Precision 1 14 16 18 26 13 17 20 24 14 15 19 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