Please answer by using Excel Visual Basic

A B D E F G H 1 J 1 Practice 12 2 Create an application to evaluate demand assignments for each truck. 3 User should be able to calculate total truck costs (driver stops as well as demand assigned). 4 3 Questions 5 6 #1 Write a function to calculate total costs for a given truck number. Use this function in the spreadsheet. 7 For the given truck number, check each row in the table to see if the truck was assigned a city demand. If so, update the total 8 number of stops for the truck as well as the total demand assigned to the truck. Calculate the driver cost as total number of 9 stops times driver cost. Calculate the demand cost as the total demand assigned times the demand unit cost. Return the sum of the 10 driver cost and demand cost as the total cost for the truck. 11 #2 Create a procedure to calculate the sum of all trucks based on given assignment values in table. 12 For each truck, update the total truck costs using your truck cost function. Tell the user the total cost for all trucks. 13 #3 Create a procedure to calculate the total cost for one truck. 14 Ask the user for a truck number (if non-numeric error, ask user if they want to cancel). Use the truck cost function to tell the user 15 the total cost for the given truck number. Then ask the user if they want to calculate a new truck number. If so, repeat the procedure. 16 17 18 City Truck 1 Truck 2 Truck 3 Demand 19 Cburg 233 20 Bburg 349 21 Alexandria 383 22 Vienna 462 23 Salem 553 24 Roanoke 565 25 26 Capacity 600 500 1200 27 Driver Cost $10.00 $30.00 $50.00 Calculate Total Costs 28 Demand Unit Cost $2.50 $1.75 $2.25 29 30 Truck Cost #NAME? #NAME? #NAME? Calculate One Truck 31 Documentation P9 P10 P11 P12 +