TE_02_ PTALatrineMatrix_19Jul22to18Jul23_v4.xlsx

XLSX spreadsheet 53 KB Posted Jun 17, 2022

Attached to: Portable Latrines Supplies and Incidental Services, Pohakuloa Training Area and Kawaihae Dock on the Island of Hawaii
Solicitation number: W912CN-22-R-0011
Issued by: Department of the Army Materiel Command Army Contracting Command

View the file

Other files

File	Type	Posted
Annex A - SOR 22-R-0011 0001 Amendment 1.pdf	PDF	Jun 28, 2022
SF30 Solicitation Amendment 22-R-0011 0002.pdf	PDF	Jun 28, 2022
Annex A - SOR 22-R-0011 0002 Amendment 2.pdf	PDF	Jun 28, 2022
Attachment 1 - Questions and Answers 1.pdf	PDF	Jun 28, 2022
SF30 Solicitation Amendment 22-R-0011 0001.pdf	PDF	Jun 27, 2022
Annex A - SOR 22-R-0011 0001 Amendment 1.pdf	PDF	Jun 27, 2022
Attachment 1 - Questions and Answers 1.pdf	PDF	Jun 27, 2022
FY22PTAPortableLatrines QASP_v6.docx	DOCX document	Jun 27, 2022
Attachment 2 - Questions and Answer - DTD 27 June 2022.pdf	PDF	Jun 27, 2022
TE_01C_AreaMap_PTA_RemoteLocations_v1.pdf	PDF	Jun 27, 2022
TE_06_PTAInvasivePestPreventionSOPFinal2018.07.03.pdf	PDF	Jun 17, 2022
TE_1B_AreaMap_PTACantonment.pdf	PDF	Jun 17, 2022
TE_05_PTARestrictedAreasPortableLatrinePlacement.pdf	PDF	Jun 17, 2022
TE_03_PTA_InstallationAccessPassForm.pdf	PDF	Jun 17, 2022
Amendment 1.pdf	PDF	Jun 17, 2022
TE_1A_AreaMap_KawaihaeDock.pdf	PDF	Jun 17, 2022
Attachment 1 Work Experience.rtf	RTF text file	Jun 17, 2022
Annex A to OPORD 18-011 FY22 PTA_KDock Portable Latrines Renewal - PWS 10.27.21v16_ 6.16.22.docx	DOCX document	Jun 17, 2022
HI-2204 IGCE FY22 PTA Chem Latrines Renewal_CLIN Description.xlsx	XLSX spreadsheet	Jun 17, 2022
TE_01C_AreaMap_PTA_RemoteLocations.pdf	PDF	Jun 17, 2022
TE_01D_AreaMap_ContractorLatrineHolding.pdf	PDF	Jun 17, 2022
TE_04_PTAInstallationAccessControlPolicy.pdf	PDF	Jun 17, 2022
Solicitation 22-R-0011.pdf	PDF	May 20, 2022

Show all 23

On GovTribe

Work with this file

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.

Nov

				FEWR:
NAME OF UNIT: 1st Bn 12th Marines	REQUESTOR: GySgt Pamintuan		EMAIL:______________________________________________	GFEBS PR #:
OFFICE PH #:808-257-8010	CELL #:808-393-5352	FAX #
GPC CARDHOLDER RANK & FULL NAME:___________________________________________				LATRINE REQUEST NO.: ______________________
GPC CARDHOLDER EMAIL:______________________________________________________
FINANCIAL POC & PHONE:

MONTH NOVEMBER 2012
LOCATION (Gen Desc w/GPS 6-Digit Grid)	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	COUNT Latrine Days	COST Latrine Days	COUNT Latrine Weeks	COST Latrine Week	COUNT Delivered	COST Delivery Fee	COUNT Delivered	COST Emergency Delivery	Cancellation	Relocation
																															EA	$27.57		$165.38		$27.57		$49.52	$16.54	$33.08

K-Dock 4 4 4 4 16 $441.12 $0.00 4 $110.28 $0.00

Small Motor Pool 2 2 2 2 8 $220.56 $0.00 2 $55.14 $0.00

Large Motorpool 2 2 2 2 8 $220.56 $0.00 8 $220.56 $0.00

AHA 2 2 2 2 2 8 $220.56 $0.00 8 $220.56 $0.00

TACT VEH GATE 338,865 1 1 1 1 1 $27.57 $0.00 1 $27.57 $0.00

Range 8 $0.00 $0.00 $0.00 $0.00

Blank - ADD LOCTION IF NEEDED $0.00 $0.00 $0.00 $0.00

