Reference no: EM13879748
Please Show process Using Solver Data Analysis so I can understand the process for each Each year a municipality hires a private bus company to transport (round back ) elementary students . The service manager must develop city a transportation plan to minimize the cost of transportation. The annual cost of transportation It depends on the number of student - mile that the company transports (eg 20 students take two miles involves 40 students - mile is the same carry 8 Students 5 miles).
3 city schools can receive students from each point of the town, north (N ) , East ( E) , west (O ), and south ( S ) In the north live 240 children attending elementary school In the east , 120, in the west, 400, and in the south, 200. In one school may enroll no more than 360 students , the School 2 not more than 400 , and in school 3 , no more than 260. The following table shows the distance in miles between neighborhoods and schools :
|
N
|
E
|
W
|
S
|
|
School 1
|
2
|
3
|
1.4
|
3.2
|
|
School 2
|
3.2
|
2.4
|
2
|
2
|
|
School 3
|
3.6
|
1.4
|
3
|
2.2
|
1) - Set your objective function and restrictions to minimize costs in this case number of students - mile. Also identify their decision variables.
2) -Find the result of the objective function and the number of children in each neighborhood They are going to the 3 schools . Explain your results.
3) -¿Change 2) If now the ability of students from the School 2 is 500 and the School 3 is 180 ?
Do not forget to set the trivial restrictions (which means variables decision must be greater or equal to zero)
|
What activity is a burst activity
: Draw a project network from the following information. What activity(s) is a burst activity? What activity(s) is a merge activity
|
|
Market price of the common stock averaged
: On December 31, 2012, Dow Steel Corporation had 600,000 shares of common stock and 300,000 shares of 8%, noncumulative, nonconvertible preferred stock issued and outstanding.
|
|
Difference between insider trading and a ponzi scheme
: A classic example of acting unethically is Lehman or Enron's case. After their downfall, one would think employees would act ethically and companies would focus on promoting ethical practices in the workplace. What's the difference between insider ..
|
|
Diameter and initially at a uniform temperature
: A long copper cylinder 0.6 m in diameter and initially at a uniform temperature of 38°C is placed in a water bath at 93°C. Assuming that the heat transfer coefficient between the copper and the water is 1248 W/(m2 K), calculate the time required t..
|
|
Find the result of the objective function
: Find the result of the objective function and the number of children in each neighborhood They are going to the 3 schools . Explain your results.
|
|
Calculate net operating profit after taxes for the company
: Calculate Net Operating Profit After Taxes for this company's Financial statements. Other operating income, net of other operating expense (nature).
|
|
Opinion regarding the future of large face-to-face meetings
: With the advent of virtual meeting technologies, the expanding presence of social media and the continued budget pressures facing corporations, what is your opinion regarding the future of large face-to-face meetings
|
|
Determine the diameter of a suitable air main
: Determine the diameter of a suitable air main for the distribution - Table of equivalent pipe lengths for valves and fittings as used on air distribution systems
|
|
What is the relevant refunding investment outlay?
: What is the relevant refunding investment outlay?
|