Att D - Cost Proposal (Addendum 1) (updated).xlsx

XLSX spreadsheet 38 KB Posted

Attached to
USDA Foods Warehousing and Distribution ServicesBid Documents
Solicitation number
26-85265
Issued by
Marion County, Indiana

About this file

Written by GovTribe AI ·

This is a Cost Proposal template for Food Warehouse and Distribution Services for the Indiana Department of Education (IDOE), submitted as Addendum 1 to the original RFP. The proposal covers five geographic regions within Indiana and requires respondents to provide pricing for three categories of food storage and distribution: Cooler Units, Dry Units, and Frozen Units. Respondents must populate all yellow-shaded cells with cost-per-case pricing for each unit type and region. The estimated volumes are based on historical delivery data from SY 2024-2025, with Region 1 showing 83,903 cases at the low estimate and 104,879 at the high estimate, Region 2 with 69,273 and 86,591 cases respectively, Region 3 with 78,351 and 97,939 cases, Region 4 with 53,168 and 66,460 cases, and Region 5 with 68,994 and 86,243 cases. The total estimated volume across all regions is 353,689 cases at the high estimate level. The Cost Proposal must be submitted in the original Excel format without format modifications or pricing caveats, and respondents may provide supplementary pricing information on potential cost savings in a separate attachment, though only the required cost proposal will be scored during evaluation.

Pricing must include cost-per-case rates for each unit type per region, with Monthly Storage costs automatically calculated at 2.5 times the case cost to reflect average product storage of two and a half months. Additional cost components include In-Out Handling and Delivery charges per case. The "High Estimated Volume" figures will be used for cost evaluation against baseline evaluation costs by region, as described in RFP Section 3.2.3. Respondents may populate optional Delivery Adjustments tabs with per-case adjustments based on the OPIS fuel price index; however, these adjustments will not be scored during cost evaluation and are subject to state acceptance, rejection, or negotiation. For respondents making Minority Business Enterprise (MBE) and Women Business Enterprise (WBE) subcontractor commitments, the Total Bid Amount from the Total Bid tab should be used to calculate the commitment percentage. The template includes a Cost Proposal Summary section with fields for Low Estimate and High Estimate totals by region, culminating in a Total Bid Amount for the five-year initial contract term.

View the file

Other files

File Type Posted
RFP Main Document (Addendum 2).pdf PDF
Addendum 2.pdf PDF
Vendor Questions - State Responses.xlsx XLSX spreadsheet
Pre-Proposal Conference Slide Deck.pdf PDF
Pre-Proposal Conference - Attendance Report.xlsx XLSX spreadsheet
Addendum 1.pdf PDF
Att B - Sample Contract.docx DOCX document
Att I - Pre-proposal Network Form.docx DOCX document
Exhibit 1 to 8.docx DOCX document
Att M - Estimated Volume and Sites by Region Based on SY 2025 updated 9_24_25.xlsx XLSX spreadsheet
Att K - Scope of Work.pdf PDF
Att G - Q&A Template.xlsx XLSX spreadsheet
Cloud Questionnaire.xlsx XLSX spreadsheet
Att J - Attestation Form.docx DOCX document
Att B2 - IOT-PaaS.docx DOCX document
Att C - Indiana Economic Impact Form.xls XLS spreadsheet
Artificial Intelligence - Technical Proposal Questions.docx DOCX document
Infrastructure Overview.docx DOCX document
RFP Main Document.pdf PDF
Att F - Technical Proposal.docx DOCX document
Att H - Reference Check Form.docx DOCX document
Att N - 2526 Region Map.docx DOCX document
Att L - Delivery Sites and 2025 Cases Delivered.xlsx XLSX spreadsheet
Att D - Cost Proposal.xlsx XLSX spreadsheet
Att E - Business Proposal.docx DOCX document
Att A - MWBE.docx DOCX document
Att B3 - IOT-SaaS.docx DOCX document
Att B1 - IOT-IaaS.docx DOCX document
Att A1 - IVOSB.docx DOCX document
Show all 29

On GovTribe

Work with this file

  • 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.

Instructions Food Warehouse and Distribution Services for the Indiana Department of Education (IDOE)

