The sample source data shown in the table below provides the information about employees, their residential state, county, city and…