Develop an Excel$-$based Decision Support System $($DSS$)$ using Visual Basic for Applications $($VBA$).$ The DSS will consist of a mathematical model implemented in a spreadsheet, a user interface, and VBA code connecting the model and user interface.

The Kartick Company is trying to determine how much of each of two products to produce over the coming planning period. There are three departments, A$,$ B$,$ and C$,$ with limited labor hours available in each department. Each product must be processed by each department and the per$-$unit requirements for each product, labor hours available, and per$-$unit profit are as shown below. Labor required in each department Department Product $($hours$/$unit$)$ Labor Hours Product $1$ Product $2$ Available A $1\mathrm{.}000\mathrm{.}30100$ B $0\mathrm{.}300\mathrm{.}1236$ C $0\mathrm{.}150\mathrm{.}5650$ Profit Contribution $$33\mathrm{.}00$ $$24\mathrm{.}00$ Let x$1=$ the amount of product $1$ to produce x$2=$ the amount of product $2$ to produce Maximize $33$ x$1+24$ x$2$ s$.$t$.1\mathrm{.}0$ x$1+0\mathrm{.}30$ x$2100$ Department A $0\mathrm{.}30$ x$1+0\mathrm{.}12$ x$236$ Department B $0\mathrm{.}15$ x$1+0\mathrm{.}56$ x$250$ Department C x$1,$ x$20$

The Kartick Company is trying to determine how much of each of two products to produce over the

coming planning period. There are three departments, A$,$ B$,$ and C$,$ with limited labor hours available

in each department. Each product must be processed by each department and the per$-$unit

requirements for each product, labor hours available, and per$-$unit profit are as shown below.

Let quadx$\_(1)=$ the amount of product $1$ to produce

x$\_(2)=$ the amount of product $2$ to produce

Maximize$\_33\}\backslash$mp@subsup$\{$x$\}\{1\}\{\}+24\backslash$mp@subsup$\{$x$\}\{2\}\{$

s$.$t$,$

$1\mathrm{.}0\backslash$mp@subsup$\{$x$\}\{1\}\{\}+0\mathrm{.}30\backslash$mp@subsup$\{$x$\}\{2\}\{\}\backslash$leq$100$ Department A

$0\mathrm{.}30\backslash$mp@subsup$\{$x$\}\{1\}\{\}+0\mathrm{.}12\backslash$mp@subsup$\{$x$\}\{2\}\{\}\backslash$leq$36$ Department B

$0\mathrm{.}15\backslash$mp@subsup$\{$x$\}\{1\}\{\}+0\mathrm{.}56\backslash$mp@subsup$\{$x$\}\{2\}\{\}\backslash$leq$50$ Department C

$\backslash$mp@subsup$\{$x$\}\{1\}\{\},\backslash$mp@subsup$\{$x$\}\{2\}\{\}\backslash$geq$0$