2022 CWN MFSU Invoicing Revsied DLP_4.4.22.xlsx

XLSX spreadsheet 44 KB Posted

Attached to
USDA Forest Service National Interagency Fire Center (NIFC) - 2022 Call When Needed (CWN) Mobile Food Service Units (MFSU) Blanket Purchase Agreement (BPA)
Solicitation number
1202SC22Q2100
Issued by

View the file

Other files

Show all 14

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Instructions

GUIDANCE FOR CWN MOBILE FOOD SERVICES UNIT INVOICING (DATED 3/30/2022)
1. The contractor will utilize the provided Daily Blank (x) sheet to input the DAILY MEAL ORDER/INVOICE – MOBILE FOOD
SERVICES (Exhibits 5 / 5A / 5B / 5C) totals for each day in the invoice package. The Summary Sheet will total all the items from
each day to create a Summary sheet to be submitted for payment.
2. The areas in green are the only areas where the Contractor may input data. The other areas of each Daily or Summary sheet
are protected as they contain the formulas to calculate the item and daily totals. The bottom total in the orange box is the total
to be invoiced for each day and the Payment Total on the Summary sheet. The Payment Total is value the automated "bot" will
submit to IPP for payment.
3. The Contractor is required to use Exhibit 5 / 5A / 5B / 5C each day to create the Daily Meal Record that is signed by the
Government representative (generally a FDUL). This signed Daily Meal Record is used to complete the daily invoice
sheet that will be included for payment. The signed Daily Meal Record must be provided with the daily invoice sheet
as a .pdf, as evidence of the Government's acceptance of the Daily Meal Record.
4. The Contractor is required to email the Summary sheet including all Daily Blank (x) sheets and all supporting signed Daily
Meal Records every X days to the Finance Section email; Finance will submit to sm.fs.asc_eera@usda.gov to be processed
for payment.
6. NOTE: Exhibits 5 & 5A are for non-COVID related invoicing and Exhibits 5B & 5C are for COVID-related invoicing.
COVID-related means while under COVID Food Service precautions/guidelines. See Custom Clause #9 for more
information.
1. NICC shall contact all Mobile Retardant Base Contractors (see below for a list of all MRB contractors and 24 hour contact
information) to determine the current location of their suitable MRB that is closest to the needed location. The distance to the
incident will be determined using Google Maps and the shortest mileage distance from the current location of each MRB to the
address specified on the Resource Order. In the event Google Maps is not operable, the Government may use any other
method of determining the shortest mileage distance.
2. If a Contractor does not respond within one hour of being contacted, that Contractor may be eliminated from competition
for that particular order.
3. NICC shall perform a best value determination for all potential offerors, utilizing the following best value formula:
· (Input total actual mileage to and from the incident) x $ price/mile = total mileage
· 15 days x $ MRB price/day = total daily fee
· 1 relocation fee x $ price = total relocation fee
· 1 crew change out x $ price = total crew change out fee
· Put through Charges include the sum of all items below:
· 50,000 gals of First Tier x $ 0 – 50K price
· 25,000 gals of Second Tier x $ >50K price
· 10,000 gals of water x $ water price
4. The total summed value of this scenario will be compared to other offerors and the lowest total evaluated cost will be used
to determine the best value resource. NICC shall place the Resource Order with the MRB unit determined to be the best value.
5. NICC shall document the best value determination for each Resource Order specifying the results of the best value
determination for each Contractor and specifying the MRB selected for the order based on the best value determination.
6. NICC shall send the documented results of the Resource Order and best value determination to the Contracting Officer at the
time of placing the order – email to Larry.Robillard@usda.gov, telephone 208-387-5682.
7. The contractor is responsible for sending a copy of the Resource Order to the Contracting Officer within 3 days of accepting
the order.

Please note, the only cells in this spreadsheet you provide input are the mileage for each Contractor, highlighted in yellow.

Summary

