Problem 2

MedTech wants your help with HR supply estimates. They have estimated employee flow throughout the organization and have mapped this information onto the following Markov matrix:

Table 2: Transition probability matrix

	N	A	B	C	D	Exits
A. Production Engineer	30	90%				10%
B. Team Leader	90	6%	77%	4%		13%
C. Technician Class II	200		10%	65%	5%	20%
D. Technician Class I	250			22%	70%	8%
Total employees (2017)	570

1. Outline employee movement projections and the supply estimates for each level for next year (i.e., 2018).
2. Assuming the distribution of employees in the 4 jobs remains the same, utilize your HR demand estimate from problem 1 to calculate how many employees MedTech needs to hire in each position.

(Please attach in excel form if possible)