Conduct your gap analysis.

5) Calculate the gaps between demand and supply. Use each of the demand estimates to show possible gaps. Note how the number varies due to different values of demand estimates.

6) Does it appear that you will be overstaffed or understaffed?

7) Choose the demand estimate you think will be more reasonable. Why did you make this choice? Assume that the organization tells you they expect the need to be a long-term need. They would like to hire new employees.

AutoSave OFF OES Application 4 - HR Forecasting & Planning Data - Instructor Home Insert Draw Page Layout Formulas Data Review View Chart Design Format Tell me Share Comments X LG Calibri (Body) v 10 ~ Al A Wran Text Insert v Ceneral AYO Paste BIU A Merge & Center Delete Format Conditional Format Cell Formatting as Table Styles Sort Filter Ideas Find Select Sensitivity y Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No Chart 1 XX J L M N o P P Q R CS Rating Line Fit Plot 600 500 400 GS/FD FTES 300 200 GS/FD FTES Predicted GS/FD FTES 100 0 B C D E F G H 1 1 SUMMARY OUTPUT 2 2 3 Regression Statistics 4 Multiple R 0.940735 5 R Square 0.884983 6 Adjusted R 0.878593 7 Standard E 37.17914 8 Observatio 20 9 10 ANOVA 11 df SS MS F ignificance F 12 Regression 1 191445 191445 138.4986 6.9E-10 13 Residual 18 24881.19 1382.289 14 Total 19 216326.2 15 16 Coefficientsandard Erre Stat P-value Lower 95% Upper 95%ower 95.0%pper 95.0% 17 Intercept -23.0154 31.47952 -0.73112 0.474114 -89.1514 43.12058 -89.1514 43.12058 18 CS Rating 93.90681 7.979477 11.76854 6.9E-10 77.14256 110.6711 77.14256 110.6711 19 20 2 21 22 RESIDUAL OUTPUT 23 24 Observation.cted GS/FD Residuals 25 1 362.0025 -41.0025 26 2 277.4864 11.51362 0 1 2 4 5 6 3 CS Rating Regression 1147 Data + Page Layout 10 W - 150% Home Insert Draw Page Layout Formulas Data Review View Chart Design Format Tell me Share 0 Comments Insert v X LE Calibrl (Body v 10 ~ APA Wran Text General 32E (27 X Delete WO Poste BIUM Av Merge & Center Conditional Format Call Formatting as Table Styles Sort Filter Format v Find & Select Sensitivity Yes No Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Chart 1 x x x A B D E F G . 1 J K L M N 0 P R 21 22 RESIDUAL OUTPUT 23 24 Observation.cted GS/FD Residuals 25 1 362.0025 -41.0025 26 2 277.4864 11.51362 27 3 399.5652 0.434764 28 4 437.128 62.87204 29 5 174.1889 16.81112 30 6 164.7982 -14.7982 001001000 31 7 380.7839 -24.7839 . 32 8 446.5186 4.481356 1 * 33 9 408.9559 -28.9559 22 34 10 258.705 -38.705 35 11 249.3143 -60.3143 1 36 12 117.8448 57.15521 *onto 37 13 427.7373 67.26272 CO2 38 14 352.6118 27.38817 39 15 343.2211 -32.2211 40 16 371.3932 -10.3932 41 17 437.128 -38.128 42 18 399.5652 24.43476 43 19 418.3466 0.653401 44 20 258.705 16.29499 45 46 47 Regression Data + E CP 150%