Question: Complete the following tasks relating to Activity 2 . 8 on how to use information to support decision makingState your conclusions from the analysisRecommend a

Complete the following tasks relating to Activity 2.8 on how to use information to support decision makingState your conclusions from the analysisRecommend 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?
Complete the following tasks relating to Activity

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!