Schedule A-1 FY2020-2022 order history for RFP 230000001892.xls

XLS spreadsheet 61 KB Posted

Attached to
MDOC-medically necessary athletic shoes for prisoners
Solicitation number
RFP 472 230000001892 1
Issued by
Michigan

About this file

This is a historical order history schedule for RFP 230000001892 regarding medically necessary athletic shoes for the Michigan Department of Corrections (MDOC) covering the fiscal years 2020 through 2022. The document provides detailed usage data by brand, style number, color, shoe size, and width for approved shoe models, enabling the state to establish accurate baseline quantities for future procurement planning. The three primary brands included in the historical record are Shoe Corporation (styles 2800 and 3700 mid-high in black), and Bob Barker Company (styles B72 and W72 in black and white across multiple widths). Usage data spans standard to extra-wide shoe sizes, ranging from size 3 to size 18, with width designations including D, E, EE, and F widths, reflecting the diverse footwear needs of the inmate population.

The historical order data reveals significant variation in demand across shoe sizes and widths, with the largest order volumes concentrated in sizes 9 through 13 and width categories D and EE. For example, Bob Barker Company B72 Black size 12 EE accumulated 214 total units across the three-year period, while Bob Barker Company B72 Black size 10 EE totaled 192 units. The document notes that all estimates are based on historical MDOC orders for 2020-2022 and are not predictive of future usage or orders. Additionally, the MDOC lacks historical data for 6E width shoes, which may indicate either minimal demand or absence of prior procurement in that width category. This schedule serves as a foundational tool for vendors to understand expected demand patterns and for the state to project future inventory requirements and budget appropriations.

View the file

Other files

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

Sheet1

