Recreate the table given below in a new worksheet. Add columns to the table below to...

Transcribed Image Text:

Recreate the table given below in a new worksheet. Add columns to the table below to complete needed information. 1. It is important to establish a relationship between sales productivity and wages. Create a table for the following information (you will need to add columns); 2. Calculate selling costs percentage for each sales associate. Selling cost is gross wages + net sales. Gross wages is hourly wages plus any commission. Also note commission is based off net sales. You will need to use basic math to calculate gross wages. 3. Add a row and show the totals for net sales and hours worked, Add a row and calculate the averages for net sales, hours worked, wage per hour and commission Sales Associate Frank Gwen Heather Jason Kathy Lacey Tracy Oliver David Joan Kelly Olivia Net Sales $9.796 $9,362 $6,854 $5,936 $4,815 $7.491 $3,796 $5,262 $9,154 $4,453 $6,175 $7,321 Hours Worked 38 40 SESPRESSES 32 28 20 20 42 34 30 28 20 20 Wage per Hour Commission% $ 7.75 2.0% $ 645 2.0% $ 8.00 1.0% $ 8.15 8.00 $ $ $ $ S $ $ $ 8.00 6.35 7.50 8.75 6.45 9.75 8.00 3.0% 3.0% 3.0% 1.9% 2.1% 1.5% 3.0% 3.0% 3.3% d. Calculate the selling cost for the entire department (you need to use totals). Also calculate average earnings per hour for each associate based on the data given. (3 pts.) 2- Using conditional formatting, highlight the cost % cell for employees with cost%> 6% (1.5 pts.) 3- Sort the table in descending order of selling cost % per employee (1.5 pts.) Recreate the table given below in a new worksheet. Add columns to the table below to complete needed information. 1. It is important to establish a relationship between sales productivity and wages. Create a table for the following information (you will need to add columns); 2. Calculate selling costs percentage for each sales associate. Selling cost is gross wages + net sales. Gross wages is hourly wages plus any commission. Also note commission is based off net sales. You will need to use basic math to calculate gross wages. 3. Add a row and show the totals for net sales and hours worked, Add a row and calculate the averages for net sales, hours worked, wage per hour and commission Sales Associate Frank Gwen Heather Jason Kathy Lacey Tracy Oliver David Joan Kelly Olivia Net Sales $9.796 $9,362 $6,854 $5,936 $4,815 $7.491 $3,796 $5,262 $9,154 $4,453 $6,175 $7,321 Hours Worked 38 40 SESPRESSES 32 28 20 20 42 34 30 28 20 20 Wage per Hour Commission% $ 7.75 2.0% $ 645 2.0% $ 8.00 1.0% $ 8.15 8.00 $ $ $ $ S $ $ $ 8.00 6.35 7.50 8.75 6.45 9.75 8.00 3.0% 3.0% 3.0% 1.9% 2.1% 1.5% 3.0% 3.0% 3.3% d. Calculate the selling cost for the entire department (you need to use totals). Also calculate average earnings per hour for each associate based on the data given. (3 pts.) 2- Using conditional formatting, highlight the cost % cell for employees with cost%> 6% (1.5 pts.) 3- Sort the table in descending order of selling cost % per employee (1.5 pts.)

Answer rating: 100% (QA)

Sales Associates Net sales Hours worked Frank 9796 38 Gwen 9362 40 Heather 6854 32 Jason 5936 ... View the full answer