Kevin Brooks a Lab Technician at UTech, Jamaica has decided to purchase a queen-sized set from Singer Jamaica Limited. Mr. Brooks can choose from one of five (5) options that are available to him to pay for the bed set; a. Cash price at 0% b. 3 Months at 5% c. 10 Months at 12% d. 24 months at 18% e. 36 Months at 28% 1. Create a table that will reflect the calculations based on the payment options that Mr. Brooks has available, shown above. The cash price for the bed set is $98,600.00 plus the General Consumption Tax (GCT). GCT is 17.5%. a. Create a table to reflect the information above. Save the workbook as "Excel labtestl yourID "" (for example "excel labtest1 0100001"). [5 marks] b. Using the IF Statement, determine the number of years that are in each payment option; print " 1 " for all payment options that are less than 12 months. [10 marks] c. Charges =( Cash Price * GCT)+( Cash Price * Interest Rate ) d. Total Payment = Cash Price + Charges [5 marks] [4 marks]