Note: Question 11 refers to question 25. Also, Submit a filled out hard-copy LP Template for each problem; also submit an Excel spreadsheet for each problem.

11. Refer to question 25 at the end of Chapter 2. Implement a spreadsheet model for this problem and solve it using Solver. 25. Sanderson Manufacturing produces ornate, decorative wood frame doors and win- dows. Each item produced goes through three manufacturing processes: cutting, sanding, and finishing. Each door produced requires 1 hour in cutting, 30 minutes in sanding, and 30 minutes in finishing. Each window requires 30 minutes in cut- ting, 45 minutes in sanding, and 1 hour in finishing. In the coming week Sander- son has 40 hours of cutting capacity available, 40 hours of sanding capacity, and 60 hours of finishing capacity. Assume all doors produced can be sold for a profit of $500 and all windows can be sold for a profit of $400. a. Formulate an LP model for this problem b. Sketch the feasible region. c. What is the optimal solution