RFP 230000001892 - Medically Necessary Athletic Shoes
SCHEDULE A-1
HISTORICAL ORDER HISTORY FOR 2020-2022 BY STYLE, SIZE AND WIDTH (FOR APPROVED SHOES)
BrandStyle #ColorSizeWidthQuantity-2020Quantity-2021Quantity-2022Total Usage for 2020-2022
Shoe Corpartion2800Black4.54E22
Shoe Corpartion2800Black54E11
Shoe Corpartion2800Black74E33
Shoe Corpartion2800Black7D0
Shoe Corpartion2800Black7.54E22
Shoe Corpartion2800Black84E23510
Shoe Corpartion2800Black8D0
Shoe Corpartion2800Black8.54E471223
Shoe Corpartion2800Black8.5D0
Shoe Corpartion2800Black94E1081735
Shoe Corpartion2800Black9D0
Shoe Corpartion2800Black9.54E881935
Shoe Corpartion2800Black104E21212870
Shoe Corpartion2800Black10D0
Shoe Corpartion2800Black10.54E17203067
Shoe Corpartion2800Black10.5D213
Shoe Corpartion2800Black114E322845105
Shoe Corpartion2800Black11D33
Shoe Corpartion2800Black11.54E12142248
Shoe Corpartion2800Black124E27303996
Shoe Corpartion2800Black12D2114
Shoe Corpartion2800Black134E17293177
Shoe Corpartion2800Black13D112
Shoe Corpartion2800Black144E7171640
Shoe Corpartion2800Black14D11
Shoe Corpartion2800Black154E16916
Shoe Corpartion2800Black15D0
Shoe Corpartion2800Black164E426
Shoe Corpartion2800Black174E11
Shoe Corpartion2800Black184E2338
BrandStyle #ColorSizeWidthQuantity-2020Quantity-2021Quantity-2022Total Usage for 2020-2022
Shoe Corporation3700 (mid-high)Black6.54E11
Shoe Corporation3700 (mid-high)Black74E1348
Shoe Corporation3700 (mid-high)Black7D0
Shoe Corporation3700 (mid-high)Black7.54E437
Shoe Corporation3700 (mid-high)Black84E56415
Shoe Corporation3700 (mid-high)Black8D0
Shoe Corporation3700 (mid-high)Black8.54E1225
Shoe Corporation3700 (mid-high)Black8.5D0
Shoe Corporation3700 (mid-high)Black94E24612
Shoe Corporation3700 (mid-high)Black9D0
Shoe Corporation3700 (mid-high)Black9.54E36312
Shoe Corporation3700 (mid-high)Black9.5D11
Shoe Corporation3700 (mid-high)Black104E1311327
Shoe Corporation3700 (mid-high)Black10D0
Shoe Corporation3700 (mid-high)Black10.54E59317
Shoe Corporation3700 (mid-high)Black10.5D11
Shoe Corporation3700 (mid-high)Black114E18131041
Shoe Corporation3700 (mid-high)Black11D112
Shoe Corporation3700 (mid-high)Black11.54E510924
Shoe Corporation3700 (mid-high)Black11.5D0
Shoe Corporation3700 (mid-high)Black124E771226
Shoe Corporation3700 (mid-high)Black12D314
Shoe Corporation3700 (mid-high)Black134E57921
Shoe Corporation3700 (mid-high)Black13D0
Shoe Corporation3700 (mid-high)Black144E291122
Shoe Corporation3700 (mid-high)Black14D112
Shoe Corporation3700 (mid-high)Black154E112
BrandStyle #ColorSizeWidthQuantity-2020Quantity-2021Quantity-2022Total Usage for 2020-2022
Bob Barker CompanyB72Black3D66
Bob Barker CompanyB72Black4D1010
Bob Barker CompanyB72Black4.5D44
Bob Barker CompanyB72Black5D617
Bob Barker CompanyB72Black5.5D44
Bob Barker CompanyB72Black6D2027552
Bob Barker CompanyB72Black6.5D11191444
Bob Barker CompanyB72Black7D94720
Bob Barker CompanyB72Black7.5D12171342
Bob Barker CompanyB72Black8D3281748
Bob Barker CompanyB72Black8.5D815629
Bob Barker CompanyB72Black9D17263578
Bob Barker CompanyB72Black9.5D2192252
Bob Barker CompanyB72Black10D364153130
Bob Barker CompanyB72Black10.5D25373193
Bob Barker CompanyB72Black11D242156101
Bob Barker CompanyB72Black11.5D11331660
Bob Barker CompanyB72Black12D302061111
Bob Barker CompanyB72Black13D21143772
Bob Barker CompanyB72Black14D771630
Bob Barker CompanyB72Black15D145
Bob Barker CompanyB72Black16D33
Bob Barker CompanyB72Black17D134
BrandStyle #ColorSizeWidthQuantity-2020Quantity-2021Quantity-2022Total Usage for 2020-2022
Bob Barker CompanyW72White9.5D101
Bob Barker CompanyW72White10D110011
Bob Barker CompanyW72White10.5D505
Bob Barker CompanyW72White11D22022
Bob Barker CompanyW72White12D120021
Bob Barker CompanyW72White13D110011
BrandStyle #ColorSizeWidthQuantity-2020Quantity-2021Quantity-2022Total Usage for 2020-2022
Bob Barker CompanyB72Black5E11
Bob Barker CompanyB72Black5.5E77
Bob Barker CompanyB72Black6E123
Bob Barker CompanyB72Black6.5E81624
Bob Barker CompanyB72Black7E214622
Bob Barker CompanyB72Black7.5E16925
Bob Barker CompanyB72Black8E10191746
Bob Barker CompanyB72Black8.5E7221443
Bob Barker CompanyB72Black9E356219116
Bob Barker CompanyB72Black9.5E1419942
Bob Barker CompanyB72Black10E7210142215
Bob Barker CompanyB72Black10.5E236162146
Bob Barker CompanyB72Black11E857544204
Bob Barker CompanyB72Black11.5E21253985
Bob Barker CompanyB72Black12E8110347231
Bob Barker CompanyB72Black13E5210723182
Bob Barker CompanyB72Black14E1243964
Bob Barker CompanyB72Black15E85316
Bob Barker CompanyB72Black16E3126
Bob Barker CompanyB72Black17E1225
Bob Barker CompanyB72Black18E11
BrandStyle #ColorSizeWidthQuantity-2020Quantity-2021Quantity-2022Total Usage for 2020-2022
Bob Barker CompanyB72Black8EE11121033
Bob Barker CompanyB72Black8.5EE1015833
Bob Barker CompanyB72Black9EE373548120
Bob Barker CompanyB72Black9.5EE26254697
Bob Barker CompanyB72Black10EE395994192
Bob Barker CompanyB72Black10.5EE493752138
Bob Barker CompanyB72Black11EE735054177
Bob Barker CompanyB72Black11.5EE213148100
Bob Barker CompanyB72Black12EE606787214
Bob Barker CompanyB72Black13EE363933108
Bob Barker CompanyB72Black14EE21221861
Bob Barker CompanyB72Black15EE5131028
Bob Barker CompanyB72Black16EE1258
Bob Barker CompanyB72Black17EE11
BrandStyle #ColorSizeWidthQuantity-2020Quantity-2021Quantity-2022Total Usage for 2020-2022
Bob Barker CompanyW72White7EE11
Bob Barker CompanyW72White8.5EE11
Bob Barker CompanyW72White9EE11
Bob Barker CompanyW72White9.5EE11
Bob Barker CompanyW72White10EE11
Bob Barker CompanyW72White10.5EE5319
Bob Barker CompanyW72White11EE112
Bob Barker CompanyW72White11.5EE213
Bob Barker CompanyW72White12EE112
Bob Barker CompanyW72White13EE112
Bob Barker CompanyW72White14EE213
BrandStyle #ColorSizeWidthQuantity-2020Quantity-2021Quantity-2022Total Usage for 2020-2022
Bob Barker CompanyB72Black9F3003
Bob Barker CompanyB72Black9.5F2002
Bob Barker CompanyB72Black10F2002
Bob Barker CompanyB72Black10.5F2002
Bob Barker CompanyB72Black11F2002
Bob Barker CompanyB72Black11.5F4004
Bob Barker CompanyB72Black12F1001
Bob Barker CompanyB72Black13F4004
The estimates are based on histiorical orders for the MDOC for 2020-2022. Estimates are not predictive of future usage or orders.
The MDOC does not have any historical data for the 6E width shoes.

Sheet2

Sheet3

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