COST PROPOSAL INSTRUCTIONS
1. Respondents must populate all yellow-shaded cells. Pricing must be provided by cost per case for Cooler, Dry, and Frozen Unit line items, for each region included in the proposal.
2. The “Estimated Volume” column of each regional cost proposal provides usage estimations based on historical figures and is used to calculate a total estimated cost. The total estimated cost will be evaluated against the baseline evaluation cost provided for each region, as described in RFP Section 3.2.3. The “High Estimated Volume” figures will be used the cost evaluation.
3. The "Monthly Storage" costs will be automatically calculated to include 2.5X the case cost entered due to the average product storage equaling two and a half months.
4. In the "Delivery Adjustments" tabs, Respondents may populate the yellow-shaded cells with their proposed per-case adjustments to be made to the delivery costs provided for each appropriate region, based on the OPIS fuel price index. Please be advised that the "Delivery Adjustments" tabs will not be scored during the cost evaluation. The State reserves the right to accept, reject, or negotiate any adjustments proposed. All cost information must be submitted with this in consideration.
5. The Cost Proposal must be submitted in the original Excel format. Any attempts to manipulate the format of the Cost Proposal template, attach caveats to pricing, or submit pricing that deviates from the current format will put the Respondent's proposal at risk.
6. Respondents may provide any additional pricing information on ways the state can realize additional savings through the company in a separate attachment, if desired. However, Respondents are advised that only the required cost information requested in the Cost Proposal will be scored during the cost evaluation.
For MBE/WBE Subcontractor commitments, Respondents should use the Total Bid Amount in Cell D13 on the Total Bid tab when figuring the commitment percentage.
NOTES
If attachments are necessary, please indicate where they may be located in the electronic file.

Region (1) Region 1 - Proposed Pricing 2026-2027 Company Name:

Cooler UnitsCost per CaseEstimated VolumeSubtotalHigh Estimated VolumeHigh Estimated Subtotal
Monthly Storage
In-Out Handling
Delivery
TOTAL PER CASE$ - 01,465$ - 01,831$ - 0
Dry UnitsCost per CaseEstimated VolumeSubtotalHigh Estimated VolumeHigh Estimated Subtotal
Monthly Storage
In-Out Handling
Delivery
TOTAL PER CASE$ - 036,954$ - 046,193$ - 0
Frozen UnitsCost per CaseEstimated VolumeSubtotalHigh Estimated VolumeHigh Estimated Subtotal
Monthly Storage
In-Out Handling
Delivery
TOTAL PER CASE$ - 045,484$ - 056,855$ - 0

TOTALS 83,903 $ - 0 104,879 $ - 0

Monthly Storage is multiplied by 2.5 in the total per case calculation to include 2.5 months storage in the per case price.

The estimated volumes listed above are based on actual deliveries from SY 2024-2025 and are only used to estimate the potential volume for the regions. The high estimate adds 25% to the low estimate for volume for internal budgetary estimates only.

Delivery Adjustments (1) Region 1 - Delivery Adjustments & OPIS Index Pricing

OPIS Index Pricing
FromToPer Case AdjustmentFromToPer Case Adjustment
$ 1.0000$ 1.0999$ 3.6000$ 3.6999
$ 1.1000$ 1.1999$ 3.7000$ 3.7999
$ 1.2000$ 1.2999$ 3.8000$ 3.8999
$ 1.3000$ 1.3999$ 3.9000$ 3.9999
$ 1.4000$ 1.4999$ 4.0000$ 4.0999
$ 1.5000$ 1.5999$ 4.1000$ 4.1999
$ 1.6000$ 1.6999$ 4.2000$ 4.2999
$ 1.7000$ 1.7999$ 4.3000$ 4.3999
$ 1.8000$ 1.8999$ 4.4000$ 4.4999
$ 1.9000$ 1.9999$ 4.5000$ 4.5999
$ 2.0000$ 2.0999$ 4.6000$ 4.6999
$ 2.1000$ 2.1999$ 4.7000$ 4.7999
$ 2.2000$ 2.2999$ 4.8000$ 4.8999
$ 2.3000$ 2.3999$ 4.9000$ 4.9999
$ 2.4000$ 2.4999$ 5.0000$ 5.0999
$ 2.5000$ 2.5999$ 5.1000$ 5.1999
$ 2.6000$ 2.6999$ 5.2000$ 5.2999
$ 2.7000$ 2.7999$ 5.3000$ 5.3999
$ 2.8000$ 2.8999$ 5.4000$ 5.4999
$ 2.9000$ 2.9999$ 5.5000$ 5.5999
$ 3.0000$ 3.0999$ 5.6000$ 5.6999
$ 3.1000$ 3.1999$ 5.7000$ 5.7999
$ 3.2000$ 3.2999$ 5.8000$ 5.8999
$ 3.3000$ 3.3999$ 5.9000$ 5.9999
$ 3.4000$ 3.4999$ 6.0000$ 6.0999
$ 3.5000$ 3.5999$ 6.1000$ 6.1999

