Please give me a way I can answer this question in Excel. Please answer all parts including the explanationQuestion $4$ A fast food chain plans to expand by opening several new restaurants. The chain operates three types of restaurants, drive$-$through, truck$-$stop, and full$-$service. $-$ A drive$-$through restaurant costs $\backslash (\backslash$$ $100,000\backslash )$ to construct and furnish, requires $5$ employees, and has an expected annual revenue of $\backslash (\backslash$$ $200,000\backslash ).-$ A truck$-$stop restaurant costs $\backslash (\backslash$$ $20,000\backslash )$ to funish $($no construction costs$),$ requires $3$ employees, and has an expected annual revenue of $\backslash (\backslash$$ $120,000\backslash ).$ Ca $-$ A full$-$service restaurant costs $\backslash (\backslash$$ $150,000\backslash )$ to construct and funish, requires $18$ employees, and has an expected annual revenue of $\backslash (\backslash$$ $600,000\backslash ).-$ The chain has $\backslash (\backslash$$ $2,200,000\backslash )$ in capital available for expansion. $-$ Labor contracts require that they hire no more than $210$ employees, and licensing restrictions require that they open no more than $20$ new restaurants. $\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}\backslash$hline Type of Restaurant: & Driive thru & Truck stop & Full service & & & & & $\backslash \backslash \backslash$hline Revenue per Restaurant: & $\backslash (\backslash$$ $200,000\mathrm{.}00\backslash )$ & $\backslash (\backslash$$ $120,000\mathrm{.}00\backslash )$ & $\backslash (\backslash$$ $600,000\mathrm{.}00\backslash )$ & & & & & $\backslash \backslash \backslash$hline Constraints & & & & Usage & Constraint & Available & $\backslash$multicolumn$\{2\}\{|$c$|\}\{$ Left over $\}\backslash \backslash \backslash$hline Capital available & $\backslash (\backslash$$ $100,000\mathrm{.}00\backslash )$ & $\backslash (\backslash$$ $\backslash$quad $20,000\mathrm{.}00\backslash )$ & $\backslash (\backslash$$ $\backslash$quad $150,000\mathrm{.}00\backslash )$ & $\backslash (\backslash$$ $2,130,000\mathrm{.}00\backslash )$ & & $\backslash (\backslash$$ $2,200,000\mathrm{.}00\backslash )$ & $\backslash (\backslash$$ $\backslash )$ & $\backslash (70,000\mathrm{.}00\backslash )\backslash \backslash \backslash$hline Employees available & $5$ & $3$ & $18$ & $209\mathrm{.}00$ & & $210$ & $\backslash (\backslash$$ $\backslash )$ & $1\mathrm{.}00\backslash \backslash \backslash$hline Restaraunts available & $1$ & $1$ & $1$ & $20\mathrm{.}00$ & & $20$ & $\backslash (\backslash$$ $\backslash )$ & $-\backslash \backslash \backslash$hline $\backslash$end$\{$tabular$\}$ List the constaints in the table to the left. You may also list them below if that's helpful for you. $\backslash$begin$\{$tabular$\}\{|$r$|$c$|\}\backslash$hline Restaurant type & $\backslash \backslash \backslash$hline Drive thru & $7\mathrm{.}00\backslash \backslash \backslash$cline $\{2-2\}$ truck stop & $4\mathrm{.}00\backslash \backslash \backslash$hline full service & $9\mathrm{.}00\backslash \backslash \backslash$cline $\{2-3\}$ & $\backslash (\backslash$$ $\backslash$quad $7,280,000\mathrm{.}00\backslash )\backslash \backslash \backslash$hline $\backslash$end$\{$tabular$\}$ How many Drive$-$throughs should be opened? $($include $2$ decimal points$)$ How many Truck$-$stops should be opened? $($include $2$ decimal points$)$ How many Full$-$service should be opened? $($include $2$ decimal points$)$ a$)$ Generate a sensitivity report. b$)$ Next add an integer constraint in Solver $($this is in addition to the constraints you already have$)$ to find the maximum revenue and the number of each to open. Use this report to answer the questions below. Which resource is holding us back the most? $($capital$,$ labor, licensing$)$ Looking at the Allowable Decrease, if the Drive$-$thru revenue was only $\backslash (\backslash$$ $185,000\backslash )$ would the final number recommended for each type of restaurant change? $($yes or no$)$ d$)$ Looking at the surplus above and the sensitivity analysis, interpret the sensitivity analysis and make some suggestions for the company. Type your answer below.