Price_Schedule.xlsx
XLSX spreadsheet 212 KB Posted
- Attached to
- Vehicle Upfitting Federal contract opportunity
- Solicitation number
- 140L0625Q0002
About this file
This document appears to be a pricing schedule for a federal contract opportunity to provide vehicle upfitting services. The document contains pricing details for various vehicle models and classes across various Bureau of Land Management (BLM) locations and districts. Key details include:
The federal contract opportunity solicitation number is 140L0625Q0002, the agency is the Department of the Interior Bureau of Land Management National Office, and the opportunity type is a Solicitation for vehicle upfitting services. The document provides pricing information for over 100 vehicle orders across BLM districts in several states, including Idaho, Colorado, Utah, and California. The pricing includes standard equipment, additional required equipment, and betterment/optional equipment. Total vehicle costs range from approximately $30,000 to $38,000 per unit. The document also includes financial, procurement, and asset tracking information for the vehicle orders.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Sol_140L0625Q0002_Amd_0002.pdf | ||
| Questions_and_Answers_0001.pdf | ||
| Price_Schedule_Amend_1_0001.xlsx | XLSX spreadsheet | |
| Sol_140L0625Q0002_Amd_0001.pdf | ||
| Past_Performance_Reference_Template.doc | DOC document | |
| Sol_140L0625Q0002.pdf | ||
| Specifications.pdf |
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 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 19 |
| *Agency: | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM |
| Vehicle Order | |||||||||||||||||
| 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
| STANDARD | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios |
| Cost: | $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 |
| STANDARD | 14.3 Emergency Lighting Option 2 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.3 Emergency Lighting Option 2 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 |
| Cost: | $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 |
| STANDARD | 14.4 Emergency Lighting Option 3* | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.4 Emergency Lighting Option 3* | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console |
| Cost: | $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 |
| STANDARD | 14.5 Floor Mounted Console | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.5 Floor Mounted Console | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections |
| Cost: | $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 |
| STANDARD | 14.6 Skid Plates/Impact Protections | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.6 Skid Plates/Impact Protections | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard |
| Cost: | $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 |
| STANDARD | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail |
| Cost: | $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 |
| STANDARD | 14.12.3 Low price Canopy ARE | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.12.3 Low price Canopy ARE | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter |
| Cost: | $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 |
| STANDARD | 14.13 In-Cab Inverter | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.13 In-Cab Inverter | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit |
| Cost: | $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 |
| Option: | 14.14 Cell Phone Signal Booster Kit | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.14 Cell Phone Signal Booster Kit | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable |
| Cost: | $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 |
| Option: | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 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 | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | 14.20 Prewire for Location Based Services/GPS Tracking Cable | END OF SELECTED OPTIONS | SHORT BOX Chassis | END OF SELECTED OPTIONS |
| Cost: | $0.00 | $0.00 | |||||||||||||||
| Option: | END OF SELECTED OPTIONS | ||||||||||||||||
| Cost: | |||||||||||||||||
| Option: | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | |||||||||||||||
| 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 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Total for 651 Class: | $0.00 |
| 653 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 |
| *Agency: | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM |
| Vehicle Order | |||||||||||||||
| 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
| STANDARD | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios |
| Cost: | ERROR:#REF! | $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 |
| STANDARD | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 |
| Cost: | ERROR:#REF! | $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 |
| STANDARD | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.4 Emergency Lighting Option 3* | 14.4 Emergency Lighting Option 3* | 14.4 Emergency Lighting Option 3* | 14.4 Emergency Lighting Option 3* | 14.4 Emergency Lighting Option 3* |
| Cost: | ERROR:#REF! | $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 |
| STANDARD | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console |
| Cost: | ERROR:#REF! | $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 |
| STANDARD | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections |
| Cost: | ERROR:#REF! | $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 |
| STANDARD | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 DELETE REAR CAB PROTECTION AND TIE DOWN RAIL | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 DELETE REAR CAB PROTECTION AND TIE DOWN RAIL | 14.9 DELETE REAR CAB PROTECTION AND TIE DOWN RAIL | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard |
| Cost: | ERROR:#REF! | $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 |
| Option: | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.12 Canopy Package* | 14.13 In-Cab Inverter | 14.12.3 Low price Canopy ARE | 14.12 Canopy Package* | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.12.3 Low price Canopy ARE | 14.12.3 Low price Canopy ARE | 14.12.3 Low price Canopy ARE | 14.12.3 Low price Canopy ARE | 14.12.3 Low price Canopy ARE |
| Cost: | ERROR:#REF! | $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 |
| Option: | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.12.1 Optional Canopy Rear Doors* | 14.14 Cell Phone Signal Booster Kit | 14.13 In-Cab Inverter | 14.12.1 Optional Canopy Rear Doors* | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter |
| Cost: | ERROR:#REF! | $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 |
| Option: | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.12.2 Optional Canopy Compartment BOTH SIDES* | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.14 Cell Phone Signal Booster Kit | 14.12.2 Optional Canopy Compartment BOTH SIDES* | 14.15 Auxiliary Fuel Tank* | 14.15 Auxiliary Fuel Tank* | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit |
| Cost: | ERROR:#REF! | $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 |
| Option: | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | 14.13 In-Cab Inverter | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.13 In-Cab Inverter | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | ||
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| Option: | 14.14 Cell Phone Signal Booster Kit | END OF SELECTED OPTIONS | 14.14 Cell Phone Signal Booster Kit | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | |||||||||
| Cost: | $0.00 | $0.00 | |||||||||||||
| Option: | 14.20 Prewire for Location Based Services/GPS Tracking Cable | END OF SELECTED OPTIONS | 14.20 Prewire for Location Based Services/GPS Tracking Cable | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | |||||||
| Cost: | $0.00 | $0.00 | |||||||||||||
| Option: | |||||||||||||||
| Cost: | |||||||||||||||
| Option: | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | |||||||||||||
| Cost: | |||||||||||||||
| Option: | |||||||||||||||
| Cost: | |||||||||||||||
| Option: | |||||||||||||||
| Cost: | |||||||||||||||
| Option: | |||||||||||||||
| Cost: | |||||||||||||||
| Option: | |||||||||||||||
| Cost: | |||||||||||||||
| Option: | |||||||||||||||
| Cost: | |||||||||||||||
| Option: | |||||||||||||||
| Cost: | |||||||||||||||
| Option: | |||||||||||||||
| Cost: | |||||||||||||||
| Total Betterment Cost: | ERROR:#REF! | $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: ERROR:#REF! $0.00
| 654 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| *Agency: | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM |
| Vehicle Order | ||||||||||
| 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
| STANDARD | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios |
| Cost: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| STANDARD | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 |
| Cost: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| STANDARD | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console |
| Cost: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| STANDARD | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.12.3 Low price Canopy ARE | 14.12.3 Low price Canopy ARE | 14.13 In-Cab Inverter | 14.12.3 Low price Canopy ARE | 14.13 In-Cab Inverter |
| Cost: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| STANDARD | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.14 Cell Phone Signal Booster Kit | 14.13 In-Cab Inverter | 14.14 Cell Phone Signal Booster Kit |
| Cost: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| STANDARD | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.14 Cell Phone Signal Booster Kit | 14.20 Prewire for Location Based Services/GPS Tracking Cable |
| Cost: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Option: | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | END OF SELECTED OPTIONS | 14.20 Prewire for Location Based Services/GPS Tracking Cable | END OF SELECTED OPTIONS |
| Cost: | $0.00 | $0.00 | $0.00 | |||||||
| Option: | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | |||||||
| Cost: | ||||||||||
| Total Betterment Cost: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Total for 654 Class: | $0.00 |
| 655 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| *Agency: | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM | BLM |
| Vehicle Order | ||||||||||
| 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
| STANDARD | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios |
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| STANDARD | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 | 14.3 Emergency Lighting Option 2 |
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| STANDARD | 14.5 Floor Mounted Console | 14.4 Emergency Lighting Option 3* | 14.4 Emergency Lighting Option 3* | 14.4 Emergency Lighting Option 3* | 14.4 Emergency Lighting Option 3* | 14.4 Emergency Lighting Option 3* | 14.4 Emergency Lighting Option 3* | 14.4 Emergency Lighting Option 3* | 14.4 Emergency Lighting Option 3* | 14.4 Emergency Lighting Option 3* |
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| STANDARD | 14.13 In-Cab Inverter | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console |
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| STANDARD | 14.14 Cell Phone Signal Booster Kit | 14.13 In-Cab Inverter* | 14.13 In-Cab Inverter* | 14.13 In-Cab Inverter* | 14.13 In-Cab Inverter* | 14.10 SUV Partition * | 14.10 SUV Partition * | 14.13 In-Cab Inverter* | 14.13 In-Cab Inverter* | 14.13 In-Cab Inverter* |
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| STANDARD | 14.18 Leveling Kit * | 14.14 Cell Phone Signal Booster Kit* | 14.14 Cell Phone Signal Booster Kit* | 14.14 Cell Phone Signal Booster Kit* | 14.14 Cell Phone Signal Booster Kit* | 14.11 SUV Security Drawer* | 14.13 In-Cab Inverter* | 14.14 Cell Phone Signal Booster Kit* | 14.14 Cell Phone Signal Booster Kit* | 14.14 Cell Phone Signal Booster Kit* |
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Option: | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.18 Leveling Kit * | 14.18 Leveling Kit * | 14.18 Leveling Kit * | 14.18 Leveling Kit * | 14.13 In-Cab Inverter* | 14.14 Cell Phone Signal Booster Kit* | 14.18 Leveling Kit * | 14.18 Leveling Kit * | 14.18 Leveling Kit * |
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Option: | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.14 Cell Phone Signal Booster Kit* | 14.18 Leveling Kit * | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | |
| Cost: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Option: | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | 14.18 Leveling Kit * | 14.20 Prewire for Location Based Services/GPS Tracking Cable | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | |
| Cost: | $0.00 | $0.00 | ||||||||
| Option: | 14.20 Prewire for Location Based Services/GPS Tracking Cable | END OF SELECTED OPTIONS | ||||||||
| Cost: | $0.00 | |||||||||
| Option: | END OF SELECTED OPTIONS | |||||||||
| Cost: | ||||||||||
| Total Betterment Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Total for 655 Class: | $0.00 |
| 658 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 19 | 20 | 21 | 22 | 23 | 24 |
| *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 |
| Vehicle Order | ||||||||||||||||||||||||
| 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
| STANDARD | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios | 14.1 Pre-Wire for Agency Radios |
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1.00 | $1.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| STANDARD | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 | 14.2 Emergency Lighting Option 1 |
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1.00 | $1.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| STANDARD | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console | 14.5 Floor Mounted Console |
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1.00 | $1.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| STANDARD | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections | 14.6 Skid Plates/Impact Protections |
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1.00 | $1.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| STANDARD | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard | 14.7 Heavy Duty Front Bumper with Brush Guard |
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1.00 | $1.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| STANDARD | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail | 14.9 Rear Cab Protection & Tie-Down Rail |
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1.00 | $1.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| STANDARD | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter | 14.13 In-Cab Inverter |
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1.00 | $1.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| STANDARD | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit* | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit* | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit* | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit | 14.14 Cell Phone Signal Booster Kit |
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1.00 | $1.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| STANDARD | 14.17 Fire Ember Protection* | 14.18 Leveling Kit * | 14.15 Auxiliary Fuel Tank* | 14.18 Leveling Kit * | 14.15 Auxiliary Fuel Tank* | 14.15 Auxiliary Fuel Tank* | 14.15 Auxiliary Fuel Tank* | 14.15 Auxiliary Fuel Tank* | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.18 Leveling Kit * | 14.15 Auxiliary Fuel Tank* | 14.18 Leveling Kit * | 14.15 Auxiliary Fuel Tank* | 14.15 Auxiliary Fuel Tank* | 14.18 Leveling Kit * | 14.15 Auxiliary Fuel Tank* | 14.15 Auxiliary Fuel Tank* | 14.18 Leveling Kit * | 14.18 Leveling Kit * | 14.18 Leveling Kit * | 14.18 Leveling Kit * | 14.18 Leveling Kit * | 14.18 Leveling Kit * | 14.18 Leveling Kit * |
| Cost: | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#REF! | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Option: | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.18 Leveling Kit * | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.18 Leveling Kit * | 14.18 Leveling Kit * | 14.18 Leveling Kit * | 14.24 Spray on bed liner | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.18 Leveling Kit * | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.18 Leveling Kit * | 14.17 Fire Ember Protection* | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.18 Leveling Kit * | 14.18 Leveling Kit * | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable |
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1.00 | $1.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Option: | 14.24 Spray on bed liner | 14.24 Spray on bed liner | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.24 Spray on bed liner | 14.24 Spray on bed liner | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.26 Wheel Chocks | 14.24 Spray on bed liner | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.24 Spray on bed liner | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.18 Leveling Kit * | 14.24 Spray on bed liner | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.24 Spray on bed liner | 14.24 Spray on bed liner | 14.24 Spray on bed liner | 14.24 Spray on bed liner | 14.24 Spray on bed liner | 14.24 Spray on bed liner | 14.24 Spray on bed liner |
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1.00 | $1.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Option: | 14.26 Wheel Chocks | 14.26 Wheel Chocks | 14.24 Spray on bed liner | 14.26 Wheel Chocks | 14.26 Wheel Chocks | 14.24 Spray on bed liner | 14.24 Spray on bed liner | 14.24 Spray on bed liner | 14.26 Wheel Chocks | 14.24 Spray on bed liner | 14.26 Wheel Chocks | 14.24 Spray on bed liner | 14.20 Prewire for Location Based Services/GPS Tracking Cable | 14.26 Wheel Chocks | 14.24 Spray on bed liner | 14.24 Spray on bed liner | 14.26 Wheel Chocks | 14.26 Wheel Chocks | 14.26 Wheel Chocks | 14.26 Wheel Chocks | 14.26 Wheel Chocks | 14.26 Wheel Chocks | 14.26 Wheel Chocks | |
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1.00 | $1.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Option: | SIN 147 Crew Cab Chassis | END OF SELECTED OPTIONS | 14.26 Wheel Chocks | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | 14.26 Wheel Chocks | 14.26 Wheel Chocks | 14.26 Wheel Chocks | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | 14.26 Wheel Chocks | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | END OF SELECTED OPTIONS | 14.26 Wheel Chocks | 14.26 Wheel Chocks | 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 |
| Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||
| Option: | 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 | |||||||||||||||||
| Cost: | ||||||||||||||||||||||||
| Total Betterment Cost: | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#REF! | ERROR:#REF! | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| AC | AC | AC | AC | AC | ||||||||||||||||||||
| Total For 658 Class: | $0.00 |
Higbee, Brent W: Higbee, Brent W:
AutoChoice Selection:
SIN 88C Exteded Cab F350 w/ Utility Bed 115v- Outlet AT- All Terrain Tires ATC Automatic Traction controle BAT2 Dual Batt (included) CBU Camera B/U CNS Cosignee Delivery CR- Cruse CTB- Trailer Brake Controller D7- Towing MT ratio DALT- Dual Alternators DTG Dark tint glass EH- Engine Block Heater INCLUDED FB20- Bio Diesel Compatible INCLUDED OLS Oil Life system PWL- Power Windows Locks RH4V Class IV hitch
RKE - REMOTE KEYLESS ENTRY
RM -Extra Wide MIRRORS RSNC NO Console
SIAB - SIDE SUPPLEMENTAL RESTRAINT SYSTEM, ROW1
SYNC- SYNC COMO SYSTEM
SZ- Snow Plow Prep Package tES engine shutdown timer ULCR- Long Horizontal Compartment CURB SIDE UTC- Spare tire carrier in load bed WR- Increased GVWR
YD - DIESEL ENGINE
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
| 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 |
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 .