| A | B | C | D | E | F | G | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Workers Compensation Insurance Model | ||||||||||||||||||||||
2 | Employee #: | Burn Treatment: | Cut Treatment: | Muscle Strain Treatment | Assault Treatment: | Total: | Premiums: | Total Cost: | |||||||||||||||
3 | 1 | $2,770.01 | $0.00 | $0.00 | $0.00 | $2,770.01 | $1,822.99 | $2,469,554.00 | |||||||||||||||
4 | 2 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $2,105.34 | Total Premium | |||||||||||||||
5 | 3 | $0.00 | $232.47 | $4,837.23 | $0.00 | $5,069.70 | $3,303.21 | $2,590,418.75 | |||||||||||||||
6 | 4 | $1,015.22 | $0.00 | $0.00 | $0.00 | $1,015.22 | $1,825.93 | Profit Margin: | |||||||||||||||
7 | 5 | $3,849.75 | $0.00 | $0.00 | $0.00 | $3,849.75 | $2,045.78 | $120,864.76 | |||||||||||||||
8 | 6 | $1,467.51 | $0.00 | $0.00 | $0.00 | $1,467.51 | $2,015.47 | ||||||||||||||||
9 | 7 | $1,804.90 | $2,071.64 | $8,254.45 | $0.00 | $12,130.99 | $2,820.30 | ||||||||||||||||
10 | 8 | $2,848.11 | $0.00 | $875.50 | $0.00 | $3,723.61 | $2,199.27 | ||||||||||||||||
11 | 9 | $2,017.59 | $0.00 | $0.00 | $0.00 | $2,017.59 | $2,783.25 | ||||||||||||||||
12 | 10 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1,927.94 | ||||||||||||||||
13 | 11 | $922.64 | $0.00 | $0.00 | $1,485.38 | $2,408.03 | $3,394.63 | ||||||||||||||||
14 | 12 | $0.00 | $64.70 | $0.00 | $0.00 | $64.70 | $3,085.23 | ||||||||||||||||
15 | 13 | $3,030.27 | $3,517.42 | $0.00 | $0.00 | $6,547.69 | $3,370.17 | ||||||||||||||||
16 | 14 | $0.00 | $0.00 | $4,142.41 | $2,403.18 | $6,545.59 | $3,110.19 | ||||||||||||||||
17 | 15 | $840.82 | $0.00 | $3,803.47 | $0.00 | $4,644.29 | $3,045.26 | ||||||||||||||||
18 | 16 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $3,514.66 | ||||||||||||||||
19 | 17 | $3,554.06 | $3,260.65 | $0.00 | $2,460.75 | $9,275.47 | $3,070.70 | ||||||||||||||||
20 | 18 | $0.00 | $1,979.81 | $0.00 | $0.00 | $1,979.81 | $1,874.96 | ||||||||||||||||
21 | 19 | $697.43 | $0.00 | $0.00 | $0.00 | $697.43 | $2,378.23 | ||||||||||||||||
22 | 20 | $2,807.58 | $0.00 | $0.00 | $0.00 | $2,807.58 | $2,308.52 | ||||||||||||||||
23 | 21 | $195.59 | $0.00 | $5,612.32 | $0.00 | $5,807.91 | $2,199.42 | ||||||||||||||||
24 | 22 | $0.00 | $0.00 | $1,379.46 | $0.00 | $1,379.46 | $3,268.63 | ||||||||||||||||
25 | 23 | $2,128.58 | $0.00 | $0.00 | $0.00 | $2,128.58 | $2,465.11 | ||||||||||||||||
26 | 24 | $0.00 | $1,830.43 | $0.00 | $0.00 | $1,830.43 | $2,947.28 | ||||||||||||||||
27 | 25 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $2,866.39 | ||||||||||||||||
28 | 26 | $0.00 | $352.35 | $0.00 | $0.00 | $352.35 | $1,945.90 | ||||||||||||||||
29 | 27 | $0.00 | $0.00 | $1,202.42 | $0.00 | $1,202.42 | $2,991.21 | ||||||||||||||||
30 | 28 | $0.00 | $2,116.99 | $0.00 | $0.00 | $2,116.99 | $3,260.56 | ||||||||||||||||
31 | 29 | $1,129.39 | $0.00 | $0.00 | $0.00 | $1,129.39 | $2,040.12 | ||||||||||||||||
32 | 30 | $2,528.28 | $943.94 | $7,276.59 | $0.00 | $10,748.81 | $2,150.54 | ||||||||||||||||
33 | 31 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $2,284.12 | ||||||||||||||||
34 | 32 | $1,735.67 | $586.64 | $0.00 | $0.00 | $2,322.31 | $3,021.30 | ||||||||||||||||
35 | 33 | $3,255.26 | $0.00 | $0.00 | $0.00 | $3,255.26 | $1,915.91 | ||||||||||||||||
36 | 34 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $2,071.10 | ||||||||||||||||
37 | 35 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1,876.42 | ||||||||||||||||
38 | 36 | $3,789.90 | $0.00 | $0.00 | $0.00 | $3,789.90 | $2,569.86 | ||||||||||||||||
39 | 37 | $961.90 | $930.33 | $0.00 | $0.00 | $1,892.23 | $2,213.45 | ||||||||||||||||
40 | 38 | $3,371.44 | $0.00 | $4,487.10 | $0.00 | $7,858.55 | $1,973.31 | ||||||||||||||||
41 | 39 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $2,076.59 | ||||||||||||||||
42 | 40 | $0.00 | $540.87 | $0.00 | $3,084.40 | $3,625.27 | $2,022.87 | ||||||||||||||||
43 | 41 | $3,748.14 | $1,909.96 | $603.91 | $0.00 | $6,262.02 | $3,053.87 | ||||||||||||||||
44 | 42 | $0.00 | $0.00 | $991.65 | $0.00 | $991.65 | $1,971.03 | ||||||||||||||||
45 | 43 | $832.91 | $1,481.54 | $0.00 | $0.00 | $2,314.44 | $1,935.52 | ||||||||||||||||
46 | 44 | $35.86 | $1,225.74 | $0.00 | $2,498.43 | $3,760.04 | $2,108.53 | ||||||||||||||||
47 | 45 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $3,298.66 | ||||||||||||||||
48 | 46 | $1,664.31 | $0.00 | $0.00 | $0.00 | $1,664.31 | $2,941.88 | ||||||||||||||||
49 | 47 | $3,016.09 | $0.00 | $0.00 | $912.86 | $3,928.95 | $2,066.83 | ||||||||||||||||
50 | 48 | $1,034.57 | $0.00 | $3,241.84 | $0.00 | $4,276.41 | $2,127.17 | ||||||||||||||||
51 | 49 | $0.00 | $1,131.69 | $0.00 | $0.00 | $1,131.69 | $1,876.33 | ||||||||||||||||
52 | 50 | $2,170.88 | $0.00 | $0.00 | $0.00 | $2,170.88 | $2,889.89 | ||||||||||||||||
53 | 51 | $0.00 | $0.00 | $2,942.64 | $0.00 | $2,942.64 | $2,634.83 | ||||||||||||||||
54 | 52 | $0.00 | $0.00 | $1,028.55 | $395.82 | $1,424.37 | $3,220.72 | ||||||||||||||||
55 | 53 | $1,297.13 | $2,910.28 | $261.78 | $0.00 | $4,469.19 | $2,955.13 | ||||||||||||||||
56 | 54 | $1,861.60 | $442.98 | $0.00 | $0.00 | $2,304.58 | $2,088.24 | ||||||||||||||||
57 | 55 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $2,186.65 | ||||||||||||||||
58 | 56 | $0.00 | $379.57 | $3,612.99 | $0.00 | $3,992.55 | $2,316.88 | ||||||||||||||||
59 | 57 | $0.00 | $0.00 | $0.00 | $5,949.56 | $5,949.56 | $2,272.28 | ||||||||||||||||
60 | 58 | $590.17 | $0.00 | $0.00 | $0.00 | $590.17 | $3,223.19 | ||||||||||||||||
61 | 59 | $329.98 | $3,165.38 | $1,075.77 | $0.00 | $4,571.13 | $2,945.44 | ||||||||||||||||
62 | 60 | $5,319.09 | $2,976.56 | $4,616.59 | $0.00 | $12,912.24 | $3,080.19 | ||||||||||||||||
63 | 61 | $0.00 | $1,557.38 | $4,422.27 | $0.00 | $5,979.65 | $2,178.34 | ||||||||||||||||
64 | 62 | $0.00 | $495.87 | $0.00 | $2,084.42 | $2,580.28 | $1,778.86 | ||||||||||||||||
65 | 63 | $2,936.66 | $1,354.88 | $0.00 | $0.00 | $4,291.54 | $3,114.65 | ||||||||||||||||
66 | 64 | $1,222.24 | $0.00 | $2,530.06 | $0.00 | $3,752.31 | $3,095.30 | ||||||||||||||||
67 | 65 | $95.56 | $0.00 | $0.00 | $0.00 | $95.56 | $2,411.97 | ||||||||||||||||
68 | 66 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1,757.44 | ||||||||||||||||
69 | 67 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $2,801.05 | ||||||||||||||||
70 | 68 | $0.00 | $0.00 | $813.96 | $0.00 | $813.96 | $3,452.17 | ||||||||||||||||
71 | 69 | $1,842.27 | $255.58 | $102.14 | $0.00 | $2,199.99 | $3,164.05 | ||||||||||||||||
72 | 70 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $3,194.46 | ||||||||||||||||
73 | 71 | $2,472.62 | $73.24 | $0.00 | $0.00 | $2,545.86 | $1,889.44 | ||||||||||||||||
74 | 72 | $0.00 | $0.00 | $3,805.14 | $1,721.41 | $5,526.55 | $2,210.72 | ||||||||||||||||
75 | 73 | $1,986.60 | $0.00 | $0.00 | $0.00 | $1,986.60 | $2,279.19 | ||||||||||||||||
76 | 74 | $312.29 | $0.00 | $0.00 | $0.00 | $312.29 | $2,041.34 | ||||||||||||||||
77 | 75 | $1,420.23 | $507.29 | $0.00 | $0.00 | $1,927.51 | $2,892.60 | ||||||||||||||||
78 | 76 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $2,734.18 | ||||||||||||||||
79 | 77 | $0.00 | $0.00 | $718.37 | $0.00 | $718.37 | $2,678.87 | ||||||||||||||||
80 | 78 | $3,300.13 | $0.00 | $1,165.30 | $850.82 | $5,316.24 | $3,065.92 | ||||||||||||||||
81 | 79 | $0.00 | $1,676.51 | $0.00 | $0.00 | $1,676.51 | $3,025.05 | ||||||||||||||||
82 | 80 | $0.00 | $1,665.26 | $0.00 | $0.00 | $1,665.26 | $2,769.93 | ||||||||||||||||
83 | 81 | $0.00 | $0.00 | $0.00 | $1,677.61 | $1,677.61 | $3,094.59 | ||||||||||||||||
84 | 82 | $1,083.18 | $2,804.31 | $3,195.77 | $227.60 | $7,310.86 | $2,997.93 | ||||||||||||||||
85 | 83 | $1,009.86 | $1,429.63 | $0.00 | $3,791.48 | $6,230.97 | $1,900.79 | ||||||||||||||||
86 | 84 | $2,250.87 | $0.00 | $1,718.95 | $0.00 | $3,969.82 | $2,420.84 | ||||||||||||||||
87 | 85 | $2,107.91 | $18.23 | $0.00 | $0.00 | $2,126.14 | $1,871.78 | ||||||||||||||||
88 | 86 | $2,488.05 | $2,334.18 | $0.00 | $2,303.04 | $7,125.28 | $2,200.33 | ||||||||||||||||
89 | 87 | $485.41 | $0.00 | $3,624.91 | $0.00 | $4,110.32 | $2,288.96 | ||||||||||||||||
90 | 88 | $2,058.79 | $0.00 | $0.00 | $0.00 | $2,058.79 | $2,103.43 | ||||||||||||||||
91 | 89 | $1,175.25 | $0.00 | $1,683.90 | $3,731.57 | $6,590.72 | $3,163.38 | ||||||||||||||||
92 | 90 | $2,342.71 | $0.00 | $1,810.91 | $0.00 | $4,153.62 | $2,928.63 | ||||||||||||||||
93 | 91 | $2,045.10 | $0.00 | $1,087.48 | $0.00 | $3,132.58 | $1,755.65 | ||||||||||||||||
94 | 92 | $1,787.93 | $1,572.69 | $3,081.43 | $0.00 | $6,442.05 | $3,130.52 | ||||||||||||||||
95 | 93 | $0.00 | $1,865.82 | $0.00 | $0.00 | $1,865.82 | $2,300.19 | ||||||||||||||||
96 | 94 | $0.00 | $549.12 | $737.84 | $0.00 | $1,286.95 | $3,623.49 | ||||||||||||||||
97 | 95 | $1,726.24 | $0.00 | $2,923.09 | $0.00 | $4,649.33 | $3,345.73 | ||||||||||||||||
98 | 96 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1,959.68 | ||||||||||||||||
99 | 97 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $3,149.59 | ||||||||||||||||
100 | 98 | $130.55 | $1,244.01 | $0.00 | $1,909.59 | $3,284.15 | $3,632.78 | ||||||||||||||||