Please respond utillzing the excel attached:

QUESTION $2(8$ points$)$:

The Hickory Cabinet and Furniture Company had some changes in supplier and buyer contracts, as well

as labor opportunities. The sofa retailer left the profit at $$300$ per sofa, while a contract with another

retailer increased the profit on chairs to $$225$ and on tables to $$275.$ Additionally, the upholstery vendor

decided to sell in lots of size $601,$ meaning the available upholstery is now only $601$ yards since the

company doesn't want to buy $1202$ yards at a time $($current is $1000$ yds available at a time$).$ As a result of

another plant going out of business, the labor supply increased to $401$ hours. Based on changes in the

profit amounts and available resources, the sensitivity output for this formulation is provided in the

worksheet named "Hickory $2."$ Use the output the answer the following questions.

a$.1$ Point: In cells J$5$:L$5$ input the values of the decision variables that result from the new

model solution.

b$.1$ Point: In cells J$6$:K$6$ input the lower and upper range of sofa profit for which the

optimal decision variables would remain the same.

c$.1$ Point: In J$7$ input the value that represents how much table profit would have to

increase by to have a solution that includes making tables.

d$.1$ Point: In cell J$8,$ input either the word$($s$)$ "change" or $"$no change" to indicate what

would happen to the optimal solution if chair profit could be increased by $$30.$

e$.1$ Point: In cell J$13,$ input the value that indicates the amount of the wood resource

remaining.

f$.1$ Point: In cell J$14,$ input the value indicating the maximum amount the company would

be willing to pay for an additional yard of upholstery.

g$.1$ Point: In cell J$15,$ input the value representing how much more profit could be obtained

by obtaining $10$ additional hours of labor.

h$.1$ Point: In cell J $165,$ input the value representing how much profit would be lost if

warehouse capacity dropped by $500$ pieces of furniture.Question $2$

Constraints