05 Atch5_Historical Data.pdf

HISTORICAL DATA

OF

PRESENT CONTRACT

Attachment 5 to RFP No. FA520523R0002

Summary of Construction Project, Contract No. FA520518D0004

As of 18 Oct 22 Total Project

Contract Year Contract Period Nr. Amount

Basic Period 19 Jun 18 - 19 Oct 19 29 461,272,607

Option Year I 19 Oct 19 - 18 Oct 20 13 400,877,265

Option Year II 19 Oct 20 - 18 Oct 21 21 552,021,398

Option Year III 19 Oct 21 - 18 Oct 22 37 1,372,427,956

Aggregate Amount 100 2,786,599,226

Average per Year 23 643,061,360

Individual Task Order

Highest ¥216,551,139

Lowest ¥229,500

Average ¥27,865,992

List of Task Orders issued in Basic Period

TO – Task Order

Step – Task Order Procedures, 1-Step Construction, or 2-Step Survey/Construction, ref. RFP, Atch. 1, Other

Contract Requirements, para. 6.H004

Awd Date – Award Date

P.P. – Performance Period

TO# Project Description Work Site Step Award Date TO Amount (¥) P.P.

FA520518F0044 Survey/Repair Roof and Widen Roll-up Door, B1743 Industrial Fac 2-Survey 06/19/18 ¥229,500 14

FA520518F0068 Repair Roof and Widen Roll-up Door, B1743 Industrial Fac 2-Const 07/17/18 ¥28,934,801 120

FA520518F0071 Survey/Maintain Exterior Main Base MFH 100s Area MFH 2-Survey 07/20/18 ¥306,000 48

FA520518F0072 Survey /Repair Roof, B1341 Industrial Fac 2-Survey 07/20/18 ¥306,000 48

FA520518F0073 Survey/Repair SOQs (B2104 and B2110) MFH 2-Survey 07/20/18 ¥918,000 49

FA520518F0074 Survey/Pressure Reducing Valves, MFH North Area MFH 2-Survey 07/25/18 ¥459,000 35

FA520518F0075 Repair Conduit for Fiber Lines, B1940 to B3003 Industrial Fac 1 07/28/18 ¥39,084,853 180

FA520518F0083 Pressure Reducing Valves, MFH North Area MFH 2-Const 08/27/18 ¥9,157,786 135

FA520518F0085 Construct Pad for Boulder Misc. 1 09/05/18 ¥1,274,058 110

FA520518F0087 Repair Hangar Entrance Canopy, B970 Industrial Fac 1 09/07/18 ¥8,583,691 135

FA520518F0089 Repair Roof, B1341 Industrial Fac 2-Const 09/07/18 ¥2,267,803 110

FA520518F0095 Add Drainage, SMDC JTAGS Area Industrial Fac 1 09/12/18 ¥6,496,678 232

FA520518F0102 Repair SOQs (B2104 and B2110) MFH 2-Const 09/24/18 ¥109,014,085 511

FA520518F0120 Repair Gate Heater Control System, 87211 HAS/Airfield 1 09/25/18 ¥25,285,251 420

FA520518F0122 Maintain Exterior Main Base MFH 100s Area MFH 2-Const 09/25/18 ¥15,836,536 180

FA520519FA011 Survey/Add Combined Array, MSOC MSOC 2-Survey 03/04/19 ¥1,306,090 51

FA520519FA013 Survey/Renovate Room 1137, B485, Misawa Club Misc. 2-Survey 03/15/19 ¥612,000 56

FA520519FA014 Survey/Repair ITT, NCO B485 Rm 1131 Misc. 2-Survey 03/15/19 ¥306,000 56

FA520519FA026 Survey/Repair Roof, B928 Misc. 2-Survey 05/14/19 ¥459,000 45

FA520519FA029 Repair ITT, NCO B485 Rm 1131 Misc. 2-Const 06/10/19 ¥8,439,688 150

FA520519FA033 Add Combined Array, MSOC MSOC 2-Const 06/10/19 ¥76,313,209 210

