NOTE: The following requirements must be met in your spreadsheet: F NO MANUAL CALCULATIONS!!! Do not count, total, or calculate anything manually. You must use Excel to do these tasks for you. >- USE CELL REFERENCES: Your calculation formulas must contain cell references to numbers or other information in the spreadsheet. DO NOT type numbers into your formulas. {The whole point of Excel is to have these occur automatically. You must demonstrate the ability to do this in your assign ment!]. 3-- USE THE TURN OVER FORMULA! Each of your turnover calculations must be expressed as a TU RNOYER RATE. In other words, use the turnover formula to calculate each. Your numerator [the top number in the equation} will change based on the termination type, but the denominator {the bottom number in the equation] will stay the same for all turnover calculations} PART 2: Memo to Management '1. Create a memo to the company president, informing him of the results of the turnover analysis. I Make sure to include brief explanations of the different types of turnover, so he will know what is included in each category. I Inc! ude a summary of the turnover rates the overall turnover rate AND the rates for each category. [It may be helpful to use a Table in Word to present this data neatly and professionally]. I Inc! ude any observations you have regarding the organization's turnover in each category. I Include any recommendations you have for reducing turnover of various types. Your plans may be general at this point [e.g. "We should review our compensation structu re.\"}. Your submission will contain TWO documents: 1. Completed spreadsheet containing calculations 2. Memo to company owner summarizing Turnover Analysis. Grading: Your grade for this assignment will be based on: I Ability to demonstrate knowledge of various types of turnover by assigning terminations to appropriate categories. I Ability to correctly calculate turnover rates using turnover formula. Using an incorrect formula, or not using the formula for all calculations, will result in point deductions [if terminations .a" if employees] * me. I Efcient and accurate use of Excel to conduct basic calculations. 0 Spreadsheet must contain calculated elds. 0 No manual counting, adding, or calculating allowed. 0 Calculation formulas must use cell references {e.g. do not type numbers into the formulas]