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 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
You will notice that two reports have been generated for Daniel and Eric by setting the First Name criteria in cell A The Spreadsheet from Learning Activity was used to derive Daniels report first by clearing all the criteria cells and then by entering the following formula into cell ADaniel Erics report was derived in a similar fashion by clearing cell A 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?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
