Question: please solwing this question clearly and neadly. that's all data. need your help 1. A manufacturer produces a line of household products fabricated from sheet

please solwing this question clearly and neadly. that's all data. need your help
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 0.15 0.12 Product 3 0.05 Product 4 0.10 0.10 Dept. Stamping Drilling Assembly Finishing Packaging Product 1 0.03 0.06 0.05 0.04 0.02 Production hours available 400 400 500 450 400 0.10 0.12 0.05 0.03 0.20 0.06 0.12 0.05 0.02 Table 2: Product Cost $6 Sales Potential Minimum Maximum 1000 6000 1 Selling price $10 $25 $16 2. $11 $11 3 4 500 100 500 3000 1000 $20 $14Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
