Attachment F - 09-6774947 Recap Family Housing PMDS V7.xlsx
XLSX spreadsheet 58 KB Posted
- Attached to
- Recapitalize Family Housing, Station Portage, U. S. Coast Guard Station Portage, Dollar Bay, MI
- Solicitation number
- 70Z04725RPCNI0002
About this file
This document is a Real Property Project Management Data Sheet (PMDS) for a federal construction project to recapitalize family housing at the U.S. Coast Guard Station in Portage, Michigan.
The project will construct new multiplex family housing consisting of (4) three-bedroom and (3) four-bedroom units across two separate buildings, along with a new playground, parking lot, equipment storage building, and residential septic system upgrades. The project will demolish the existing family housing units and modify various infrastructure assets. The total estimated construction cost is $5.9 million. The project has three optional add-ons: 1) design and construct one 3-bedroom housing unit, 2) design and construct one duplex with two 3-bedroom units, and 3) design and construct one maintenance building. This opportunity is limited to DHS, NMACC III, Pool II contract holders, with an expected performance period from award to beneficial occupancy.
View the file
Other files
Show all 30
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
PMDS V7
| Real Property Project Management Data Sheet (PMDS) | ||||||||||||||||
| Project Title: | Recapitalize Family Housing | FR Project #: | TBD | Establish CIP Project | ||||||||||||
| Landlord Name: | CG STA PORTAGE | City: | Dollar Bay | State: | MI | SAM Parent Project #: | 09-6774947 | Original CAP Package | ||||||||
| Landlord ATU-OPFAC: | 30405 | Site# (SUID): | 1984 | Site (SUID) Name: | CG STA PORTAGE | 16 Digit Obligation DOC ID | ||||||||||
| (OE Only). Construction & Design | Supplemental CAP Package | |||||||||||||||
| Project Funding Information | Expense Project | |||||||||||||||
| Funding Information | ||||||||||||||||
| (Line of Accounting) | Funding Year | Funding Amount | Projected Completion Date | Type of Funding (Use Dropdown) | PMDS Type |
(Use Pick-List)
| AGCY | RGN | APPR | LIM | AFC | PE | CC | |
| ACI | |||||||
| AFC-43 | |||||||
| MASI | |||||||
| AFC-30 |
| Project Description |
| Construct new Multiplex Acompanied Housing at US CG STA Portage, Dollar Bay, MI to meet Family Housing Design CSTO Standards and HMSA-Lite requirements. Housing will consist of (4) three-bedroom and (3) four-bedroom housing units in two separate structures (2 four bedroom + 2 three bedroom units in one building, and 1 four bedroom + 2 three bedroom units in the other building) at CG STA Portage, MI. A new playground, parking lot, equipment storage building, concrete pads for two existing storage sheds and a residential septic system expansion will be included. Replace Housing Fence (Less than 6 FT) with a new housing fence (6 FT and above). |
| Asset Affected by Project - Detailed Breakdown | ||||||||
| DEMOLISH/ REMOVE (100% Asset Disposal - No Partials) | ||||||||
| RPUID | ASSET NAME | B/L/S | PRV ($K) | CHILD PROJ# | DISPOSAL DATE | COST | %CC | NOTES |
| 11851 | Fasmily Quarters #1 (4BR) | B | $706 | 09-6774947 | ||||
| 11852 | Fasmily Quarters #2 (3BR) | B | $598 | 09-6774947 | ||||
| 11853 | Fasmily Quarters #3 (4BR) | B | $706 | 09-6774947 | ||||
| 11854 | Fasmily Quarters #4 (3BR) | B | $588 | 09-6774947 | ||||
| 11855 | Fasmily Quarters #5 (3BR) | B | $598 | 09-6774947 | ||||
| 11856 | Fasmily Quarters #6 (3BR-HDCP) | B | $631 | 09-6774947 | ||||
| 854449 | Housing Playground | S | $294 | 09-6774947 | ||||
| 810941 | Interior Fence and Wall (Less than 6 FT) | S | $21,579 | 09-6774947 |
| MODIFY (All Modifications Regardless of Impact to Size or Function) | ||||||||||
| RPUID | ASSET NAME | B/L/S | PRV ($K) | CHILD PROJ# | EXIST SIZE | FINAL SIZE | UM | COST | %CC | NOTES (Describe Changes) |
| 42449 | Heat Gas Distribution Line | S | $46,043 | 09-6774947 | 1,421 | 2,421 | LF | |||
| 42484 | Storm Drainage - Sewer | S | $53,920 | 09-6774947 | 527 | 1,027 | LF | |||
| 42486 | Septic Tank, Drain Field, and Lagoon - Housing | S | $7,770 | 09-6774947 | 1,000 | 40,000 | GA | |||
| 42447 | Sidewalk and Walkway, Surfaced | S | $46,438 | 09-6774947 | 567 | 1,367 | SY | |||
| 42483 | Sewer and Industrial Waste Line | S | $27,305 | 09-6774947 | 400 | 1,400 | LF | |||
| 42487 | Water Distribution Line, Potable | S | $157,328 | 09-6774947 | 1,568 | 2,568 | LF | |||
| 811192 | Electrical Power Distribution Lines, Underground | S | $1,362,476 | 09-6774947 | 5,018 | 6,018 | LF | |||
| 42446 | Paved Vehicle Parking | S | $52,625 | 09-6774947 | 938 | 1,538 | SY | |||
| 42450 | Telephone Serevice | S | $38,410 | 09-6774947 | 0.3 | 0.3 | MI |
| NEW (100% New Construction or Other Acquisition) | ||||||||||
| RPUID | ASSET NAME | B/L/S | CATCODE | CHILD PROJ# | SIZE | UoM | DIS (Acquired) | COST | %CC | NOTES |
| Family Housing - Multiplex As Shown Below | 09-6774947 | |||||||||
| 4 Bedroom Unit | B | 71103 | 09-6774947 | 3,289 | GSF | |||||
| 4 Bedroom Unit | B | 71103 | 09-6774947 | 3,289 | GSF | |||||
| 4 Bedroom Unit | B | 71103 | 09-6774947 | 3,289 | GSF | |||||
| 3 Bedroom Unit | B | 71103 | 09-6774947 | 2,386 | GSF | |||||
| 3 Bedroom Unit | B | 71103 | 09-6774947 | 2,386 | GSF | |||||
| 3 Bedroom Unit | B | 71103 | 09-6774947 | 2,386 | GSF | |||||
| 3 Bedroom Unit | B | 71103 | 09-6774947 | 2,386 | GSF | |||||
| Personal Garage (Equipment Storage Building) | B | 71410 | 09-6774947 | 800 | GSF | |||||
| Housing Playground | S | 75024 | 09-6774947 | 1 | EA | |||||
| Interior Fence and Wall (6 FT and Above) | S | 87215 | 09-6774947 | 2,000 | LF | |||||
| Housing Storage Buildings (2 buildings) | S | 71410 | 09-6774947 | 126 | SF | $9,329 | $4,664.50 each |
| Legend: | RPUID = Real Property Unique Identifier | CATCODE = Category Code | DIS = Date in Service = "Date Acquired" for New Assets | CC = Construction Cost | ||||
| PRV = Plant Replacement Value | UM or UoM = Unit of Measure | %CC = % of Total Const Cost | B/L/S = Building or Land or Structure (Choose one) | |||||
| RPAS PMDS Notes Updates | ||||||||
| Notes: | ||||||||
| RPAS Signature | Date | |||||||
| Direct Cost Capitalized Asset Accepted for Completion: For Accounting Use Only | ||||||||
| ASSET NAME | DIRECT COST | DIS | OPFAC | RPUID | NOTES |
| PMDS Approval | ||
| Title | Office Symbol | Signature and Date |
| CAP PKG Preparer | CG-438 CAT | |
| Project Manager | FDCC/CEU | |
| Business Finance Manager/Resource Manager | CG-438 | |
| Reviewer | CG-845 | |
| Approver | CG-845 | |
| FINCEN FR | FINCEN-FR | |
| PMDS Version #7 |
AC&I Project Cost
| PMDS ATTACHMENT | |
| FDCC REAL PROPERTY COST SUMMARY (RPCS) SHEET |
| PROJECT TITLE | ERROR:#REF! | SFRL No. | ERROR:#REF! | |||||||
| Benefitting Unit(s) | FR Project No. | ERROR:#REF! | ||||||||
| Landlord | ERROR:#REF! | City | ERROR:#REF! | State | ERROR:#REF! | SAM No. | ERROR:#REF! | |||
| Lndlrd ATU-OPFAC | ERROR:#REF! | Installation No. | Site Number | ERROR:#REF! | Date | Funding Year | ERROR:#REF! | |||
| Acquisition Type | Bid | Dsgn-Bld | 8A | Govt. Est. | Funding Source | |||||
| Project Status | Active | Complete | Closed | Award | Final Direct Cost | |||||
| PART I - SURVEY AND DESIGN | ||||||||||
| Project Manager | Unit | Phone No. | ||||||||
| Government S&D Estimate | Date | |||||||||
| Awarded S&D Amount | Date | |||||||||
| Contract No. | Contract No. | |||||||||
| Task Order No. | Task Order No. | |||||||||
| Vendor/Contractor | Vendor/Contractor | |||||||||
| Accounting Line | Accounting Line | |||||||||
| FPD Document ID | FPD Document ID | |||||||||
| S&D Funded Amount | S&D Funded Amount | |||||||||
| S&D Amount Spent to Date | S&D Amount Spent to Date | |||||||||
| Contract No. | Contract No. | |||||||||
| Task Order No. | Task Order No. | |||||||||
| Vendor/Contractor: | Vendor/Contractor: | |||||||||
| Accounting Line | Accounting Line | |||||||||
| FPD Document ID | FPD Document ID | |||||||||
| S&D Funded Amount | S&D Funded Amount | |||||||||
| S&D Amount Spent to Date | S&D Amount Spent to Date | |||||||||
| Contract No. | Contract No. | |||||||||
| Task Order No. | Task Order No. | |||||||||
| Vendor/Contractor | Vendor/Contractor | |||||||||
| Accounting Line | Accounting Line | |||||||||
| FPD Document ID | FPD Document ID | |||||||||
| S&D Funded Amount | S&D Funded Amount | |||||||||
| S&D Amount Spent to Date | S&D Amount Spent to Date | |||||||||
| Contract No. | Contract No. | |||||||||
| Task Order No. | Task Order No. | |||||||||
| Vendor/Contractor | Vendor/Contractor | |||||||||
| Accounting Line | Accounting Line | |||||||||
| FPD Document ID | FPD Document ID | |||||||||
| S&D Funded Amount | S&D Funded Amount | |||||||||
| S&D Amount Spent to Date | S&D Amount Spent to Date | |||||||||
| Contract No. | Contract No. | |||||||||
| Task Order No. | Task Order No. | |||||||||
| Vendor/Contractor | Vendor/Contractor | |||||||||
| Accounting Line | Accounting Line | |||||||||
| FPD Document ID | FPD Document ID | |||||||||
| S&D Funded Amount | S&D Funded Amount | |||||||||
| S&D Amount Spent to Date | S&D Amount Spent to Date | |||||||||
| PMDS ATTACHMENT - Page #2 |
| FDCC REAL PROPERTY COST SUMMARY (RPCS) SHEET | |||||||||||
| PROJECT TITLE | ERROR:#REF! | SFRL No. | ERROR:#REF! | ||||||||
| Benefitting Unit(s) | CIP Project No. | ERROR:#REF! | |||||||||
| Landlord | ERROR:#REF! | City | ERROR:#REF! | State | ERROR:#REF! | SAM No. | ERROR:#REF! | ||||
| Lndlrd ATU-OPFAC | ERROR:#REF! | Installation No. | Site Number | ERROR:#REF! | Date | Funding Year | ERROR:#REF! | ||||
| Acquisition Type | Bid | Dsgn-Bld | 8A | Govt. Est. | Funding Source | ||||||
| Project Status | Active | Complete | Closed | Award | Final Direct Cost | ||||||
| PART II - CONSTRUCTION | |||||||||||
| Project Manager | Unit | Phone No. | |||||||||
| Government Const. Estimate | Date | ||||||||||
| Awarded Const. Amount | Date | ||||||||||
| Contract No. | Contract No. | ||||||||||
| Task Order No. | Task Order No. | ||||||||||
| Vendor/Contractor | Vendor/Contractor | ||||||||||
| Accounting Line | Accounting Line | ||||||||||
| FPD Document ID | FPD Document ID | ||||||||||
| Const. Funded Amount | Const. Funded Amount | ||||||||||
| Const. Amnt Spent to Date | Const. Amnt Spent to Date | ||||||||||
| Contract No. | Contract No. | ||||||||||
| Task Order No. | Task Order No. | ||||||||||
| Vendor/Contractor: | Vendor/Contractor: | ||||||||||
| Accounting Line | Accounting Line | ||||||||||
| FPD Document ID | FPD Document ID | ||||||||||
| Const. Funded Amount | Const. Funded Amount | ||||||||||
| Const. Amnt Spent to Date | Const. Amnt Spent to Date | ||||||||||
| Contract No. | Contract No. | ||||||||||
| Task Order No. | Task Order No. | ||||||||||
| Vendor/Contractor | Vendor/Contractor | ||||||||||
| Accounting Line | Accounting Line | ||||||||||
| FPD Document ID | FPD Document ID | ||||||||||
| Const. Funded Amount | Const. Funded Amount | ||||||||||
| Const. Amnt Spent to Date | Const. Amnt Spent to Date | ||||||||||
| Contract No. | Contract No. | ||||||||||
| Task Order No. | Task Order No. | ||||||||||
| Vendor/Contractor | Vendor/Contractor | ||||||||||
| Accounting Line | Accounting Line | ||||||||||
| FPD Document ID | FPD Document ID | ||||||||||
| Const. Funded Amount | Const. Funded Amount | ||||||||||
| Const. Amnt Spent to Date | Const. Amnt Spent to Date | ||||||||||
| PART III - PROJECT COMPLETION | |||||||||||
| DIRECT PROGRAM COSTS AC&I (SHORE OR MASI) | DIRECT PROGRAM COSTS OE (AFC43) | PROJECT COST | TOTAL COMPLETION PROJECT COST | ||||||||
| S & D Cost | S & D Cost | ||||||||||
| Govt. Estimate DB | Govt. Estimate DB | Project Award Date: | Funded: | ||||||||
| Design Award Cost | Design Award Cost | Project BOD date: | Expended: | ||||||||
| Construction Award Cost | Construction Award Cost | Project Completion date: | Balance: | ||||||||
| Total Const. Cost (CC) | Total Const. Cost (CC) | TOTAL DIRECT COST | |||||||||
| Furniture /Eqpt | Furniture /Eqpt | TOTAL IN-DIRECT COST | |||||||||
| Electronics | Electronics | ||||||||||
| Inspection Srvcs | Inspection Srvcs | ||||||||||
| Other Travel | Other Travel | OTHER | |||||||||
| TOTAL DIRECT CST | $0.00 | TOTAL DIRECT CST | $0.00 | TOTAL PROJECT COST | $0.00 | ||||||
| Other Travel | Other Travel | OTHER | |||||||||
| TOTAL DIRECT CST | $0.00 | TOTAL DIRECT CST | $0.00 | TOTAL PROJECT COST | $0.00 |
File details come from the government source that posted it. Updated .