Amendment 0010 Attachment 2- Airlift VSM-WMS Template.xlsx
XLSX spreadsheet 24 KB Posted
- Solicitation number
- SPE300-20-R0001
View the file
Other files
Show all 43
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
Upload Ship from CAGE Ship to DODAAC Requisition Contract PIID LSN UOM Air Lift Request Qty (CS) Unit Cube Unit Weight Total Cost Ship Date Package Indicator Package Weight Package Length Package Width Package Height Accessorial Item Description Item Cube Item Weight Unit Cost On Hand Qty (CS) Due Out Qty (CS) Avail Qty (CS) Due In QTY (CS) On Ord Qty (CS) Due In Date Van # AMD (CS) Sales Last 30 Days (CS) Reason for Air Lift Request DLA Troop Support Comment SPV # Airwaybill No. Vendor Reference No. TAC
Sheet1
| Re-Auto Eval based on a new quote submission | |||
| BIT-C16-0012-PR-FT02-TC52-01 | 1 | Procurement | Auto solicitation processing is executed on an AIDC LTC_Project: |
1) RFx is Published
| 3) the Auto Eval flag is set to "Y". | PR-EXT-14272 | Solicitation is created | |
| Solicitation is Published. | To create a Contract, refer to the job aid on EBS Online Help (Long-Term Contracts (LTCs) - Creating and Maintaining Contracts via Spreadsheet Upload) |
To edit the Option Provision Date, refer to the job aid on EBS Online Help (Post-Award - Exercising a Term Option on a Contract)
| BIT-C16-0012-PR-FT02-TC52-02 | 2 | Procurement | No Quotes are submitted | |
| Change the solicitation submission deadline to the current system date. | Solicitation closing date is changed. | |||
| BIT-C16-0012-PR-FT02-TC52-03 | 3 | Procurement | Auto Evaluation processing is executed | |
| The Solicitation will drop for Buyer Assistance | The response is dropped for Manual Review. The Auto Eval flag on the Solicitation (BUS2200: BBP_PDHGP: ZZRR_AUTO_EVAL) is set to 'M' | |||
| BIT-C16-0012-PR-FT02-TC52-04 | 4 | Procurement | The Buyer (Purchasing Specialist) navigates to the Workload Screen in SRM Portal. |
Locate the Auto Evaluation Status field and the Auto Remarks fields for the RFx Display Solicitation by Clicking on the RFx PIIN PR-FRM-14713 The Buyer Workload screen is displayed
Auto Eval Status = Drop to Manual The RFx is displayed in SRM Portal
| BIT-C16-0012-PR-FT02-TC52-05 | 5 | Procurement | Copy and paste Text from embedded word file into the Auto Award Maintenance tray | PR-FRM-14300 | All text will be accepted and the formatting will remain. |
| BIT-C16-0012-PR-FT02-TC52-06 | 6 | Procurement | Expand the textbox to the you are able to view all lines. | The buyer is able to view all lines in the textbox | |
| BIT-C16-0012-PR-FT02-TC52-07 | 7 | Procurement | Submit a quote (via DIBBS), greater than the Price Reasonableness Threshold, on a Solicitation that received no quotes and has an Automatic Evaluation status (BUS2200: BBP_PDHSC: ZZAUTO_EVAL_STAT) of ‘M’. | Bid is entered successfully and can be viewed in SRM. | |
| BIT-C16-0012-PR-FT02-TC52-08 | 8 | Procurement | Re-Auto Evaluation processing is executed on the above solicitation with the following characteristics: |
1) The Auto Re-Evaluation flag is not ‘N’ or ‘F’.
2) An award has not been made.
| 3) The closing date has not passed the Re-Auto Evaluation Days (the Re-Auto Evaluation Days field - currently 90 based on quote validity days) plus the Solicitation Closing date is greater than or equal to the system date). | PR-EXT-14212 | The Re-Automatic Evaluation field is set to ‘Y’. | ||||
| BIT-C16-0012-PR-FT02-TC52-09 | 9 | Procurement | Automatic Evaluation processing is executed on the solicitation and has the Re-Automatic Evaluation flag set to 'Y'. | PR-EXT-14204 | The qualified quote passes all pricing and final edits criteria and an award is created. An Award abstract and form DD1155 are generated and stored as an attachment to the award in SRM | |
| BIT-C16-0012-PR-FT02-TC52-10 | 10 | Procurement | Make sure that Text placed in the 14300 tray is transferred to the top of the continuation page(page 2) of the DD1155 for the Award | The text placed in 14300 tray is transferred to the DD1155 Form for the Award | ||
| Buyer Assisted Award for a RFx that has dropped to Manual 'M' and Buyer selects a different Awardee. | ||||||
| BIT-C16-0012-PR-FT02-TC52-11 | 11 | Procurement | Auto solicitation processing is executed on an unsolicited EXTREQ: |
1) EXTREQ is not canceled
2) the Auto Solicitation field is set with a "Y".
3) the Auto Eval flag is set to "Y" PR-EXT-14272 Solicitation is created
PS_SETASIDE=N
Solicitation is Published.
| BIT-C16-0012-PR-FT02-TC52-12 | 12 | Procurement | Submit a quote (via DIBBS) with a total dollar value that is greater than the Price Reasonableness Threshold (BUS2202: BBP_PDHGP: TOTAL_VALUE) > PC1 (ZRRT_AE_CONFIG: ZZRR_EVAL_PRC_REAS_THRESH). | Bid is entered successfully and can be viewed in SRM. |
| BIT-C16-0012-PR-FT02-TC52-13 | 13 | Procurement | Submit a second quote (via DIBBS) with a total dollar value that is greater than the Price Reasonableness Threshold (BUS2202: BBP_PDHGP: TOTAL_VALUE) > PC1 (ZRRT_AE_CONFIG: ZZRR_EVAL_PRC_REAS_THRESH). | Bid is entered successfully and can be viewed in SRM. |
| BIT-C16-0012-PR-FT02-TC52-14 | 14 | Procurement | Change the solicitation closing date to the current system date. | Solicitation closing date is changed. |
| BIT-C16-0012-PR-FT02-TC52-15 | 15 | Procurement | Auto Evaluation processing is executed on the lowest quote where: |
1) the lowest quote is greater than the Price Reasonableness Threshold (BUS2202: BBP_PDHGP: TOTAL_VALUE) > PC1 (ZRRT_AE_CONFIG: ZZRR_EVAL_PRC_REAS_THRESH)
2) the percentage difference calculation between the low quote and the next lowest quote is greater than PC2 (ZRRT_AE_CONFIG: ZZRR_COMP_PRICE_PERCENT)%. (currently 25%) The response is dropped for Manual Review. The Auto Eval flag on the Solicitation (BUS2200: BBP_PDHGP: ZZRR_AUTO_EVAL) is set to 'M'.
The Auto Eval Reject Reason field on the Sol (BUS2200: BBP_PDHGP: ZZRR_AUTOEVAL_REJ) is set to 'MA' (Failed Auto Eval Pricing - no competition and no qualified history to establish price reasonableness (Manual)) BIT-C16-0012-PR-FT02-TC52-16 16 Procurement The Buyer (Purchasing Specialist) navigates to the Workload Screen in SRM Portal.
Locate the Auto Evaluation Status field and the Auto Remarks fields for the RFx
Display Solicitation by Clicking on the RFx PIIN PR-FRM-14713 The Buyer Workload screen is displayed
Auto Eval Status = Drop to Manual
Auto Remarks = NO - Failed Auto Pricing - no competition & no qualified history to establish price reasonableness (Manual)
The RFx is displayed in SRM Portal BIT-C16-0012-PR-FT02-TC52-17 17 Procurement Validate the Auto Eval Reject Reason and Auto Eval Status fields in the RFx header. Automated Evaluation Reject Reasons (BUS2200: BBP_PDHGP: ZZRR_AUTOEVAL_REJ) = MA
Automated Evaluation Status (BUS2202: BBP_PDHGP: ZZRR_AUTO_EVAL) = M.
| BIT-C16-0012-PR-FT02-TC52-18 | 18 | Procurement | For Solicitations which has dropped for buyer assistance (includes manual and second look drops), validate that the ‘Auto Maint’ button is available from the Solicitation (Bid Invitation) in the ‘Auto’ tab | PR-FRM-14300 | The "Auto Maint" button on the "Auto Tab" is present. |
| BIT-C16-0012-PR-FT02-TC52-19 | 19 | Procurement | Validate that the Price Reasonableness code drop down menu contains applicable domain values. | PR-FRM14300 | The drop down menu has applicable domain values. |
| BIT-C16-0012-PR-FT02-TC52-20 | 20 | Procurement | Choose an awardee from the drop-down on the Solicitation which has dropped for buyer assistance, but do not select a price reasonableness code and hit SAVE. | PR-FRM-14300 | A pop up message: “Error, you must input a price reasonableness code if selecting an awardee” will be displayed and the action cannot be completed. |
| BIT-C16-0012-PR-FT02-TC52-21 | 21 | Procurement | Validate that CAGEs who submitted a Bid Response (Quote) via DIBBS (web/EDI/Batch) (which have not been manually modified or input, zzquote_method does not contain M) are available for selection via a drop-down to include CAGE and Vendor name. | PR-FRM-14300 | Cages that submitted a Quote and have not been manually modified or input are present in the drop down. The drop down includes CAGE and Vendor name. |
| BIT-C16-0012-PR-FT02-TC52-22 | 22 | Procurement | Manually type in a CAGE CODE and Price Reason Code (do not select the drop down) | PR-FRM-14300 | You should not be permitted to manually type in a CAGE code, only selections from the drop down are permitted. |
| BIT-C16-0012-PR-FT02-TC52-23 | 23 | Procurement | Choose an Awardee and Price Reasonableness Code on a solicitation which has dropped for buyer assistance and then check the "Cancel" button. | PR-FRM-14300 | This will clear any entered/selected data and close the screen without saving any data. |
| BIT-C16-0012-PR-FT02-TC52-24 | 24 | Procurement | The KO selects an awardee different than the Auto Eval Suggested Awardee (BUS2200:BBP_PDHSC:ZZPGC_AWD_BUYER) from the awardee drop-down menu on a solicitation which has dropped for buyer assistance, complete a price reasonableness code, and hit the "SAVE" button. | PR-FRM-14300 | The Awardee CAGE and Price reasonableness code (BBP_PDHSC: ZZ_BUY_ASST _CAGE and BBP_PDHSC: ZZPRC_REAS_CD) are filled out and visible on the Auto Tab. The Auto Awardee indicator is set to ‘Y.’ The Auto Awardee Indicator (BUS2200: BBP_PDHSC: ZZAUTO_AWARD) is available in bbp_pd. |
| BIT-C16-0012-PR-FT02-TC52-25 | 25 | Procurement | Copy and paste. Text from embedded word file into the Auto Award Maintenance screen | PR-FRM-14300 | All text will be accepted and the formatting will remain. |
| BIT-C16-0012-PR-FT02-TC52-26 | 26 | Procurement | Expand the textbox to the you are able to view all lines. | The buyer is able to view all the text lines | |
| BIT-C16-0012-PR-FT02-TC52-27 | 27 | Procurement | Re-Automatic evaluation processing is executed on a solicitation that has the following characteristics: |
1) the Auto Awardee field (BBP_PDHSC: ZZAUTO_AWARD) is set to ‘Y’
2) An award has NOT been made (ZZAUTO_EVAL != ‘A’)
| 3) The Re-Auto Eval flag (ZZRE_AUTO_EVAL) does not equal ‘F’ or 'N'. | The Automated Award (BBP_PDHSC: ZZAUTO_AWARD) is set to ‘A’ (This will trigger the Automatic Evaluation logic, PR-EXT-14204, to make an award and create the follow-on award documents.) and the Re-Auto Eval flag (ZZRE_AUTO_EVAL) is set to ‘Y’. | ||||
| BIT-C16-0012-PR-FT02-TC52-28 | 28 | Procurement | Automatic Evaluation processing is executed on the solicitation. | The PIIN type field (BUS2201:BBP_PDHSC_ ZZPIIN_TYPE) is set to 'V'. BUS2201:BBP_PDHSC - ZZBEST_VALUE = 'Y'. An award is made. An Award abstract and form DD1155 are generated and stored as an attachment to the award in SRM. The buyer that chooses the awardee must be captured via this form (BUS2200: BBP_PDHSC: ZZBUY_ASST_PGCKO) so when the Auto PO is created in PR-EXT-14204, that buyer's PGC is applied to the award rather than the Auto KO PGC. | |
| BIT-C16-0012-PR-FT02-TC52-29 | 29 | Procurement | Click on the "Auto Maint" button on the "Auto Tab" for a solicitation that has a PO already created for it and view the 'Withdraw Small Business SetAside and Resolicit' checkbox. | The checkbox is grayed out and not available for selection. | |
| BIT-C16-0012-PR-FT02-TC52-30 | 30 | Procurement | Make sure that Text placed in the 14300 tray is transferred to the top of the continuation page(page 2) of the DD1155 | The text placed in 14300 tray is transferred to the DD1155 Form for the Award |
File details come from the government source that posted it. Updated .