5_Reporting Templates.xlsx

XLSX spreadsheet 54 KB Posted Apr 16, 2021

Attached to: Vertical Replenishment (VERTREP) Detachment Pacific Detachment A Federal contract opportunity
Solicitation number: N32205-21-R-4134
Issued by: Department of the Navy Military Sealift Command

About this file

Written by GovTribe AI · Dec 27, 2023

This document package contains daily operational reports, personnel reports, sortie summaries, maintenance summaries, pilot status reports, and metrics reports for a Vertical Replenishment Detachment supporting Pacific operations. It also includes a related federal contract opportunity solicitation.

The reports provide status updates on two helicopters and crews, including aircraft availability, flight hours, personnel rotations, maintenance timelines, and safety and sortie metrics. The solicitation seeks a contractor to provide a two-helicopter detachment with pilots, maintainers and support equipment to deploy aboard MSC ships for logistics and vertical replenishment services to Navy and partner ships worldwide for 365 days per year. The required services include ship-based commercial helicopter operations and all applicable regulatory compliance.

View the file

Other files for this federal contract opportunity

Other files attached to Vertical Replenishment (VERTREP) Detachment Pacific Detachment A, newest first.
File	Type	Posted
11_DD Form 1423 - CDRL_Daily.pdf	PDF	May 11, 2021
14_DD Form 1423 - CDRL_Qualifications.pdf	PDF	May 11, 2021
15_DD Form 1423 - CDRL_Semi.pdf	PDF	May 11, 2021
17_DD Form 1423 - CDRL_Third Party Insp.pdf	PDF	May 11, 2021
08_QUESTIONS AND ANSWERS -N32205-21-R-4134.pdf	PDF	May 11, 2021
12_DD Form 1423 - CDRL_Monthly.pdf	PDF	May 11, 2021
13_DD Form 1423 - CDRL_Personnel.pdf	PDF	May 11, 2021
16_DD Form 1423 - CDRL_SOP.pdf	PDF	May 11, 2021
07_QUESTIONS AND ANSWERS -N32205-21-R-4134_v2.pdf	PDF	May 10, 2021
10_DD FORM 254_2018_ver for N32205-21-C-2297.pdf	PDF	May 7, 2021
06_QUESTIONS AND ANSWERS -N32205-21-R-4134.pdf	PDF	May 6, 2021
AMENDMENT 0001 N32205-21-R-4134.pdf	PDF	May 5, 2021
05_QUESTIONS AND ANSWERS -N32205-21-R-4134.pdf	PDF	May 4, 2021
19_PAC_Det_A_Pricing Spreadsheet_v2.xlsx	XLSX spreadsheet	May 4, 2021
04_QUESTIONS AND ANSWERS -N32205-21-R-4134.pdf	PDF	May 3, 2021
03_QUESTIONS AND ANSWERS -N32205-21-R-4134.pdf	PDF	Apr 29, 2021
02_QUESTIONS AND ANSWERS -N32205-21-R-4134.pdf	PDF	Apr 27, 2021
02_QUESTIONS AND ANSWERS -N32205-21-R-4134_01.pdf	PDF	Apr 27, 2021
7_PERFORMANCE QUESTIONNAIRE (V1.1, 7-23-13).pdf	PDF	Apr 27, 2021
10_DD FORM 254 for N32205-21-C-2297.pdf	PDF	Apr 27, 2021
01_QUESTIONS AND ANSWERS -N32205-21-R-4134_01.pdf	PDF	Apr 20, 2021
10_PAST PERFORMANCE QUESTIONNAIRE_Redacted.pdf	PDF	Apr 16, 2021
15_DD Form 1423 - CDRL_Semi.pdf	PDF	Apr 16, 2021
13_DD Form 1423 - CDRL_Personnel.pdf	PDF	Apr 16, 2021
6_Detachment Performance Plan_Det A.pdf	PDF	Apr 16, 2021
14_DD Form 1423 - CDRL_Qualifications.pdf	PDF	Apr 16, 2021
17_DD Form 1423 - CDRL_Third Party Insp.pdf	PDF	Apr 16, 2021
18_Reporting Templates.pdf	PDF	Apr 16, 2021
3_T-AKE Hangar specifications.pdf	PDF	Apr 16, 2021
4_Primary-Logistics_Ports.pdf	PDF	Apr 16, 2021
8_GFP_Attachment_PAC Det A.xlsx	XLSX spreadsheet	Apr 16, 2021
N32205-21-R-4134_SOLICITATION_DET_A_Redacted.pdf	PDF	Apr 16, 2021
1_QUALITY ASSURANCE SURVEILLANCE PLAN.pdf	PDF	Apr 16, 2021
2_QASP MATRIX PAC Det A Enclosure (2).pdf	PDF	Apr 16, 2021
7_DD FORM 254 for N32205-21-C-2297.pdf	PDF	Apr 16, 2021
9_PAST PERFORMANCE DATA SHEET.pdf	PDF	Apr 16, 2021
11_DD Form 1423 - CDRL_Daily.pdf	PDF	Apr 16, 2021
12_DD Form 1423 - CDRL_Monthly.pdf	PDF	Apr 16, 2021
16_DD Form 1423 - CDRL_SOP.pdf	PDF	Apr 16, 2021
19_Pricing Spreadsheet.xlsx	XLSX spreadsheet	Apr 16, 2021

