$($worth $40$ points$)$ The Good$-$to$-$Go Suitcase Company makes three kinds of suitcases: $(1)$ Standard, $(2)$ Deluxe, and $(3)$ Luxury styles. Each suitcase goes through four production stages: $(1)$ cutting and coloring, $(2)$ assembly, $(3)$ finishing, and $(4)$ quality and packaging. The total number of hours available in each of these departments is $630,600,708,$ and $135,$ respectively. Each Standard suitcase requires $0\mathrm{.}7$ hours of cutting and coloring, $0\mathrm{.}5$ hours of assembly, $1$ hour of finishing, and $0\mathrm{.}1$ hours of quality and packaging. The corresponding numbers for each Deluxe suitcase are $1$ hour, $\frac{5}{6}$ hours, $\frac{2}{3}$ hours, and $0\mathrm{.}25$ hours, respectively. Likewise, the corresponding numbers for each Luxury suitcase are $1$ hour, $\frac{2}{3}$ hours, $0\mathrm{.}9$ hours, and $0\mathrm{.}4$ hours, respectively.

The sales revenue for each type of suitcase is as follows: Standard $$36\mathrm{.}05,$ Deluxe $$39\mathrm{.}50,$ and Luxury $$43\mathrm{.}30.$ The material costs are Standard $$6\mathrm{.}25,$ Deluxe $$7\mathrm{.}50,$ and Luxury $$8\mathrm{.}50.$ The hourly cost of labor for each department is cutting and coloring $$10,$ assembly $$6,$ finishing $$9,$ and quality and packaging $$8.$

The Excel layout and LP Sensitivity Report of Good$-$to$-$Go's problem are shown in Screenshots $4-11$A and $4-11$B$,$ respectively. Each of the following questions is independent of the others.

In the Spreadsheet for Good$-$to$-$Go Suitcase Company below:

a$.$ What cell$($s$)$ designate the Decision Variables?

b$.$ What cell$($s$)$ designate the Objective Solution $($problem answer$)?$

c$.$ In the equations, which of the cells should employ absolute addressing?

d$.$ What is the optimal production plan shown by the spreadsheet? The optimal production plan is :

$\backslash$table$[[$Produce$,$Standard suitcases$],[$Produce$,$Deluxe suitcases$],[$Produce$,-$uxury suitcases$],[$for a total profit of$,]]$

e$.$ b$.$ Which resources are binding and why? List all that apply

The Binding Resources are:

$($since there are four constraints, Could be $1,2,3,$ or $4$ answers here$)$

How did you determine the above resources binding?

f$.$ Suppose Good$-$to$-$Go is considering including a polishing process, the cost of which would be added directly to the price. Each Standard suitcase would require $10$ minutes of time in this treatment,Microsoft Excel $14\mathrm{.}0$ Sensitivity Report

Problems P$4\mathrm{.}22823.$ Good$-$to$-$Go Suitcase Company

Variable Cells

$\backslash$table$[[$Cell$,$Name,$\backslash$table$[[$Final$],[$Value$]],\backslash$table$[[$Reduced$],[$Cost$]],\backslash$table$[[$Objective$],[$Coefficient$]],\backslash$table$[[$Allowable$],[$Increase$]],\backslash$table$[[$Allowable$],[$Decrease$]]],[$$ B $$4,$Solution value Standard,$540\mathrm{.}00,0\mathrm{.}00,10\mathrm{.}00,3\mathrm{.}50,2\mathrm{.}56],[$$$C$$$4,$Solution value Deluxe,$252\mathrm{.}00,0\mathrm{.}00,9\mathrm{.}00,5\mathrm{.}29,1\mathrm{.}61],[$SD$$4,$Solution value Luxury,$0\mathrm{.}00,-1\mathrm{.}12,9\mathrm{.}50,1\mathrm{.}12,1E30$