PLEASE INCLUDE SCREEN GRABS of EXCEL setup, formulas used and where, and what Solver looks like.

Problem $49.$ Fidelity Savings & Loans $($FS&L$)$ operates a number of banking

facilities throughout the Southeastern United States. The officers of FS&L wants to

analyze the efficiency of the various branch offices using DEA. The following data

has been selected to represent appropriate input and output measures of each

banking facility.

Branch R$.$O$.$A$.$ New Loans Satisfaction Labor Hours Op$.$ Costs

$15\mathrm{.}32770923\mathrm{.}736\mathrm{.}34$

$23\mathrm{.}39780943\mathrm{.}494\mathrm{.}43$

$34\mathrm{.}95790935\mathrm{.}986\mathrm{.}31$

$46\mathrm{.}01730826\mathrm{.}497\mathrm{.}28$

$56\mathrm{.}40910987\mathrm{.}098\mathrm{.}69$

$62\mathrm{.}89860903\mathrm{.}463\mathrm{.}23$

$76\mathrm{.}94880897\mathrm{.}369\mathrm{.}07$

$87\mathrm{.}18970996\mathrm{.}387\mathrm{.}42$

$95\mathrm{.}98770944\mathrm{.}746\mathrm{.}75$

$104\mathrm{.}97930915\mathrm{.}046\mathrm{.}35$

a$)$ Identify the inputs and outputs for FS&L$.$ Are they all measured on the

appropriate scale for use with DEA?

b$)$ Compute the DEA efficiency of each branch office.

c$)$ Which offices are DEA efficient?

d$)$ What input and output levels should branch $5$ aspire to in order to become

efficient?

Please solve and post utilizing solver. Pls include the solver window screen captures.