Doortodoor Sports Equipment Company

1. The numbers of the "Doortodoor Sports Equipment Company" (DSEC) show job stability within the company for levels two and three. Level 1 for Sales Full time (SF) and Sales Part time (SP) are not that bad either, based upon the numbers of employee's that exit the company. In addition, positions SF and SP have a large amount of internal stability based upon internal employee movements. Promotional paths very for the different levels. SP to SF employee promotions and movements is a number that is not expected at a 7.5% and, vice versa, with 50 SF employees moving to SP positions. The number of employee movements may be due to unseen job variables. Advancements from ASM to Regional Sales Manager (RSM) is a expected percentage. SP and SF advancement to ASM is high and also may have unforeseen job variables contributing to the calculated percentage. Demotions, if that is what they all are, is quite significant when compared between the SF and SP employees. 50 SF employees will move to the SP position. 90 SP employees will not move at all. Employees that are asked or decide to leave are high with 175 SF employees leaving. The only exceptions with this is the data of RSM with 9 employee's exiting the company. Creating a high turnover rate, if each year 9 RSM are leaving.

CURRENT SF SP ASM RSM LOSS

SF 500 250 50 25 0 175

SP 150 7.5 90 15 0 37.5

ASM 50 2.5 0 40 5 2.5

RSM 30 0 0 0 21 9

Promoted and demoted

SF SP ASM RSM

SF 50 25

SP 7.5 15

ASM 2.5 5

RSM 5

GAP

SF 250 175(LOSS)+25(ASM)+50(SP)=250

250

SP 90 37.5(LOSS)+15(ASM)+7.5(SF)=60

60

ASM 40 2.5(LOSS)+2.5(SF)+5(RSM)=10

10

RSM 21 9 (LOSS)

9

2. To forecast numbers for year 2013, one needs to look at the gap analysis. Level 1 SF will have a higher demand for employment. Due to the movement of SF to SP and ASM positions, a gap is created and when added to the employees that exited the company, 50 percent hiring is need. Now, the 250 open positions can be augmented with internal hiring from the small number of SP's moving into a SF position. But most will have to be hired externally. To fill SP positions, from the projected numbers of SF, internal employment