Question: A11 A B C fx D E Write a few sentences below to summarize your results: F G H J K M N P

A11 A B C fx D E Write a few sentences below to summarize your results: F G H J K M N P 1 Main City has four elementary schools (Addison, Beeks, Canfield, Daley) and 2 each school has a capacity of 400 students. Children need to be assigned to 3 schools so that their travel time (by bus) is as short as possible. Bus Travel Time: Area Student District Addison Beeks Canfield Daley population 4 Housing in the town is clusted into 5 neighborhoods (North, South, East, West, 5 and Central); average travel time between each of the neighborhoods and the 6 schools is shows in the table at the right. North 12 23 35 17 250 South 26 15 21 27 340 East 18 20 22 31 310 7 West 29 24 35 10 210 8 Using a spreadsheet model and Solver, determine the number of children that should 9 be assigned from each district to each school to minimize total student travel time. Central 15 10 23 16 290 10 11 Write a few sentences below to summarize your results: 12 13 14 15 16 17

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

In the Myer Emporium case, Myer Emporium Ltd. sold its future income streams for an immediate lump sum. How was this transaction treated for tax purposes? Question 7Answer a. The transaction was...

Maryville has built a new elementary school so that the town now has a total of four schoolsAddison, Beeks, Canfield, and Daley. Each has a capacity of 400 students. The school wants to assign...

Bayville has built a new elementary school, increasing the towns total to four schoolsAddison, Beeks, Canfield, and Daley. Each has a capacity of 400 students. The school board wants to assign...

YOU have just graduated from Deakin as an accounting and finance graduate. During your time at Deakin, you were organized and diligent with your studies and thus graduated with flying colors. This...

Use software to analyze the U.S. Statewide Crime data file on the text CD on y = violent crime rate and x = percentage of single parent families. a. Construct a scatter-plot. What does it show? b....

Do a bit of research on PERL, another server-side language. Why do you suppose that PHP has succeeded where PERL has not? Use your OWN words; do not merely copy something from the internet.

Discuss other design issues, such as the type of treatment variable, ordering effects, and matching subjects.

An 8-molar hydrochloric acid solution [SG = 1.12, Cp = 2.76 J/ (gC)] is produced by absorbing hydrogen chloride [HC1 (g)] in water. Liquid water enters the absorber at 25C and gaseous HCJ is fed at...

Capwell Corporation uses a periodic inventory system. The company's ending inventory on December 31, 2013, its fiscal-year end, based on a physical count, was determined to be $331,000. Capwell's...

Annual cash inflows from two competing investment projects are given below: The discount rate is 7%. Click here to view Exhibit 148-1 and Exhibit 14B-2, to determine the appropriate discount...

what is the work content and components of the project. It can be described by naming all the activities performed?

Gas mixtures. A mixture composed of CO and H2 is contained at 283 kPa. Calculate the partial pressure of the H in kPa in this mixture if the mole fraction of CO is 68 %. Provide the answer to three...

the earnings after tax and dividends under each of the following two financing options based on the document: 1.bond financing: $20 million at 7 percent interest.

Pedagogically, there has been empirical evidence to support that there is lack of student's interest in enrollment in marketing analytics courses. Specifically, the biased perception of marketing as...

A typical wire coating die is shown schematically in the figure below. throughout the mold It is incompressible at steady state and is an isothermal flow. Rheological properties of the fluid, power...

A recently graduated M.B.A., Mark Thomas, had been hired three months ago as assistant direc- tor of the Abbington Youth Center. Prior to earning his M.B.A., he had worked in several manufac- turing...

You deposit $10,000 in a savings account that earns 7.5% simple interest per year. What is the minimum number of years you must wait to double your balance? Suppose instead that you deposit the...

Teddie Bower,Inc.,reported the following data in its annual financial statements (dollars in thousands): 1999 2000 Sales $333,667 $313,456 Cost of goods soldLIFO 32,587 44,690 Cost of goods soldFIFO...

Pratsky, Inc., had the following account balances: December 31, 1999 Assets Liabilities Cash $12,500 Accounts payable $10,000 Accounts Receivable 22,400 Allowance for Stockholders Equity:...

Jeans RUs, Inc., reported the following data in its annual financial statements (dollars in thousands): 2000 2001 Cost of goods soldLIFO 31,678 44,690 Cost of goods soldFIFO 31,089 41,656 Ending...