EXPANDING THE WORKFORCE? Should we or shouldn't we? You are the human resource manager for Twinkle Toes Tap Shoes, Inc. Twinkle Toes is considering expanding its operations in order to double its current sales in five years. This means production must double. It will require expanding the workforce and payroll. You have been asked to project the staffing levels and payroll costs necessary to expand. In addition to the current work force the following personnel will be required: Al Two additional sales representatives (Level 10). B] Three additional secretaries / clerical (Level 6.) 7 C] Ten additional assembly-line operators (Level 4) for the production department 8 D] Three additional materials handlers (Level 4) for the production department. 9 Ej One additional assembly line supervisor (Level 14). 7 10 Now you must estimate the costs of adding these personnel to the payroll. Use the chart "Future Payroll Estimates" to compute your projection figures (assume the current pay scales remain unchanged.) Use Excel and Formulas 11 12 13 Complete the attached chart (show all your work] in order to answer the following questions: 14 15 Current Future / Projected Payroll Costs? .. 15 $876,000