HW2 A company produces several types of sofas and ottoman and is launching its new collection, which includes three- and two-seater sofas, sofa-bed, armchair, and ottoman. The data set below shows information regarding costs with production and stock, production and stock capacities, and demand for the next six months. The initial stock of each type of product is 200 units. Use Excel Solver to determine the optimal production plan for the next six months in order to minimize costs with production and stock and respecting all production and stock limitations while meeting the demand for each product. Production and stock costs Product Two-seater sofa Three-seater sofa Sofa-bed Armchair Ottoman Production cost 320 440 530 66 48 Stock cost 8 8 9 3 3 Production and stock capacities Product Two-seater sofa Three-seater sofa Sofa-bed Armchair Ottoman Production capacity 1800 1600 1500 2000 2000 Stock capacity 20000 18000 15000 22000 22000 Demand for the next six months Product Two-seater sofa Three-seater sofa Sofa-bed Armchair Ottoman Jan 1200 1250 1400 1850 1850 Feb 1500 1430 1500 1700 1700 Mar 1400 1650 1200 2100 2050 Apr 1860 1700 1350 2000 1950 May 2000 1450 1600 1850 2050 June 1700 1500 1450