Which components should be made in order to maximize output/profit? Integer linear programming

MEMO TO: Management Scientist Analysist From: Larry McMurtry. CFO McMurtry manufacturing The McMurtry manufacturing company produces four support beams that are used by various other manufacturing companies. Production: The demand, profit per component material requirements and one time set-up costs are listed in the following table: Component Profit (5) 35.00 26.00 45.00 32.00 Demand (1000s) 85 65 28 38 Labor (hr) 2.0 2.5 4.0 1.5 Steel (lbs) 25 22 34 29 Set-up Costs ($) SSO 400 700 350 2 3 4 The production dept. has indicated that there are 350 hours of labor and 2 tons of steel available during the next production cycle. Marketing: Research done by the marketing department hus indicates that products 3 and 4 are used interchangeably so only one of them should be produced. Management: Management would like you to format the problem, solve it using Excel and give them your Tecommendations