If you can do this problem on excel and screenshot the answers and tables!!!!!!!!

Part 1: You are a planning consultant to a firm that is considering the construction of a major mall. At present, the city consists of four residential zones and the central business district where the mall activity is concentrated. Your clients are interested in your prediction of the patronage that the center will attract if built to compete with the CBD. The data below has been made available to you. Calculate all target- year (2024) interchange volumes and the target-year patronage of the two commercial zones. Also draw the TAZ, interzonal impedances, and label the volume and time to each zone. a. Daily Shopping trip production (trips per person): X3 = 1 0 X2 X 1-2 3 4 or more Olola 0.3 0.2 0.2 0.4 0.3 0.3 UN 0.5 0.4 0.4 0.2 0.1 0.1 X3 = II 0 2 X2 X 1-2 3 4 or more . 0.4 0.3 0.3 0.5 0.3 0.3 0.6 0.5 0.6 0.2 0.1 0.1 Where: X1 = household size (persons/household) X2 = auto ownership (cars/household) X3 = household income level (I or II) b. Relative shopping mall attractiveness: The relative shopping mall attractiveness of commercial zones has been found to be the following regression equation: A = 6Xa +4X_ Where: Xa = area of mall floor space provided, in acres Xb = available parking area, in acres c. Land-use and socioeconomic projections: Zone X1 1 2 3 2 2 1 2 2 4. Residential Zones Number of households X2 X3 2021 2024 1 I 200 2 I 400 2 I 250 2 II 100 1 I 200 2 II 100 3 II 80 1 I 400 0 II 150 1 II 250 0 I 50 2 I 300 1 II 250 2 II 3 II 25 2 II 55 3 1 2 3 2 2 2 2 4 3 4 2021 = base year 2024 = target year 300 For the target year, 2024, add 2% increase per year. Round up to next whole number. Commercial Zones Zone 2021 2024 5 (CBD) 6 (Mall) 3 0 2.5 0 Xa 3 1 Xb 3 2 d. Gravity Model parameters: i. In F = -In W, W is the interzonal impedance, in minutes ii. Ku J 5(CBD) 6 (mall) I 1 0.9 2 0.9 1.2 3 1.0 1.0 4 1.2 1.5 1.0 ilon e. Times to each zone: Assume c=1 J 5(CBD) 6 (mall) I 1 2 3 4 10 min 15 min 18 min 20 min 15 min 20 min 12 min 15 min Part 1: You are a planning consultant to a firm that is considering the construction of a major mall. At present, the city consists of four residential zones and the central business district where the mall activity is concentrated. Your clients are interested in your prediction of the patronage that the center will attract if built to compete with the CBD. The data below has been made available to you. Calculate all target- year (2024) interchange volumes and the target-year patronage of the two commercial zones. Also draw the TAZ, interzonal impedances, and label the volume and time to each zone. a. Daily Shopping trip production (trips per person): X3 = 1 0 X2 X 1-2 3 4 or more Olola 0.3 0.2 0.2 0.4 0.3 0.3 UN 0.5 0.4 0.4 0.2 0.1 0.1 X3 = II 0 2 X2 X 1-2 3 4 or more . 0.4 0.3 0.3 0.5 0.3 0.3 0.6 0.5 0.6 0.2 0.1 0.1 Where: X1 = household size (persons/household) X2 = auto ownership (cars/household) X3 = household income level (I or II) b. Relative shopping mall attractiveness: The relative shopping mall attractiveness of commercial zones has been found to be the following regression equation: A = 6Xa +4X_ Where: Xa = area of mall floor space provided, in acres Xb = available parking area, in acres c. Land-use and socioeconomic projections: Zone X1 1 2 3 2 2 1 2 2 4. Residential Zones Number of households X2 X3 2021 2024 1 I 200 2 I 400 2 I 250 2 II 100 1 I 200 2 II 100 3 II 80 1 I 400 0 II 150 1 II 250 0 I 50 2 I 300 1 II 250 2 II 3 II 25 2 II 55 3 1 2 3 2 2 2 2 4 3 4 2021 = base year 2024 = target year 300 For the target year, 2024, add 2% increase per year. Round up to next whole number. Commercial Zones Zone 2021 2024 5 (CBD) 6 (Mall) 3 0 2.5 0 Xa 3 1 Xb 3 2 d. Gravity Model parameters: i. In F = -In W, W is the interzonal impedance, in minutes ii. Ku J 5(CBD) 6 (mall) I 1 0.9 2 0.9 1.2 3 1.0 1.0 4 1.2 1.5 1.0 ilon e. Times to each zone: Assume c=1 J 5(CBD) 6 (mall) I 1 2 3 4 10 min 15 min 18 min 20 min 15 min 20 min 12 min 15 min