1 2 3 Result Summary Sheet: Problem 1 Zone ) aout (1)(rounding) aadj (1) (no rounding) aqut (2) (rounding) aadj(2)(no rounding) 2 1. Balancing Attractions (DO NOT apply friction factor adjustment, Use Excel Speadsheet to do the Calculation and Submit the Excel Worksheet) (40 pts) 1) Apply the Gravity Model (GM) to the data shown in Table 13, (i.e., Productions and Attractions, fij factors, and impedance dj) 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 a up or down to maintain the same total number of trips. Stop condition: MAPE of attractions is less than 3%. Table 1 Production and Attraction Forecasts Zone 1 2 3 Production 14 33 28 Attraction 33 28 14 4 5 6 7 8 Table 2 fij-Factors Impedance 1 2 3 Units dij fij-Factors 82 5250 41 39 | 26 | 2013 Table 3 Impedance dij Zone From To 123 81 4 2 365 3 274 LIS" Table 4 Iteration 1 Output (OD Matrix) Attraction 1 2 3 Total Production 1 2 102 14 2 19 8 6 33 3 175 6 28 Total 38 23 14 75 1 2 3 Result Summary Sheet: Problem 1 Zone ) aout (1)(rounding) aadj (1) (no rounding) aqut (2) (rounding) aadj(2)(no rounding) 2 1. Balancing Attractions (DO NOT apply friction factor adjustment, Use Excel Speadsheet to do the Calculation and Submit the Excel Worksheet) (40 pts) 1) Apply the Gravity Model (GM) to the data shown in Table 13, (i.e., Productions and Attractions, fij factors, and impedance dj) 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 a up or down to maintain the same total number of trips. Stop condition: MAPE of attractions is less than 3%. Table 1 Production and Attraction Forecasts Zone 1 2 3 Production 14 33 28 Attraction 33 28 14 4 5 6 7 8 Table 2 fij-Factors Impedance 1 2 3 Units dij fij-Factors 82 5250 41 39 | 26 | 2013 Table 3 Impedance dij Zone From To 123 81 4 2 365 3 274 LIS" Table 4 Iteration 1 Output (OD Matrix) Attraction 1 2 3 Total Production 1 2 102 14 2 19 8 6 33 3 175 6 28 Total 38 23 14 75