Solving linear programming problems in a spreadsheet yields equations for maximizing business profits. ... How to Create a BOM Using MS Excel. Tree diagrams use graphics to indicate the materials ...