Show all 40

On GovTribe

Work with this file on GovTribe

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

5.a Daily Ops Rpt

(Comp Name)	Prepared by	Detachment Daily Operational Report	Date
DET C	Porkey Pig		3-Oct-19

Aircraft Summary
Status Codes	FMC	Fully Mission Capable	Upcoming Maintenance Milestones	Tail Number	Next Scheduled Maint	Date	Next Scheduled P-2 Inspection	Date
	PMC	Partial Mission Capable		xxxxx	12.3 hrs to next 100 hr	NA	123.4 hrs	1/23/20
	NMC	Non Mission Capable		zzzzz	45.6 hrs to next 100 hr	NA	432.1 hrs	3/21/21

Date	FOB	Tail Number	Status	Flight Hours	Comments	Date	FOB	Tail Number	Status	Flight Hours	Comments
1-Oct-19	AKE-4	xxxxx	FMC	1.0		1-Oct-19	AKE-4	zzzzz	FMC	1.0
2-Oct-19	AKE-4	xxxxx	PMC	0.2		2-Oct-19	AKE-4	zzzzz	FMC	0.0
3-Oct-19	AKE-4	xxxxx	NMC	0.0		3-Oct-19	AKE-4	zzzzz	FMC	1.2
4-Oct-19	AKE-4	xxxxx				4-Oct-19	AKE-4	zzzzz
5-Oct-19	AKE-4	xxxxx				5-Oct-19	AKE-4	zzzzz
6-Oct-19	AKE-4	xxxxx				6-Oct-19	AKE-4	zzzzz
7-Oct-19	AKE-4	xxxxx				7-Oct-19	AKE-4	zzzzz
8-Oct-19	AKE-4	xxxxx				8-Oct-19	AKE-4	zzzzz
9-Oct-19	AKE-4	xxxxx				9-Oct-19	AKE-4	zzzzz
10-Oct-19	AKE-4	xxxxx				10-Oct-19	AKE-4	zzzzz
11-Oct-19	AKE-4	xxxxx				11-Oct-19	AKE-4	zzzzz
12-Oct-19	AKE-4	xxxxx				12-Oct-19	AKE-4	zzzzz
13-Oct-19	AKE-4	xxxxx				13-Oct-19	AKE-4	zzzzz
14-Oct-19	AKE-4	xxxxx				14-Oct-19	AKE-4	zzzzz
15-Oct-19	AKE-4	xxxxx				15-Oct-19	AKE-4	zzzzz
16-Oct-19	AKE-4	xxxxx				16-Oct-19	AKE-4	zzzzz
17-Oct-19	AKE-4	xxxxx				17-Oct-19	AKE-4	zzzzz
18-Oct-19	AKE-4	xxxxx				18-Oct-19	AKE-4	zzzzz
19-Oct-19	AKE-4	xxxxx				19-Oct-19	AKE-4	zzzzz
20-Oct-19	AKE-4	xxxxx				20-Oct-19	AKE-4	zzzzz
21-Oct-19	AKE-4	xxxxx				21-Oct-19	AKE-4	zzzzz
22-Oct-19	AKE-4	xxxxx				22-Oct-19	AKE-4	zzzzz
23-Oct-19	AKE-4	xxxxx				23-Oct-19	AKE-4	zzzzz
24-Oct-19	AKE-4	xxxxx				24-Oct-19	AKE-4	zzzzz
25-Oct-19	AKE-4	xxxxx				25-Oct-19	AKE-4	zzzzz
26-Oct-19	AKE-4	xxxxx				26-Oct-19	AKE-4	zzzzz
27-Oct-19	AKE-4	xxxxx				27-Oct-19	AKE-4	zzzzz
28-Oct-19	AKE-4	xxxxx				28-Oct-19	AKE-4	zzzzz
29-Oct-19	AKE-4	xxxxx				29-Oct-19	AKE-4	zzzzz
30-Oct-19	AKE-4	xxxxx				30-Oct-19	AKE-4	zzzzz
31-Oct-19	AKE-4	xxxxx				31-Oct-19	AKE-4	zzzzz
OIC Comments

