Proposed next steps:
You need to be the project owner to select a next step.
Since the number of hours required to produce the requested spreadsheet is extensive, we propose first conducting research to determine if there are existing tools that produce the desired results. We propose providing 4-6 tools/programs that calculate the total employer cost, including being able to change assumptions based on the state of residence. For each company/program found, we will provide a summary of the tool/program, what factors can be included in the calculation (insurance, PTO, dental, fitness club, overhead, taxes, etc), any available pricing, target market, and competitive advantage.
Additionally, in order to use an existing tool, data would still be required on the typical benefits provided to salaried employers. Therefore, we propose (1) providing a list of the typical benefits provided to salaried employees, and (2-4) providing details on the average employer cost of each benefit. As we do not yet know how many benefits there will be, we can't determine the total number of requests this would be. However, we estimate that the average employer cost for 3-4 benefits could be determined in each request. This could change based on data availability.
Alternatively, to begin the process of creating the spreadsheet, we can begin by collecting data on all the components that should be included when determining total employee cost. This would be divided into (1) salary and benefits components, (2) mandatory employer taxes and insurance, (3) soft costs directly related to each employee (onboarding, supplies, furniture, etc), and (4) overhead expenses (building costs, utilities, office supplies, etc.). Each report would provide a list of all the components that need to be included for that particular category, along with a justification for why the list is complete.