Southland Furniture CaseEve Bowman is the manager of Southland Furniture store, and she is planning a NewYear$$s Day sale. The store has only $75$ square feet of space available to display and stockthis merchandise. During this sale, each folding table costs $$5,$ retails for $$11,$ and takesup $2$ square feet of space. Each chair costs $$4,$ retails for $$9,$ and takes up $1$ square foot ofspace. The maximum amount allocated for purchasing the tables and chairs for sale is$$280.$ Eve doesn$$t think that she can sell more than $40$ chairs, but the demand for tables isvirtually unlimited. Eve has asked you to help her determine how many tables and chairsshe should purchase in order to make the most profit.To complete this task:

$1.$ Create a workbook named Southland. Include a Documentation sheet.

$2.$ Design an Order sheet to determine the product mix to maximize Eve$$s profit. Donot include formulas to calculate unused resources on this sheet $($you must be ableto determine these values from the answer report$).$ Include a Per Unit DataSection: $($price$,$ cost etc.$)$; Include a summary area; Include a Constraints$/$Limitations area. and use cell references in the solver constraints.

$3.$ Use solver to find a solution and save the answer report.

$4.$ Save your model to a blank area on the Order sheet and label the areaappropriately.

$5.$ Save and close

Southland Notes:

$1.$ Do not type values in the solver set up $$ use cell references. Remember to takecare of the negative number constraint.

$2.$ Use your cost accounting concepts

Use excel to solve problem. $($Please answer ASAP$)$

Answer rating: 100% (QA)

To determine the product mix that maximizes Eves profit you can follow these steps 1 Open a new work... View the full answer