Please respond the below using step by step in excel $-$ attached is the excel in question.

QUESTION $1(20$ points$)$:

The Hickory Cabinet and Furniture Company produces sofas, tables, and chairs. The plant uses three

main resources to make furniture $-$ wood, upholstery, and labor. The resource requirements for each

piece of furniture and the total resources available weekly are as follows.

The furniture is produced on a weekly basis and stored in the warehouse until the end of the week, when

it is shipped out. The warehouse has a total capacity of $650$ pieces of furniture. Each sofa earns $$300$ in

profit, each table $$200,$ and each chair $$150.$ The company wants to know how many pieces of each type

of furniture to make per week to maximize profit. The worksheet named "Hickory I $"$ contains a template

for solving this LP problem.

a$.$ Review the LP algebraic formulation provided. Make sure you understand how the

formulation is derived from the problem described above.

b$.20$ Points: Solve the LP model with Excel Solver using the template provided. Generate the

sensitivity report.

$[2$ points for correctly specifying decision variables

$3$ points for correctly specifying the objective function equation

$4$ points for setting up constraints correctly $(1$ per constraint$)$

$11$ points for generating the correct optimal solution and sensitivity report$]$