FA520519FA043 Survey/Repair CATM Berm, Draughon Range Draugh-Range 2-Survey 06/25/19 ¥612,000 56

FA520519FA062 Survey/Construct RTB Containment At FAC 1150 Industrial Fac 2-Survey 08/08/19 ¥306,000 50

FA520519FA063 Survey/Repair Radio Over Intrnet Protocol (ROIP) MFH 2-Survey 08/09/19 ¥927,003 49

FA520519FA064 Repair Conduit for Fiber Optic, B918 to B3001 Misc. 1 08/27/19 ¥19,556,649 360

FA520519FA066 Repair Conduit for Fiber Optic, B12 to B653 Misc. 1 08/27/19 ¥5,309,498 120

FA520519FA067 Repair ITT, NCO B485 Rm 1131 Misc. 2-Const 09/13/19 ¥482,431 150

FA520519FA085 Repair Radio Over Internet Protocol (ROIP) MFH 2-Const 09/25/19 ¥25,273,232 358

FA520519FA086 Repair CATM Berm, Draughon Range Draugh-Range 2-Const 09/30/19 ¥73,215,765 360

List of Task Orders issued in Option Year One

TO# Project Description Work Site Step Award Date TO Amount (¥) P.P.

FA520520F0009 Repair Roof, B928 Misc. 2-Const 10/25/19 ¥23,450,212 258

FA520520F0025 Survey/Convert Storage Room to Office Space, B793 Misc. 2-Survey 02/21/20 ¥972,776 76

FA520520F0028 Survey/Repair Munition Drop Area, Rokkasho Vil Misc. 2-Survey 03/11/20 ¥2,777,052 93

FA520520F0049 Survey/Repair Iron Hand Community Fitness, B1006 (Bay3)Misc. 2-Survey 05/19/20 ¥819,776 64

FA520520F0081 Repair Iron Hand Community Fitness, B1006 (Bay3) Misc. 2-Const 07/28/20 ¥20,082,526 150

FA520520F0085 Construct RTB Containment At FAC 1150 Industrial Fac 2-Const 08/06/20 ¥10,571,765 300

FA520520F0086

FA520520F0087

Renovate Room 1137, B485, Misawa Club Misc. 2-Const 08/10/20 ¥10,248,580 150

FA520520F0089 Add Antenna Pad, MSOC MSOC 1 08/10/20 ¥1,925,855 75

FA520520F0090 Repair Lightning Protection System, B1501 MSOC 1 08/10/20 ¥4,529,311 90

FA520520F0092 Repair Steam System, B973 Weasel's Den Industrial Fac 1 08/31/20 ¥216,551,139 850

FA520520F0093 Repair Product Saver Tank Piping Industrial Fac 1 08/26/20 ¥1,163,602 120

FA520520F0094 Repair Chilled Water System, Chiller #1&#4, B1525 MSOC 1 09/01/20 ¥105,626,334 225

FA520520F0096 Repair Domestic Hot Water Tank B539 Industrial Fac 1 08/31/20 ¥2,158,337 90

List of Task Orders issued in Option Year Two

FA520521F0040

FA520521F0042

Survey/Repair Mokuteki Café, B626 Misc. 2-Survey 03/02/21 ¥963,774 57

FA520521F0046 Survey/Repair Interior/Exterior JROTC, B740 Rooms 29 & 30 Misc. 2-Survey 03/08/21 1514321 64

FA520521F0047 Repair Interior/Exterior JROTC, B740 Rooms 29 & 30 Misc. 2-Const 06/04/21 ¥50,458,808 225

FA520521F0052

FA520521F0077

Repair Mokuteki Café, B626 Misc. 2-Const 03/08/21 ¥19,711,794 150

FA520521F0074 Survey/Repair A/C, Drom B672 Misc. 2-Survey 04/02/21 ¥1,055,321 67

FA520521F0075 Survey/Repair A/C, Drom B673 Misc. 2-Survey 04/02/21 ¥1,208,321 67

