ScenarioBigtunes Inc. manufactures a premium grade Bluetooth headset that has a list price of $$499.$ With varying cash and trade discounts it is tedious to determine a customer's final price. Consequently, Bigtunes Inc. has contracted you to set up a template in Excel to help them reconcile customer payments against the appropriate net cash price.InstructionsFollow the basic structure in chapter $6$ pg $231$ of your math text to create a table on Worksheet $1$ that calculates the Total Amount Due. Since you will be using this template repetitively, create an input section that allows you to change the values for the list price, number sold, relevant dates, customer type and delivery charge for each reconciliation. In addition, identify the following payment terms on worksheet $2$: The GST rate is $5\%.$ Cash discount is $2\%$ of net price if gaid within $20$ days of the invoice date. Trade discounts are offered according to the following schedule:$1-$Reg. Customer$2-$Retailer$3-$Wholesaler$4-$Distributor$0\%30\%10\%5\%$Your customer type input cell should be created to provide a drop down list of the four options above. $($Hint: use the list option in the data validation tool on your ribbon$).$ In order to automatically calculate the correct discount rate based on the type of customer chosen, you will need to calculate the single discount equivalent and employ the VLOOKUP function. Utilize the IF function to calculate whether the cash discount applies $($Hint: you can perform mathematical calculations on dates$).$Practice inputting various amounts to ensure that the spreadsheet works properly. Format the spreadsheet