Attach._D_-_Deployment_and_Logistics_Workbook.xlsx
XLSX spreadsheet 54 KB Posted
- Attached to
- Statewide Contract CA|1-22-70-34|0000000165
- Contract number
- 1-22-70-34
- Issued by
- California
About this file
This document is a Deployment and Logistics Workbook for the Department of General Services, Procurement Division PC Goods Contracts, specifically Attachment D, which details a comprehensive breakdown of logistics and value-added services for equipment deployment. The document appears to be a detailed task checklist and service breakdown for a state-level technology procurement contract, focusing on various stages of equipment handling, storage, configuration, and deployment.
The workbook outlines four primary service sections: Warehouse Receiving and Processing, Equipment Assembly & Configuration, Equipment Order Administration and Logistics, and On-Site Deployment Services. These services include tasks such as long-term equipment storage (up to 360 days), custom equipment assembly, barcode scanning, asset reporting, schedule creation for staggered deliveries, end-user training, software installation, peripheral connection, data migration, and equipment repurposing or recycling. While specific pricing is not explicitly detailed, the document provides granular time allocations for each task, ranging from 0.01 to 1.75 hours per unit or project, indicating a highly structured and meticulously planned approach to technology equipment deployment and management.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attach._C_-_PCRC_Workbook_-_Supp._4.xlsx | XLSX spreadsheet | |
| Laptops_Comparisons_R6.xlsx | XLSX spreadsheet | |
| Attach._B_-_PC_Goods_Spec_(70-34)_-_Supp._4.pdf | ||
| User_Instructions_1-22-70-34_-_Supp_10.docx | DOCX document | |
| User_Instructions_1-22-70-33_-_Supp._8.docx | DOCX document |
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
D&L Task Checklist
| Department of General Services, Procurement Division | ||||
| PC Goods Contracts | ||||
| Attachment D - Deployment & Logistics Breakdown Summary (See tabs 1-4 for itemized details) | ||||
| Section 1: Warehouse Receiving and Processing of Equipment | ||||
| Unit Time (hr) | PC Goods Qty (Project Based or Unit Based) | Total Time (hrs) | Task Description | Included (Y/N) |
| N/A | Project | 0 | Provide Long-Term Equipment Storage - up to 90 days (per SOW) | |
| N/A | Project | 0 | Provide Long-Term Equipment Storage - up to 180 days (per SOW) | |
| N/A | Project | 0 | Provide Long-Term Equipment Storage - up to 360 days (per SOW) | |
| N/A | Project | 0 | Used Equipment - Inventory and Preparation for Reuse of Equipment | |
| 0.01 | Per Unit | 0 | Bar Code Scan of equipment serial numbers and download into database | |
| N/A | Project | 0 | Detail asset reporting per customer requirement to include electronic/manual input and transfer per SOW | |
| Section 2: Equipment Assembly & Configuration | ||||
| Unit Time (hr) | PC Goods Qty (Project Based or Unit Based) | Total Time (hrs) | Task Description | Included (Y/N) |
| 0.40 | Per Unit | 0 | Custom All-in-One Assembly of factory components into non-factory configuration per customer specs | |
| 0.25 | Per Unit | 0 | Replace/Upgrade internal Computer Component, i.e., RAM, Video Card (post factory configuration) | |
| 0.30 | Per Unit | 0 | Perform BIOS settings or changes, i.e., Enable/Disable (Wake on LAN) during imaging | |
| N/A | Project | 0 | Advanced Imaging Services | |
| Section 3: Equipment Order Administration and Logistics | ||||
| Unit Time (hr) | PC Goods Qty (Project Based or Unit Based) | Total Time (hrs) | Task Description | Included (Y/N) |
| N/A | Project | 0 | Creating a Customer Schedule for Staggered Delivery to multiple locations (per SOW) (Schedule Only) | |
| N/A | Project | 0 | Creating a Customer Schedule for Staggered Delivery to single location (per SOW) (Schedule Only) | |
| N/A | Project | 0 | Create and implement custom/scanned data/cutsheets per scope of work (per SOW) | |
| 1.75 | Per Unit | 0 | Secure Cart Rental *** (unit time is per cart) *** | |
| Section 4: On Site Deployment Services | ||||
| Unit Time (hr) | PC Goods Qty (Project Based or Unit Based) | Total Time (hrs) | Task Description | Included (Y/N) |
| N/A | Project | 0 | End user training: per scope of work | |
| 0.50 | Per Unit | 0 | PC Implementation and Data migration between old and new system | |
| N/A | Project | 0 | Custom Remote On-Site Coordination/Onsite Project Management for larger rollouts (per SOW) | |
| 0.50 | Per Unit | 0 | Add/Remove software as required from a computer | |
| 0.25 | Per Unit | 0 | Launch virus protection, update and scan | |
| 0.17 | Per Unit | 0 | Add peripherals as required via direct connect, scanners, printers, PDA's | |
| 0.25 | Per Unit | 0 | Move and place equipment to be re-purposed into storage or re-deployment at single customer location | |
| 0.17 | Per Unit | 0 | vPro provisioning via customer-supplied certificate on USB | |
| N/A | Project | 0 | Configure Intel AMT USB key, install Intel SCS, integrate with MS AD and SCCM (per SOW) | |
| 0.35 | Per Unit | 0 | DOD wipe, certify and signoff | |
| End of Sheet |
Section 1 Grid
| Department of General Services, Procurement Division | |||||||||||
| PC Goods Contracts | |||||||||||
| Attachment D - Section 1: Warehouse Receiving and Processing of Equipment | |||||||||||
| Long-Term Equipment Storage - up to 90 days (per SOW) | Fraction of D&L (Hrs) | Long-Term Equipment Storage - up to 180 days (per SOW) | Fraction of D&L (Hrs) | Long-Term Equipment Storage - up to 360 days (per SOW) | Fraction of D&L (Hrs) | Used Equipment - Inventory and Preparationfor Reuse of Equipment | Fraction of D&L (Hrs) | Bar Code Scanning | Fraction of D&L (Hrs) | Detail Asset Reporting per customer requirement to include electronic/manual input and transfer per SOW | Fraction of D&L (Hrs) |
| Storing customer equipment,up to 90 days beyond the statewide contract requirement of 30 calendar days, upon delivery to Contractor. Secure Storage, with regular Inventory checks to ensure no lost product. Provide customer access for inventory confirmation. | Storing customer equipment,up to 180 days beyond the statewide contract requirement of 30 calendar days, upon delivery to Contractor. Secure Storage, with regular Inventory checks to ensure no lost product. Provide customer access for inventory confirmation. | Storing customer equipment,up to 360 days beyond the statewide contract requirement of 30 calendar days, upon delivery to Contractor. `Secure Storage, with regular Inventory checks to ensure no lost product. Provide customer access for inventory confirmation. | This task covers all the vendor effort surounding proper transport, documentation, and secure storage of all used equipment being returned by the customer specifically for reuse by the same customer. | Scan equipment barcodes and enter manufacturer's serial numbers into Contractor handheld barcode scanner. | 0.010 | Locate and export detailed asset information as needed from Contractor database which includes: site location, customer PO, product description, manufacturer part number, customer asset number, custom asset tags, manufacturer serial number, delivery work order number, delivery location, contact person, and date/time delivered with signature validation. | |||||
| Note: Secure monitored, insured facilities. |
Storage will only be charged if there is a delay in the project schedule and the storage charge is mutually agreed upon by Contractor and the customer.
During the storage period, equipment will be un-palletized to build orders and the remaining equipment will be re-palletized. Note: Secure monitored, insured facilities.
Storage will only be charged if there is a delay in the project schedule and the storage charge is mutually agreed upon by Contractor and the customer.
During the storage period, equipment will be un-palletized to build orders and the remaining equipment will be re-palletized. Note: Secure monitored, insured facilities.
Storage will only be charged if there is a delay in the project schedule and the storage charge is mutually agreed upon by Contractor and the customer.
| During the storage period, equipment will be un-palletized to build orders and the remaining equipment will be re-palletized. | Boxing up used device and all associated accessories at installation location. | Blank | Blank | Create custom asset report for customer from exported asset report. Format into MS Excel format by sorting report by type of equipment, location, date of delivery, customer purchase order. | ||||||||
| Blank | Blank | Blank | Blank | Blank | Blank | Consolidation and documentation of all used equipment at vendor warehouse. | Blank | Blank | Deliver asset report updates to customer in MS Excel format on a regular basis throughout the project for use on customer SharePoint. Ready data for Remedy or Services Desk import and quality checks. | |||
| Blank | Blank | Blank | Blank | Blank | Blank | Transport upon completion of project of all used equipment back to agency location. | Blank | Blank | Note: Database experts are made available to assist the State in importing and normalizing data in their IT systems. | |||
| Project Total Hours: | 0.000 | Project Total Hours: | 0.000 | Project Total Hours: | 0.000 | Project Total Hours: | 0.000 | Unit Total: | 0.010 | Project Total Hours: | 0.000 | |
| Units Ordered | Project | Units Ordered | Project | Units Ordered | Project | Units Ordered | Project | Units Ordered | Units Ordered | Project | ||
| Total Hours | 0 | Total Hours | 0 | Total Hours | 0 | Total Hours | 0 | Total Hours | 0 | Total Hours | 0 | |
| End of Sheet |
&"-,Bold"&22NWN Value Added Services (VAS) Task Detail
&12&F &12&D
Section 2 Grid
| Department of General Services, Procurement Division | |||||||
| PC Goods Contracts | |||||||
| Attachment D - Section 2: Equipment Assembly & Configuration | |||||||
| Custom All-in-One Assembly of factory components into non-factory configuration per customer specs | Fraction of D&L (Hrs) | Replace/Upgrade internal Computer Component, i.e., RAM, Video Card | Fraction of D&L (Hrs) | Perform Bios settings or changes, i.e. WOL (wake on LAN) during imaging | Fraction of D&L (Hrs) | Advanced Imaging Services | Fraction of D&L (Hrs) |
| Remove factory standard stands from monitors that need to be reconfigured to state standards (example: non-standard stands). | 0.050 | Install one of the following after the equipment is received at the Contractor warehouse: RAM, hard drive, wireless card or video card (desktop PC only). | 0.250 | Connect computer to power (for desktop, also connect to monitor) and start computer. | 0.100 | Additional handling necessary to facilitiate imaging services outside of the vendor facility. Covers the additional handling needed for controlled imaging in a customer or secondary secure environment which is different from the final installation location. | |
| Lay out components in assembly line fashion for non-standard configuration. | 0.050 | Blank | Blank | Enter BIOS and make changes per SOW, i.e., add asset name, change security access, enable Wake On LAN. | 0.200 | Blank | Blank |
| Attachment of custom bracket to PC. | 0.075 | Blank | Blank | Blank | Blank | Blank | Blank |
| Attachment of custom bracket to Monitor. | 0.075 | Blank | Blank | Blank | Blank | Blank | Blank |
| Construct the PC and the monitor onto one shared Integrated Work Center Stand. | 0.075 | Blank | Blank | Blank | Blank | Blank | Blank |
| Repackage accessories into custom zip lock packaging. | 0.035 | Blank | Blank | Blank | Blank | Blank | Blank |
| Repackage completed non-standard configuration into custom packaging. | 0.040 | Blank | Blank | Blank | Blank | Blank | Blank |
| Unit Total: | 0.400 | Unit Total: | 0.250 | Unit Total: | 0.300 | Project Total Hours: | 0.000 |
| Units Ordered | Units Ordered | Units Ordered | Units Ordered | Project | |||
| Total Hours | 0 | Total Hours | 0 | Total Hours | 0 | Total Hours | 0 |
| End of Sheet |
&"-,Bold"&22NWN Value Added Services (VAS) Task Detail
&12&F &12&D
Section 3 Grid
| Department of General Services, Procurement Division | |||||||
| PC Goods Contracts | |||||||
| Attachment D - Section 3: Equipment Order Administration and Logistics | |||||||
| Creating a Customer Schedule for Staggered Delivery to multiple locations (per SOW) (Schedule Only) | Fraction of D&L (Hrs) | Creating a Customer Schedule for Staggered Delivery to single location (per SOW) (Schedule Only) | Fraction of D&L (Hrs) | Custom Installation Documentation | Fraction of D&L (Hrs) | Secure Cart Rental (Customer performs installation of Equipment, not included when Contractor performs installation) | Fraction of D&L (Hrs) |
| Assign Contractor team and meet with customer to discuss schedule needs and resource requirements. | Assign Contractor team and meet with customer to discuss schedule needs and resource requirements. | Meet with customer to identify critical information needed for custom installation documentation. | Computer equipment is placed on an Contractor-supplied 5’x 2’x 6’ rolling rack. Contractor to organize computers, pad and shrink wrap each rack for damage prevention. |
| 1.250 | |||||||
| Meet with customer to merge, communicate and manage all calendar and logistics into a proposed delivery schedule. | Meet with customer to merge, communicate and manage all calendar and logistics into a proposed delivery schedule. | Create sample documentation for customer review and approval. | After delivery, move rack into customer facility per customer's direction. | 0.250 | |||
| Review approved schedule and commit resources (personnel, vehicles, and equipment). Sort equipment and accessories. Remove dunnage as required by SOW. | Review approved schedule and commit resources (personnel, vehicles, and equipment). Sort equipment and accessories. Remove dunnage as required by SOW. | Print custom installation documentation for installation team. | Collect rack at customer facility and move to pick up locaiton, i.e., loading dock. | 0.250 | |||
| Generate required documents for receiving of equipment by customer at each location - includes, but not limited to, customer packing slips with serial #'s, location and contact information, & delivery instructions. | Generate required documents for receiving of equipment by customer at each location - includes, but not limited to, customer packing slips with serial #'s, location and contact information, & delivery instructions. | Organize printed installation documentation per location and installation date(s). | Note: All Racks are left on site with customer for customer use for approximately two weeks. Contractor will pick up all racks at a pre-scheduled date and time at no additional cost to customer. | Blank | |||
| Blank | Blank | Blank | Blank | Upon completion, scan installation documentation to network storage. | Blank | Blank | |
| Blank | Blank | Blank | Blank | Note: Coordination with state facilities, IT and asset management personnel is done to ensure efficient accounting of state assets. | Blank | Blank | Blank |
| Project Total Hours: | 0.000 | Project Total Hours: | 0.000 | Project Total Hours: | 0.000 | Unit Total: | 1.750 |
| Units Ordered | Project | Units Ordered | Project | Units Ordered | Project | Units Ordered | |
| Total Hours | 0 | Total Hours | 0 | Total Hours | 0 | Total Hours | 0 |
| End of Sheet |
&"-,Bold"&22NWN Value Added Services (VAS) Task Detail
&12&F &12&D
Section 4 Grid
| Department of General Services, Procurement Division | |||||||||||||||||||
| PC Goods Contracts | |||||||||||||||||||
| Attachment D - Section 4: On Site Deployment Services | |||||||||||||||||||
| Training per Customer Scope | Fraction of D&L (Hrs) | PC Implementation and Data migration between old and new system | Fraction of D&L (Hrs) | Custom Remote On-Site Coordination | Fraction of D&L (Hrs) | Add/Remove software as required from a computer | Fraction of D&L (Hrs) | Launch virus protection, update and scan | Fraction of D&L (Hrs) | Add peripherals as required via direct connect, scanners, printers, PDA's | Fraction of D&L (Hrs) | Move and place equipment to be re-purposed into storage or re-deployment at single customer location | Fraction of D&L (Hrs) | vPro provisioning via customer-supplied certificate on USB | Fraction of D&L (Hrs) | Configure Intel AMT USB key, install Intel SCS, integrate with MS AD and SCCM | Fraction of D&L (Hrs) | DOD wipe and certify computer | Fraction of D&L (Hrs) |
| Design, build and deliver one hour of training per unique customer requirements. | Login to the operating system (OS) with a temporary user account assigned by the customer. | 0.150 | Assign remote on-site Contractor personnel to assist the customer with daily on-site coordination and planning of equipment locations and implementation of the customer's custom installation schedule. Work with customer to organize daily work assignments and complete the validation of complete installation of equipment. Report work progress and escalate equipment replacement as needed. | At time of computer installation, login to customer computer with provided credentials. | 0.050 | At time of computer installation, login to customer computer with provided credentials. | 0.050 | At time of computer installation, attach up to three peripherals and test connections as required by customer. | 0.170 | At time of new computer installations, sort equipment to be recycled and equipment to be re-purposed. For re-purposed equipment, stage equipment in temporary on site storage per customer requirements. | 0.100 | At customer site, activate vPro AMT on one computer with provided USB key. Confirm activation with customer IT. | 0.167 | Assist the Customer with the setup and provisioning of AMT into the Active Directory and Microsoft SCCM per scope of work. | Perform wipe of data from internal storage device in computer equipment. | 0.250 | |||
| Blank | Blank | Initiate transfer of single user's data files to customer storage (1GB maximum). | 0.150 | Blank | Blank | Install/uninstall provided software on computer per customer requirements (up to three software programs). | 0.450 | Launch virus protection program and search for updates. Launch Quick Scan as required by customer. | 0.200 | Blank | Blank | Move re-purposed equipment to new installation locations on site at current location per customer requirements. | 0.150 | Blank | Blank | Blank | Blank | Scan manufacturer barcodes and customer property asset tag numbers into Contractor handheld scanner. | 0.050 |
| Blank | Blank | After new computer is installed, restore single user's data files to new computer. | 0.100 | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Create custom asset report for customer from exported asset report. Format into MS Excel format by sorting report by type of equipment, asset #, serial #, date of DOD wipe, date of delivery to recycler. | 0.050 |
| Blank | Blank | Validate successful migration with customer. | 0.100 | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank |
| Blank | Blank | Note: Customer requirements as detailed in SOW may require more than one-half hour of time to complete user data migration. | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | Blank | |
| Project Total Hours: | Unit Total: | 0.500 | Project Total Hours: | Unit Total: | 0.500 | Unit Total: | 0.250 | Unit Total: | 0.170 | Unit Total: | 0.250 | Unit Total: | 0.167 | Project Total Hours: | Unit Total: | 0.350 | |||
| Units Ordered | Project | Units Ordered | Units Ordered | Project | Units Ordered | Units Ordered | Units Ordered | Units Ordered | Units Ordered | Units Ordered | Project | Units Ordered | |||||||
| Total Hours | 0 | Total Hours | 0 | Total Hours | 0 | Total Hours | 0 | Total Hours | 0 | Total Hours | 0 | Total Hours | 0 | Total Hours | 0 | Total Hours | 0 | Total Hours | 0 |
| End of Sheet |
&"-,Bold"&22NWN Value Added Services (VAS) Task Detail
&12&F &12&D
File details come from the government source that posted it. Updated .