FA520521F0080 Add Led Light, Soccer Field 74999 Misc. 1 05/06/21 ¥29,226,202 135

FA520521F0082 Survey/Repair Mechanical System, HAS B3141 HAS/Airfield 2-Survey 04/30/21 ¥850,503 63

FA520521F0083 Survey/Repair Mechanical System, HAS B3295 HAS/Airfield 2-Survey 04/30/21 ¥850,503 63

FA520521F0085 Survey/Repair Exterior Lighting, B1501, B1522, B1523 MSOC 2-Survey 05/13/21 ¥459,000 43

FA520521F0086 Survey/Repair Exterior Lighting, MSOC RADOMES MSOC 2-Survey 05/13/21 ¥561,000 47

FA520521F0089 Repair A/C, Drom B673 Misc. 2-Const 05/25/21 ¥58,647,448 360

FA520521F0090 Repair A/C, Drom B672 Misc. 2-Const 05/25/21 ¥51,240,603 360

FA520521F0092 Repair Thaw System, HAS B3220 HAS/Airfield 1 06/10/21 ¥26,434,870 326

FA520521F0099 Repair Exterior Lighting, B1501, B1522, B1523 MSOC 2-Const 06/23/21 ¥42,512,000 360

FA520521F0100 Repair Mechanical System, HAS B3295 HAS/Airfield 2-Const 06/24/21 ¥80,109,155 450

FA520521F0101 Repair Mechanical System, HAS B3141 HAS/Airfield 2-Const 06/24/21 ¥133,074,238 540

FA520521F0111 Repair Electrical Panel, B626 Mokuteki Misc. 1 08/06/21 ¥7,483,687 110

FA520521F0112 Survey/Repair ODR, B486 Misc. 2-Survey 08/06/21 ¥1,514,321 46

FA520521F0113 Survey/Repair Conduit for Fiber Optic, B600 Area Misc. 2-Survey 08/06/21 ¥703,547 46

FA520521F0130 Repair ODR, B486 Misc. 2-Const 09/14/21 ¥43,441,982 240

List of Task Orders issued in Option Year Three

FA520522F0015 Repair Exterior Lighting, B1523 MSOC 1 12/07/21 ¥2,611,752 210

FA520522F0032 Survey/Repair Mechanical System, HAS B3049 HAS/Airfield 2-Survey 03/02/22 ¥635,358 26

FA520522F0049 Repair Mechanical System, HAS B3048 HAS/Airfield 1 03/21/22 ¥85,410,218 510

FA520522F0050 Survey/Repair Electric Power Receiving Station, B229 Misc. 2-Survey 03/15/22 ¥2,130,290 44

FA520522F0053 Repair Mechanical System, HAS B3049 HAS/Airfield 2-Const 03/28/22 ¥105,888,359 630

FA520522F0056 Survey/Repair AHU in Paint Booth, B3130 HAS/Airfield 2-Survey 03/31/22 ¥1,324,550 70

FA520522F0059 Repair Conduit for Fiber Optic, B600 Area Misc. 2-Const 04/21/22 ¥13,222,400 170

FA520522F0063 Add Asphalt Road, MSOC MSOC 1 05/10/22 ¥15,327,915 150

FA520522F0065 Survey/Repair HVAC, B660 Misc. 2-Survey 05/19/22 ¥657,774 36

FA520522F0066 Survey/Repair HVAC, B661 Misc. 2-Survey 05/19/22 ¥657,774 36

FA520522F0067 Survey/Repair HVAC, B665 Misc. 2-Survey 05/19/22 ¥657,774 36

FA520522F0068 Survey/Repair HVAC, B667 Misc. 2-Survey 05/19/22 ¥657,774 36

FA520522F0069 Survey/Repair HVAC, B668 Misc. 2-Survey 05/19/22 ¥657,774 36

FA520522F0070 Survey/Repair Smokehouse B485 Misc. 2-Survey 05/26/22 ¥703,547 49

FA520522F0071 Repair Electrical Panel, B1517 MSOC ECP Misc. 1 05/27/22 ¥6,404,875 120

