hrmExprd WorkforceStusto Complete Compatibility Mode] - Excel Aditya Sharma Data Arial - 16 = CRIS File Home Insert Page Layout Formulas Review View Help Tell me what you want to do Share X Out AutoSum - A 2 Wrap Text General AT O - Copy Paste BLU Cell A Conditional Format as Insert Delete Format === C% Sort & Find & Format Painter Merge & Center Formatting Table Styles Clear Filter Select Clipboard Font Alignmen Number Styles Ecrting O GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files sale with genuine Office today Gel genuine Office Learn more A1 fx EXPANDING THE WORKFORCE? Shuuld we ur shouldn't we? D F G H M EXPANDING THE WORKFORCE? Should we or shouldn't we? 2 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: K N 3 4 5 Al Two additional sales representatives (both Level 10), 6 BL Two additional secretaries / clerical (both Level 6.) C] Ten additional assembly-line operators (Level 4) for the production department. 2 Dj Three additional materials handlers (Level 4) for the production department. 9 EJ One additional assembly line supervisor (Level 14). 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] to answer the following questions: 14 15 Current Future / Projected Payroll Costs? 16 $7,51,000 should be from below 17 Sales 18 $ 15,00,000.00 19 Sheet1 + Select destination and press ENTER or choose Paste B19 H Type here to search O 20'C Cloudy AD) E ENG 21:00 02-10-2021 29 10 hrmExprd WorkforceStusto Complete Compatibility Mode] - Excel Aditya Sharma Share File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do X Out AutoSum Calibri - 11 - A 2 Wrap Text General Peste Copy Cell Conditional Format as Insert Delete Format A- Sort & Find & BIU. % Merge & Center Format Painter Formatting Table Styles Clear Filter Select Font Cipboard Stvies Number Calls Alignment Editing O GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of suftware counterfeiting. Avoid interruption and keep your files sale with genuine Office Loday. Gel Genuine Office Learn more X E6 A c D 1 K M N o 17 Sales 18 $ 15,00,000.00 19 Percentage of sales which a payroll represents? 22 23 24 > Would you recommend the expansion? Why or why not? 26 27 29 "Future Payroll Estimates POSITION PAY SCALE PRESENT NUMBER OF PROJECTED PAYROLL COSTS PRESENT. Changes PROJECTED PAYROLL/ to Number STAFF of Staff NUMBERS STAFF 20 31 MANAGEMENT 32 Level 24 23 Level 18 34 Level 11 25 30 CLERICAL $ $ S S 65,000 45,000 30.000 1 $ 1 $ 3 $ 65,000 45,000 90,000 AAAAA Sheet1 + Reacy B19 Type here to search 0 20'C Cloudy AD 40 E ENG 2101 02-10-2021 29 10 hrmExprd WorkforceStusto Complete Compatibility Mode] - Excel Aditya Sharma Share File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do X Out AutoSum Calibri - 11 - A == 2 Wrap Text General Paste Copy Cell Conditional Format as Insert Delete Format BIU Sort & Find & * Format Painter Merge & Center Formatting Table Styles Clear Filter Select Clipboard Font Alignment Number Styles Calls Editing O GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files sale with genuine Orlice loday Gel genuine Office Learn more A X E6 A D 1 K M N o P "Future Payroll Estimates" PAY SCALE PRESENT NUMBER OF Changes PROJECTED PRESENT to Number STAFF PAYROLL of Staff NUMBERS PROJECTED PAYROLLI COSTS STAFF POSITION 30 MANAGEMENT 31 22 Level 24 22 Level 18 1 Level 11 35 36 CLERICAL 37 Level 10 3 Level 6 S 5 $ 65,000 45,000 30,000 1 $ 11 5 3 $ 65,000 45,000 90,000 S S $ 20.000 15,000 25 315 40,000 45,000 40 PRODUCTION 41 Level 14 42 Level 10 43 Level 8 4. Level 5 45 Level 4 46 47 SALES 4 Level 10 S S 5 $ $ 25,000 20,000 17.000 15,000 14.000 31 S 1 S 25 2 5 131 $ 75,000 20,000 34,000 30,000 1.82,000 5 25,000 51 5 1.25,000 50 51 TOTALS $ 2,26,000 36 $ 7,51,000 | ** .53 Sheet1 # Reacy B19 Type here to search O E 20'C Cloudy A GD 4) E ENG 2101 02-10-2021 29 10