Contractor:XYZ CompanyStarting Inv. No:2022 - 0001
Unit No.:CWN MFSU Unit XEnding Inv. No:2022 - 0007
Contract No.:12024B20T25XXInv. Start Date:1-Jun-22
Inv. End Date:7-Jun-22
Incident Name:Big Apple Fire
Incident Number:ID-PDF-000001
Resource No.:E-230
* Green fields to be filled by contractorJob Code:ABC-20-5600
SUB ITEMITEM DESCRIPTIONUNIT OF MEASUREPRICE PER UNITTOTAL QUANTITYTOTAL CALCULATED AMOUNT
101Hand Washing Unit RateDay$0.000$0.00
102Mileage RateMile$0.000$0.00
103Breakfast RateMeal$0.000$0.00
104Cold Can Breakfast RateMeal$0.000$0.00
105Sack Lunch RateMeal$0.000$0.00
106Dinner RateMeal$0.000$0.00
107MRE SupplementalMeal$0.000$0.00
108Relocation Fee RateMove$0.000$0.00
109Optnl. Box (brkfst/dinner)Each$8.000$0.00
109AOptnl. Cooler (brkfst/dinner)Meal$0.450$0.00
Supplemental Items
110Bottled Sports Type DrinkOunce$0.000$0.00
111Brewed CoffeeGallon$0.000$0.00
112Hot ChocolateGallon$0.000$0.00
113Tea (iced or hot)Gallon$0.000$0.00
114Bottled WaterOunce$0.000$0.00
115IcePound$0.000$0.00
116Ground CoffeePound$0.000$0.00
117Sandwiches MeatEach$0.000$0.00
118Sandwiches Non-MeatEach$0.000$0.00
119SoupGallon$0.000$0.00
120Addtnl. Refer Space/cu.ft.$0.000$0.00
121Addtnl. Tents & Seating/60 Pers.$0.000$0.00
Miscellaneous Charges and Credits$ - 0
Invoice Total$0.00
Sumbit complete invoice package to : Finance Section email or hand delivery
****Each email (invoice package) shall contain one Summary sheet and the supporting daily
sheets and corresponding, signed DAILY MEAL ORDER/INVOICE – MOBILE FOOD
SERVICES (Exhibit 5 / 5A / 5B / 5C) attached, for that payment package.****

D1

Contractor:XYZ CompanyDaily Inv. No:2022 - 0001
Unit No.:CWN MFSU Unit XInvoice Date:1-Jun-22
Contract No.:12024B20T25XXIncident Name:Big Apple Fire
Incident Number:ID-PDF-000001
Resource No.:E-230
* Green fields to be filled by contractorJob Code:ABC-20-5600
SUB ITEMITEM DESCRIPTIONUNIT OF MEASUREPRICE PER UNITDAILY QUANTITYTOTAL CALCULATED AMOUNT
101Hand Washing Unit RateDay$0.00$0.00
102Mileage RateMile$0.00$0.00
103Breakfast RateMeal$0.00$0.00
104Cold Can Breakfast RateMeal$0.00$0.00
105Sack Lunch RateMeal$0.00$0.00
106Dinner RateMeal$0.00$0.00
107MRE SupplementalMeal$0.00$0.00
108Relocation Fee RateMove$0.00$0.00
109Optnl. Box (brkfst/dinner)Each$8.00$0.00
109AOptnl. Cooler (brkfst/dinner)Meal$0.45$0.00
Supplemental Items
110Bottled Sports Type DrinkOunce$0.00$0.00
111Brewed CoffeeGallon$0.00$0.00
112Hot ChocolateGallon$0.00$0.00
113Tea (iced or hot)Gallon$0.00$0.00
114Bottled WaterOunce$0.00$0.00
115IcePound$0.00$0.00
116Ground CoffeePound$0.00$0.00
117Sandwiches MeatEach$0.00$0.00
118Sandwiches Non-MeatEach$0.00$0.00
119SoupGallon$0.00$0.00
120Addtnl. Refer Space/cu.ft.$0.00$0.00
121Addtnl. Tents & Seating/60 Pers.$0.00$0.00
Miscellaneous Charges and Credits$0.00
Total Daily Amount:$0.00

D2

