1) Because of population growth, the state of Washington has been given an additional seat in...

1) Because of population growth, the state of Washington has been given an additional seat in the House of Representatives, making a total of ten. The state legislature, which is currently controlled by the Republicans, needs to develop a plan for redistricting the state. There are 18 major cities in the state of Washington that need to be assigned to 1 of the 10 congressional districts. The next table gives the numbers of registered democrats and registered republicans in each city. Each district must contain between 150,000 and 350,000 of these registered voters. Use Evolutionary Solver to assign each city to 1 of the 10 congressional districts in order to maximize the number of districts that have more registered Republicans than registered Democrats (hint: use the SUMIF function; decision variables must be >=1 and <=10). City Democrat Republican 1 152 62 2 81 59 3 75 83 4 34 52 5 62 87 6 38 87 7 48 69 8 74 49 9 98 62 10 66 72 11 83 75 12 86 82 13 72 83 14 28 53 15 112 98 16 45 82 17 93 68 18 72 98 USING EXCEL AND SUMIF FUNCTION SHOW ALL WORK

Solutions

Expert Solution

Formulas:

E21 =SUMPRODUCT(E3:E20,$D$3:$D$20) copy to E21:N21

O3 =SUM(E3:N3) copy to O3:O20

E23 =SUM(E21:N21)

The assignment of congressional district to each city is indicated by binary variable value equal to 1 in the decision variables matrix (E3:N20)

Thanks

keosha answered 1 month ago

Next > < Previous

Related Solutions

Accounting 1. Because of a change in a state law, Romulus County has been informed that...

Accounting 1. Because of a change in a state law, Romulus County has been informed that it will receive $100,000 less in state revenue than was budgeted. 2. Purchase orders and other commitment documents in the amount of $1,032,000 were issued during the six months ended April 30, 2005. 3. Property taxes of $6,500 and interest and penalties receivable of $1,340, which had been written off in prior years, were collected. Additional interest of $270 that had accrued since the...

1) In a given year the nominal growth rate is 7% with inflation and population growth...

1) In a given year the nominal growth rate is 7% with inflation and population growth rates of 2% and 1.2% respectively, then real growth rate of GDP per capita is: A. 3.8%. B. 5.0 %. C. 5.8%. D. 7.0 %. 2) You purchase a bag of chocolate chips for $3, a bag of flour for $1, a bag of sugar for $.50, a half dozen eggs for $.50, and a half pound of butter for $2. You use all...

A) If an economy is in a steady state with no population growth or technological change...

A) If an economy is in a steady state with no population growth or technological change and the marginal product of capital is greater than the depreciation rate: steady-state consumption per worker would be higher in a steady state with a higher saving rate. steady-state consumption per worker would be higher in a steady state with a lower saving rate. the depreciation rate should be decreased to achieve the Golden Rule level of consumption per worker. the economy is following...

Global warming has been linked to the growth of population of some insects and pests in...

Global warming has been linked to the growth of population of some insects and pests in cooler areas where they have not been previously seen. What global systems does this population growth affect? Identify a positive and a negative feedback resulting from it.

Consider an economy in steady state (or on a “balanced growth path”)without population growth. Suppose that...

Consider an economy in steady state (or on a “balanced growth path”)without population growth. Suppose that a mysterious new disease (COVID-19) suddenly kills half of the population. We are interested in the effect this likely has on kapital and output per person , both in the short and the long run. How will this affect in the Solow-model? Show with a graph

Question 1 Australia’s population growth does not reflect the fertility rate because of net migration. Lectures...

Question 1 Australia’s population growth does not reflect the fertility rate because of net migration. Lectures discussed the role of immigration, but did not cover the arguments for and against increasing immigration. Present the economic reasons for and against increasing immigration to Australia.

1: What is the name of the court of general jurisdiction in the state of Washington?...

1: What is the name of the court of general jurisdiction in the state of Washington? 2: What is the name of the trial court in the federal system? 3: When does a lawsuit begin under Washington law? 4: Explain ADR and why do businesses prefer these methods? 5: Identify the four elements of negligence. 6: What is defamation? Name 2 types of defamation. 7: What is meant by strict liablity? In what circumstances is strict liability applied? 8: What...

5. Another equation that has been used to model population growth is the Gompertz equation dP...

5. Another equation that has been used to model population growth is the Gompertz equation dP /dt = rP ln (K P ) , where r and K are positive constants, and P(t) > 0. (a) Sketch a clearly labeled graph of f(P), where dP/dt = f(P) (state the main facts you used to obtain your answer). (b) Draw the phaseline. Next to it, sketch a set of integral curves in the t − P plane. (c) State and classify...

Suppose we have a whale population that has been declines to 1000 individuals. The growth rate...

Suppose we have a whale population that has been declines to 1000 individuals. The growth rate is 2% a year and the carrying capacity is 10,000. Calculate (use Excel) how many years are needed to have the population recover to 5,000 or more, meaning that during those years, no harvesting can take place. Once the population is recovered, how many whales can be harvested per year in a sustainable way? Can you show me how to put the formula in...

given that a large population which has been living on an isolated is in hardy weinberg...

given that a large population which has been living on an isolated is in hardy weinberg equilibrium; what can be said about the relative fitness of the dominant individuals relative to the recessive individuals

Subjects