Edward is the president of Edge Truss Works, a firm thatmanufactures two types of trusses for space

Edward is the president of Edge Truss Works, a firm thatmanufactures two types of trusses for space applications: Aluminumand composite. The demand for the aluminum model is 650 trusses permonth; demand for the composite truss is 400 per month. Edge has amonthly operating capacity of 1600 hours, with the aluminum modeltaking up 1.5 hours to produce and the composite model requiring 2hours. Each aluminum truss sold yields a $12K profit, and profitfor the aluminum model is $14K. Edge has listed the followinggoals: 1) Attain a profit as close to $12,000K as possible eachmonth 2) Avoid underutilization of the firm’s production capacity 3) Sell as many trusses as possible Set up and solve this problem as a goal programming model withexcel. Attached

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"