FA520522F0073 Repair Electric Power Receiving Station, B229 Misc. 2-Const 06/02/22 ¥34,744,711 180

FA520522F0075 Repair AHU in Paint Booth, B3130 HAS/Airfield 2-Const 06/13/22 ¥128,515,901 360

FA520522F0076 Repair HVAC, B660 Misc. 2-Const 06/16/22 ¥74,093,269 360

FA520522F0077 Repair HVAC, B661 Misc. 2-Const 06/16/22 ¥73,322,530 360

FA520522F0078 Repair HVAC, B665 Misc. 2-Const 06/16/22 ¥83,657,027 360

FA520522F0080 Repair HVAC, B667 Misc. 2-Const 06/16/22 74530959 360

FA520522F0081 Repair HVAC, B668 Misc. 2-Const 06/16/22 ¥60,564,127 360

FA520522F0083 Repair Exterior Lighting, MSOC RADOMES MSOC 2-Const 06/21/22 ¥81,850,424 420

FA520522F0090 Repair Floors, B740 Misc. 1 07/06/22 ¥5,080,620 60

FA520522F0092

FA520522F0093

Repair Smokehouse B485 Misc. 2-Const 07/08/22 ¥9,762,929 115

FA520522F0082 Repair Interior and Lighting, B486 Misc. 1 06/16/22 ¥9,510,026 100

FA520522F0098 Survey/Repair Fire Suppression, B1404 HAS/Airfield 2-Survey 07/27/22 ¥1,162,547 47

FA520522F0099 Survey/Repair HAS Door, B3140 HAS/Airfield 2-Survey 07/28/22 ¥774,003 60

FA520522F0100 Survey/Repair Arts & Crafts, B486 Misc. 2-Survey 07/28/22 ¥933,047 47

FA520522F0107 Survey/Repair Dining Facility, B624 Misc. 2-Survey 08/19/22 ¥1,361,321 42

FA520522F0108 Survey/Repair Helping Agencies, B220 Misc. 2-Survey 08/19/22 ¥1,055,321 42

FA520522F0117 Repair HAS Door, B3140 HAS/Airfield 2-Const 09/30/22 ¥135,792,596

FA520522F0118 Repair Fire Suppression, B1404 HAS/Airfield 2-Const 09/07/22 ¥64,923,017 330

FA520522F0123 Repair Arts & Crafts, B486 Misc. 2-Const 09/13/22 ¥27,007,764 260

FA520522F0127 Repair Dining Facility, B624 Misc. 2-Const 09/26/22 ¥161,290,012 315

FA520522F0128 NAVY VOIP Misc. 1 09/20/22 ¥2,294,931 80

FA520522F0129 Repair Helping Agencies, B220 Misc. 2-Const 09/20/22 ¥103,252,740 240

Summary of Total Direct Cost per Range

Aggregate (Past Nine-Year and 4-Month)

Total Direct Cost Range Nr. Total (¥) Share on Nr Share on

Amount

¥10,000,000 and below 157 415,859,565 55% 6%

¥10,000,001 - ¥50,000,000 85 2,105,011,916 30% 33%

¥50,000,001 - ¥100,000,000 32 2,226,746,211 11% 35%

¥100,000,001 and above 12 1,701,495,606 4% 26%

Aggregate Amount 286 6,449,113,298 100% 100%

Average per Year Typical Total Direct Cost Range

(Basic 1-Yr + 4 Opt Yr + 6 Mo = 5.5-Yr)

(Typical TDC Formula: UPB Cost Ave/yr

Total x 5.5) Total Direct Cost Range Nr. Total (¥)

¥10,000,000 and below 16.8 44,556,382 245,060,101

¥10,000,001 - ¥50,000,000 9.1 225,536,991 1,240,453,450

¥50,000,001 - ¥100,000,000 3.4 238,579,951 1,312,189,731

¥100,000,001 and above 1.3 182,303,101 1,002,667,054

Aggregate Amount 30.6 690,976,425 3,800,370,336