SECTION B: 20 MARKS Using the goal seeking feature in Ms excel demonstrate a scenario where an employee earns a basic salary of 50000. The overtime payrate per hour is 2500. The total overtime amount =hours worked x payrate per hour. The total gross pay = basicpay+overtime overtime amount. The Tax payable = 30% of the gross pay. The netpay = grosspay-tax payable i) Enter the date in a worksheet to computer the net pay if the overtime hrs are 15 (6 Marks) Using the goal seeking feature how many hours do you need for overtime to take home a net pay of 130,000 (4 Marks) iii) Using the scenario manager the worst case and the best case scenario of not having overtime and having 80 over hours (6 Marks)