Technical_Exhibit_1_Latrines_Matrix.xlsx
XLSX spreadsheet 73 KB Posted
- Solicitation number
- W912CN17Q0011
About this file
Technical Exhibit 1 Latrines Matrix
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Technical_Exhibit_2_Historical_Data.pdf | ||
| Attachment_1__Work_Experience.doc | DOC document | |
| W912CN17Q0011.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
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
Blank - ADD LOCTION IF NEEDED $0.00 $0.00 $0.00 $0.00
Blank - ADD LOCTION IF NEEDED $0.00 $0.00 $0.00 $0.00
Blank - ADD LOCTION IF NEEDED $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
Name Month#1
| PTA CHEMICAL LATRINES | ||||||
| START DATE: | END DATE: | |||||
| NAME OF UNIT: | REQUESTER: | |||||
| NAME OF EXERCISE/TRAINING: | # PAX: | |||||
| CELL #: | ||||||
| FINANCIAL POC NAME & PHONE #: | ||||||
| FINANCIAL POC EMAIL: | ||||||
| COR Name (ARMY ONLY): | COR Phone#: | COR Email: | ||||
| MONTH OF: |
| CLIN X001 | CLIN X002 | CLIN X003 | CLIN X004 | CLIN X005 | CLIN X006 | CLIN X007 | |||||||||||||||||||||||||||||||||||||||||
| 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. | 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 | 31 | COUNT Latrine Days | COST Latrine Days | COUNT Latrine Weeks | COST Latrine Week | COUNT Delivered | COST Delivered | COUNT Emrgncy Delivered | COST Emrgncy Delivered | COUNT Emergency Cleaning | COST Emergency Cleaning | COUNT 8-Hr Relocate | COST 8-Hr Relocate | COUNT 8 HR Cancel | COST 8 Hr Cancel | CHECK COSTS |
| MONTH OF: |
K-Dock $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Small Motor Pool $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Large Motorpool $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
TACT VEH GATE 338,865 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
AHA 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Task Force (South of Bldg# 177) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Living Area (West of Bldg# 121) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Vehicle Wash Facility (TVWF) Bldg#382 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Range 4 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Range 7 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Range 11T $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Range 12 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Range 15 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Range 10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Range 17 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
PU'U AHI 282,857 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
PU'U Keiki $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Range 1A $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Range 1B $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Range 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Range 5 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Range 8 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Range 8b $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Range 13 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Range 13A $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
Range 20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
RELOCATIONS? Recommend for Flexibility $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 0.00
| Add locations ABOVE this line by "Inserting" Rows | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 0.00 | |||||||
| Or write over locations not needed. | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
TOTAL Month #1: $0.00 0.00 TOTAL (CHECK)
INSTRUCTIONS:
| FILL OUT TOP (YELLOW) PORTION IN FULL |
| Each month requires a separate worksheet. |
| Estimate 15 people per latrine. |
| POC for PTA Latrines: Sheldon M. Takajo -PTA COR -808-864-0822 | ||
| Email the completed matrix above to PTA COR for cost calculations. | ||
| Contact PTA COR if there are questions about completing the above matrix. | TOTAL MONTH 1 | $0.00 |
MUST BE FINALIZED AT LEAST 30 DAYS BEFORE DEPLOYMENT DATE . TOTAL MONTH 2 $0.00
| GRAND TOTAL | $0.00 | |
| Latrines are cleaned every other day plus a final clean out at the end |
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 &A &F
Name Month#2
| PTA CHEMICAL LATRINES | |||||
| START DATE: | END DATE: | ||||
| NAME OF UNIT: | REQUESTER: | ||||
| NAME OF EXERCISE/TRAINING: | # PAX: | ||||
| UNIT POC for PTA Services CELL #: | |||||
| FINANCIAL POC NAME & PHONE #: | |||||
| FINANCIAL POC EMAIL: | |||||
| COR Name (ARMY ONLY): | COR Phone#: | COR Email: |
| CLIN X001 | CLIN X002 | CLIN X003 | CLIN X004 | CLIN X005 | CLIN X006 | CLIN X007 | ||||||||||||||||||||||||||||||||||||||||||
| 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. | COUNT Latrine Days | COST Latrine Days | COUNT Latrine Weeks | COST Latrine Week | COUNT Delivered | COST Delivered | COUNT Emrgncy Delivered | COST Emrgncy Delivered | COUNT Emergency Cleaning | COST Emergency Cleaning | COUNT 8-Hr Relocate | COST 8-Hr Relocate | COUNT 8 HR Cancel | COST 8 Hr Cancel | CHECK COSTS | |||||||||||||||||||||||||||||||||
| MONTH OF: | 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 | 31 | ||||||||||||||||
| ERROR:#REF! | ||||||||||||||||||||||||||||||||||||||||||||||||
| K-Dock | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Sprung Shelter Motor Pool | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Large Motorpool | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| TACT VEH GATE 338,865 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| AHA 2 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Task Force (South of Bldg# 177) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Living Area (West of Bldg# 121) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Vehicle Wash Facility (TVWF) Bldg#382 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| BAX | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Range 1A | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Range 1B | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Range 2 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Range 6 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Range 8 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Range 10 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| PU'U AHI 282,857 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| PU'U Keiki | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| FOB | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Firing Points | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Burn Pan | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| ADD LOCATIONS or GRID COORDINATES | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| ADD LOCATIONS or GRID COORDINATES | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||||||||
| 0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Add locations ABOVE this line by "Inserting" Rows | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | ||||||||||||||||||||||||||||||||||
| Or write over locations not needed. | ||||||||||||||||||||||||||||||||||||||||||||||||
| TOTAL Month #1: | $0.00 | ERROR:#REF! | TOTAL (CHECK) |
INSTRUCTIONS:
| FILL OUT TOP (YELLOW) PORTION IN FULL | ||
| Each month requires a separate worksheet. | TOTAL MONTH 1 | $0.00 |
| Estimate 15 people per latrine. | ||
| TOTAL MONTH 2 | $0.00 | |
| POC for PTA Latrines: Sheldon M. Takajo -PTA COR -808-864-0822 | ||
| Email the completed matrix above to PTA COR for cost calculations. | GRAND TOTAL | $0.00 |
| Contact PTA COR if there are questions about completing the above matrix. | ||
| ALL Orders and Changes go through PTA COR | ||
| MUST BE FINALIZED AT LEAST 45 DAYS BEFORE DEPLOYMENT DATE . | ||
| Over $2500 - MIPRS go to: Lori T. Honda AND Cindy Bae. Under $2500 will be on Unit's GPC. |
Latrines are cleaned every other day plus a final clean out at the end
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 &A &F
Sheet11
File details come from the government source that posted it. Updated .