Attachment C - Prevoyance Results.xlsx
XLSX spreadsheet 20 KB Posted
- Solicitation number
- 19FR6325R0001
- Issued by
-
Department of State US Embassy Paris
About this file
This document appears to be an attachment titled "Prevoyance Results.xlsx" that contains financial details related to a federal contract opportunity for the U.S. Embassy in France.
The key details are:
- The contract is for Health Insurance Services, including medical, maternity, disability and death benefits for locally employed staff, former employees, retirees of the U.S. government in France and their eligible dependents.
- The contract will be a fixed-price type contract with firm-fixed price task orders.
- The anticipated performance period is for a one-year period.
- All responsible sources may submit a quotation, which will be considered. The government may award the contract based on the initial offer without discussion.
- Contractors must be registered in the SAM database prior to submitting an offer.
- The opportunity is subject to FAR clause 52.229-12 on tax on certain foreign procurements.
- Electronic responses are allowed, and offers must be submitted prior to the response date and time.
- The federal agency involved is the U.S. Department of State, US Embassy Paris.
View the file
Other files
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
Feuil1
| Attachment C | |||||||||||||||||||||||||||||||||||||||||||||||||
| US EMBASSY FRANCE | |||||||||||||||||||||||||||||||||||||||||||||||||
| Deadline : May 2024 | |||||||||||||||||||||||||||||||||||||||||||||||||
| Detail: risk / contract | |||||||||||||||||||||||||||||||||||||||||||||||||
| Actual figures | 2022 | Actual figures | 2021 | Actual figures | 2020 | Actual figures | 2019 | Actual figures | 2018 | ||||||||||||||||||||||||||||||||||||||||
| Risks | Contracts Nb | Gross rates | Spending | Net rates | Spending | Balances | Net percentages | Gross rates | Spending | Net rates | Spending | Provisions | Charges | Balance | Net percentages | Gross rates | Spending | Net rates | Spending | Provisions | Charges | Balances | Net percentages | Gross rates | Spending | Net rates | Spending | Provisions | Charges | Balances | Net percentages | Gross rates | Spending | Net rates | Spending | Provisions | Charges | Balances | Net percentages | Gross rates | Spending | Net rates | Spending | Provisions | Charges | Balances | Net percentages | Gross rates | Spending |
| SICK LEAVE | 0LV9959 P | 7,906 | 1,028 | 6,878 | 0 | 6,878 | 0.00% | 7,686 | 999 | 6,687 | 0 | 0 | 0 | 6,687 | 0.00% | 7,953 | 1,034 | 6,919 | 0 | 0 | 0 | 6,919 | 0.00% | 8,039 | 1,045 | 6,994 | 0 | 0 | 0 | 6,994 | 0.00% | 7,832 | 1,018 | 6,814 | 0 | 0 | 0 | 6,814 | 0.00% | 7,788 | 1,013 | 6,775 | 0 | 0 | 0 | 6,775 | 0.00% | 47,204 | 6,137 |
| SICK LEAVE | 6009827 P | 41,429 | 5,386 | 36,043 | 5,328 | 30,715 | 14.78% | 40,594 | 5,277 | 35,317 | 20,387 | 77,991 | 98,378 | -63,061 | 278.56% | 43,182 | 5,614 | 37,568 | 19,026 | 0 | 19,026 | 18,542 | 50.64% | 40,978 | 5,327 | 35,651 | 92,691 | 94,525 | 187,216 | -151,565 | 525.14% | 35,175 | 4,573 | 30,602 | 31,573 | 0 | 31,573 | -971 | 103.17% | 37,855 | 4,921 | 32,934 | 0 | 0 | 0 | 32,934 | 0.00% | 239,213 | 31,098 |
| DEATH | 0LV9959 P | 50,605 | 6,579 | 44,026 | 43,995 | 31 | 99.93% | 49,190 | 6,395 | 42,795 | 0 | 0 | 0 | 42,795 | 0.00% | 50,899 | 6,617 | 44,282 | 131,888 | 0 | 131,888 | -87,606 | 297.84% | 51,447 | 6,688 | 44,759 | 0 | 0 | 0 | 44,759 | 0.00% | 50,396 | 6,551 | 43,845 | 0 | 0 | 0 | 43,845 | 0.00% | 50,032 | 6,504 | 43,528 | 0 | 0 | 0 | 43,528 | 0.00% | 302,569 | 39,334 |
| DEATH | 0LW7992 P | 0 | 0 | 0 | 0 | 0 | 0.00% | 0 | 0 | 0 | 41,288 | 0 | 41,288 | -41,288 | 0.00% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0 | 0 | 0 | 26,493 | 0 | 26,493 | -26,493 | 0.00% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0 | 0 |
| DEATH | 6009827 P | 11,428 | 1,486 | 9,942 | 0 | 9,942 | 0.00% | 11,198 | 1,456 | 9,742 | 0 | 0 | 0 | 9,742 | 0.00% | 11,912 | 1,549 | 10,363 | 0 | 0 | 0 | 10,363 | 0.00% | 11,304 | 1,470 | 9,834 | 0 | 0 | 0 | 9,834 | 0.00% | 17,835 | 2,319 | 15,516 | 0 | 0 | 0 | 15,516 | 0.00% | 19,228 | 2,500 | 16,728 | 0 | 0 | 0 | 16,728 | 0.00% | 82,905 | 10,780 |
| DEATH MAINTAINING | 0LV9959 P | 0 | 0 | 0 | 0 | 0 | 0.00% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0 | 0 |
| DEATH MAINTAINING | 6009827 P | 0 | 0 | 0 | 0 | 0 | 0.00% | 0 | 0 | 0 | 0 | 7,434 | 7,434 | -7,434 | 0.00% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0 | 0 | 0 | 0 | 3,374 | 3,374 | -3,374 | 0.00% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0 | 0 |
| Total | 111,368 | 14,479 | 96,889 | 49,323 | 47,566 | 50.91% | 108,668 | 14,127 | 94,541 | 61,675 | 85,425 | 147,100 | -52,559 | 155.59% | 113,946 | 14,814 | 99,132 | 150,914 | 0 | 150,914 | -51,782 | 152.24% | 111,768 | 14,530 | 97,238 | 119,184 | 97,899 | 217,083 | -119,845 | 223.25% | 111,238 | 14,461 | 96,777 | 31,573 | 0 | 31,573 | 65,204 | 32.62% | 114,903 | 14,938 | 99,965 | 0 | 0 | 0 | 99,965 | 0.00% | 671,891 | 87,349 |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .