Acme Inc. calculates an employee’s weekly gross pay as follo…
Acme Inc. calculates an employee’s weekly gross pay as following: if the employee works less than 20 hours then the entire worked hours are paid only 75% of the pay rate, if the employee works up to 40 hours but not less than 20 hours is the entire work hours are paid at a regular pay rate, and if the employee works over 40 hours, the entire worked hours are paid at one time and a half time of the pay rate. Using an Excel file, write a VBA procedure to model Acme Inc’s business rules for gross pay. First row should have the name of the columns as following: have column A populated with the employee’s name and column B populated with the job title. Use the variables sngHours, sngRate, and sngGross. Read the input variables sngHours from column C, and sngRate from column D from an Excel file. Write the output sngGross in column D in the same Excel file.. Run the code for at least 6 examples with worked hours that will represent the scenario above. Add a loop structure to go through all your records. You can use a fix number of loops or a variable loop as long as you use a loop structure. After testing and debugging, please submit the working VBA code below and attach the Excel file with the extension xls file to this question. The Excel file should have both the data set and the VBA code. Double check you attached the correct file and that the file has the VBA code.