formulate LP and solve.

Data Set - Steelco to save OR ome Draw Insert Page Layout Formulas Review Data View Tell me zoom ide 5 Unde Wir Form Zoom 100% la Normal Break Page Custom Heading Nee Are Free Free Freeze First Zoom to 100% Pe Layout View Window A Danes Top Row Column 15 : x x D . 0 Table Selling Price of Each Type of Beam Beam Selling Price (Son) You have recently been hired by GCM, a prestigious consulting firm, as a full-time consultant. Congratulations! $1.000 As part of your first project within GCM, you have been assigned to work for Steelco Inc, which manufactures w $750 U $1,500 steel beams. Steelco Inc. manufactures 1, W. U, H. and L beams. You are required to help Steelco develop an H $1,200 optimired work schedule for the 12 months of 2022. This year, under a similar demand and without any 5800 optimiration tools, the company expects to clear around $60,000,000 in profits from these five products. To manufacture beams, Steelco purchases recycled steel for $400/ton and new steel for $600/ton. Due to the quality of the stoel, only 80% of the recycled steel can be used to produce the products. Furthermore, at most 6,000 tons of recycled steel can be purchased each month and only 5,000 tons of new steel can be purchased at any month Each ton of I, W, U, H, and L beams that is produced is sold by the price described in Table 1 (sce file Data Set - Steelco.xlsx in Canvas). Due to quality requirements, at least 40%, 20%, 60%, 10%, und 25% of I, W. U, H, and Lbcams, respectively, must be manufactured from new steel Each ton of product held over in inventory from one month to the next month costs the company S40/ton If demand at each month is not met, then there is a penalty cost of S100/ton for I bcams, $300/ion for W beams, $250 tons for U beams, $600/hon for H beams, and S1000/ron for L beams. In such a case, the item is placed on backorder and the order must be shipped to the customer at some future time. Demand of each product over the next 12 months is shown in Table 2 (see file Data Set - Steeloo.xlsx in Canvas). You must assume that you have nothing in inventory or items that are backordered, and that you must end 2022 with the same condition 3500 Table 2-Demand of each type of Beam over the Next 12 Months Beam Month 1 W U H L Jan 3500 2400 2700 2500 1200 Feb 1000 300 2400 1300 1500 Mar 700 900 3100 500 4300 Apr 1400 800 1600 3300 3900 May 2000 1400 3600 2100 800 Jun 2000 900 3700 1500 200 Jul 1000 900 2000 1000 A 1700 1000 3100 800 1200 2000 1700 3300 4100 2200 1 Oct 3000 1500 3000 2000 1300 12 NOV 1000 1900 2000 2000 4100 Dec 700 2000 3100 100 1000 24 25 36 3 E 19 30 38 32 11 17 18