Region (2) Region 2 - Proposed Pricing 2026-2027 Company Name:

Cooler UnitsCost per CaseEstimated VolumeSubtotalHigh Estimated VolumeHigh Estimated Subtotal
Monthly Storage
In-Out Handling
Delivery
TOTAL PER CASE$ - 01,443$ - 01,804$ - 0
Dry UnitsCost per CaseEstimated VolumeSubtotalHigh Estimated VolumeHigh Estimated Subtotal
Monthly Storage
In-Out Handling
Delivery
TOTAL PER CASE$ - 033,828$ - 042,285$ - 0
Frozen UnitsCost per CaseEstimated VolumeSubtotalHigh Estimated VolumeHigh Estimated Subtotal
Monthly Storage
In-Out Handling
Delivery
TOTAL PER CASE$ - 034,002$ - 042,503$ - 0

TOTALS 69,273 $ - 0 86,591 $ - 0

Monthly Storage is multiplied by 2.5 in the total per case calculation to include 2.5 months storage in the per case price.

The estimated volumes listed above are based on actual deliveries from SY 2024-2025 and are only used to estimate the potential volume for the regions. The high estimate adds 25% to the low estimate for volume for internal budgetary estimates only.

Delivery Adjustments (2) Region 2 - Delivery Adjustments & OPIS Index Pricing

OPIS Index Pricing
FromToPer Case AdjustmentFromToPer Case Adjustment
$ 1.0000$ 1.0999$ 3.6000$ 3.6999
$ 1.1000$ 1.1999$ 3.7000$ 3.7999
$ 1.2000$ 1.2999$ 3.8000$ 3.8999
$ 1.3000$ 1.3999$ 3.9000$ 3.9999
$ 1.4000$ 1.4999$ 4.0000$ 4.0999
$ 1.5000$ 1.5999$ 4.1000$ 4.1999
$ 1.6000$ 1.6999$ 4.2000$ 4.2999
$ 1.7000$ 1.7999$ 4.3000$ 4.3999
$ 1.8000$ 1.8999$ 4.4000$ 4.4999
$ 1.9000$ 1.9999$ 4.5000$ 4.5999
$ 2.0000$ 2.0999$ 4.6000$ 4.6999
$ 2.1000$ 2.1999$ 4.7000$ 4.7999
$ 2.2000$ 2.2999$ 4.8000$ 4.8999
$ 2.3000$ 2.3999$ 4.9000$ 4.9999
$ 2.4000$ 2.4999$ 5.0000$ 5.0999
$ 2.5000$ 2.5999$ 5.1000$ 5.1999
$ 2.6000$ 2.6999$ 5.2000$ 5.2999
$ 2.7000$ 2.7999$ 5.3000$ 5.3999
$ 2.8000$ 2.8999$ 5.4000$ 5.4999
$ 2.9000$ 2.9999$ 5.5000$ 5.5999
$ 3.0000$ 3.0999$ 5.6000$ 5.6999
$ 3.1000$ 3.1999$ 5.7000$ 5.7999
$ 3.2000$ 3.2999$ 5.8000$ 5.8999
$ 3.3000$ 3.3999$ 5.9000$ 5.9999
$ 3.4000$ 3.4999$ 6.0000$ 6.0999
$ 3.5000$ 3.5999$ 6.1000$ 6.1999

Region (3) Region 3 - Proposed Pricing 2026-2027 Company Name:

Cooler UnitsCost per CaseEstimated VolumeSubtotalHigh Estimated VolumeHigh Estimated Subtotal
Monthly Storage
In-Out Handling
Delivery
TOTAL PER CASE$ - 01,521$ - 01,901$ - 0
Dry UnitsCost per CaseEstimated VolumeSubtotalHigh Estimated VolumeHigh Estimated Subtotal
Monthly Storage
In-Out Handling
Delivery
TOTAL PER CASE$ - 034,035$ - 042,544$ - 0
Frozen UnitsCost per CaseEstimated VolumeSubtotalHigh Estimated VolumeHigh Estimated Subtotal
Monthly Storage
In-Out Handling
Delivery
TOTAL PER CASE$ - 042,795$ - 053,494$ - 0

TOTALS 78,351 $ - 0 97,939 $ - 0

Monthly Storage is multiplied by 2.5 in the total per case calculation to include 2.5 months storage in the per case price.

The estimated volumes listed above are based on actual deliveries from SY 2024-2025 and are only used to estimate the potential volume for the regions. The high estimate adds 25% to the low estimate for volume for internal budgetary estimates only.

