Part 1 A workbook template will be created that will record and calculate the data for each branch shown on the next page. (The data for each branch must be recorded in a separate workbook.) Use the Spreadsheet Plan on page 4 to sketch this template. Import the text file called Commission Ratestxt into a new workbook. Name the worksheet Commission Rates. Create a named range for the commission rates data. The Commission Rates data is used to look up the % commission each sales person will receive. This percentage will then be used to calculate the commission for each month, based on monthly sales. Insert a new sheet before the Commission Rates worksheet. Name the new sheet Sales. On the Sales worksheet. calculate the commission each sales person will re- ceive each month. Each month if a sales person equals or exceeds a 12 % commission target. they re- ceive an additional bonus of $1,250. Insert a column for each month to determine if the sales person will receive the bonus. {T his can be achieved by combining an IF and a VLOOKUP statement.) The commission target and the amount of bonus on offer will vary every quarter. Ensure that this is taken into account when designing the spread- sheet by positioning the bonus amount and the 9% commission target in separate cells at the top of the worksheet data. Completed El El El