Personnel Summary
Air Crew/Operations Billets				Maintenance/Logistics Billets				Quals
Position	IN AO	REQ	∆	Position	IN AO	REQ	∆	Description	IN AO	REQ	∆
PIC	3	3		Mx Foreman	1	1	0
SIC	2	2		Line Mx	2	2	0
				Avionics Mx
				Mx Trainer

Totals:	5	5	0	Totals:	3	3	0	CVP (CONUS Visiting Personnel)	0
Total Number Personnel On Station:							8

INSTRUCTIONS
The SITREP report shall be completed each day by the Site Manager/OIC or designee and forwarded to PM. PM will forward to MSC daily.
The Date prepared will be the actual day of operation and will be entered in the cell under "Date Prepared" regardless of the aircraft's flying status.
	AIRCRAFT SECTION
One of the most important purposes of the daily SITREP is to report the availability of aircraft to the customer by using the appropriate FMC, PMC or NMC Codes.
The accuracy of this reporting determines the billable events for each aircraft.
An aircraft not available for the scheduling and execution of missions for the assigned day will be reported as NMC.
If an aircraft is PMC, indicate types of missions the affected aircraft is unable to perform in the comments section next to the aircraft status.
	MISSION CODES
V=VERTREP, P=Passenger Transfer, M=Mail Transfer, C=Internal Cargo, L=Logistics (Flights to other vessels or shore facilities for support purposes)
S=Search and Rescue Flights, T=Training, F=Functional Check Flight/ Maintenance Check, O=Other (provide comments)
	PERSONNEL SECTION
Report in the PERSONNEL SECTION of the SITREP an accurate account for each position/billet represented at the site. This is accomplished by entering total on site personnel in the "On-Site" column and the total required in the "Required" column. Informa

NOTE: Due to the wide distribution of this report, accuracy is paramount!

5.b Daily Personnel Rpt

(Comp. Name)	Prepared By	Detachment Daily Personnel Report	Date
DET C	Porkey Pig		3-Oct-19

