Schedule C MI Prod & Ben Usage.xlsx

This file is a usage data report from the State of Michigan detailing average product and beneficiary usage for FY2020, covering the period October 1, 2019 through September 30, 2020. The report presents consumption patterns for healthcare products identified by HCPCS codes, with specific modifiers applicable to certain items (A4351 and A4352). The data encompasses 53 line items representing various medical supplies and equipment, organized by item number and HCPCS code. Monthly average beneficiary counts range from zero to 9,609 users, with total billed units varying significantly across product categories. Notable high-volume items include T4541 with 9,609 monthly average beneficiaries and 798,247 monthly average billed units, T4535 with 5,917 beneficiaries and 919,018 monthly average units, and T4527 with 3,136 beneficiaries and 330,618 monthly average units. Lower-volume items such as A4314, A4315, A4326, and A4340 show zero monthly average beneficiaries during the reporting period.

The report serves as a baseline usage metric for Michigan's healthcare product procurement and budgeting purposes, reflecting actual state beneficiary consumption patterns across multiple product categories. The data indicates significant variation in utilization rates, with some products demonstrating substantial monthly usage (T4535 with over 11 million total billed units) while others show minimal or no utilization during the fiscal year. This usage information would typically inform contract forecasting, inventory planning, and vendor selection decisions for ongoing state healthcare supply procurement.