Developing a clear plan for getting profit

Question

Assignment:

The St. Louis Companies An irritated Roger Hatton finds himself sitting in the St. Louis airport after hearing that his flight to Chicago has been delayed—and, if the storm in Chicago continues, possibly cancelled. Because he must get to Chicago if at all possible, Roger is stuck at the airport. He decides he might as well try to get some work done, so he opens his laptop computer and calls up the Claimnum file. Roger was recently assigned as an analyst in the worker’s compensation section of the St. Louis Companies, one of the biggest issuers of worker’s compensation insurance in the country. Until this year, the revenues and claim costs for all parts of the company were grouped together to determine any yearly profit or loss. Therefore, no one really knew if an individual department was profitable. Now, however, the new president is looking at each part of the company as a profit center. The clear implication is that money-losing departments may not have a future unless they develop a clear plan to become profitable. When Roger asked the accounting department for a listing, by client, of all policy payments and claims filed and paid, he was told that the information is available but he may have to wait two or three months to get it. He was able to determine, however, that the department has been keeping track of the clients who file frequent (at least one a month) claims and the total number of firms that purchase workers’ compensation insurance. Using the data from this report, Roger divides the number of clients filing frequent claims by the corresponding number of clients. These ratios, in the file Claimnum, are as follows:

Year	Ratio (%)	Year	Ratio (%)
1	3.8	12	6.1
2	3.6	13	7.8
3	3.5	14	7.1
4	4.9	15	7.6
5	5.9	16	9.7
6	5.6	17	9.6
7	4.9	18	7.5
8	5.6	19	7.9
9	8.5	20	8.3
10	7.7	21	8.4
11	7.1

Provide complete and step by step solution for the question and show calculations and use formulas.