Authorized Personnel			Items required to be completed						PM's Discretion		Comments
Billet	Name	Qual/ position	Location	Start Rotation	End Rotation	TDY To	TDY From	In/Out	VISA Expiration	Single or Multi Entry Visa
PIC	Bunny, Bugs	OIC	AKE-4	10/1/19	2/2/20			IN
PIC	Duck, Daffy	OIC	AKE-4	10/1/19	2/2/20			IN
PIC	Leghorn, Foghorn	Operations	AKE-4	2/2/20	5/6/20			OUT
SIC	Pig, Porkey	Admin O	AKE-4	10/1/19	2/2/20			IN
SIC	Fudd, Elmer	Training	AKE-4	2/2/20	5/6/20			OUT
PIC	Coyote, Wiley	Operations	AKE-4	10/1/19	2/2/20			IN
SIC	Bird, Tweety	Admin O	AKE-4	2/2/20	5/6/20			OUT
SIC	Runner, Road	Training	AKE-4	10/1/19	2/2/20			IN

Mx Foreman	Mouse, Mickey	Lead ENG	AKE-4	10/1/19	2/2/20	IN
Mx Foreman	Duck, Donald	Lead ENG	AKE-4	2/2/20	5/6/20	OUT
Line Mx	Dog, Goofey	ENG	AKE-4	2/2/20	5/6/20	OUT
Line Mx	Cat, Pete	ENG	AKE-4	10/1/19	2/2/20	IN
Line Mx	Duck, Daisy	ENG	AKE-4	10/1/19	2/2/20	IN

Billet	Number required in AO	Number in AO	TDY Out	TDY In
PIC	3	3	0	1
SIC	2	2	1	0
Mx Foreman	1	1	1	0
Line Mx	2	2	0	1

The PERSTAT Report is a work tool which provides a3n accurate daily report of the personnel in the AO Date Prepared Enter the date of the PERSTAT in the cell below "Date Prepared."

Prepared By Enter the Last Name of the person preparing the PERSTAT in the cell below "Prepared By."

NAME

Enter Last Name, First of each employee for the respective program.

BILLET

Enter the applicable position for the employee.

Location Enter the applicable base location (city or vessel).

Start Rotation Enter the first date of travel the person arrives in the AO.

End Rotation Enter the first date of travel from AO to the HOR.

TDY To/From Enter TDY location (city or vessel) In AO Enter appropriate response from the choices below:

IN	is used the day after the personnel arrives, and continues to be used until the employee departs.
OUT	is used the day after the personnel departs the AO, and continues to be used untill personnel arrives back in AO.
ARRIVED	is used the actual day the personnel arrives in the AO.
DEPARTED	is used the actual day the personnel departs the AO.
TDY	is used the individual is on temporary duty assignment .

VISA Expiration / Single or Multi Entry Visa Provide the applicable information in appropriate cells. The requirement to complete this information is at the discretion of the Respective Program Manager

5.c Daily & Monthly Sortie Summ

(Comp. Name)	Prepared by	Detachment Monthly Sortie Summary	Date
DET C	Porkey Pig		3-Oct-19

Date

Aircraft Type

Tail number

PIC

SIC

From/To

Mission Hours

Training Hours

FCF Hours

Shipboard Fuel (gal)

Other Fuel (gal)

External Loads

Pallets

Cargo (lbs)

Mail (lbs)

PAX Carried

1-Oct-19

Helo

xxxxx

Bunny

Pig

ship

1.0

0.0

- 0

20,000

- 0

2-Oct-19

Helo

xxxxx

Bunny

Bird

AKE-4

0.0

0.2

- 0

3-Oct-19

Helo

xxxxx

0.0

- 0

4-Oct-19

Helo

xxxxx

5-Oct-19

Helo

xxxxx

6-Oct-19

Helo

xxxxx

7-Oct-19

Helo

xxxxx

8-Oct-19

Helo

xxxxx

9-Oct-19

Helo

xxxxx

10-Oct-19

Helo

xxxxx

11-Oct-19

Helo

xxxxx

