Please solve in excel and show steps and formulas.

Polly Astaire makes fine clothing for big and tall men. A few years ago, Astaire entered the sportswear market with the Sunset line of shorts, pants, and shirts. Management wants to make the amount of each product that will maximize profits. Each type of clothing is routed through two departments, A and B$.$ The relevant data for each product are as follows: PROCESSING TIME $($HR$)$Product Department A Department B Material $($yd$)$Shirts $212$Shorts $231$Pants $344$Department A has $120$ hours of capacity, department B has $160$ hours of capacity, and $90$ yards of material are available. Each shirt contributes $$10$ to profits and overhead; each pair of shorts, $$10$; and each pair of pants, $$23.$

a$.$ Specify the objective function and constraints for this problem.

b$.$ Use a computer package such as POM for Windows to solve the problem