I need help solving the model with the highlighted cells.

1) Develop a DEA model under row 33.

2) Get efficiency scores and weights of the 10 banks. Fill the table around cell A16.

3) Compare your DEA efficiency scores and the scatter plot on this worksheet. State your findings on this orange text box.

AutoSave OFF Insert Draw Page Layout X Calibri (Body) 11 (A - U BIU fx A Homework Bank Home G Paste N19 1 2 3 4 5 6 7 X 1 2 3 4 5 6 7 8 B Input Tellers A B C Formulas A A Efficiency 8 9 10 11 12 9 13 10 14 15 16 Efficiency Score 17 18 Bank 1 19 Bank 2 20 Bank 3 21 Bank 4 22 Bank 5 23 Bank 6 24 Bank 7 25 25 Bank 8 7 26 Bank 9 27 27 Bank 10 28 29 30 31 32 33 Develop the model under this line 34 35 Input Weight Data DI . C D Output2 Output1 Deposits processed Check processed 3 64 82 5 98 93 2 61 96 4 87 50 6 63 95 5 85 97 2 88 61 5 83 67 7 86 97 3 83 92 == = = = Review Output 1 Weight E View + Output 2 Weight Tell me ab Wrap Text F Bank PreAn04 Trochiano.Will General $ %9 .00 .0 H Efficiency2 Efficiency1 Deposits processed/ Tellers Check processed/ Tellers 3 21.3 27.3 5 19.6 18.6 2 30.5 48.0 4 21.8 12.5 6 10.5 15.8 5 17.0 19.4 2 44.0 30.5 5 16.6 13.4 0.0 50.0 7 12.3 13.9 10.0 20.0 30.0 40.0 Efficiency of Deposits processed 3 27.7 30.7 Note: As you did in Example 4.8, if you use sumproduct() for Input and Output cells, put the changing (decision) variables on the second input. Otherwise Solver in Excel 2016 may encounter an error. 1) Develop a DEA model under row 33. 2) Get efficiency scores and weights of the 10 banks. Fill the table around cell A16. 3) Compare your DEA efficiency scores and the scatter plot on this worksheet. State your findings on this orange text box. Merge & Center G Input Tellers 1 2 3 4 5 6 7 8 9 10 % 95.00 V Conditional Format Cell Formatting as Table Styles K 60.0 50.0 40.0 30.0 20.0 10.0 0.0 Efficiency of Checks processed Insert v Delete Format v Bank 3 s L Share AP. O. Sort & Find & Filter Select M Bank 7