Please help solve this problem in Excel and also with the formulas visible. I want to be able to follow the solution to understand how it is done. Thank you!

A furniture manufacturer makes a mix of desks (D) and chairs (C). Each desk uses three units of wood, and each chair uses five units of wood. Each desk generates a profit of $55, and each chair generates $35 in profit. Production facilities are setup in such a way that the number of chairs produced must be exactly 1.5 times the number of desks. The plant capacity is 100 pieces of furniture a day. There are 190 units of wood available per day. The furniture manufacturer wishes to find the optimal daily production combination of desks and chairs in order to maximize profit in a given day. a. State the Objective function mathematically. b. State the constraints mathematically. c. Setup the model in Excel and use Solver to determine the optimized solution. d. How many desks should be produced? e. How many chairs should be produced? f. What is the overall daily profit?