12-Oct-19

Helo

xxxxx

13-Oct-19

Helo

xxxxx

14-Oct-19

Helo

xxxxx

15-Oct-19

Helo

xxxxx

16-Oct-19

Helo

xxxxx

17-Oct-19

Helo

xxxxx

18-Oct-19

Helo

xxxxx

19-Oct-19

Helo

xxxxx

20-Oct-19

Helo

xxxxx

21-Oct-19

Helo

xxxxx

22-Oct-19

Helo

xxxxx

23-Oct-19

Helo

xxxxx

24-Oct-19

Helo

xxxxx

25-Oct-19

Helo

xxxxx

26-Oct-19

Helo

xxxxx

27-Oct-19

Helo

xxxxx

28-Oct-19

Helo

xxxxx

29-Oct-19

Helo

xxxxx

30-Oct-19

Helo

xxxxx

31-Oct-19

Helo

xxxxx

1-Oct-19

Helo

zzzzz

Duck

Coyote

Ship

1.0

0.0

- 0

22,000

- 0

2-Oct-19

Helo

zzzzz

0.0

- 0

3-Oct-19

Helo

zzzzz

Coyote

Runner / Pig

AKE-4

0.0

1.2

0.0

- 0

6,000

- 0

4-Oct-19

Helo

zzzzz

5-Oct-19

Helo

zzzzz

6-Oct-19

Helo

zzzzz

7-Oct-19

Helo

zzzzz

8-Oct-19

Helo

zzzzz

9-Oct-19

Helo

zzzzz

10-Oct-19

Helo

zzzzz

11-Oct-19

Helo

zzzzz

12-Oct-19

Helo

zzzzz

13-Oct-19

Helo

zzzzz

14-Oct-19

Helo

zzzzz

15-Oct-19

Helo

zzzzz

16-Oct-19

Helo

zzzzz

17-Oct-19

Helo

zzzzz

18-Oct-19

Helo

zzzzz

19-Oct-19

Helo

zzzzz

20-Oct-19

Helo

zzzzz

21-Oct-19

Helo

zzzzz

22-Oct-19

Helo

zzzzz

23-Oct-19

Helo

zzzzz

24-Oct-19

Helo

zzzzz

25-Oct-19

Helo

zzzzz

26-Oct-19

Helo

zzzzz

27-Oct-19

Helo

zzzzz

28-Oct-19

Helo

zzzzz

29-Oct-19

Helo

zzzzz

30-Oct-19

Helo

zzzzz

31-Oct-19

Helo

zzzzz

(xxxxx) Monthly Totals

Next P-4: 3210.1 hrs or 6/01/2022

Next P-2: 123.4 hrs or 1/23/20

1.0

0.0

0.2

- 0

20,000

- 0

(zzzzz) Monthly Totals

Next P-4: 4567.8 hrs or 12/1/2023

Next P-2: 432.1 hrs or 3/21/21

1.0

1.2

0.0

- 0

28,000

- 0

Detachment Monthly Totals

2.0

1.2

0.2

- 0

48,000

- 0

5.d.1 Monthly Maint Summary

(Comp. Name)	Prepared By	Prepared By	Detachment Monthly Maintenance Summary	Date
Det C	Porkey Pig	John Doe		31-Oct-19

Aircraft Type/Model/Series	Tail Number	Status	Current Airframe Time	Next Inspection Type (P-2/P-4, 400, 800, 3200, etc.)	Next P-2 Inspection		Next P-4 Inspection		Comments
					Hours To	Due Date	Hours To	Due Date
Helo	xxxxx	FMC	13579.1	P-2	123.4	1/23/20	3210.1	1/23/20	12.3hrs to next 100 hr
Helo	zzzzz	FMC	8642	P-2	432.1	3/21/21	4567.8	3/21/21	45.6 hrs to next 100 hr

