PenaltyCalculationExample.xlsx
XLSX spreadsheet 11 KB Posted
- Attached to
- Landing Gear Collaborative Supply Chain Integration Federal contract opportunity
- Solicitation number
- SPRHA1-17-R-1234
About this file
This solicitation is for a Landing Gear Collaborative Supply Chain Integration contract to provide spare parts, maintenance, data, and testing services to the Department of the Air Force over a potential 10-year period. The contractor will supply landing gear spare parts for the Air Force and Defense Logistics Agency inventories, as well as perform forging die maintenance and provide technical data packages. The solicitation includes line items for Air Force and DLA spare parts, first article testing for specific national stock numbers, maintenance support, data deliverables, and test reports. Delivery locations and schedules will be determined on individual delivery orders. The solicitation was issued by the Department of the Air Force Materiel Command Lifecycle Management Center located at Hill Air Force Base.
Penalty Calculation Example
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| SPRHA117R1234_______0012.RTF | RTF text file | |
| LG_CSCI_Statements_16_November_2017.pdf | ||
| SPRHA117R1234_______0010.RTF | RTF text file | |
| SPRHA117R1234_______0010_SectionLAmd10.pdf | ||
| SPRHA117R1234_______0009.RTF | RTF text file | |
| SPRHA117R1234_______0008.RTF | RTF text file | |
| SPRHA117R1234_______0006.pdf | ||
| SPRHA117R1234_AMD_05.pdf | ||
| SPRHA117R1234_______0004.pdf | ||
| LGCSCITRDRFPAmendment4.pdf | ||
| PenaltyCalculationExample.xlsx | XLSX spreadsheet | |
| LGCSCITRDRFPAmendment4.pdf | ||
| SPRHA117R1234_______0004.pdf | ||
| Questions_and_Answers.pdf |
Show all 14
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Example
| Variables | Factors (as %) | Penalty | Penalty as Percent of Order Total | ||||
| Order Value | Order Qty | Delivered On-Time Qty | Days Late Delivery Completed | Days Late | Ratio | ||
| $ 1,000,000.00 | 1500 | 1200 | 42 | 0.1136365477 | 0.7155417528 | $ 4,747.80 | 0.47% |
| 500,000.00 | 750 | 750 | 0 | 0 | 0 | - 0 | 0.00% |
| 615,168.00 | 980 | 975 | 65 | 0.4820084641 | 0.0029154519 | 1,196.83 | 0.19% |
| 250,000.00 | 89 | 40 | 120 | 2.7457368394 | 3.2681282952 | 7,647.93 | 3.06% |
| 1,650,000.00 | 6450 | 5200 | 95 | 1.4511624222 | 0.6825200824 | 16,334.62 | 0.99% |
File details come from the government source that posted it. Updated .