Note: Upload Excel File and share Link Please.

A chemical plant makes three major products on a weekly basis. Each of these products requires a certain quantity of raw chemical and different production times, and yields different profits. The pertinent information is in following table. Note that there is sufficient warehouse space at the plant to store a total of 450 kg/week.

a) Establish the equations explaining the system.

b) Solve it using the MS Office Excel Solver to get the highest profit; make production optimization and determine the product quantities.

Please show how to do this problem in Excel solver. all steps to solve it in EXCEL SOLVER.

Note: Upload Excel File and share Link Please.

Product 1 Product 2 Product 3 Resource Availability Raw chemical 6 kg/kg 0.05 hr/kg 4 kg/kg 0.1 hr/kg 12 kg/kg 0.2 hr/kg 2500 kg 55 hr/week Production time Profit $30/kg $30/kg $35/kg Product 1 Product 2 Product 3 Resource Availability Raw chemical 6 kg/kg 0.05 hr/kg 4 kg/kg 0.1 hr/kg 12 kg/kg 0.2 hr/kg 2500 kg 55 hr/week Production time Profit $30/kg $30/kg $35/kg