Balancing Attractions ( DO NOT apply friction factor adjustment, Use Excel Spead
ID: 283579 • Letter: B
Question
Balancing Attractions (DO NOT apply friction factor adjustment, Use Excel Speadsheet to do the Calculation and Submit the Excel Worksheet) (20 pts)
1) Apply the Gravity Model (GM) to the data shown in Table 1–3, (i.e., Productions and Attractions, “ ” factors, and impedance “ ”) in order to verify the trip matrix in Table 4 (iteration 1 output).
2) Apply the “balancing of attractions” procedure to the “iteration 1 output”. Use Integers in the GM calculations. Round the resulting up or down to maintain the same total number of trips. Stop condition: MAPE of attractions is less than 10%.
Table 1 Production and Attraction Forecasts
Zone
1
2
3
Production
14
33
28
Attraction
33
28
14
Table 2 -Factors
Impedance
Units
1
2
3
4
5
6
7
8
-Factors
82
52
50
41
39
26
20
13
Table 3 Impedance
Zone FromTo
1
2
3
1
8
1
4
2
3
6
5
3
2
7
4
Table 4 Iteration 1 Output (OD Matrix)
Attraction
Production
1
2
3
Total
1
2
10
2
14
2
19
8
6
33
3
17
5
6
28
Total
38
23
14
75
Zone
1
2
3
Production
14
33
28
Attraction
33
28
14
Explanation / Answer
Answer:
As we cannot use the friction factor for the given problem, therefore we have to rely on adjusted attraction factor which are as follows;
A = (A1/C)A1
Where, A= adjusted attraction factor, A1= attraction value from attraction column, C= actual attraction from iteration column
By applying the values in above equation we can verify the asked values.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.