Delivery Adjustments (3) Region 3 - Delivery Adjustments & OPIS Index Pricing

OPIS Index Pricing
FromToPer Case AdjustmentFromToPer Case Adjustment
$ 1.0000$ 1.0999$ 3.6000$ 3.6999
$ 1.1000$ 1.1999$ 3.7000$ 3.7999
$ 1.2000$ 1.2999$ 3.8000$ 3.8999
$ 1.3000$ 1.3999$ 3.9000$ 3.9999
$ 1.4000$ 1.4999$ 4.0000$ 4.0999
$ 1.5000$ 1.5999$ 4.1000$ 4.1999
$ 1.6000$ 1.6999$ 4.2000$ 4.2999
$ 1.7000$ 1.7999$ 4.3000$ 4.3999
$ 1.8000$ 1.8999$ 4.4000$ 4.4999
$ 1.9000$ 1.9999$ 4.5000$ 4.5999
$ 2.0000$ 2.0999$ 4.6000$ 4.6999
$ 2.1000$ 2.1999$ 4.7000$ 4.7999
$ 2.2000$ 2.2999$ 4.8000$ 4.8999
$ 2.3000$ 2.3999$ 4.9000$ 4.9999
$ 2.4000$ 2.4999$ 5.0000$ 5.0999
$ 2.5000$ 2.5999$ 5.1000$ 5.1999
$ 2.6000$ 2.6999$ 5.2000$ 5.2999
$ 2.7000$ 2.7999$ 5.3000$ 5.3999
$ 2.8000$ 2.8999$ 5.4000$ 5.4999
$ 2.9000$ 2.9999$ 5.5000$ 5.5999
$ 3.0000$ 3.0999$ 5.6000$ 5.6999
$ 3.1000$ 3.1999$ 5.7000$ 5.7999
$ 3.2000$ 3.2999$ 5.8000$ 5.8999
$ 3.3000$ 3.3999$ 5.9000$ 5.9999
$ 3.4000$ 3.4999$ 6.0000$ 6.0999
$ 3.5000$ 3.5999$ 6.1000$ 6.1999

Region (4) Region 4 - Proposed Pricing 2026-2027 Company Name:

Cooler UnitsCost per CaseEstimated VolumeSubtotalHigh Estimated VolumeHigh Estimated Subtotal
Monthly Storage
In-Out Handling
Delivery
TOTAL PER CASE$ - 01,480$ - 01,850$ - 0
Dry UnitsCost per CaseEstimated VolumeSubtotalHigh Estimated VolumeHigh Estimated Subtotal
Monthly Storage
In-Out Handling
Delivery
TOTAL PER CASE$ - 026,170$ - 032,713$ - 0
Frozen UnitsCost per CaseEstimated VolumeSubtotalHigh Estimated VolumeHigh Estimated Subtotal
Monthly Storage
In-Out Handling
Delivery
TOTAL PER CASE$ - 025,518$ - 031,898$ - 0

TOTALS 53,168 $ - 0 66,460 $ - 0

Monthly Storage is multiplied by 2.5 in the total per case calculation to include 2.5 months storage in the per case price.

The estimated volumes listed above are based on actual deliveries from SY 2024-2025 and are only used to estimate the potential volume for the regions. The high estimate adds 25% to the low estimate for volume for internal budgetary estimates only.

Delivery Adjustments (4) Region 4 - Delivery Adjustments & OPIS Index Pricing

OPIS Index Pricing
FromToPer Case AdjustmentFromToPer Case Adjustment
$ 1.0000$ 1.0999$ 3.6000$ 3.6999
$ 1.1000$ 1.1999$ 3.7000$ 3.7999
$ 1.2000$ 1.2999$ 3.8000$ 3.8999
$ 1.3000$ 1.3999$ 3.9000$ 3.9999
$ 1.4000$ 1.4999$ 4.0000$ 4.0999
$ 1.5000$ 1.5999$ 4.1000$ 4.1999
$ 1.6000$ 1.6999$ 4.2000$ 4.2999
$ 1.7000$ 1.7999$ 4.3000$ 4.3999
$ 1.8000$ 1.8999$ 4.4000$ 4.4999
$ 1.9000$ 1.9999$ 4.5000$ 4.5999
$ 2.0000$ 2.0999$ 4.6000$ 4.6999
$ 2.1000$ 2.1999$ 4.7000$ 4.7999
$ 2.2000$ 2.2999$ 4.8000$ 4.8999
$ 2.3000$ 2.3999$ 4.9000$ 4.9999
$ 2.4000$ 2.4999$ 5.0000$ 5.0999
$ 2.5000$ 2.5999$ 5.1000$ 5.1999
$ 2.6000$ 2.6999$ 5.2000$ 5.2999
$ 2.7000$ 2.7999$ 5.3000$ 5.3999
$ 2.8000$ 2.8999$ 5.4000$ 5.4999
$ 2.9000$ 2.9999$ 5.5000$ 5.5999
$ 3.0000$ 3.0999$ 5.6000$ 5.6999
$ 3.1000$ 3.1999$ 5.7000$ 5.7999
$ 3.2000$ 3.2999$ 5.8000$ 5.8999
$ 3.3000$ 3.3999$ 5.9000$ 5.9999
$ 3.4000$ 3.4999$ 6.0000$ 6.0999
$ 3.5000$ 3.5999$ 6.1000$ 6.1999