Contractor:XYZ CompanyDaily Inv. No:2022 - 0002
Unit No.:CWN MFSU Unit XInvoice Date:2-Jun-22
Contract No.:12024B20T25XXIncident Name:Big Apple Fire
Incident Number:ID-PDF-000001
Resource No.:E-230
* Green fields to be filled by contractorJob Code:ABC-20-5600
SUB ITEMITEM DESCRIPTIONUNIT OF MEASUREPRICE PER UNITDAILY QUANTITYTOTAL CALCULATED AMOUNT
101Hand Washing Unit RateDay$0.00$0.00
102Mileage RateMile$0.00$0.00
103Breakfast RateMeal$0.00$0.00
104Cold Can Breakfast RateMeal$0.00$0.00
105Sack Lunch RateMeal$0.00$0.00
106Dinner RateMeal$0.00$0.00
107MRE SupplementalMeal$0.00$0.00
108Relocation Fee RateMove$0.00$0.00
109Optnl. Box (brkfst/dinner)Each$8.00$0.00
109AOptnl. Cooler (brkfst/dinner)Meal$0.45$0.00
Supplemental Items
110Bottled Sports Type DrinkOunce$0.00$0.00
111Brewed CoffeeGallon$0.00$0.00
112Hot ChocolateGallon$0.00$0.00
113Tea (iced or hot)Gallon$0.00$0.00
114Bottled WaterOunce$0.00$0.00
115IcePound$0.00$0.00
116Ground CoffeePound$0.00$0.00
117Sandwiches MeatEach$0.00$0.00
118Sandwiches Non-MeatEach$0.00$0.00
119SoupGallon$0.00$0.00
120Addtnl. Refer Space/cu.ft.$0.00$0.00
121Addtnl. Tents & Seating/60 Pers.$0.00$0.00
Miscellaneous Charges and Credits$0.00
Total Daily Amount:$0.00

D3

Contractor:XYZ CompanyDaily Inv. No:2022 - 0003
Unit No.:CWN MFSU Unit XInvoice Date:3-Jun-22
Contract No.:12024B20T25XXIncident Name:Big Apple Fire
Incident Number:ID-PDF-000001
Resource No.:E-230
* Green fields to be filled by contractorJob Code:ABC-20-5600
SUB ITEMITEM DESCRIPTIONUNIT OF MEASUREPRICE PER UNITDAILY QUANTITYTOTAL CALCULATED AMOUNT
101Hand Washing Unit RateDay$0.00$0.00
102Mileage RateMile$0.00$0.00
103Breakfast RateMeal$0.00$0.00
104Cold Can Breakfast RateMeal$0.00$0.00
105Sack Lunch RateMeal$0.00$0.00
106Dinner RateMeal$0.00$0.00
107MRE SupplementalMeal$0.00$0.00
108Relocation Fee RateMove$0.00$0.00
109Optnl. Box (brkfst/dinner)Each$8.00$0.00
109AOptnl. Cooler (brkfst/dinner)Meal$0.45$0.00
Supplemental Items
110Bottled Sports Type DrinkOunce$0.00$0.00
111Brewed CoffeeGallon$0.00$0.00
112Hot ChocolateGallon$0.00$0.00
113Tea (iced or hot)Gallon$0.00$0.00
114Bottled WaterOunce$0.00$0.00
115IcePound$0.00$0.00
116Ground CoffeePound$0.00$0.00
117Sandwiches MeatEach$0.00$0.00
118Sandwiches Non-MeatEach$0.00$0.00
119SoupGallon$0.00$0.00
120Addtnl. Refer Space/cu.ft.$0.00$0.00
121Addtnl. Tents & Seating/60 Pers.$0.00$0.00
Miscellaneous Charges and Credits$0.00
Total Daily Amount:$0.00

D4

Contractor:XYZ CompanyDaily Inv. No:2022 - 0004
Unit No.:CWN MFSU Unit XInvoice Date:4-Jun-22
Contract No.:12024B20T25XXIncident Name:Big Apple Fire
Incident Number:ID-PDF-000001
Resource No.:E-230
* Green fields to be filled by contractorJob Code:ABC-20-5600
SUB ITEMITEM DESCRIPTIONUNIT OF MEASUREPRICE PER UNITDAILY QUANTITYTOTAL CALCULATED AMOUNT
101Hand Washing Unit RateDay$0.00$0.00
102Mileage RateMile$0.00$0.00
103Breakfast RateMeal$0.00$0.00
104Cold Can Breakfast RateMeal$0.00$0.00
105Sack Lunch RateMeal$0.00$0.00
106Dinner RateMeal$0.00$0.00
107MRE SupplementalMeal$0.00$0.00
108Relocation Fee RateMove$0.00$0.00
109Optnl. Box (brkfst/dinner)Each$8.00$0.00
109AOptnl. Cooler (brkfst/dinner)Meal$0.45$0.00
Supplemental Items
110Bottled Sports Type DrinkOunce$0.00$0.00
111Brewed CoffeeGallon$0.00$0.00
112Hot ChocolateGallon$0.00$0.00
113Tea (iced or hot)Gallon$0.00$0.00
114Bottled WaterOunce$0.00$0.00
115IcePound$0.00$0.00
116Ground CoffeePound$0.00$0.00
117Sandwiches MeatEach$0.00$0.00
118Sandwiches Non-MeatEach$0.00$0.00
119SoupGallon$0.00$0.00
120Addtnl. Refer Space/cu.ft.$0.00$0.00
121Addtnl. Tents & Seating/60 Pers.$0.00$0.00
Miscellaneous Charges and Credits$0.00
Total Daily Amount:$0.00

