Attachment T Aggregate Delivery Locations.xlsx

XLSX spreadsheet 19 KB Posted

Attached to
FNS Storage and Distribution Services Federal contract opportunity
Solicitation number
12-3198-25-R-0010
Issued by
Department of Agriculture Food and Nutrition Service

About this file

Written by GovTribe AI ·

This is an Excel spreadsheet attachment titled "Aggregate Delivery Locations" that provides detailed delivery and inventory data for a two-zone food distribution network. The data covers shipping locations, delivery frequencies, and inventory requirements across three temperature categories (Dry, Cooler, and Frozen).

Zone 1 contains 183 shipping sites and Zone 2 has 200 sites, with Zone 1 handling 54% of total outbound orders and Zone 2 handling 46%. Monthly delivery volumes include approximately 5.2M pounds dry goods, 370K pounds cooler items, and 291K pounds frozen products for Zone 1, while Zone 2 processes about 4.2M pounds dry goods, 289K pounds cooler items, and 417K pounds frozen products. The document specifies warehouse inventory minimums (based on 4-month estimates) and maximums (based on 6-month estimates) for each temperature category, measured in both cases and pallets. The data reflects deliveries from January 2023 through November 2024 and includes adjustments for FDPIR Guide Rate changes from September 2023 and June 2024.

View the file

Other files for this federal contract opportunity

Other files attached to FNS Storage and Distribution Services, newest first.
File Type Posted
Attachment K Performance Work Statement PWS revised.pdf PDF
12-3198-25-R-0010 Amend A00001.pdf PDF
Attachment X rev. Incentive and Penalties.xlsx XLSX spreadsheet
A00001 Questions and Answers.xlsx XLSX spreadsheet
Attachment A USDA CSFP Rev Max Month Distrib Rates.pdf PDF
Attachment F CSFP Factsheet.pdf PDF
Attachment S CSFP Foods Available List.xlsx XLSX spreadsheet
Attachment W Reporting Template with References.xlsx XLSX spreadsheet
SF1449 12-3198-25-R-0010.pdf PDF
Attachment H MAP for FDPIR - CSFP Zone and Program Locations.pdf PDF
Attachment I Detailed Zone Delivery Locations w Avg Volumes.xlsx XLSX spreadsheet
Attachment J Pricing Schedule.xlsx XLSX spreadsheet
Attachment L CSFP and FDPIR Food Package Descr.pdf PDF
Attachment M Nat Multifood Warehouse Interaction With WBSCM.pdf PDF
Attachment P Monthly Transportation Invoice.xlsx XLSX spreadsheet
Attachment R FDPIR Foods Available List.xlsx XLSX spreadsheet
ATTACHMENT Y Past Performance Questionnaire.docx DOCX document
Solicitation 12-3198-25-R-0010.pdf PDF
Attachment C USDA Foods Available List for CSF.pdf PDF
Attachment D USDA Foods Available List for FDP.pdf PDF
Attachment G TEFAP Factsheet.pdf PDF
Attachment K Performance Work Statement PWS.pdf PDF
Attachment O Bi-Monthly Storage Invoice.xlsx XLSX spreadsheet
Attachment Q Household Foods Shelf Life Guidelines.xlsx XLSX spreadsheet
Attachment U Summary of CSFP and FDPIR Orders.xlsx XLSX spreadsheet
Attachment V Temp Humidity Req.xlsx XLSX spreadsheet
Attachment Z Subcontracting Plan.pdf PDF
Attachment B USDA FDPIR Monthly Distribution G.pdf PDF
Attachment E FDPIR Factsheet.pdf PDF
Attachment N Bi-Monthly Transaction Handling Invoice.xlsx XLSX spreadsheet
Attachment X Incentives and Penalties.xlsx XLSX spreadsheet
Show all 31

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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

table

Zone# of Ship to SitesAvg. Deliveries per Month per SiteDry - Avg. Number of Material Codes per Month per SiteDry - Avg. Monthly Quantity Requested (Outbound), pounds (All Sites Total)Dry - Avg. Monthly Quantity Requested (Outbound), cases (All Sites Total)Cooler - Avg. Number of Material Codes per Month per SiteCooler - Avg. Monthly Quantity Requested (Outbound), pounds (All Sites Total)Cooler - Avg. Monthly Quantity Requested (Outbound), cases (All Sites Total)Frozen - Avg. Number of Material Codes per Month per SiteFrozen - Avg. Monthly Quantity Requested (Outbound), pounds (All Sites Total)Frozen - Avg. Monthly Quantity Requested (Outbound), cases (All Sites Total)% Share of National Total Outbound Orders% Share of National Dry Outbound Orders% Share of National Frozen Outbound Orders% Share of National Cooler Outbound OrdersDry - Avg. Monthly Quantity Replinished (Inbound), casesCooler - Avg. Monthly Quantity Replinished (Inbound), casesFrozen - Avg. Monthly Quantity Replinished (Inbound), casesDry - Avg. Monthly Quantity Replinished (Inbound), palletsCooler - Avg. Monthly Quantity Replinished (Inbound), palletsFrozen - Avg. Monthly Quantity Replinished (Inbound), palletsDry - WHSE Active Inventory Cases MinDry - WHSE Active Inventory Cases MaxCooler - WHSE Active Inventory Cases MinCooler - WHSE Active Inventory Cases MaxFrozen - WHSE Active Inventory Cases MinFrozen - WHSE Active Inventory Cases MaxDry - WHSE Active Inventory Pallets MinDry - WHSE Active Inventory Pallets MaxCooler - WHSE Active Inventory Pallets MinCooler - WHSE Active Inventory Pallets MaxFrozen - WHSE Active Inventory Pallets MinFrozen - WHSE Active Inventory Pallets Max
11830.914.85156872.5245134.90.8369596.515525.62291420.18995.45454.941.256.1231261.930149.9107049.33329.5398.12358.5934966140244910767816151735981.653972.413227.619841.41397.62096.4775.61163.4
22000.817.54241766.4199502.30.9288826.111711.82.9416671.812451.44645.158.843.9196654.425638.191029.82831.2338.52005.5750715.61126073.494139.2141208.849805.674708.410456.815685.21266.41899.61100.81651.2