Maintenance Status Legend
Due more than 180 days / 100 hrs	P-2 inspections are required ever xxx flight hours
Due less than 180 but more than 90 days / 50 hrs	P-4 inspections are required every vv years and/or cccc flight hours
Due less than 90 days / 25 hrs

5.d.2 Monthly Pilot Status

(Comp. Name)	Prepared By	Detachment Monthly Pilot Status Report	Date
Det C	Porkey Pig		31-Oct-19

Name

Certificate Type

Certificate Number

Total Flight Hours (YTD)

Total Night Hours (Last 12 Mos)

Medical

Non-Aircraft Specific Training

Aircraft Specific Training

Instructor Pilot/Check Airman training

293 Checkride

297 Checkride

299 Checkride

Comments

Bunny, Bugs

ATP

date

Duck, Daffy

ATP

date

Leghorn, Foghorn

ATP

date

Pig, Porkey

ATP

date

Fudd, Elmer

COM

date

Coyote, Wiley

ATP

date

Bird, Tweety

ATP

date

Runner, Road

COM

date

Number Pending Expirations	Medical	Non-Aircraft Specific Training	Aircraft Specific Training	Instructor Pilot/Check Airman training	293 Checkride	297 Checkride	299 Checkride
30 Day Expiration	0				0	0	0	Comments
60 Day Expiration	0				0	0	0
90 Day Expiration	0				0	0	0

5.e Semi-Annual Metric

(Comp. Name)	Prepared By	Prepared By	Det Semi-Annual Metrics Report Oct-Mar	Date	Date	Date
Det C	Porkey Pig	John Doe		31-Mar-20

Date (FY 2017)	Aircraft Type	Number Aircraft Days NMC*	Number Safety Incidents	Total Sorties	VERTREP Sorties	Total Flight Time (hours)	Mission Time (hours)	Training Time (hours)	FCF Time (hours)	Fuel Purchased (gal)	External Loads	Pallets	Cargo (lbs)	Mail (lbs)	PAX Carried
October-19	Helo	4	0	8	7	18.0	17.0	1.0	0	1,000	30	40	50,000	60	7
November-19	Helo	4	0	8	6	19.0	18.0	0.0	1.0	2,000	30	40	50,000	60	7
December-19	Helo	4		8	7	20.0	19.0	1	0	1,000	30	40	50,000	60	7
January-20	Helo	4	0	8	6	21.0	20.0	0.0	1	2,000	30	40	50,000	60	7
February-20	Helo	4	0	8	7	22.0	21.0	1.0	0.0	1,000	30	40	50,000	60	7
March-20	Helo	4	0	8	6	23.0	22.0	0.0	1	2,000	30	40	50,000	60	7

Oct 2019-Mar 2020 Totals 24 0 48 39 123.0 117.0 3.0 3 9,000 180 240 300,000 360 42

(Comp. Name)	Prepared By	Prepared By	Det Semi-Annual Metrics Report Apr-Sep	Date	Date	Date
Det C	Porkey Pig	John Doe		31-Mar-20	DD MON YY	DD MON YY

Date (FY 2017)

Aircraft Type

Number Aircraft Days NMC*

Number Safety Incidents

Total Sorties

VERTREP Sorties

Total Flight Time (hours)

Mission Time (hours)

Training Time (hours)

FCF Time (hours)

Fuel Purchased (gal)

External Loads

Pallets

Cargo (lbs)

Mail (lbs)

PAX Carried

April-20

Helo

May-20

Helo

June-20

Helo

July-20

Helo

August-20

Helo

September-20

Helo

Apr-Sep 2020 Totals

FY 2020 Totals	24	0	48	39	123.0	117.0	3.0	3	9,000	180	240	300,000	360	42
* Aircraft Days NMC = number of days per month. Definition: One day NMC = one aircraft NMC. For example, two detachment aircraft are down on same day = 2 days NMC.

File details come from the government source that posted it. Updated Apr 20, 2021.