This image shows the form with values automatically populated for Location and Total Employees fields based on Department.