Please use QM for windows all detail $[$QX$]-8-1($Production problem$)$ Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and a Danish Modern model. Each cabinet produced must go through three departments: carpentry, painting, and finishing. The table on this page contains all relevant information concerning production times per cabinet produced and production capacities for each operation per day, along with net revenue per unit produced. The firm has a contract with an Indiana distributor to produce a minimum of $300$ of each cabinet per week $($or $60$ cabinets per day$).$ Owner Bob Winkler would like to determine a product mix to maximize his daily revenue.

a$.$ Formulate as an LP problem.

b$.$ Solve using an LP software program or spreadsheet.

$\backslash$table$[[$CABINET STYLE,$\backslash$table$[[$CARPENTRY$],[($IHOURS$],[$CABINET$)]],\backslash$table$[[$PAINTING$],[($HOURS$],[$CABINET$)]],\backslash$table$[[$FINISHING$],[($HOURS$],[$CABINET$)]],\backslash$table$[[$NET REVIENUEV$],[$CABINET $($$$)]]],[$French Provincial,$3,1\mathrm{.}5,0\mathrm{.}75,28],[$Danish Modem,$2,1,{0\mathrm{.}75}_{?},25],[$Department capacily $($hours$),\frac{?}{\text{b}\text{a}\text{r}}(360),200,125,]]$

$\backslash$table$[[$INVESTMIENT$,\backslash$table$[[$PROJECTED RATE$],[$OF RETURN $(\%)]]],[$Los Angeles municipal bonds,$5\mathrm{.}3],[$Thompson Electronics, Inc.,$6\mathrm{.}8],[$United Aerospace Corp.,$4\mathrm{.}9],[$Palmer Drugs,$8\mathrm{.}4],[$Happy Days Nursing Homes,$11\mathrm{.}8]]$