!!!URGENT!!!

Please solve using Sets and Data sections on LINGO

1. A manufacturer produces a line of household products fabricated from sheet metal. To illustrated his production planning problem supposed that he makes only four products and his production system consists of five production centers: stamping, drilling, assembly, finishing (painting and printing), and packaging. For a given month, he must decide how much of each product to manufacture and aid in this decision he has assembled the data shown in Table 1 and 2. Furthermore, he knows that only 2000 square feet of sheet metal will be available during the month for products 2 and 4. Product 2 requires 2.0 square feet sheet metal per unit and product 4 uses 1.2 square feet sheet metal per unit. Formulate this as a LP model in LINGO by using Sets and Data sections. Table 1: Product 2 Product 1 0.03 0.06 Product 3 0.05 Product 4 0.10 0.15 0.12 Production hours available 400 400 500 450 Dept. Stamping Drilling Assembly Finishing Packaging 0.10 0.10 0.12 0.05 0.04 0.02 0.05 0.03 0.02 0.20 0.06 0.12 0.05 400 Table 2: Product Cost $6 1 Sales Potential Minimum Maximum 1000 6000 500 500 3000 100 1000 Selling price $10 $25 $16 $20 2 $11 $11 3 4 $14