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

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 Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy