B08_Attachment_2-_Price_Schedule_.xlsx
XLSX spreadsheet 228 KB Posted
- Attached to
- Vehicle Upfitting Federal contract opportunity
- Solicitation number
- 140L0625Q0047
About this file
This Excel spreadsheet is a comprehensive price schedule for vehicle orders across multiple Bureau of Land Management (BLM) districts, detailing vehicle procurement for fiscal year 2026. The document covers multiple vehicle classes (651, 653, 656) and includes extensive vehicle specifications for Ford F-250 SuperCrew Gas trucks and GM 3500 Diesel trucks, with orders spanning districts in Nevada, Oregon, California, Utah, Idaho, Colorado, Arizona, and Washington. Each vehicle order includes detailed information such as district identifiers, replacement vehicle information, funding sources, base pricing, options, and total vehicle costs, with most vehicles priced between $29,884 and $92,414.
The price schedule reveals a structured approach to vehicle replacement, with each order noting the specific district, replacement rationale (such as "Replaces I621121" or "New Purchase"), and associated financial tracking information. Vehicle options vary by district but commonly include features like canopy packages, shipping to contractor facilities, auxiliary fuel tanks, bed organizers, and specialized equipment like engine block heaters and reverse obstacle sensors. The document provides granular financial details including available funds, total vehicle funds, chassis costs, and any additional cost responsibilities for specific districts, demonstrating a methodical federal procurement process for fleet vehicle acquisition.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Sol_140L0625Q0047_Amd_0003.pdf | ||
| Sol_140L0625Q0047_Amd_0002.pdf | ||
| B08__Combined_Synopsis_and_Solicitation_0001.pdf | ||
| Sol_140L0625Q0047_Amd_0001.pdf | ||
| Sol_140L0625Q0047.pdf | ||
| B08_Attachment_3-_Past_Performance_Reference_Template.doc | DOC document | |
| B08__Combined_Synopsis_and_Solicitation.pdf | ||
| B08__Attachment_1_-_Specifications.docx | DOCX document |
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
Sheet4651
| Ao# | COST | Current Aval$ | NEED | |||||||||||||||||
| 1 | 21591 | 68255.7801783375 | ||||||||||||||||||
| 2 | 21592 | 68255.7801783375 | ||||||||||||||||||
| 3 | 22369 | 68255.7801783375 | ||||||||||||||||||
| 4 | 22388 | 65593.3164926952 | 71606 | |||||||||||||||||
| 5 | 22392 | 65593.3164926952 | 67269 | |||||||||||||||||
| 6 | 22393 | 69073.7995032746 | 67365 | |||||||||||||||||
| 7 | 22408 | 69073.7995032746 | 65859 | |||||||||||||||||
| 8 | 22409 | 69073.7995032746 | 75043 | |||||||||||||||||
| 9 | 22410 | 69073.7995032746 | 71902 | |||||||||||||||||
| 10 | 20642 | 29884.5207002519 | ||||||||||||||||||
| 11 | 22543 | 29884.5207002519 | ||||||||||||||||||
| 12 | 22544 | 29884.5207002519 | ||||||||||||||||||
| 13 | 22546 | 29884.5207002519 | ||||||||||||||||||
| 14 | 22547 | 29884.5207002519 | ||||||||||||||||||
| 15 | 22549 | 29884.5207002519 | ||||||||||||||||||
| 16 | 22385 | 68255.7801783375 | 69010 | |||||||||||||||||
| 17 | 22387 | 69073.7995032746 | 76684 | |||||||||||||||||
| 18 | NEEDED (17025) | 2413.07 | ||||||||||||||||||
| 19 | NEEDED (16034) | 2413.07 | ||||||||||||||||||
| 68255.7801783375 | 68255.7801783375 | 68255.7801783375 | 65593.3164926952 | 65593.3164926952 | 69073.7995032746 | 69073.7995032746 | 69073.7995032746 | 69073.7995032746 | 29884.5207002519 | 29884.5207002519 | 29884.5207002519 | 29884.5207002519 | 29884.5207002519 | 29884.5207002519 | 68255.7801783375 | 69073.7995032746 | 2413.07 | 2413.07 |
Sheet2653
| Ao# | COST | Current Aval$ | NEED | NOTE | |||||||||||||||||||||||||||||
| 1 | 21249 | $81,196.43 | 71736 | good | |||||||||||||||||||||||||||||
| 2 | 21593 | $82,889.62 | 55000 | $27,889.62 | NEW PURCH | ||||||||||||||||||||||||||||
| 3 | 22288 | $84,549.51 | 83172 | good | |||||||||||||||||||||||||||||
| 4 | 21628 | $79,577.78 | 80000 | good | |||||||||||||||||||||||||||||
| 5 | 21629 | $79,577.78 | 61373 | $18,204.78 | Conversion | ||||||||||||||||||||||||||||
| 6 | 21630 | $79,577.78 | 64468 | $15,109.78 | Conversion | $18,680.78 | 60897 | 3571 | 64468 | ||||||||||||||||||||||||
| 7 | 22294 | $82,889.62 | 81249 | good | |||||||||||||||||||||||||||||
| 8 | 22313 | $84,549.51 | 90899 | good | 85417 | 5482 | 90899 | ||||||||||||||||||||||||||
| 9 | 22347 | $84,549.51 | 72582 | $11,967.51 | 1510 done | 67100 | 5482 | 72582 | |||||||||||||||||||||||||
| 10 | 22346 | $84,549.51 | 74089 | $10,460.51 | 1510 done | 68607 | 5482 | 74089 | |||||||||||||||||||||||||
| 11 | 22395 | $78,533.96 | 74468 | $4,065.96 | 1510 done | ||||||||||||||||||||||||||||
| 12 | 22588 | $80,378.41 | 85468 | good | 50468 | 35000 | 85468 | ||||||||||||||||||||||||||
| 13 | 22594 | $92,414.90 | 94917 | good | 47917 | 47000 | 94917 | ||||||||||||||||||||||||||
| 14 | 22595 | $80,395.80 | 83000 | good | |||||||||||||||||||||||||||||
| 15 | 22659 | $81,196.43 | 85000 | good | |||||||||||||||||||||||||||||
| 16 | 22620 22626 | $81,196.43 | 83663 | good | |||||||||||||||||||||||||||||
| 17 | 22370 | $81,196.43 | 83594 | good | 59594 | 24000 | 83594 | ||||||||||||||||||||||||||
| 18 | 20648 | NPS | $79,418.66 | ||||||||||||||||||||||||||||||
| 19 | 20649 | NPS | $79,418.66 | ||||||||||||||||||||||||||||||
| 20 | 22545 | NPS | $79,418.66 | ||||||||||||||||||||||||||||||
| 21 | 22593 | NPS | $79,418.66 | ||||||||||||||||||||||||||||||
| 22 | 20669 | NPS | $79,418.66 | 88 | |||||||||||||||||||||||||||||
| 23 | 20657 | NPS | $79,418.66 | ||||||||||||||||||||||||||||||
| 24 | 22778 | $79,577.78 | 91370 | good | |||||||||||||||||||||||||||||
| 25 | 22779 | $79,577.78 | 88988 | good | |||||||||||||||||||||||||||||
| 26 | 22781 | $80,210.16 | 83000 | good | |||||||||||||||||||||||||||||
| 27 | 22782 | $80,210.16 | 83000 | good | |||||||||||||||||||||||||||||
| 28 | 22783 | $80,210.16 | 83000 | good | |||||||||||||||||||||||||||||
| 29 | 21127 | $77,530.30 | 79906 | good | |||||||||||||||||||||||||||||
| 30 | 21626 | $84,549.51 | 85000 | Good | |||||||||||||||||||||||||||||
| 31 | 21627 | $84,072.42 | 85000 | good | |||||||||||||||||||||||||||||
| $81,196.43 | $82,889.62 | $84,549.51 | $79,577.78 | $79,577.78 | $79,577.78 | $82,889.62 | $84,549.51 | $84,549.51 | $84,549.51 | $78,533.96 | $80,378.41 | $92,414.90 | $80,395.80 | $81,196.43 | $81,196.43 | $81,196.43 | $79,418.66 | $79,418.66 | $79,418.66 | $79,418.66 | $79,418.66 | $79,418.66 | $79,577.78 | $79,577.78 | $80,210.16 | $80,210.16 | $80,210.16 | $77,530.30 | $84,549.51 | $84,072.42 | |||
| 1 | AO 21249 BLM 653 Elko, NV Replaces I620355 | ||||||||||||||||||||||||||||||||
| 2 | AO 21593 BLM 653 Battle Mountain, NV Replaces new purchase | ||||||||||||||||||||||||||||||||
| 3 | AO 22288 BLM 653 Battle Mountain, NV Replaces I623685 | ||||||||||||||||||||||||||||||||
| 4 | AO 21628 BLM 653 Carson City, NV Replaces I623819 (165) | ||||||||||||||||||||||||||||||||
| 5 | AO 21629 BLM 653 Carson City, NV Replaces I620902 (196) | ||||||||||||||||||||||||||||||||
| 6 | AO 21630 BLM 653 Carson City, NV Replaces I623701 (196) | ||||||||||||||||||||||||||||||||
| 7 | AO 22294 BLM 653 Coeur D'Alene, ID Replaces I428567 | ||||||||||||||||||||||||||||||||
| 8 | AO 22313 BLM 653 Prineville, OR Replaces I622641 | ||||||||||||||||||||||||||||||||
| 9 | AO 22347 BLM 653 Prineville, OR Replaces I623093 | ||||||||||||||||||||||||||||||||
| 10 | AO 22346 BLM 653 Lakeview, OR Replaces I429353 | ||||||||||||||||||||||||||||||||
| 11 | AO 22395 BLM 653 Barstow, CA Replaces I621372 | ||||||||||||||||||||||||||||||||
| 12 | AO 22588 BLM 653 Grand Junction, CO Replaces I620199 (196) | ||||||||||||||||||||||||||||||||
| 13 | AO 22594 BLM 653 Hines, OR Replaces i429927 (196) | ||||||||||||||||||||||||||||||||
| 14 | AO 22595 BLM 653 Hines, OR Replaces NEW PURCHASE | ||||||||||||||||||||||||||||||||
| 15 | AO 22659 BLM 653 Spokane, WA Replaces NEW PURCHASE | ||||||||||||||||||||||||||||||||
| 16 | AO 22620 22626 BLM 653 Spokane, WA Replaces I623676 (159) | ||||||||||||||||||||||||||||||||
| 17 | AO 22370 BLM 653 Lakeview, OR Replaces I429431 (651) | ||||||||||||||||||||||||||||||||
| 18 | AO 22778 BLM 653 St. George, UT Replaces I620746 (652) | ||||||||||||||||||||||||||||||||
| 19 | AO 22779 BLM 653 St. George, UT Replaces I620736 (652) | ||||||||||||||||||||||||||||||||
| 20 | AO 22781 BLM 653 Medford, OR Replaces New Purchase | ||||||||||||||||||||||||||||||||
| 21 | AO 22782 BLM 653 Medford, OR Replaces New Purchase | ||||||||||||||||||||||||||||||||
| 22 | AO 22783 BLM 653 Medford, OR Replaces New Purchase | ||||||||||||||||||||||||||||||||
| 23 | AO 21127 BLM Ely, NV Replaces I620211 | ||||||||||||||||||||||||||||||||
| 24 | AO 21626 BLM Ely, NV Replaces NEW PURCHASE 1 OF 2 | ||||||||||||||||||||||||||||||||
| 25 | AO 21627 BLM Ely, NV Replaces NEW PURCHASE 2 OF 2 |
Sheet1
| AO# + Replacement | PR# | |||||||
| 651 | AREQ | |||||||
| 1 | AO 21591 BLM 651 Boise, ID Replaces I621121 (3for2 _1) | 40602983 | x | 0RX881 | 0RX881 | |||
| 2 | AO 21592 BLM 651 Boise, ID Replaces I621120 (3for2 _2) | 40602984 | x | 0RX882 | 0RX882 | |||
| 3 | AO 22369 BLM 651 Boise, ID Replaces I623134 | 40602985 | x | 0RX882 | 0RX883 | |||
| 4 | AO 22388 BLM 651 Boise, ID Replaces I621358 | NEED TO MAKE (same as 22392) | x | 0RX894 | 0RX894 | |||
| 5 | AO 22392 BLM 651 Boise, ID Replaces I621359 | 40602986 | x | 0RX884 | 0RX884 | |||
| 6 | AO 22393 BLM 651 Susanville, CA Replaces I621363 | 40602987 | x | 0RX885 | 0RX885 | |||
| 7 | AO 22408 BLM 651 Elderado Hills CA Replaces I621514 | 40602988 | x | 0RX888 | 0RX888 | |||
| 8 | AO 22409 BLM 651 Bishop, CA Replaces I621515 | 40602989 | x | 0RX890 | 0RX890 | |||
| 9 | AO 22410 BLM 651 Bakersfield, CA Replaces I621513 | 40603070 | x | 0RX891 | 0RX891 | |||
| 10 | AO 22385 BLM 651 Safford, AZ Replaces I620846 | 40603071 | x | 0RX892 | 0RX892 | |||
| 11 | AO 22387 BLM 651 Lake Havasu, AZ Replaces I621356 | 40603072 | x | 0RX893 | 0RX893 | |||
| 653 | 0RX816 | |||||||
| 1 | AO 21249 BLM 653 Elko, NV Replaces I620355 | 40603028 | x | 0RX816 | 0RX818 | |||
| 2 | AO 21593 BLM 653 Battle Mountain, NV Replaces new purchase | 40603029 | x | 0RX818 | 0RX819 | |||
| 3 | AO 22288 BLM 653 Battle Mountain, NV Replaces I623685 | 40603050 | x | 0RX819 | 0rx820 | |||
| 4 | AO 21628 BLM 653 Carson City, NV Replaces I623819 (165) | 40603051 | x | 0rx820 | 0RX821 | |||
| 5 | AO 21629 BLM 653 Carson City, NV Replaces I620902 (196) | 40603052 | x | 0RX821 | 0RX822 | |||
| 6 | AO 21630 BLM 653 Carson City, NV Replaces I623701 (196) | 40603053 | x | 0RX822 | 0RX823 | |||
| 7 | AO 22294 BLM 653 Coeur D'Alene, ID Replaces I428567 | 40603054 | x | 0RX823 | 0RX824 | |||
| 8 | AO 22313 BLM 653 Prineville, OR Replaces I622641 | 40603055 | x | 0RX824 | 0RX825 | |||
| 9 | AO 22347 BLM 653 Prineville, OR Replaces I623093 | 40603056 | x | 0RX825 | ORX826 | |||
| 10 | AO 22346 BLM 653 Lakeview, OR Replaces I429353 | 40603057 | x | ORX826 | 0RX827 | |||
| 11 | AO 22395 BLM 653 Barstow, CA Replaces I621372 | 40603058 | x | 0RX827 | 0RX828 | |||
| 12 | AO 22588 BLM 653 Grand Junction, CO Replaces I620199 (196) | 40603059 | x | 0RX828 | 0RX837 | |||
| 13 | AO 22594 BLM 653 Hines, OR Replaces i429927 (196) | 40603060 | x | 0RX837 | 0RX837 | |||
| 14 | AO 22595 BLM 653 Hines, OR Replaces NEW PURCHASE | 40603061 | x | 0RX837 | 0RX838 | |||
| 15 | AO 22659 BLM 653 Spokane, WA Replaces NEW PURCHASE | 40603062 | x | 0RX838 | 0RX839 | |||
| 16 | AO 22620 22626 BLM 653 Spokane, WA Replaces I623676 (159) | 40603063 | x | 0RX839 | 0RX841 | |||
| 17 | AO 22370 BLM 653 Lakeview, OR Replaces I429431 (651) | 40603064 | x | 0RX841 | 0RX843 | |||
| 18 | AO 22778 BLM 653 St. George, UT Replaces I620746 (652) | 40603065 | x | 0RX843 | 0RX848 | |||
| 19 | AO 22779 BLM 653 St. George, UT Replaces I620736 (652) | 40603066 | x | 0RX848 | 0RX851 | |||
| 20 | AO 22781 BLM 653 Medford, OR Replaces New Purchase | 40603067 | x | 0RX851 | 0RX852 | |||
| 21 | AO 22782 BLM 653 Medford, OR Replaces New Purchase | 40603068 | x | 0RX852 | 0RX852 | |||
| 22 | AO 22783 BLM 653 Medford, OR Replaces New Purchase | 40603069 | x | 0RX852 | 0RX864 | |||
| 23 | AO 21127 BLM Ely, NV Replaces I620211 | 40603080 | x | 0RX864 | 0RX865 | |||
| 24 | AO 21626 BLM Ely, NV Replaces NEW PURCHASE 1 OF 2 | 40603081 | x | 0RX865 | 0RX866 | |||
| 25 | AO 21627 BLM Ely, NV Replaces NEW PURCHASE 2 OF 2 | 40603082 | x | 0RX866 | 0RX789 | |||
| 670 | 0RX796 | |||||||
| 1 | AO 22097 BLM 670 Replaces I621925 | 0RX789 | 0RX801 | |||||
| 2 | AO 23322 BLM 670 Replaces I621084 | 0RX796 | NO AREQ | |||||
| 3 | AO 23323 BLM 670 Boise, ID Replaces New Purchase | 0RX801 | 0RW863 | |||||
| 657 | 0RW869 | |||||||
| 0RW863 | 0RW870 | |||||||
| 0RW869 | 0RW873 | |||||||
| 0RW870 | 0RW876 | |||||||
| 0RW873 | 0RW877 | |||||||
| 0RW876 | 0RW887 | |||||||
| 0RW877 | 0RW891 | |||||||
| 0RW887 | 0RW893 | |||||||
| 0RW891 | 0RW894 | |||||||
| 0RW893 | 0RW896 | |||||||
| 0RW894 | 0RW916 | |||||||
| 0RW896 | 0RW918 | |||||||
| 0RW916 | 0RW919 | |||||||
| 0RW918 | 0RW920 | |||||||
| 0RW919 | 0RW921 | |||||||
| 0RW920 | 0RW922 | |||||||
| 0RW921 | 0RW923 | |||||||
| 0RW922 | 0RW924 | |||||||
| 0RW923 | ||||||||
| 0RW924 | ||||||||
| AO 22251 BLM 661 Twin Falls, ID Replaces i622505 | 40566570 $153000 submitted W/ ATTACHMENTS | 140L3721A0001 | 140L3722F0126 | |||||
| AO 22253 BLM 661 Moab, UT Replaces i428504 | 40566571 $153000 submitted W/ ATTACHMENTS | 140L3721A0001 | 140L3722F0127 | |||||
| AO 22264 BLM 661 Rock Springs, WY Replaces i622617 | 40566573 $153000 submitted W/ ATTACHMENTS | 140L3721A0001 | 140L3722F0128 | |||||
| AO 22367 BLM 661 Elko, NV Replaces i429436 | 40566574 $153000 submitted need to add attahments | 140L3721A0001 | 140L3722F0129 | |||||
| AO 22011 NPS 661 Dinosaur, CO Replaces i512476 (662) | 40555392 | 140L3721A0001 | 140L3722F0005 | |||||
| AO 22012 NPS 661 Whiskeytown , CA Replaces i518848 | 40555393 | 140L3721A0001 | 140L3722F0006 |
| 651 | 1 | 2 | 3 |
| Vehicle Order | |||
| Vehicle Model | 2026 Ford F-250 SuperCrew Gas | 2026 Ford F-250 SuperCrew Gas | 2026 Ford F-250 SuperCrew Gas |
| State - District: | NM-ABD | AZ-GID | CA-NOD |
| Identifier #: | UTL-1532 | BC-4102 | BC-8117 |
| Selected Options |
jfitchne: jfitchne:
For Year 2, year 3, 4 etc..
Formula in cost columns needs to change to the correct column # (from table 11 on command option tab)
Column #1 Example should have the following:
Selected Options should show the standard equipment (NOT DISTRICT PAID OPTIONS) this differs for each class Total cost for standard options should be input into the Credit for Standard Options on ROW# 61
| Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | |
| Price: | $0.00 | $0.00 | $0.00 |
| 9.1 Canopy Package | 9.5 Shipping Vehicle to contractor Facility | 9.1 Canopy Package | |
| Price: | $0.00 | $0.00 | $0.00 |
| 9.2 In-Cab Inverter | END OF SELECTED OPTIONS | 9.2 In-Cab Inverter | |
| $0.00 | SHORT BOX Chassis | $0.00 | |
| 9.5 Shipping Vehicle to contractor Facility | 9.4 Bed Organizer | ||
| $0.00 | $0.00 | ||
| END OF SELECTED OPTIONS | 9.5 Shipping Vehicle to contractor Facility | ||
| SHORT BOX Chassis | $0.00 | ||
| END OF SELECTED OPTIONS | |||
| SHORT BOX Chassis | |||
| Total Vehicle Price: | $0.00 | $0.00 | $0.00 |
| Total for 651 Class: | $0.00 |
| 653 | ||||||||||||||||||||
| Vehicle Order | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| Vehicle Model | 2026 GM 3500 Diesel | 2026 GM3500 Diesel | 2026 GM3500 Diesel | 2026 GM3500 Diesel | 2026 GM3500 Diesel | 2026 GM3500 Diesel | 2026 GM3500 Diesel | 2026 GM3500 Diesel | 2026 GM3500 Diesel | 2026 GM3500 Diesel | 2026 GM3500 Diesel | 2026 GM3500 Diesel | 2026 GM3500 Diesel | 2026 GM3500 Diesel | 2026 GM3500 Diesel | 2026 GM3500 Diesel | 2026 GM3500 Diesel | 2026 GM3500 Diesel | 2026 GM3500 Diesel | 2026 GM3500 Diesel |
| State - District: | OR-LAD | NV-WID | NV-EKD | NV-CDD | NV-CCD | NV-BMD | MT-EMD | MT-EMD | NV-WID | OR-BUD | OR-VAD | OR-VAD | OR-VAD | UT-WDD | ID-CDD | OR-CBD | OR-CBD | OR-MED | CO-GJD | UT-GRD |
| Identifier #: | BC-7171 | BC-2123 | BC-1103 | BC-3108 | CAPT-30 | BC-6106 | UTL-2542 | UTL-2587 | BC-2126 | DV-2101 | BC-3122 | UTL-3504 | BC-3121 | UT-2520 | FT-4505 | BC-6103 | BC-6104 | BC-6104 | UTL-2512 | UTL-7521 |
| Selected Options |
jfitchne: jfitchne:
For Year 2, year 3, 4 etc..
Formula in cost columns needs to change to the correct column # (from table 11 on command option tab)
Column #1 Example should have the following:
Selected Options should show the standard equipment (NOT DISTRICT PAID OPTIONS) this differs for each class Total cost for standard options should be input into the Credit for Standard Options on ROW# 61
| Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | Base Cost for Section 1 through 8 | |
| Price: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| 9.5 Shipping Vehicle to contractor Facility | 9.5 Shipping Vehicle to contractor Facility | 9.1 Canopy Package | 9.1 Canopy Package | 9.5 Shipping Vehicle to contractor Facility | 9.5 Shipping Vehicle to contractor Facility | 9.3 Auxiliary Fuel Tank | 9.3 Auxiliary Fuel Tank | 9.5 Shipping Vehicle to contractor Facility | 9.3 Auxiliary Fuel Tank | 9.5 Shipping Vehicle to contractor Facility | 9.5 Shipping Vehicle to contractor Facility | 9.5 Shipping Vehicle to contractor Facility | 9.5 Shipping Vehicle to contractor Facility | 9.5 Shipping Vehicle to contractor Facility | 9.3 Auxiliary Fuel Tank | 9.3 Auxiliary Fuel Tank | 9.5 Shipping Vehicle to contractor Facility | 9.5 Shipping Vehicle to contractor Facility | 9.4 Bed Organizer | |
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | 9.5 Shipping Vehicle to contractor Facility | 9.5 Shipping Vehicle to contractor Facility | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | 9.5 Shipping Vehicle to contractor Facility | 9.5 Shipping Vehicle to contractor Facility | END OF SELECTED OPTIONS | 9.5 Shipping Vehicle to contractor Facility | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | 9.5 Shipping Vehicle to contractor Facility | 9.5 Shipping Vehicle to contractor Facility | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | 9.5 Shipping Vehicle to contractor Facility | |
| SHORT BOX Chassis | LONG BOX Chassis | $0.00 | $0.00 | LONG BOX Chassis | SHORT BOX Chassis | $0.00 | $0.00 | LONG BOX Chassis | $0.00 | SHORT BOX Chassis | SHORT BOX Chassis | SHORT BOX Chassis | SHORT BOX Chassis | SHORT BOX Chassis | $0.00 | $0.00 | SHORT BOX Chassis | LONG BOX Chassis | $0.00 | |
| END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | |||||||||||||
| LONG BOX Chassis | SHORT BOX Chassis | LONG BOX Chassis | LONG BOX Chassis | SHORT BOX Chassis | SHORT BOX Chassis | SHORT BOX Chassis | LONG BOX Chassis | |||||||||||||
| Total Vehicle Price: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Total for 653 Class: | $0.00 |
| 656 | 0 | 1 | 2 | 3 | 2 | 3 |
| *Agency: | BLM | BLM | BLM | BLM | NPS | BIA |
| *Agency Order Number: | EXAMPLE | 22151 | 22801 | 22802 | MANUALLY ENTER AO# | |
| Header: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| *District / Unit Name: | Idaho Falls District | Colorado State Office | West Desert District | West Desert District | ||
| Street Address: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| City/ST/Zip: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| State AFMO or Designee: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Fleet Manager: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Fire Program Contact: | ERROR:#REF! | Randy Jacks 970-216-8751 | ||||
| FBMS Information | ||||||
| PR Title: | 2021 BLM Class 656 Order | 2022 BLM Class 656 Order | 2022 BLM Class 656 Order | 2022 BLM Class 656 Order | 2022 NPS Class 656 Order | 2022 BIA Class 656 Order |
| Description: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Functional Location: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| UPC Code: | NOT APPLICABLE 656/657 | NOC WILL INPUT | NOC WILL INPUT | NOC WILL INPUT | ERROR:#REF! | ERROR:#REF! |
| Cost Estimate $: | NOT APPLICABLE 656/657 | $30,895.80 | $30,895.80 | $30,895.80 | ||
| Betterment PR # | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | ||
| Contract Number: | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | ||
| Purchase Order (PO): | NOT APPLICABLE 656/657 | |||||
| PO Date: | NOT APPLICABLE 656/657 | |||||
| Vendor Job Number: | NOT APPLICABLE 656/657 | |||||
| Other Vendor Number: | NOT APPLICABLE 656/657 | |||||
| Vendor Invoice #: | NOT APPLICABLE 656/657 | |||||
| FBMS Invoice #: | NOT APPLICABLE 656/657 | |||||
| Material Document #: | NOT APPLICABLE 656/657 | |||||
| Acceptance Date: | 11/5/21 | 6/13/22 | ||||
| AutoChoice PR #: | 12345678 | 40557525 | 40599653 | 40599654 | ||
| AutoChoice Requisition #: |
jfitchne: jfitchne:
| 1482y4 ???? ???? | 1482Y4 123-456 | 1482y4 1295 2151 | 1482Y4-2299-2801 | 1482Y4-2299-2802 | |||
| AutoChoice RPN #: | OPN344 | 0QT169 | RS375 | RS376 | |||
| New Asset/Equipment #: | 1405535 | ||||||
| Financial Information | |||||||
| Fund: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Functional Area: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Cost Center: | ERROR:#REF! | LLCO915000 | LLUTW00200 | LLUTW00200 | ERROR:#REF! | ERROR:#REF! | |
| WBS: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Commitment: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Replaced Vehicle Info | |||||||
| *Old License Plate (CLASS): | I123456 | I428931 (163) | New Purchase | New Purchase | |||
| Old Asset Equipment #: | N/A | 10050254 | N/A | N/A | |||
| Life Cycle: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Current Utilization: | 72000 | 61601 | N/A | N/A | |||
| Date of Utilization Report: | 11/5/19 | 10/22/21 | N/A | N/A | |||
| *Available Funds: |
jfitchne: jfitchne:
| F.O.R. + SALVAGE (FROM NOC WEBSITE) | $42,000.00 | $28,276.00 | $0.00 | $0.00 | |
| Date of Funds Report: | 10/21/21 | N/A | N/A | ||
| Funding | |||||
| Available Funds: |
jfitchne: jfitchne:
| F.O.R. + SALVAGE (FROM NOC WEBSITE) | $42,000.00 | $28,276.00 | $0.00 | $0.00 | |||
| 1510-18V (Base) | $0.00 | $2,619.00 | $32,000.00 | $32,000.00 | $0.00 | $0.00 | |
| Date | RECEIVED 11/2/21 | 8/29/22 | 8/29/22 | ||||
| 1510-18V (Options): | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Date: | |||||||
| 1510-18V (Additional): | $0.00 | $0.00 | $6,700.00 | $6,700.00 | $0.00 | $0.00 | |
| Date: | 10/27/22 | 10/27/22 | |||||
| 1510-18V (Additional): | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Date: | |||||||
| 1510-18V (Additional): | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Date: | |||||||
| Total Vehicle Funds: |
jfitchne: jfitchne:
| F.O.R. + SALVAGE + 1510-18V CONTRIBUTIONS | $42,000.00 | $30,895.00 | $38,700.00 | $38,700.00 | $0.00 | $0.00 |
| Credit For Standard Options: |
jfitchne: jfitchne:
THIS SHOULD EQUAL THE COST OF THE OPTIONS THAT ARE STANDARD FOR THE CLASS
EACH COLUMN SHOULD BE THE SAME $aumount FOR THIS ROW ON THE TAB
| $0.00 | $0.00 | $0.00 | $0.00 |
| Total Betterment Option Cost: |
jfitchne: jfitchne:
=SUM (OF ALL OPTIONS SELECTED, B76 THRU THE LAST OPTION)
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Chassis Cost STANDARD |
jfitchne: jfitchne:
From Drop Downs tab Needs to be updated annually Price changes frequently so to avoid changing entire spreadsheet manual input may be necessary here
ERROR:#REF! $30,895.00
jfitchne: jfitchne:
VendorFORD Model Year:2022 Model:EXPLORER Shipment Days:180 MPG(City/Hwy/Combined):20/27/23 g CO2/mile:386
Color:
YZ OXFORD WHITE 1
Base Price (A) 30,207.00 + Vehicle options:
AC2 AUX. REAR AIR CONDITIONING 0.00
E85 ETHANOL FLEXIBLE FUEL 0.00
EH ENGINE BLOCK HEATER, OEM 83.00
IE1 Increased Power Engine 1 0.00
PLG POWER LIFTGATE 0.00
SRS3 SIDE SUPPLEMENTAL RESTRAINT SYSTEM ROW 3 0.00
SYNC SYNC VOICE ACTIVATED COMMUNICATION SYSTEM 0.00
Total Vehicle options: (B) 83.00 = Sub-Total Unit Price (A+B) 30,290.00 Quantity (C) x 1 = Sub-Total Price (A+B)*C 30,290.00 + Order options:
Total Order options (D) 0.00 = Total Price (A+B)*C)+D 30,290.00 + GSA Surcharge 605.80
| = Total Selling Price $(F) 30,895.80 | $38,557.02 |
| jfitchne: Base Price (A) | 37,718.00 |
+ Vehicle options:
| AEB1 | AUTONOMOUS EMERGENCY BRAKING TO LOW SPEED | 0.00 |
| BSDS | BLIND SPOT DETECTION SYSTEM | 0.00 |
| BTCS | BLUETOOTH COMPATIBLE SYSTEM | 0.00 |
| EH | ENGINE BLOCK HEATER, OEM | 83.00 |
| FCAS | FORWARD COLLISION ALERT SYSTEM | 0.00 |
| IE1 | Increased Power Engine 1 | 0.00 |
| LDW | LANE DEPARTURE WARNING SYSTEM | 0.00 |
| PLG | POWER LIFTGATE | 0.00 |
| RCTA | REAR CROSS TRAFFIC ALERT | 0.00 |
| SRO | OEM REVERSE OBSTACLE SENSOR | 0.00 |
| SRS3 | SIDE SUPPLEMENTAL RESTRAINT SYSTEM ROW 3 | 0.00 |
| SYNC | SYNC VOICE ACTIVATED COMMUNICATION SYSTEM | 0.00 |
| Total Vehicle options: (B) | 83.00 | |
| = Sub-Total Unit Price (A+B) | 37,801.00 | |
| Quantity (C) | x 1 | |
| = Sub-Total Price (A+B)*C | 37,801.00 |
+ Order options:
| Total Order options (D) | 0.00 |
| = Total Price ((A+B)*C)+D | 37,801.00 |
| + GSA Surcharge | 756.02 |
| = Total Selling Price $(F) | 38,557.02 |
= Estimated Unit Selling Price $ (F/C) 38,557.02
| $38,557.02 | |
| jfitchne: Base Price (A) | 37,718.00 |
+ Vehicle options:
| AEB1 | AUTONOMOUS EMERGENCY BRAKING TO LOW SPEED | 0.00 |
| BSDS | BLIND SPOT DETECTION SYSTEM | 0.00 |
| BTCS | BLUETOOTH COMPATIBLE SYSTEM | 0.00 |
| EH | ENGINE BLOCK HEATER, OEM | 83.00 |
| FCAS | FORWARD COLLISION ALERT SYSTEM | 0.00 |
| IE1 | Increased Power Engine 1 | 0.00 |
| LDW | LANE DEPARTURE WARNING SYSTEM | 0.00 |
| PLG | POWER LIFTGATE | 0.00 |
| RCTA | REAR CROSS TRAFFIC ALERT | 0.00 |
| SRO | OEM REVERSE OBSTACLE SENSOR | 0.00 |
| SRS3 | SIDE SUPPLEMENTAL RESTRAINT SYSTEM ROW 3 | 0.00 |
| SYNC | SYNC VOICE ACTIVATED COMMUNICATION SYSTEM | 0.00 |
| Total Vehicle options: (B) | 83.00 | |
| = Sub-Total Unit Price (A+B) | 37,801.00 | |
| Quantity (C) | x 1 | |
| = Sub-Total Price (A+B)*C | 37,801.00 |
+ Order options:
| Total Order options (D) | 0.00 |
| = Total Price ((A+B)*C)+D | 37,801.00 |
| + GSA Surcharge | 756.02 |
| = Total Selling Price $(F) | 38,557.02 |
= Estimated Unit Selling Price $ (F/C) 38,557.02
EDIT COMMENT TO INSURE ACCURATE
jfitchne: jfitchne:
AREQ ADDITIONAL REQUIREMENTS 0.00
BLS BEDLINER, OEM SPRAY-ON 455.00
BTCS BLUETOOTH COMPATIBLE SYSTEM 0.00
CLMP CLEARANCE LAMPS 85.00
DALT DUAL ALTERNATORS, OEM 355.00
EH ENGINE BLOCK HEATER, OEM 85.00
RKE REMOTE KEYLESS ENTRY 0.00
RM EXTRA WIDE MIRRORS 178.00
SRO OEM REVERSE OBSTACLE SENSOR 268.00
VU VINYL UPHOLSTERY, FRONT AND REAR -708.00
Total Vehicle options: (B) 718.00 = Sub-Total Unit Price (A+B) 37,315.00 Quantity (C) x 1 = Sub-Total Price (A+B)*C 37,315.00 + Order options:
Total Order options (D) 0.00 = Total Price (A+B)*C)+D 37,315.00 + GSA Surcharge 746.30 = Total Selling Price $(F) 38,061.30 EDIT COMMENT TO INSURE ACCURATE jfitchne: jfitchne:
AREQ ADDITIONAL REQUIREMENTS 0.00
BLS BEDLINER, OEM SPRAY-ON 455.00
BTCS BLUETOOTH COMPATIBLE SYSTEM 0.00
CLMP CLEARANCE LAMPS 85.00
DALT DUAL ALTERNATORS, OEM 355.00
EH ENGINE BLOCK HEATER, OEM 85.00
RKE REMOTE KEYLESS ENTRY 0.00
RM EXTRA WIDE MIRRORS 178.00
SRO OEM REVERSE OBSTACLE SENSOR 268.00
VU VINYL UPHOLSTERY, FRONT AND REAR -708.00
Total Vehicle options: (B) 718.00 = Sub-Total Unit Price (A+B) 37,315.00 Quantity (C) x 1 = Sub-Total Price (A+B)*C 37,315.00 + Order options:
Total Order options (D) 0.00 = Total Price (A+B)*C)+D 37,315.00 + GSA Surcharge 746.30 = Total Selling Price $(F) 38,061.30 Chassis Cost NON STANDARD jfitchne: jfitchne:
Enter cost of chassis options that differ from the Standard, Example 1: if the standard is a Extended cab and a crew cab is selected the enter the difference in cost her.
| Example 2: if the standard is an 8 ft bed and a short bed is secleted enter the differance in cost here (negative $ amount) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Cost Unit Is Responsible For: |
jfitchne: jfitchne:
COST UNIT IS RESPONABLE FOR = CHASSIS OPTIONS THAT ARE NOT STANDARD + BETTERMENT OPTIONS THAT ARE NOT STANDARD
ADDITIONALLY, IF THE AVAILABEL FUNDS ARE NOT EQUAL OR GREATER THAN THE TOTAL VEHICLE COST AND THE VEHICLE HAS NOT MET ITS REPLACEMENT REQUIRMETN A BUYOUT IS NECESSARY TO MAKE UP THE DIFFERANCE.
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Balance For WCF Class: |
jfitchne: jfitchne:
IF THIS NUMER IS NEGATIVE AND THE VHEICLE HAS NOT MET REQUIRED REPLACEMENT THE THE UNIT MUST PROVIDE A 1510-18V
| TO COVER THE COST. | ERROR:#REF! | $0.00 | $142.98 | $142.98 | $0.00 | $0.00 | |
| Total Vehicle Cost: | ERROR:#REF! | $30,895.00 | $38,557.02 | $38,557.02 | $0.00 | $0.00 | |
| Vehicle Order | |||||||
| FEOS Order Date: | No FEOS 656 | No FEOS 656 | No FEOS 656 | INPUT MANUAL | INPUT MANUAL | ||
| Chassis: |
jfitchne: jfitchne:
| list is from command options tab (EDIT THERE IF NECESSARY) | Ram 3500 | SELECT CHASSIS | SELECT CHASSIS | SELECT CHASSIS | SELECT CHASSIS | SELECT CHASSIS | |
| New VIN: | 11111111111111 | 1FMSK8BB7NGB05435 | NOT YET ASSIGNED 10/22 | NOT YET ASSIGNED 10/22 | INPUT MANUAL | INPUT MANUAL | |
| Pump: |
jfitchne: jfitchne:
list is from command options tab (EDIT THERE IF NECESSARY)
| NOT APPLICABLE | NOT APPLICABLE | NOT APPLICABLE | NOT APPLICABLE | NOT APPLICABLE | NOT APPLICABLE | |
| State - District: | ERROR:#REF! | 656 N/A | 656 N/A | 656 N/A | INPUT MANUAL | INPUT MANUAL |
| Identifier #: | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 |
| Radio: | 656 N/A | 656 N/A | 656 N/A | INPUT MANUAL | INPUT MANUAL | |
| New License Plate: | I623456 | INPUT MANUAL | INPUT MANUAL | INPUT MANUAL | INPUT MANUAL | INPUT MANUAL |
| Selected Options |
jfitchne: jfitchne:
For Year 2, year 3, 4 etc..
Formula in cost columns needs to change to the correct column # (from table 11 on command option tab)
Column #1 Example should have the following:
Selected Options should show the standard equipment (NOT DISTRICT PAID OPTIONS) this differs for each class Total cost for standard options should be input into the Credit for Standard Options on ROW# 61 jfitchne: jfitchne:
F.O.R. + SALVAGE (FROM NOC WEBSITE)
jfitchne: jfitchne:
F.O.R. + SALVAGE (FROM NOC WEBSITE)
jfitchne: jfitchne:
F.O.R. + SALVAGE + 1510-18V CONTRIBUTIONS
jfitchne: jfitchne:
THIS SHOULD EQUAL THE COST OF THE OPTIONS THAT ARE STANDARD FOR THE CLASS
EACH COLUMN SHOULD BE THE SAME $aumount FOR THIS ROW ON THE TAB
=SUM (OF ALL OPTIONS SELECTED, B76 THRU THE LAST OPTION)
1482y4 ???? ????
jfitchne: jfitchne:
From Drop Downs tab Needs to be updated annually Price changes frequently so to avoid changing entire spreadsheet manual input may be necessary here jfitchne: jfitchne:
Enter cost of chassis options that differ from the Standard, Example 1: if the standard is a Extended cab and a crew cab is selected the enter the difference in cost her.
Example 2: if the standard is an 8 ft bed and a short bed is secleted enter the differance in cost here (negative $ amount) jfitchne: jfitchne:
VendorFORD Model Year:2022 Model:EXPLORER Shipment Days:180 MPG(City/Hwy/Combined):20/27/23 g CO2/mile:386
Color:
YZ OXFORD WHITE 1
Base Price (A) 30,207.00 + Vehicle options:
AC2 AUX. REAR AIR CONDITIONING 0.00
E85 ETHANOL FLEXIBLE FUEL 0.00
EH ENGINE BLOCK HEATER, OEM 83.00
IE1 Increased Power Engine 1 0.00
PLG POWER LIFTGATE 0.00
SRS3 SIDE SUPPLEMENTAL RESTRAINT SYSTEM ROW 3 0.00
SYNC SYNC VOICE ACTIVATED COMMUNICATION SYSTEM 0.00
Total Vehicle options: (B) 83.00 = Sub-Total Unit Price (A+B) 30,290.00 Quantity (C) x 1 = Sub-Total Price (A+B)*C 30,290.00 + Order options:
Total Order options (D) 0.00 = Total Price (A+B)*C)+D 30,290.00 + GSA Surcharge 605.80 = Total Selling Price $(F) 30,895.80 jfitchne: jfitchne:
COST UNIT IS RESPONABLE FOR = CHASSIS OPTIONS THAT ARE NOT STANDARD + BETTERMENT OPTIONS THAT ARE NOT STANDARD
ADDITIONALLY, IF THE AVAILABEL FUNDS ARE NOT EQUAL OR GREATER THAN THE TOTAL VEHICLE COST AND THE VEHICLE HAS NOT MET ITS REPLACEMENT REQUIRMETN A BUYOUT IS NECESSARY TO MAKE UP THE DIFFERANCE.
jfitchne: Base Price (A) 37,718.00 + Vehicle options:
| AEB1 | AUTONOMOUS EMERGENCY BRAKING TO LOW SPEED | 0.00 |
| BSDS | BLIND SPOT DETECTION SYSTEM | 0.00 |
| BTCS | BLUETOOTH COMPATIBLE SYSTEM | 0.00 |
| EH | ENGINE BLOCK HEATER, OEM | 83.00 |
| FCAS | FORWARD COLLISION ALERT SYSTEM | 0.00 |
| IE1 | Increased Power Engine 1 | 0.00 |
| LDW | LANE DEPARTURE WARNING SYSTEM | 0.00 |
| PLG | POWER LIFTGATE | 0.00 |
| RCTA | REAR CROSS TRAFFIC ALERT | 0.00 |
| SRO | OEM REVERSE OBSTACLE SENSOR | 0.00 |
| SRS3 | SIDE SUPPLEMENTAL RESTRAINT SYSTEM ROW 3 | 0.00 |
| SYNC | SYNC VOICE ACTIVATED COMMUNICATION SYSTEM | 0.00 |
| Total Vehicle options: (B) | 83.00 | |
| = Sub-Total Unit Price (A+B) | 37,801.00 | |
| Quantity (C) | x 1 | |
| = Sub-Total Price (A+B)*C | 37,801.00 |
+ Order options:
| Total Order options (D) | 0.00 |
| = Total Price ((A+B)*C)+D | 37,801.00 |
| + GSA Surcharge | 756.02 |
| = Total Selling Price $(F) | 38,557.02 |
= Estimated Unit Selling Price $ (F/C) 38,557.02
IF THIS NUMER IS NEGATIVE AND THE VHEICLE HAS NOT MET REQUIRED REPLACEMENT THE THE UNIT MUST PROVIDE A 1510-18V
TO COVER THE COST.
jfitchne: Base Price (A) 37,718.00 + Vehicle options:
| AEB1 | AUTONOMOUS EMERGENCY BRAKING TO LOW SPEED | 0.00 |
| BSDS | BLIND SPOT DETECTION SYSTEM | 0.00 |
| BTCS | BLUETOOTH COMPATIBLE SYSTEM | 0.00 |
| EH | ENGINE BLOCK HEATER, OEM | 83.00 |
| FCAS | FORWARD COLLISION ALERT SYSTEM | 0.00 |
| IE1 | Increased Power Engine 1 | 0.00 |
| LDW | LANE DEPARTURE WARNING SYSTEM | 0.00 |
| PLG | POWER LIFTGATE | 0.00 |
| RCTA | REAR CROSS TRAFFIC ALERT | 0.00 |
| SRO | OEM REVERSE OBSTACLE SENSOR | 0.00 |
| SRS3 | SIDE SUPPLEMENTAL RESTRAINT SYSTEM ROW 3 | 0.00 |
| SYNC | SYNC VOICE ACTIVATED COMMUNICATION SYSTEM | 0.00 |
| Total Vehicle options: (B) | 83.00 | |
| = Sub-Total Unit Price (A+B) | 37,801.00 | |
| Quantity (C) | x 1 | |
| = Sub-Total Price (A+B)*C | 37,801.00 |
+ Order options:
| Total Order options (D) | 0.00 |
| = Total Price ((A+B)*C)+D | 37,801.00 |
| + GSA Surcharge | 756.02 |
| = Total Selling Price $(F) | 38,557.02 |
= Estimated Unit Selling Price $ (F/C) 38,557.02
| Paint and Striping: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| STANDARD | ||||||
| Cost: | ||||||
| STANDARD | ||||||
| Cost: | ||||||
| STANDARD | ||||||
| Cost: | ||||||
| STANDARD | ||||||
| Cost: | ||||||
| STANDARD | ||||||
| Cost: | ||||||
| STANDARD | ||||||
| Cost: | ||||||
| STANDARD | ||||||
| Cost: | ||||||
| Option: | ||||||
| Cost: | ||||||
| Option: | ||||||
| Cost: | ||||||
| Option: | ||||||
| Cost: | ||||||
| Option: | ||||||
| Cost: | ||||||
| Option: | ||||||
| Cost: | ||||||
| Option: | ||||||
| Cost: | ||||||
| Option: | ||||||
| Cost: | ||||||
| Option: | ||||||
| Cost: | ||||||
| Option: | ||||||
| Cost: | ||||||
| Option: | ||||||
| Cost: | ||||||
| Option: | ||||||
| Cost: | ||||||
| Option: | ||||||
| Cost: | ||||||
| Option: | ||||||
| Cost: | ||||||
| Option: | ||||||
| Cost: | ||||||
| Option: | ||||||
| Cost: | ||||||
| Total Betterment Cost: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| NOTES | NOTES | NOTES | NOTES | NOTES | NOTES | NOTES |
| DEALERSHIP SELECTED | Western Slope Auto Company GRAND JCT CO 81505 9702430843 | Larry H Miller Ford, 1340 S. 500 W. Salt Lake, UT 84115 | Larry H Miller Ford, 1340 S. 500 W. Salt Lake, UT 84115 | |||
| CONTRATOR LOCATION/CODE | N/A | N/A | ||||
| DIRECTIONS: input info on each line starting at order initiation and ending at payment/acceptance. Insure that standard equipment is correct for the class. Enter the option equipment. PRINT FOLDER: Highlight rows starting at row 62 through end of notes and print selection. Fit to one page. Column A and Rows 1-10 will print (to change go to Page Layout <Print Titles) | Arrived 6/13/22 at dealer | |||||
| 600 Request | 600 Request | 600 Request | 600 Request | 600 Request | ||
| 1520-58 | 1520-58 | 1520-58 | 1520-58 | 1520-58 | ||
| 1510-18V Purchase | 1510-18V Purchase | 1510-18V Purchase | 1510-18V Purchase | 1510-18V Purchase | ||
| 1510-18V Options | 1510-18V additional funds 6700 | 1510-18V additional funds 6700 | 1510-18V Options | 1510-18V Options | ||
| Signed auto choice order | Signed auto choice order |
| 657 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 1 |
| *Agency: | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BIA |
| *Agency Order Number: | EXAMPLE | 22415 | 22406 | 22413 | 22405 | 21391 | 22403 | 22589 | 22590 | 22660 | 22683 | 22684 | 22685 | 22727 | 22728 | 22729 | 22730 | 22731 | 22752 | 22753 | 22784 | 22785 | 22791 | 22792 | 22793 | 22794 | 22796 | MANUALLY ENTER AO# |
| Header: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| *District / Unit Name: | Idaho Falls District | Color Country District | Southwest Fire & Aviation | Colorado River Distrct | Southern Nevada District | Billings FO | Southern Nevada District | Jackson FO | Wind River / Bighorn Basin District | Upper CO River Interagency Fire & Aviation | Lakeview District | Lakeview District | Lakeview District | High Desert District | High Desert District | High Desert District | High Desert District | High Desert District | Twin Falls District | Twin Falls District | Medford District | Medford District | Color Country District | Color Country District | Color Country District | Color Country District | Canyon Country District | |
| Street Address: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| City/ST/Zip: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| State AFMO or Designee: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Fleet Manager: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Fire Program Contact: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| FBMS Information | ||||||||||||||||||||||||||||
| PR Title: | 2021 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BLM Class 657 Order | 2022 BIA Class 657 Order |
| Description: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Functional Location: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| UPC Code: | NOT APPLICABLE 656/657 | ERROR:#REF! | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | ERROR:#REF! |
| Cost Estimate $: | NOT APPLICABLE 656/657 | $47,251.50 | $47,069.94 | $47,069.94 | $47,069.94 | $47,251.50 | $47,069.94 | $50,400.00 | $49,686.00 | $50,388.00 | $47,069.94 | $47,069.94 | $47,069.94 | $47,069.94 | $58,226.70 | $58,226.70 | $58,226.70 | $59,750.00 | $47,069.94 | $47,069.94 | $47,069.94 | $47,069.94 | $47,069.94 | $47,069.94 | $47,069.94 | $47,069.94 | $47,069.94 | |
| Betterment PR # | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | |
| Contract Number: | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | |
| Purchase Order (PO): | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | |
| PO Date: | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | |
| Vendor Job Number: | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | |
| Other Vendor Number: | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | |
| Vendor Invoice #: | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | |
| FBMS Invoice #: | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | |
| Material Document #: | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | NOT APPLICABLE 656/657 | |
| Acceptance Date: | 11/5/21 | 6/30/22 | 6/29/22 | 7/1/22 | June 13-23 2022 | 8/23/22 | June 13-23 2022 | |||||||||||||||||||||
| AutoChoice PR #: | 12345678 | 40559293 | 40559291 | PR 40559292 | PR 40559290 | PR 40559293 | PR 40559294 | 40599933 | 40599935 | 40599936 | 40600073 | 40600074 | 40600075 | 40600079 | 40600160 | 40600161 | 40600162 | 40600163 | 40600164 | 40600165 | 40600181 | 40600166 | 40600167 | 40600168 | 40600169 | 40600180 | ||
| AutoChoice Requisition #: |
jfitchne: jfitchne:
| 1482y4 ???? ???? | 1482Y4 123-456 | 1482y4 1306 2415 | 1482y4 1306 2406 | 1482y4 1306 2413 | 1482y4 1306 2405 | 1482y4 1306 2391 | 1482y4 1306 2403 | 1482Y4-2336-2589 | 1482Y4-2336-2590 | 1482Y4-2336-2660 | 1482Y4-2336-2683 | 1482Y4-2336-2684 | 1482Y4-2336-2685 | 1482Y4-2336-2728 | 1482Y4-2336-2729 | 1482Y4-2336-2730 | 1482Y4-2336-2731 | 1482Y4-2336-2752 | 1482Y4-2336-2753 | 1482Y4-2336-2784 | 1482Y4-2336-2785 | 1482Y4-2336-2791 | 1482Y4-2336-2792 | 1482Y4-2336-2793 | 1482Y4-2336-2794 | 1482Y4-2336-2796 | |||
| AutoChoice RPN #: | OPN344 | 0QT303 | 0QT301 | 0QT302 | 0QT300 | 0QT299 | 0QT304 | 0RW863 | 0RW869 | 0RW870 | 0RW873 | 0RW876 | 0RW877 | 0RW887 | 0RW891 | 0RW893 | 0RW894 | 0RW896 | 0RW916 | 0RW918 | 0RW919 | 0RW920 | 0RW921 | 0RW922 | 0RW923 | 0RW924 | |||
| New Asset/Equipment #: | 1405535 | ||||||||||||||||||||||||||||
| Financial Information | |||||||||||||||||||||||||||||
| Fund: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Functional Area: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Cost Center: | ERROR:#REF! | llutc00200 | ERROR:#REF! | ERROR:#REF! | LLNVS00540 | ERROR:#REF! | ERROR:#REF! | LLES913000 | LLWYR0014 | LLCOU01000 | LLORL00000 | LLORL00000 | LLORL00000 | LLWYD00140 | LLWYD00140 | LLWYD00140 | LLWYD00140 | LLWYD00140 | LLIDT004000 | LLIDT004000 | LLORM00000 | LLORM00000 | LLUTC00200 | LLUTC00200 | LLUTC00200 | LLUTC00200 | LLUTY00200 | ERROR:#REF! | |
| WBS: | ERROR:#REF! | LW.MV.6570000 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | LWMV06570000 | LWMV06570000 | LWMV06570000 | LWMV06570000 | LWMV06570000 | LWMV06570000 | LWMV06570000 | LWMV06570000 | LWMV06570000 | LWMV06570000 | LWMV06570000 | LWMV06570000 | LWMV06570000 | LWMV06570000 | ERROR:#REF! | |
| Commitment: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Replaced Vehicle Info | |||||||||||||||||||||||||||||
| *Old License Plate (CLASS): | I123456 | i621554 | I621205 | i621419 | I621196 | I621125 | I621195 | NEW PURCHASE | NEW PURCHASE | NEW PURCHASE | 4 for 1 2 of 4 | 4 for 1 3 of 4 | 4 for 1 4 of 4 | New Purchase | New Purchase | New Purchase | New Purchase | New Purchase | I621650 (165) | New Purchase | New Purchase | New Purchase | New Purchase | New Purchase | New Purchase | New Purchase | New Purchase | ||
| Old Asset Equipment #: | N/A | 10194694 | 10179020 | 10185841 | 10178940 | 10177120 | 10178939 | NOT APPLICABLE | NOT APPLICABLE | NOT APPLICABLE | 10003490 (4 for 1 669) | 10003490 (4 for 1 669) | 10003490 (4 for 1 669) | N/A | N/A | N/A | N/A | N/A | 10197865 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | ||
| Life Cycle: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| Current Utilization: | 72000 | 64547 | 63342 | 74541 | 60805 | 78406 | 70207 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 73433 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | ||
| Date of Utilization Report: | 11/5/19 | 11/1/21 | 11/1/21 | 11/1/21 | 11/1/21 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 10/1/22 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | ||||
| *Available Funds: |
jfitchne: jfitchne:
| F.O.R. + SALVAGE (FROM NOC WEBSITE) | $42,000.00 | $48,247.00 | $46,620.00 | $52,272.00 | $45,988.00 | $41,000.00 | $41,000.00 | $41,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $44,515.61 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Date of Funds Report: | 11/1/21 | 11/1/21 | 11/1/21 | 11/1/21 | 10/27/22 APPROXAMATE | 10/27/22 APPROXAMATE | 10/27/22 APPROXAMATE | 12/31/23 | |||||||||||||||
| Funding | |||||||||||||||||||||||
| Available Funds: |
jfitchne: jfitchne:
| F.O.R. + SALVAGE (FROM NOC WEBSITE) | $42,000.00 | $48,247.00 | $46,620.00 | $52,272.00 | $45,988.00 | $41,000.00 | $41,000.00 | $41,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $44,515.61 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||
| 1510-18V (Base) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $50,390.00 | $58,500.00 | $50,400.00 | $0.00 | $0.00 | $0.00 | $50,000.00 | $50,000.00 | $50,000.00 | $50,000.00 | $50,000.00 | $13,600.00 | $41,000.00 | $41,000.00 | $41,000.00 | $41,000.00 | $41,000.00 | $41,000.00 | $41,000.00 | $41,000.00 | $0.00 | ||
| Date | 09/01/22 | 10/31/22 | 8/2/22 | 8/2/22 | 8/2/22 | 8/2/22 | 8/2/22 | 8/2/22 | 12/31/22 | 8/22/22 | 8/22/22 | 8/22/22 | 8/29/22 | 8/29/22 | 8/29/22 | 8/29/22 | 8/29/22 | 1190000.00 | ||||||||||||
| 1510-18V (Options): | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Date: | ||||||||||||||||||||||||||||||
| 1510-18V (Additional): | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $8,110.00 | $0.00 | $9,350.00 | $17,500.00 | $17,500.00 | $17,500.00 | $0.00 | $8,500.00 | $8,500.00 | $8,500.00 | $9,750.00 | $17,500.00 | $17,500.00 | $17,500.00 | $18,750.00 | $18,750.00 | $18,750.00 | $18,750.00 | $17,500.00 | $0.00 | |||
| Date: | 10/31/22 | 10/31/22 | 10/31/22 | 10/31/22 | 10/31/22 | 10/31/2022 From AO 22727 | 10/31/2022 From AO 22727 | 10/31/2022 From AO 22727 | 10/31/2022 From AO 22727 | $0.00 | 10/31/22 | 10/31/22 | 10/31/22 | 10/31/22 | 10/31/22 | 10/31/22 | 10/31/22 | 10/31/22 | ||||||||||||
| 1510-18V (Additional): | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Date: | ||||||||||||||||||||||||||||||
| 1510-18V (Additional): | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Date: | ||||||||||||||||||||||||||||||
| Total Vehicle Funds: |
jfitchne: jfitchne:
| F.O.R. + SALVAGE + 1510-18V CONTRIBUTIONS | $42,000.00 | $48,247.00 | $46,620.00 | $52,272.00 | $45,988.00 | $0.00 | $0.00 | $58,500.00 | $58,500.00 | $59,750.00 | $58,500.00 | $58,500.00 | $58,500.00 | $0.00 | $58,500.00 | $58,500.00 | $58,500.00 | $59,750.00 | $58,115.61 | $58,500.00 | $58,500.00 | $41,000.00 | $41,000.00 | $41,000.00 | $59,750.00 | $59,750.00 | $58,500.00 | $0.00 |
| Credit For Standard Options: |
jfitchne: jfitchne:
THIS SHOULD EQUAL THE COST OF THE OPTIONS THAT ARE STANDARD FOR THE CLASS
EACH COLUMN SHOULD BE THE SAME $aumount FOR THIS ROW ON THE TAB
| $0.00 | $0.00 | $0.00 |
| Total Betterment Option Cost: |
jfitchne: jfitchne:
=SUM (OF ALL OPTIONS SELECTED, B76 THRU THE LAST OPTION)
| $0.00 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | $0.00 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
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 .