• Complete the following tasks relating to Activity 2.8 on how to use information to support decision making
• State your conclusions from the analysis
• Recommend a course of action to improve the sales totals of the poorly performing salesman.
• Your conclusions and recommendations should be justified.

Activity 2.8

You will notice that two reports have been generated for Daniel and Eric by setting the First Name criteria in cell A2. The Spreadsheet from Learning Activity 2.6 was used to derive Daniels report first by clearing all the criteria cells and then by entering the following formula into cell A2 ==Daniel Erics report was derived in a similar fashion by clearing cell A2 and entering ==Eric You are to now adopt the role of a manager within this company. In this role you are responsible for driving sales by effectively managing and developing the sales team. Review and compare Daniels figures against Erics and consider the questions below.

A. Based on the Total Sales information for Daniel and Eric which salesman is performing well and which is performing poorly?

B. From the Total and Average hours worked information can we determine if the salesman that is performing well is in fact achieving such successful sales totals by simply working longer hours? Does that explain why the sales figures differ so much?

C. From the Total, Average, Minimum and Maximum customers served information can we determine if the salesman that is performing well is in fact achieving such successful sales totals by simply approaching and serving more customers? Is the difference significant enough to explain why the sales figures differ so much? Can we conclude that the poorly performing salesman is simply shirking his duty and not seeking to serve customers?

D. What does the information possibly suggest about the skills of the two salesmen with respect to salesmanship?

Eric's Report Daniel'. Report D E D E First Name Customer Served Sales Hours Worked First Name Customer Served Sales Hours Worked 1 1 =Durist Enc 2 2 3 4 4 First Name Customer Served Sales Hours Worked First Name Customer Served Sales Hours Worked 5 5 8. Kathy 121 57.005.00 21 00 6 Kathryn 12 $7,00600 21.00 7 Daniel 41 $9.000 11 23.00 7 Daniel 15 $9.000 11 23.00 8 Eric 12 $3.290 99 30.00 8 Eric 12 $3.290.99 30.00 9 Jean 111 $8,043.691 29.00 9 Jean 11 53,043.69 29.00 10 Eric 14 $4.020.00 29.00 10 Erk 14 $4.020.00 29.00 11 Daniel 15 $8.500.00 21.00 11 Daniel 15 $8.500.00 21.00 12 Jane 21 56.034 22 2100 12 Jane 211 $6,034 22 21.00 13 13 14 Total 30,00 $17.500.11 44.00 14 Total 26.00 $7,310.99 59.00 15 Average 15.00 $3,750.06 22.00 15 Average 13.00 $3,655.50 23.50 18 Minimum 15.00 $3.500.00 21.00 18 Minimum 12.00 $3,290.99 29.00 17 Maximum 15.00 $9,000.11 23.00 17 Maximum 14.00 $4,020.00 30.00