Tony's manufacturing produces ornate, decorative wood frame doors and windows. Each item produce 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 cutting, 45 minutes in sanding, and 1 hour in finishing. In the coming week Tony's has 40 hours of cutting capacity available, 40 hours of standing capacity, and 60 hours of finishing capacity. Assume that all doors produced can be sold for a profit of $500 and all windows can be sold for a profit of $400.

A. Formulate this problem as a linear programming problem.

B. What the decision variables are

C. What the objective function is.

D. What the relevant constraints are.

E. Set up the problem in a spreadsheet and solve it using Solver.