i need a solution using a vba coding only. i dont have time please

A hotel has a pricing policy as follows: - 1-2 people: $85/ room - 3 people $90/ room - 4 people or more people: $95/ room +$10 per person for each person over 4. (For example, 5 people would cost $105.) If the customer is staying on company business, there is a 15% discount. If any of the people staying in the room is over 60 years of age, there is a 20% discount. A customer does not receive both discounts. The following table is an IPO chart for this problem. An IPO chart shows the input, the processing, and the outbut for. You may use whatever form of decision structure that makes sense to you. You may get input and give output in whatever way you want, as long as it makes sense for a non-VBA familiar user. Be sure to use all of the conventions we have used all semester, that will be part of the grade. You will turn in your Excel file via Canvas. The assignment is due today at 2:20