Region (5) Region 5 - Proposed Pricing 2026-2027 Company Name:

Cooler UnitsCost per CaseEstimated VolumeSubtotalHigh Estimated VolumeHigh Estimated Subtotal
Monthly Storage
In-Out Handling
Delivery
TOTAL PER CASE$ - 01,927$ - 02,409$ - 0
Dry UnitsCost per CaseEstimated VolumeSubtotalHigh Estimated VolumeHigh Estimated Subtotal
Monthly Storage
In-Out Handling
Delivery
TOTAL PER CASE$ - 035,398$ - 044,248$ - 0
Frozen UnitsCost per CaseEstimated VolumeSubtotalHigh Estimated VolumeHigh Estimated Subtotal
Monthly Storage
In-Out Handling
Delivery
TOTAL PER CASE$ - 031,669$ - 039,586$ - 0

TOTALS 68,994 $ - 0 86,243 $ - 0

Monthly Storage is multiplied by 2.5 in the total per case calculation to include 2.5 months storage in the per case price.

The estimated volumes listed above are based on actual deliveries from SY 2024-2025 and are only used to estimate the potential volume for the regions. The high estimate adds 25% to the low estimate for volume for internal budgetary estimates only.

Delivery Adjustments (5) Region 5 - Delivery Adjustments & OPIS Index Pricing

OPIS Index Pricing
FromToPer Case AdjustmentFromToPer Case Adjustment
$ 1.0000$ 1.0999$ 3.6000$ 3.6999
$ 1.1000$ 1.1999$ 3.7000$ 3.7999
$ 1.2000$ 1.2999$ 3.8000$ 3.8999
$ 1.3000$ 1.3999$ 3.9000$ 3.9999
$ 1.4000$ 1.4999$ 4.0000$ 4.0999
$ 1.5000$ 1.5999$ 4.1000$ 4.1999
$ 1.6000$ 1.6999$ 4.2000$ 4.2999
$ 1.7000$ 1.7999$ 4.3000$ 4.3999
$ 1.8000$ 1.8999$ 4.4000$ 4.4999
$ 1.9000$ 1.9999$ 4.5000$ 4.5999
$ 2.0000$ 2.0999$ 4.6000$ 4.6999
$ 2.1000$ 2.1999$ 4.7000$ 4.7999
$ 2.2000$ 2.2999$ 4.8000$ 4.8999
$ 2.3000$ 2.3999$ 4.9000$ 4.9999
$ 2.4000$ 2.4999$ 5.0000$ 5.0999
$ 2.5000$ 2.5999$ 5.1000$ 5.1999
$ 2.6000$ 2.6999$ 5.2000$ 5.2999
$ 2.7000$ 2.7999$ 5.3000$ 5.3999
$ 2.8000$ 2.8999$ 5.4000$ 5.4999
$ 2.9000$ 2.9999$ 5.5000$ 5.5999
$ 3.0000$ 3.0999$ 5.6000$ 5.6999
$ 3.1000$ 3.1999$ 5.7000$ 5.7999
$ 3.2000$ 3.2999$ 5.8000$ 5.8999
$ 3.3000$ 3.3999$ 5.9000$ 5.9999
$ 3.4000$ 3.4999$ 6.0000$ 6.0999
$ 3.5000$ 3.5999$ 6.1000$ 6.1999

Total Bid

COST PROPOSAL SUMMARY

Low EstimateHigh Estimate
Region 1$ - 0$ - 0
Region 2$ - 0$ - 0
Region 3$ - 0$ - 0
Region 4$ - 0$ - 0
Region 5$ - 0$ - 0
One-Year Total$ - 0$ - 0
Total Bid Amount (5-Year Initial Contract Term)$ - 0

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