(PLEASE SHOW EXCEL STEPS)A manufacurer of bathroom fixturesproduces fiberglass bathtubs in an assebly operations consisting ofthree processes: moldinig, smoothing, and painting. The number ofunits that can be put throught each process in an hour is shownbelow. (Note: the three processes are contious ans sequential;thus, no more units can be smoothed or painted than have beenmolded.) The labor cost Each bathtub requires 90 pounds offiberglass, and the company has a total of 10,000 pounds offiberglass available each week Each bathtub earns a profit of $175.The manager of the company wants to know how many hours per week torun each process in order to maximize profit. Formulate and solve alinear programing model for this problem
Process, Output, and Cost as Follows--- (Modeling: 7units/hr @$8/hr) (Smoothing: 12units/hr @ $5/hr) (Painting: 10units/hr @$6.50/hr)
