16 I A manufacturer is going to produce four products. The relative data for production are listed below. Product 1 Product 2 Product 3 Product 4 Setup cost 400 400 500 600 Unit profit 100 60 120 160 Resource needed for unit 10 12 production The total resource available is 1000. Suppose product 2 and 4 are mutually competitive items, hence will not be produced at the same time. Product 1 will be produced only if product 3 is produced. Try to establish the mathematical model for this problem to determine the production quantity of each product with total profit maximized. Solve it with Excel