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

Question

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

Accepted Answer

The Answer is in the image, click to view ...

Question

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

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Fundamentals Of Auditing

Students also viewed these Accounting questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question