D5

Contractor:XYZ CompanyDaily Inv. No:2022 - 0005
Unit No.:CWN MFSU Unit XInvoice Date:5-Jun-22
Contract No.:12024B20T25XXIncident Name:Big Apple Fire
Incident Number:ID-PDF-000001
Resource No.:E-230
* Green fields to be filled by contractorJob Code:ABC-20-5600
SUB ITEMITEM DESCRIPTIONUNIT OF MEASUREPRICE PER UNITDAILY QUANTITYTOTAL CALCULATED AMOUNT
101Hand Washing Unit RateDay$0.00$0.00
102Mileage RateMile$0.00$0.00
103Breakfast RateMeal$0.00$0.00
104Cold Can Breakfast RateMeal$0.00$0.00
105Sack Lunch RateMeal$0.00$0.00
106Dinner RateMeal$0.00$0.00
107MRE SupplementalMeal$0.00$0.00
108Relocation Fee RateMove$0.00$0.00
109Optnl. Box (brkfst/dinner)Each$8.00$0.00
109AOptnl. Cooler (brkfst/dinner)Meal$0.45$0.00
Supplemental Items
110Bottled Sports Type DrinkOunce$0.00$0.00
111Brewed CoffeeGallon$0.00$0.00
112Hot ChocolateGallon$0.00$0.00
113Tea (iced or hot)Gallon$0.00$0.00
114Bottled WaterOunce$0.00$0.00
115IcePound$0.00$0.00
116Ground CoffeePound$0.00$0.00
117Sandwiches MeatEach$0.00$0.00
118Sandwiches Non-MeatEach$0.00$0.00
119SoupGallon$0.00$0.00
120Addtnl. Refer Space/cu.ft.$0.00$0.00
121Addtnl. Tents & Seating/60 Pers.$0.00$0.00
Miscellaneous Charges and Credits$0.00
Total Daily Amount:$0.00

D6

Contractor:XYZ CompanyDaily Inv. No:2022 - 0006
Unit No.:CWN MFSU Unit XInvoice Date:6-Jun-22
Contract No.:12024B20T25XXIncident Name:Big Apple Fire
Incident Number:ID-PDF-000001
Resource No.:E-230
* Green fields to be filled by contractorJob Code:ABC-20-5600
SUB ITEMITEM DESCRIPTIONUNIT OF MEASUREPRICE PER UNITDAILY QUANTITYTOTAL CALCULATED AMOUNT
101Hand Washing Unit RateDay$0.00$0.00
102Mileage RateMile$0.00$0.00
103Breakfast RateMeal$0.00$0.00
104Cold Can Breakfast RateMeal$0.00$0.00
105Sack Lunch RateMeal$0.00$0.00
106Dinner RateMeal$0.00$0.00
107MRE SupplementalMeal$0.00$0.00
108Relocation Fee RateMove$0.00$0.00
109Optnl. Box (brkfst/dinner)Each$8.00$0.00
109AOptnl. Cooler (brkfst/dinner)Meal$0.45$0.00
Supplemental Items
110Bottled Sports Type DrinkOunce$0.00$0.00
111Brewed CoffeeGallon$0.00$0.00
112Hot ChocolateGallon$0.00$0.00
113Tea (iced or hot)Gallon$0.00$0.00
114Bottled WaterOunce$0.00$0.00
115IcePound$0.00$0.00
116Ground CoffeePound$0.00$0.00
117Sandwiches MeatEach$0.00$0.00
118Sandwiches Non-MeatEach$0.00$0.00
119SoupGallon$0.00$0.00
120Addtnl. Refer Space/cu.ft.$0.00$0.00
121Addtnl. Tents & Seating/60 Pers.$0.00$0.00
Miscellaneous Charges and Credits$0.00
Total Daily Amount:$0.00

