Spreadsheet for Breakout of Costs
508(h)costs.xlsx
General Administrative Regulations; Subpart V-Submission of Policies, Provisions of Policies, and Rates of Premium
Spreadsheet for Breakout of Costs
OMB: 0563-0064
⚠️ Notice: This form may be outdated. More recent filings and information on OMB 0563-0064 can be found here:
Document [xlsx]
Download:
xlsx |
pdf
Overview
Totals
508(h) wo CP
508(h) w CP
CP
Sheet 1: Totals
Totals for Submissions WITHOUT Concept Proposal/Paperwork Package |
|
|
Costs |
One Product |
10 Products |
Total Private |
$141,420.03 |
$1,414,200.30 |
Total RMA |
$101,764.64 |
$1,017,646.44 |
Total External Review |
$150,000.00 |
$1,500,000.00 |
|
|
|
Totals for Submissions WITH Concept Proposal/Paperwork Package |
|
|
Costs |
One Product |
22 Products |
Total Private |
$141,233.71 |
$3,107,141.62 |
Total RMA |
$101,764.64 |
$2,238,822.17 |
Total External Review |
$150,000.00 |
$3,300,000.00 |
|
|
|
Totals for Concept Proposals/Paperwork Package |
|
|
Costs |
One Product |
36 Products |
Total Private |
$1,364.82 |
$49,133.52 |
Total RMA |
$43.27 |
$1,557.78 |
Total External Review |
$16,000.00 |
$576,000.00 |
|
|
|
Overall Total Private |
|
$4,570,475.44 |
Overall Total RMA & External Review |
|
$8,634,026.39 |
Sheet 2: 508(h) wo CP
Costs for Submission of 508(h) Products WITHOUT Concept Proposal |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Submissions WITHOUT Concept Proposal/Paperwork Package = |
|
|
|
|
10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Costs |
One Product |
10 Products |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Private |
$141,420.03 |
$1,414,200.30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total RMA |
$101,764.64 |
$1,017,646.44 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total External Review |
$150,000.00 |
$1,500,000.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total for 3 Years |
|
$3,931,846.74 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Private occupations |
mean hr wage |
read hours |
wage*hrs |
first time hours |
wage*hrs |
modification hours |
wage*hrs |
correspond hours |
wage*hrs |
prep hours |
wage*hrs |
respond hours |
wage*hrs |
negotiate hours |
wage*hrs |
maintenance hours |
wage*hrs |
Mkt mger |
$57.73 |
2 |
$115.46 |
40 |
$2,309.20 |
|
$0.00 |
|
$0.00 |
5 |
$288.65 |
|
$0.00 |
|
$0.00 |
|
$0.00 |
Computer mger |
$58.00 |
|
$0.00 |
40 |
$2,320.00 |
|
$0.00 |
|
$0.00 |
5 |
$290.00 |
40 |
$2,320.00 |
|
$0.00 |
10 |
$580.00 |
Financial mger |
$54.68 |
|
$0.00 |
10 |
$546.80 |
|
$0.00 |
|
$0.00 |
|
$0.00 |
10 |
$546.80 |
|
$0.00 |
|
$0.00 |
Technical writer |
$31.55 |
|
$0.00 |
250 |
$7,887.50 |
150 |
$4,732.50 |
|
$0.00 |
|
$0.00 |
200 |
$6,310.00 |
|
$0.00 |
|
$0.00 |
Actuary |
$46.85 |
2 |
$93.70 |
80 |
$3,748.00 |
50 |
$2,342.50 |
|
$0.00 |
|
$0.00 |
50 |
$2,342.50 |
|
$0.00 |
10 |
$468.50 |
Accountant |
$32.42 |
|
$0.00 |
40 |
$1,296.80 |
10 |
$324.20 |
|
$0.00 |
|
$0.00 |
20 |
$648.40 |
|
$0.00 |
|
$0.00 |
Lawyer |
$62.03 |
2 |
$124.06 |
40 |
$2,481.20 |
10 |
$620.30 |
2 |
$124.06 |
5 |
$310.15 |
100 |
$6,203.00 |
30 |
$1,860.90 |
|
$0.00 |
Economist |
$46.31 |
2 |
$92.62 |
200 |
$9,262.00 |
150 |
$6,946.50 |
|
$0.00 |
10 |
$463.10 |
160 |
$7,409.60 |
|
$0.00 |
45 |
$2,083.95 |
Computer programmer |
$35.91 |
|
$0.00 |
200 |
$7,182.00 |
200 |
$7,182.00 |
|
$0.00 |
|
$0.00 |
100 |
$3,591.00 |
|
$0.00 |
50 |
$1,795.50 |
Underwriter |
$30.45 |
2 |
$60.90 |
150 |
$4,567.50 |
150 |
$4,567.50 |
|
$0.00 |
|
$0.00 |
100 |
$3,045.00 |
|
$0.00 |
30 |
$913.50 |
Paralegal |
$24.08 |
|
$0.00 |
40 |
$963.20 |
|
$0.00 |
5 |
$120.40 |
|
$0.00 |
50 |
$1,204.00 |
5 |
$120.40 |
|
$0.00 |
Market research |
$32.45 |
|
$0.00 |
100 |
$3,245.00 |
|
$0.00 |
|
$0.00 |
|
$0.00 |
|
$0.00 |
|
$0.00 |
|
$0.00 |
Statistician |
$36.16 |
|
$0.00 |
200 |
$7,232.00 |
200 |
$7,232.00 |
|
$0.00 |
|
$0.00 |
150 |
$5,424.00 |
|
$0.00 |
45 |
$1,627.20 |
Office |
$15.86 |
|
$0.00 |
110 |
$1,744.60 |
80 |
$1,268.80 |
3 |
$47.58 |
15 |
$237.90 |
20 |
$317.20 |
5 |
$79.30 |
10 |
$158.60 |
Totals |
|
10 |
$486.74 |
1500 |
$54,785.80 |
1000 |
$35,216.30 |
10 |
$292.04 |
40 |
$1,589.80 |
1000 |
$39,361.50 |
40 |
$2,060.60 |
200 |
$7,627.25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Federal occupations |
rate @ step 4 |
first time # emp |
hours |
Total Hrs |
cost |
modification # emp |
hours |
Total Hrs |
cost |
procedure # emp |
hours |
Total Hrs |
cost |
|
|
|
|
Directors |
$60.15 |
3 |
25 |
75 |
$4,511.14 |
3 |
25 |
75 |
$4,511.14 |
3 |
25 |
75 |
$4,511.14 |
|
|
|
|
Economist |
$43.27 |
2 |
40 |
80 |
$3,461.73 |
2 |
40 |
80 |
$3,461.73 |
2 |
40 |
80 |
$3,461.73 |
|
|
|
|
Insurance specialist |
$43.27 |
8 |
40 |
320 |
$13,846.92 |
8 |
40 |
320 |
$13,846.92 |
8 |
40 |
320 |
$13,846.92 |
|
|
|
|
Branch chief |
$51.13 |
1 |
20 |
20 |
$1,022.67 |
1 |
20 |
20 |
$1,022.67 |
1 |
20 |
20 |
$1,022.67 |
|
|
|
|
Underwriter |
$60.15 |
1 |
25 |
25 |
$1,503.71 |
1 |
25 |
25 |
$1,503.71 |
1 |
25 |
25 |
$1,503.71 |
|
|
|
|
Actuary |
$68.31 |
1 |
25 |
25 |
$1,707.79 |
1 |
25 |
25 |
$1,707.79 |
1 |
25 |
25 |
$1,707.79 |
|
|
|
|
Lawyer |
$51.13 |
1 |
40 |
40 |
$2,045.35 |
1 |
40 |
40 |
$2,045.35 |
1 |
40 |
40 |
$2,045.35 |
|
|
|
|
Computer programmer |
$36.39 |
2 |
80 |
160 |
$5,822.23 |
2 |
80 |
160 |
$5,822.23 |
2 |
80 |
160 |
$5,822.23 |
|
|
|
|
Totals |
|
19 |
|
745 |
$33,921.55 |
19 |
|
745 |
$33,921.55 |
19 |
|
745 |
$33,921.55 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
External Reviewers |
$150,000/review |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total hrs/yr |
hrs x 10 products |
Total $/product |
$ x 10 products |
|
|
|
|
|
|
|
|
|
|
|
|
|
Private occupations |
3800 |
38000 |
$141,420.03 |
$1,414,200.30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Federal occupations |
2235 |
22350 |
$101,764.64 |
$1,017,646.44 |
|
|
|
|
|
|
|
|
|
|
|
|
|
External Reviewers |
|
|
$150,000.00 |
$1,500,000.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
|
|
|
$3,931,846.74 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Sheet 3: 508(h) w CP
Costs for Submission of 508(h) Products WITH Concept Proposal |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Submissions WITH Concept Proposal/Paperwork Package = |
|
|
|
|
22 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Costs |
One Product |
22 Products |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Private |
$141,233.71 |
$3,107,141.62 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total RMA |
$101,764.64 |
$2,238,822.17 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total External Review |
$150,000.00 |
$3,300,000.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total for 3 Years |
|
$8,645,963.79 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Private occupations |
mean hr wage |
read hours |
wage*hrs |
first time hours |
wage*hrs |
modification hours |
wage*hrs |
correspond hours |
wage*hrs |
prep hours |
wage*hrs |
respond hours |
wage*hrs |
negotiate hours |
wage*hrs |
maintenance hours |
wage*hrs |
Mkt mger |
$57.73 |
2 |
$115.46 |
40 |
$2,309.20 |
|
$0.00 |
|
$0.00 |
5 |
$288.65 |
|
$0.00 |
|
$0.00 |
|
$0.00 |
Computer mger |
$58.00 |
|
$0.00 |
40 |
$2,320.00 |
|
$0.00 |
|
$0.00 |
5 |
$290.00 |
40 |
$2,320.00 |
|
$0.00 |
10 |
$580.00 |
Financial mger |
$54.68 |
|
$0.00 |
10 |
$546.80 |
|
$0.00 |
|
$0.00 |
|
$0.00 |
10 |
$546.80 |
|
$0.00 |
|
$0.00 |
Technical writer |
$31.55 |
|
$0.00 |
250 |
$7,887.50 |
150 |
$4,732.50 |
|
$0.00 |
|
$0.00 |
200 |
$6,310.00 |
|
$0.00 |
|
$0.00 |
Actuary |
$46.85 |
|
$0.00 |
80 |
$3,748.00 |
50 |
$2,342.50 |
|
$0.00 |
|
$0.00 |
50 |
$2,342.50 |
|
$0.00 |
10 |
$468.50 |
Accountant |
$32.42 |
|
$0.00 |
40 |
$1,296.80 |
10 |
$324.20 |
|
$0.00 |
|
$0.00 |
20 |
$648.40 |
|
$0.00 |
|
$0.00 |
Lawyer |
$62.03 |
2 |
$124.06 |
40 |
$2,481.20 |
10 |
$620.30 |
2 |
$124.06 |
5 |
$310.15 |
100 |
$6,203.00 |
30 |
$1,860.90 |
|
$0.00 |
Economist |
$46.31 |
|
$0.00 |
200 |
$9,262.00 |
150 |
$6,946.50 |
|
$0.00 |
10 |
$463.10 |
160 |
$7,409.60 |
|
$0.00 |
45 |
$2,083.95 |
Computer programmer |
$35.91 |
|
$0.00 |
200 |
$7,182.00 |
200 |
$7,182.00 |
|
$0.00 |
|
$0.00 |
100 |
$3,591.00 |
|
$0.00 |
50 |
$1,795.50 |
Underwriter |
$30.45 |
2 |
$60.90 |
150 |
$4,567.50 |
150 |
$4,567.50 |
|
$0.00 |
|
$0.00 |
100 |
$3,045.00 |
|
$0.00 |
30 |
$913.50 |
Paralegal |
$24.08 |
|
$0.00 |
40 |
$963.20 |
|
$0.00 |
5 |
$120.40 |
|
$0.00 |
50 |
$1,204.00 |
5 |
$120.40 |
|
$0.00 |
Market research |
$32.45 |
|
$0.00 |
100 |
$3,245.00 |
|
$0.00 |
|
$0.00 |
|
$0.00 |
|
$0.00 |
|
$0.00 |
|
$0.00 |
Statistician |
$36.16 |
|
$0.00 |
200 |
$7,232.00 |
200 |
$7,232.00 |
|
$0.00 |
|
$0.00 |
150 |
$5,424.00 |
|
$0.00 |
45 |
$1,627.20 |
Office |
$15.86 |
|
$0.00 |
110 |
$1,744.60 |
80 |
$1,268.80 |
3 |
$47.58 |
15 |
$237.90 |
20 |
$317.20 |
5 |
$79.30 |
10 |
$158.60 |
Totals |
|
6 |
$300.42 |
1500 |
$54,785.80 |
1000 |
$35,216.30 |
10 |
$292.04 |
40 |
$1,589.80 |
1000 |
$39,361.50 |
40 |
$2,060.60 |
200 |
$7,627.25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Federal occupations |
rate @ step 4 |
first time # emp |
hours |
Total Hrs |
cost |
modification # emp |
hours |
Total Hrs |
cost |
procedure # emp |
hours |
Total Hrs |
cost |
|
|
|
|
Directors |
$60.15 |
3 |
25 |
75 |
$4,511.14 |
3 |
25 |
75 |
$4,511.14 |
3 |
25 |
75 |
$4,511.14 |
|
|
|
|
Economist |
$43.27 |
2 |
40 |
80 |
$3,461.73 |
2 |
40 |
80 |
$3,461.73 |
2 |
40 |
80 |
$3,461.73 |
|
|
|
|
Insurance specialist |
$43.27 |
8 |
40 |
320 |
$13,846.92 |
8 |
40 |
320 |
$13,846.92 |
8 |
40 |
320 |
$13,846.92 |
|
|
|
|
Branch chief |
$51.13 |
1 |
20 |
20 |
$1,022.67 |
1 |
20 |
20 |
$1,022.67 |
1 |
20 |
20 |
$1,022.67 |
|
|
|
|
Underwriter |
$60.15 |
1 |
25 |
25 |
$1,503.71 |
1 |
25 |
25 |
$1,503.71 |
1 |
25 |
25 |
$1,503.71 |
|
|
|
|
Actuary |
$68.31 |
1 |
25 |
25 |
$1,707.79 |
1 |
25 |
25 |
$1,707.79 |
1 |
25 |
25 |
$1,707.79 |
|
|
|
|
Lawyer |
$51.13 |
1 |
40 |
40 |
$2,045.35 |
1 |
40 |
40 |
$2,045.35 |
1 |
40 |
40 |
$2,045.35 |
|
|
|
|
Computer programmer |
$36.39 |
2 |
80 |
160 |
$5,822.23 |
2 |
80 |
160 |
$5,822.23 |
2 |
80 |
160 |
$5,822.23 |
|
|
|
|
Totals |
|
19 |
|
745 |
$33,921.55 |
19 |
|
745 |
$33,921.55 |
19 |
|
745 |
$33,921.55 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
External Reviewers |
$150,000/review |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total hrs/yr |
hrs x 22 products |
Total $/product |
$ x 22 products |
|
|
|
|
|
|
|
|
|
|
|
|
|
Private occupations |
3796 |
83512 |
$141,233.71 |
$3,107,141.62 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Federal occupations |
2235 |
49170 |
$101,764.64 |
$2,238,822.17 |
|
|
|
|
|
|
|
|
|
|
|
|
|
External Reviewers |
|
|
$150,000.00 |
$3,300,000.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
|
|
|
$8,645,963.79 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Sheet 4: CP
Costs for Concept Proposal |
|
|
|
|
|
|
|
|
|
|
|
Total Concept Proposals/Paperwork Package = |
|
|
36 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Costs |
One Product |
36 Products |
|
|
|
Total Private |
$1,364.82 |
$49,133.52 |
|
|
|
Total RMA |
$43.27 |
$1,557.78 |
|
|
|
Total External Review |
$16,000.00 |
$576,000.00 |
|
|
|
Total for 3 years |
|
$626,691.30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Private occupations |
mean hr wage |
read hours |
wage*hrs |
prep hours |
wage*hrs |
Actuary |
$46.85 |
2 |
$93.70 |
2 |
$93.70 |
economist |
$46.31 |
2 |
$92.62 |
20 |
$926.20 |
office |
$15.86 |
|
$0.00 |
10 |
$158.60 |
Totals |
|
4 |
$186.32 |
32 |
$1,178.50 |
|
|
|
|
|
|
|
|
|
|
|
|
Federal occupations |
rate @ step 4 |
Review for completeness - # emp |
hours |
Total Hrs |
cost |
economist |
$43.27 |
1 |
1 |
1 |
$43.27 |
Totals |
|
1 |
|
1 |
$43.27 |
|
|
|
|
|
|
|
|
|
|
|
|
External Reviewers |
$16,000/review |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total hrs/yr |
hrs x 36 products |
Total $/product |
$ x 36 products |
|
Private occupations |
36 |
1296 |
$1,364.82 |
$49,133.52 |
|
Federal occupations |
1 |
36 |
$43.27 |
$1,557.78 |
|
External Reviewers |
|
|
$16,000.00 |
$576,000.00 |
|
Total |
|
|
|
$626,691.30 |
|
File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
File Modified | 0000-00-00 |
File Created | 0000-00-00 |