This problem comes from a discussion with Dr. Shafizadeh. 1. In VBA, insert a module titled Modo2-see Figure 1. In this module, one UDF will be created. Additionally, Option Explicit will be turned on. 2. In the module Modo2, create a UDF titled iCongestion which evaluates the price / hour ($ /hr) a driver will pay based on the vehicle occupancy, time of day, and average speed: Vehicle Occupancy Time of Day Average Speed Congestion Pricing o $/hr 5 $/hr 8:01 pm and 5:59 am Single Occupancy 6:00 am - 8:00 pm 20 $/hr N/A > 30 mph 530 mph N/A > 30 mph s 30 mph 8:01 pm and 5:59 am Multiple Occupancy o $/hr 2 $/hr 10 $/hr 6:00 am - 8:00 pm EXERCISE #2 8 Nested If Statements Congestion Pricing Vehicle Average Speed (mph) ($ /hr) Time VBA 6:15 AM 6:45 PM 6:15 AM 6:45 PM 8:20 PM 9:20 PM Occupancy 14 Multiple Occupancy 15 Single Occupancy 16 Multiple Occupancy 17 Single Occupancy 18 Multiple Occupancy 19 Multiple Occupancy 20 Single Occupancy 21 Single Occupancy 22 Multiple Occupancy 23 Multiple Occupancy 24 Multiple Occupancy 25 Single Occupancy 26 Single Occupancy 27 Multiple Occupancy 6:45 PM 2 $/hr 20 $/hr 10 $/hr 5 $/hr 0 $/hr o $/hr 20 $/hr 5 $/hr 10 $/hr 10 $/hr 10 $/hr 5 $/hr 0 $/hr 10 $/hr 6:45 AM 6:15 AM 8:00 PM 1:15 PM 6:00 AM 8:20 PM 6:00 PM This problem comes from a discussion with Dr. Shafizadeh. 1. In VBA, insert a module titled Modo2-see Figure 1. In this module, one UDF will be created. Additionally, Option Explicit will be turned on. 2. In the module Modo2, create a UDF titled iCongestion which evaluates the price / hour ($ /hr) a driver will pay based on the vehicle occupancy, time of day, and average speed: Vehicle Occupancy Time of Day Average Speed Congestion Pricing o $/hr 5 $/hr 8:01 pm and 5:59 am Single Occupancy 6:00 am - 8:00 pm 20 $/hr N/A > 30 mph 530 mph N/A > 30 mph s 30 mph 8:01 pm and 5:59 am Multiple Occupancy o $/hr 2 $/hr 10 $/hr 6:00 am - 8:00 pm EXERCISE #2 8 Nested If Statements Congestion Pricing Vehicle Average Speed (mph) ($ /hr) Time VBA 6:15 AM 6:45 PM 6:15 AM 6:45 PM 8:20 PM 9:20 PM Occupancy 14 Multiple Occupancy 15 Single Occupancy 16 Multiple Occupancy 17 Single Occupancy 18 Multiple Occupancy 19 Multiple Occupancy 20 Single Occupancy 21 Single Occupancy 22 Multiple Occupancy 23 Multiple Occupancy 24 Multiple Occupancy 25 Single Occupancy 26 Single Occupancy 27 Multiple Occupancy 6:45 PM 2 $/hr 20 $/hr 10 $/hr 5 $/hr 0 $/hr o $/hr 20 $/hr 5 $/hr 10 $/hr 10 $/hr 10 $/hr 5 $/hr 0 $/hr 10 $/hr 6:45 AM 6:15 AM 8:00 PM 1:15 PM 6:00 AM 8:20 PM 6:00 PM