*Alert*

REPOSTING IT PLEASE SOLVE ON EXCEL SOLVER

*Formulate this problem as a linear programming problem, create a model on Excel, and solve it on Solver. *

Decora Accessories manufactures a variety of bathroom accessories including decorative towel rods and shower curtain rods. Each of the accessories includes a rod made out of stainless steel. However, many different lengths are needed: 12, 18, 24, 40, and 60 inches. Decora purchases 60-inch rods from an outside supplier and then cuts the rods as needed for their products. Each 60-inch rod can be used to make a number of smaller rods. For example, a 60-inch rod could be used to make a 40-inch rod and an 18-inch rod (with 2 inches of waste) or five 12-inch rods (with no waste). There are numerous other ways of cutting a 60-inch rod. For the next production period, Decora needs twenty-five 12-inch rods, fifty-two 18-inch rods, forty-five 24-inch rods, thirty 40-inch rods, and twelve 60-inch rods. What is the fewest number of 60-inch rods that can be purchased to meet their production needs? Formulate this problem as a linear programming problem, create a model on Excel, and solve it on Solver.