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: 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 has 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 recommendations. 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: 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 has 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 recommendations