What should my VBA code for Excel be?

OKC Tours Programming Project Assume you have just been hired by the manager of OKC Tours (OKCT), a small company located in Oklahoma City. OKCT specializes in providing tour buses and guides to tour groups desiring to travel through some of Oklahoma's historic sites. OKCT holds tours for groups ranging from 15 to 110 people (including 15 people and 110 people tours), assume that the program user will know to only enter values between 15 and 110 people (inclusive). (This means you don't have to worry about "error-checking) Two types of buses are available for use: small buses (35 maximum tourists per bus) and large buses (55 tourists per bus),. OKCT has two small buses and two large buses: tour groups can use only combinations of two buses at a time. There are five tour bus options with each option using a different bus pairing as shown in Table 1. # of Buses Option Min and Max Tourists Small Big Per Bus Price Base aty 15 35 36 min tourists max tourists min tourists max tourists min tourists max tourists min tourists max tourists min tourists 350 450 450 700 70 71 90 91 800 900 max tourists 110 Table 1. Bus Combinations and Associated Pricing To help you better understand the information summarized in the table, OKCT provided you with a description of their pricing structure. For each bus, there is a base usage price that includes a driver and tour guide for any tour up to and including five hours in duration. (All hour calculations are rounded to the nearest whole hour.) Each small bus has a base price (SBP) of $350 and each large bus has a base price (LBP) of $450. For tours longer than 5 hours in duration, typically 25% of the base price is added for each hour above 5 hours, but no more than 4 hours above the 5 hours base are charged per day. Again, even for tours lasting longer than 5 hours, the tour length is rounded to the nearest whole hour. The table below shows a few example price calculations. The base prices and additional hourly percentage rates are subject to change at any time, thus your spreadsheet and code should allow for the modification of these rates