Please answer asap. It is using the excel VBA function. Please help!!!

Problem 1 (Require flowchart) Write VBA programs that calculate the cost of renting a car according to the following price schedule: Duration of rent Sedan SUV Daily rate $79 $69 Free miles (per day) 80 100 120 Cost of additional mile $0.69 $0.59 1-6 days 7-29 days 30 or more days Daily rate Free miles (per day) $84 80 $74 100 $64 120 Cost of additional mile $0.74 $0.64 $0.54 $59 $0.49 The program asks the user to enter the type of car (sedan or SUV), the number of the days, and the number of miles driven. The program then displays the cost for the rent. Run the program three times for the following cases and write the answers on your cover page: (a) Sedan, 10 days, 769 miles (b) SUV, 32 days, 4,056 miles (c) Sedan, 3 days, 511 miles