Please help me with this question. I ONLY NEED HELP WITH SOLVING ON EXCEL

I want you to give me a screenshot of the formulas you input in the excel cells and a screenshot of your solver parameters ( which shows constraints, etc).

I repeat ONLY send me a screenchot of excel fromulas in each cell and a screenshot of your solver parameter

There are ten communities located along Highway # 2, none of which is currently

served by the Bank of New Scotland. The Bank is considering opening up to

three branches in the ten communities (no more than one branch per community).

They believe that they will capture 20% of the market in those communities in

which a branch is constructed. Furthermore, they believe that they will capture

10% of the market in any community which does not have its own branch but

which is contiguous to a community (on either or both sides) which does have

a branch. Each branch would have an annual overhead cost of $130,000. Each

customer would give an annual contribution to profit of $25. The population of

each community is:

Community	1	2	3	4	5	6	7	8	9	10
Population (000's)	1	17	4	12	30	1	9	20	10	8

Maximize 5N₁ + 2.5N₂ 130B

Subject to number of branches B3

Balance, branches -B + summation n= 10; i=1 = 0

Balance, N₁ -N₁ + Y₁ + 17Y₂ + 4Y₃ +12Y₄ +

30Y₅ + Y₆ + 9Y₇ + 20Y₈ + 10Y₉ + 8Y₁₀ = 0

Balance, N₂ -N₂ + Z₁ + 17Z₂ + 4Z₃ + 12Z₄ +30Z₅

+Z₆ + 9Z₇ + 20Z₈ + 10Z₉ + 8Z₁₀ = 0

Relationship 1 Y_i + Z_i 1 I = 1

between Ys and Zs

Relationship 2 -Y₂ + Z₁ 0

Between Ys and Zs -Y_{i 1} Y_{i + 1} + Z_i 0 _{i = 2}

-Y₉ + Z₁₀ 0

N, N, B 0; all Y_i, Z_i

FOR EXCEL MODEL, THE FORMULA FOR THE OBJECTIVE CELL IS: =SUMPRODUCT(B4:X4, B5:X5)1000