D7

Contractor:XYZ CompanyDaily Inv. No:2022 - 0007
Unit No.:CWN MFSU Unit XInvoice Date:7-Jun-22
Contract No.:12024B20T25XXIncident Name:Big Apple Fire
Incident Number:ID-PDF-000001
Resource No.:E-230
* Green fields to be filled by contractorJob Code:ABC-20-5600
SUB ITEMITEM DESCRIPTIONUNIT OF MEASUREPRICE PER UNITDAILY QUANTITYTOTAL CALCULATED AMOUNT
101Hand Washing Unit RateDay$0.00$0.00
102Mileage RateMile$0.00$0.00
103Breakfast RateMeal$0.00$0.00
104Cold Can Breakfast RateMeal$0.00$0.00
105Sack Lunch RateMeal$0.00$0.00
106Dinner RateMeal$0.00$0.00
107MRE SupplementalMeal$0.00$0.00
108Relocation Fee RateMove$0.00$0.00
109Optnl. Box (brkfst/dinner)Each$8.00$0.00
109AOptnl. Cooler (brkfst/dinner)Meal$0.45$0.00
Supplemental Items
110Bottled Sports Type DrinkOunce$0.00$0.00
111Brewed CoffeeGallon$0.00$0.00
112Hot ChocolateGallon$0.00$0.00
113Tea (iced or hot)Gallon$0.00$0.00
114Bottled WaterOunce$0.00$0.00
115IcePound$0.00$0.00
116Ground CoffeePound$0.00$0.00
117Sandwiches MeatEach$0.00$0.00
118Sandwiches Non-MeatEach$0.00$0.00
119SoupGallon$0.00$0.00
120Addtnl. Refer Space/cu.ft.$0.00$0.00
121Addtnl. Tents & Seating/60 Pers.$0.00$0.00
Miscellaneous Charges and Credits$0.00
Total Daily Amount:$0.00

Blank Copy Do Not Delete

Contractor:XYZ CompanyDaily Inv. No:2022 - 000X
Unit No.:CWN MFSU Unit XInvoice Date:1-Jun-22
Contract No.:12024B20T25XXIncident Name:Big Apple Fire
Incident Number:ID-PDF-000001
Resource No.:E-230
* Green fields to be filled by contractorJob Code:ABC-20-5600
SUB ITEMITEM DESCRIPTIONUNIT OF MEASUREPRICE PER UNITDAILY QUANTITYTOTAL CALCULATED AMOUNT
101Hand Washing Unit RateDay$0.00$0.00
102Mileage RateMile$0.00$0.00
103Breakfast RateMeal$0.00$0.00
104Cold Can Breakfast RateMeal$0.00$0.00
105Sack Lunch RateMeal$0.00$0.00
106Dinner RateMeal$0.00$0.00
107MRE SupplementalMeal$0.00$0.00
108Relocation Fee RateMove$0.00$0.00
109Optnl. Box (brkfst/dinner)Each$8.00$0.00
109AOptnl. Cooler (brkfst/dinner)Meal$0.45$0.00
Supplemental Items
110Bottled Sports Type DrinkOunce$0.00$0.00
111Brewed CoffeeGallon$0.00$0.00
112Hot ChocolateGallon$0.00$0.00
113Tea (iced or hot)Gallon$0.00$0.00
114Bottled WaterOunce$0.00$0.00
115IcePound$0.00$0.00
116Ground CoffeePound$0.00$0.00
117Sandwiches MeatEach$0.00$0.00
118Sandwiches Non-MeatEach$0.00$0.00
119SoupGallon$0.00$0.00
120Addtnl. Refer Space/cu.ft.$0.00$0.00
121Addtnl. Tents & Seating/60 Pers.$0.00$0.00
Miscellaneous Charges and Credits$0.00
Total Daily Amount:$0.00

File details come from the government source that posted it. Updated .