additional_information

Data Nuances & Dislcaimers:
1. Columns labled as "Inbound" data represent incoming shipments to a distributor warehouse.
2. Inbound metrics represent estimates of Inbound volume based on the % of the National Outbound Shipments (columns N-P). (% of National Outbound Shipments * National Total for Inbound Shipments for each storage temp category).
3. Warehouse (WHSE) Active Inventory Minimums and Maximums represent the range of Inventory a distributor will require. The minimum is based off of a 4 month estimate of inventory, while the maximum is based off of a 6 month estimate of inventory.
4. This dataset is currently aggregated to the Zone level. To understand the number of Ship-to Parties/Program combinations that are active within each Zone, please refer to column B (# of Ship-to Sites).
5. This table does not include "Cancelled" orders EXCEPT for the "Avg. Cancelled Orders Per Month" column. For example, the "Avg Orders per Month" column does NOT include "Cancelled" orders. This table only includes deliveries from Jan 2023 - Nov 2024.
6. Separate Temperature (Storage Type) characteristics were used for estimating the 4 -6 month inventory unit estimates.
7. Material code level adjustments were made to historical data to account for FDPIR based on Guide Rate changes that occurred both in Sept 2023 and June 2024.
Columns Included:Example Values:
Zone12
# of Ship to Sites183200
Avg. Deliveries per Month per Site0.90.8
Dry - Avg. Number of Material Codes per Month per Site14.817.5
Dry - Avg. Monthly Quantity Requested (Outbound), pounds (All Sites Total)5156872.54241766.4
Dry - Avg. Monthly Quantity Requested (Outbound), cases (All Sites Total)245134.9199502.3
Cooler - Avg. Number of Material Codes per Month per Site0.80.9
Cooler - Avg. Monthly Quantity Requested (Outbound), pounds (All Sites Total)369596.5288826.1
Cooler - Avg. Monthly Quantity Requested (Outbound), cases (All Sites Total)15525.611711.8
Frozen - Avg. Number of Material Codes per Month per Site22.9
Frozen - Avg. Monthly Quantity Requested (Outbound), pounds (All Sites Total)291420.1416671.8
Frozen - Avg. Monthly Quantity Requested (Outbound), cases (All Sites Total)8995.412451.4
% Share of National Total Outbound Orders5446
% Share of National Dry Outbound Orders54.945.1
% Share of National Frozen Outbound Orders41.258.8
% Share of National Cooler Outbound Orders56.143.9
Dry - Avg. Monthly Quantity Replinished (Inbound), cases231261.9196654.4
Cooler - Avg. Monthly Quantity Replinished (Inbound), cases30149.925638.1
Frozen - Avg. Monthly Quantity Replinished (Inbound), cases107049.391029.8
Dry - Avg. Monthly Quantity Replinished (Inbound), pallets3329.52831.2
Cooler - Avg. Monthly Quantity Replinished (Inbound), pallets398.1338.5
Frozen - Avg. Monthly Quantity Replinished (Inbound), pallets2358.52005.5
Dry - WHSE Active Inventory Cases Min934966750715.6
Dry - WHSE Active Inventory Cases Max14024491126073.4
Cooler - WHSE Active Inventory Cases Min10767894139.2
Cooler - WHSE Active Inventory Cases Max161517141208.8
Frozen - WHSE Active Inventory Cases Min35981.649805.6
Frozen - WHSE Active Inventory Cases Max53972.474708.4
Dry - WHSE Active Inventory Pallets Min13227.610456.8
Dry - WHSE Active Inventory Pallets Max19841.415685.2
Cooler - WHSE Active Inventory Pallets Min1397.61266.4
Cooler - WHSE Active Inventory Pallets Max2096.41899.6
Frozen - WHSE Active Inventory Pallets Min775.61100.8
Frozen - WHSE Active Inventory Pallets Max1163.41651.2

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