Please solve this LP in excel and attach the answer report and sensitivity report.Thanks.

#2. Continue with the Veerman Furniture problem from #1. To ensure more balance in production volumes, the Marketing Department requires that each of the products must make up at least 25 percent of the total units sold. What additional constraint (s) would you add to the original formulation to account for this requirement?

\# 1. Veerman Furniture Company makes three kinds of office furniture: chairs, desks, and tables. Each product requires some labor in the parts fabrication department, the assembly department, and the shipping department. The furniture is sold through a regional distributor, who has estimated the maximum potential sales for each product in the coming quarter. Finally the accounting department has provided some data showing the profit contribution on each product. The decision problem is to determine the product-mix - that is, to maximize Veerman's profit for the quarter by choosing production quantities for the chairs, desks, and tables. The following data summarizes the parameters of the