Laserfiche WebLink
Employee Spreadsheet (Current & Future) <br />Position Title (i.e.: estimatng manager, <br />machine operator, medical assistant, office, <br />management, etc.) <br />Current FTE <br />(quantity) <br />Number of jobs <br />created within 2 <br />years of building <br />completion <br />Year 1 <br />(2025) <br />Year 2 <br />(2026) <br />Year 3 <br />(2027) <br />Ave. hrly <br />cash wage <br />rate* <br />Hourly <br />value of <br />benefits** <br />With <br />benefits <br />Total <br />Male <br />Total <br />Female <br />Ave base <br />wage <br />Average <br />Total <br />Wage <br />Customer Service 5.5 0 ($28.29) ($5.25) ($33.54) 58.5 11.5 ($32.41)($37.66)existing <br />Executive 3 0 ($75.00) ($5.25) ($80.25) $23.00 $28.25 created <br />Interior shop 9 5 ($21.92) ($5.25) ($27.17) <br />Outside sales 5 0 ($62.50) ($5.25) ($67.75) <br />Warehouse 9 0 ($24.16) ($5.25) ($29.41) <br />Sales Manager 1 0 ($62.50) ($5.25) ($67.75) <br />Order Processing 2 0 ($23.39) ($5.25) ($28.64) <br />Driver 8 0 ($29.67) ($5.25) ($34.92) <br />Supervisor 7 0 ($32.62) ($5.25) ($37.87) <br />I.T.1 0 ($51.00) ($5.25) ($56.25) <br />Marketing 1 0 ($36.82) ($5.25) ($42.07) 58.5 11.5 <br />Inventory 1 0 ($34.00) ($5.25) ($39.25) <br />Purchasing 1 0 ($39.87) ($5.25) ($45.12) <br />Exterior Shop 5 1 ($25.38) ($5.25) ($30.63) <br />Service 1 0 ($26.00) ($5.25) ($31.25) <br />Accounting 1.5 0.5 ($29.00) ($5.25) ($34.25) <br />HMI PF 1.5 0 ($23.00) ($5.25) ($28.25) <br />Controller 1 0 ($62.50) ($5.25) ($67.75) <br />TFI 7 0 ($21.00) ($5.25) ($26.25) <br />($37.30) ($5.25) ($42.55) <br />TOTAL EMPLOYEES 70.5 6.5 <br />* excludes benefits <br />**includes non-mandated benefits to employee; social security tax, unemployment insurance, workers comp and other benefeits must be excluded