DO NOT USE EXCEL

DO NOT USE EXCEL

DO NOT USE EXCEL

DO NOT USE EXCEL

DO NOT USE EXCEL

DO NOT USE EXCEL

DO NOT USE EXCEL

DO NOT USE EXCEL

DO NOT USE EXCEL

DO NOT USE EXCEL

DO NOT USE EXCEL

THANK YOU

The N. Dustrious Company produces two products: I and II. TABLE 1 Production Data for N. Dustrious Company Product I = II 5 3 30 11 Storage space (ft2/unit) 4 Raw material (lb/unit) 5 Production rate (units/hr) 60 Selling price (S/unit) 13 The raw material requirements, space needed for storage, production rates, and selling prices for these products are given in Table 1. The total amount of raw material available per day for both products is 1575 16. The total storage space for all products is 1500 ft?, and a maximum of 7 hours per day can be used for production. All products manufactured are shipped out of the storage area at the end of the day. Therefore, the two products must share the total raw material storage space, and production time. Define the decision variables clearly and formulate a linear programming (LP) model to determine how many units of each product to produce per day to maximize its total income. Don't use Excel to solve it