Att D - Cost Proposal.xlsx

XLSX spreadsheet 37 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 Excel file for Food Warehouse and Distribution Services for the Indiana Department of Education (IDOE), covering five distinct regions for the school year 2026-2027. The document provides a detailed pricing template for vendors to submit proposed costs for Cooler, Dry, and Frozen Units, with estimated volumes based on historical delivery data from School Year 2024-2025. The pricing structure includes components for case costs, monthly storage (calculated at 2.5x case cost), in-out handling, and delivery, with separate tabs for each of the five regions and a mechanism for adjusting delivery costs based on the OPIS fuel price index.

The pricing proposal requires vendors to populate yellow-shaded cells with their proposed per-case costs, with estimated volumes ranging from approximately 53,168 to 83,903 total cases across different unit types for the low estimate, and 66,460 to 104,879 for the high estimate. The document emphasizes that only the required cost information will be scored during evaluation, and warns that manipulating the template or attaching caveats to pricing could put the respondent's proposal at risk. Vendors are instructed to submit the proposal in the original Excel format, with the option to provide additional savings information in a separate attachment, though such information will not be scored in the cost evaluation.

View the file

Other files

File Type Posted
RFP Main Document (Addendum 2).pdf PDF
Addendum 2.pdf PDF
Att D - Cost Proposal (Addendum 1) (updated).xlsx XLSX spreadsheet
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 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 for internal budgetary considerations only and will not be considered in 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.
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

TOTAL BID AMOUNT: $ - 0 $ - 0

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