EXPANDING THE WORKFORCE? Should we or shouldnt 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 $1.5 million in 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: A] Two additional sales representatives (both Level 10). B] Two additional secretaries / clerical (both Level 6.) C] Ten additional assemblyline operators (Level 4) for the production department. D] Three additional materials handlers (Level 4) for the production department. E] One additional assembly line supervisor (Level 14). 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 Complete the attached chart [show all your work] to answer the following questions: Current Future / Projected Payroll Costs? $751,000 ** should be from below

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 expandin means production must double. It will require expanding the workforce and payroll. You have been asked to pr work force the following personnel will be required: Al Two additional sales representatives (both Level 10). B] Two additional secretaries / clerical (both Level 6.) C] Ten additional assembly-line operators (Level 4) for the production department. D] Three additional materials handlers (Level 4) for the production department. El One additional assembly line supervisor (Level 14). Now you must estimate the costs of adding these personnel to the payroll. Use the chart "Future Payroll Estimates" to compute Excel and Formulas Complete the attached chart [show all your work] to answer the following questions: Current Future / Projected Payroll Costs? ** $751,000 Sales $ 1.500.000.C Percentage of sales which payroll represents? Would you recommend the expansion? Why or why not? "Future Pavroll Estimates" POSITION PAY SCALE PRESENT NUMBER OF STAFF PRESENT PAYROLL Changes PROJECTED to Number STAFF of Staff NUMBERS MANAGEMENT Level24. Level 18. Level 11.. S..-65.000 S.-45.000 S.-30.000 -S...-65.000 45.000 LS 90.000 CLERICAL Level 10. Level 6. $.-20.000 S.-15.000 2$ 3$ 40.000 45.000 PRODUCTION Level 14... Level 10. Level 8. Level 5 Level4. S.-25.000. S... 20.000 $.-17 DOO $.-15.000 S.-14.000 S. --75.000 1.S...-20.000 2LS 34000 $ 30 000 13 $ 182.000 SALES. Level 10. $. 25.000 -$ 125.000 TOTALS $ 226,000 36 $ 751.000 un no