Based on this information, create and solve a ratio analysis: In their most recent discussion with VP Finance, they were informed that total sales next year $(2022)$ was expected to be $$1,500,000.$ You should assume the same amount of turnover in $2022$ as there was in the past $5$ years.

Number of new hires and turnover by year

Year

New Hires

Turnover

$2017$

$10$

$5$

$2018$

$20$

$7$

$2019$

$22$

$9$

$2020$

$25$

$12$

$2021$

$15$

$15$

Sales per year

Year

Service Sales

Product Sales

$2017$

$$250,000$

$$200,000$

$2018$

$$350,000$

$$325,000$

$2019$

$$400,000$

$$450,000$

$2020$

$$550,000$

$$600,000$

$2021$

$$625,000$

$$675,000$

How many employees need to be hired in $2022,$ show all calculations