solution
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
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 Daniel’s report first by clearing all the criteria cells and then by entering the following formula into cell A2 =”=Daniel” Eric’s 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 Daniel’s figures against Eric’s 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?
Draw an ERD for each of the following:
a. A sale can include many items and an item can be included on many sales.
b. A customer can place an order for different products sold by a retailer. A product may be sold on multiple orders and an order may be for many products.
c. An academic department at Texas A&M Commerce University offers multiple curricula and a curriculum is offered by one academic department. d. A building in Texas A&M Commerce University has multiple rooms and a room is located in a specific building.
e. The Marketing and Business Analytics Department at Texas A&M Commerce University offers courses that may have several prerequisites. Some of these courses may be a prerequisite to other courses.
f. An employee at Texas A&M Commerce University may work on different projects that may be run at multiple locations.
Hi there! Click one of our representatives below and we will get back to you as soon as possible.