NOV CLIN TOTALS	41		0		23		0		0	0
NOV SUB TOTAL COST		$1,130.37		$0.00		$634.11		$0.00
DEC CLIN TOTALS	ERROR:#REF!		ERROR:#REF!		ERROR:#REF!
DEC SUB TOTAL COST		ERROR:#REF!		ERROR:#REF!		ERROR:#REF!
TOTAL QTY EACH CLIN	ERROR:#REF!		ERROR:#REF!		ERROR:#REF!
TOTAL COST EACH CLIN		ERROR:#REF!		ERROR:#REF!		ERROR:#REF!

	TOTAL NOV	1ST MONTH TOTAL:	$1,764.48
	TOTAL DEC	2nd MONTH TOTAL:	ERROR:#REF!
		GRAND TOTAL	ERROR:#REF!
INSTRUCTIONS
Above is a matrix to order portable chemical latrines for the upcoming training at PTA. First RENAME the Excel file TAB to match your month of service.
FILL OUT TOP 9YELLOW) PORTION IN FULL
Each month requires a separate worksheet.
Over $2500 - MIPRS go to: Lori T. Honda AND Cindy Bae. Under $2500 will be on Unit's GPC.
Email the completed matrix above to the COR (Lisa.M.Duwall.civ@mail.mil) for cost calculations. MUST BE FINALIZED at least 45 days before deployment date to ensure services are in place for training.
Contact the COR in the Big Island at (808) 430-5621 if there are questions about completing the above matrix.
YOU CAN ADD LOCATIONS OR DELETE LOCATIONS NOT USED/NEEDED ON MATRIX

NOTES:	LATRINES:
Estimate 15 people per latrine.	All deployments will charge their Govt Purchase VISA card if <or=$2,500.00
Service of the latrine is every other day plus a final clean out at the end	If >$2,500.00, contact your budget analyst to set up an alternate line of
ALL non-GPC orders/changes will go to DPW's COR at PTA, Phone (808) 430-5621.	accounting on the latrine payment card.
Inquire about the warnings.
24 hours (1 day) notice required on all cancellations. Failure to meet 1 day cancellation notice, will result in charging unit(s) 1 latrine day rental per latrine.

&D &F &A month

Technical Exhibit #2 - PTA Portable Latrine Matrix Contract No. W912CN-XX-D-XXXX POP: 19 July 2022 - 18 July 2023

**NO Modifications Allowed within 48 hours of start date**MATRIX shall be finalized 45 days PRIOR to arrival**ALL Contracts or GPC payments must be completed PRIOR to ADVON**NO Latrines = NO Training**

Name of Exercise/Training:

Number of PAX:

Planning Factor: 15 personnel per latrine.

Name of Unit:

DODAAC:

Requester (Unit's POC):

Rank/Name

Field Location POC :

Rank/Name

WAWF Acceptor:

Rank/Name

Contractor POC: - xxx-xxx-xxxx

Phone

CLIN 0001

CLIN 0002

CLIN 0003

CLIN 0004

CLIN 0005

CLIN 0006

No.

LOCATION: Gen Desc or GPS 6-Digit Grid. You can add or type over locations (below). Put NUMBER of Latrines in each box under Calendar Day for locations.

Month

No. of Latrines

No. of Days

Latrine DAY

No. of Latrines

No. of Week

Latrine WEEK

No. of Latrines

Regular DELIVERY & PICKUP

No. of Latrines

REMOTE DELIVERY & PICKUP

No. of Latrines

EMERGENCY DELIVERY & PICKUP

No. of Latrines

RELOCATION

1 3 3 3 3 3 3 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

4 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

5 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

6 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

7 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

8 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

9 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

11 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

12 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

13 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

26 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

27 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

28 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

29 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00

30	Relocations																																												$0.00		$0.00
																																		ERROR:#DIV/0!	$0.00	ERROR:#DIV/0!	$0.00	0	$0.00	0	$0.00	0	$0.00	0	$0.00	0	$0.00	ERROR:#DIV/0!	$0.00
Daily Latrine Total			0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	0	$0.00	0	$0.00	0	$0.00	0	$0.00	0	$0.00	ERROR:#DIV/0!	ERROR:#DIV/0!
Month			1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	CLIN 0001		CLIN 0002		CLIN 0003		CLIN 0004		CLIN 0005		CLIN 0006		CLIN 0007		CLIN 0008
																																		Total		ERROR:#DIV/0!
		ERROR:#DIV/0!

&D &T

Sheet11

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated Jun 17, 2022.