please answer
Margate Hospital ost-containment activities have become particularly important to hospital operations managers, stimulated by major revisions in health care reimbursement policies and significant growth in marketing activities by private sector health care organizations. Recognizing that poor inventory control policies reflext ineffective use of orga- nizational assets, many hospital managers have sought to institute more systematic approaches to the control of sup- ply inventories. At Margate Hospital, analysts collected data of 20 dis- posable SKUs in a pulmonary therapy imit. These data are shown in Exhibit 12.27 (these data are available in the work- sheet Margate Hospital Case Data in MindTap). Three of the SKUs are designated as critical to patient care. The hospital administrator wants to develop better inventory management policies for these items Case Questions for Discussion: 1. Using the case data, propose a breakdown for an ABC analysis, and clearly outline how each category of items might be managed by the hospital. (Use the Excel ABC template in MindTap:) 2. How do you recommend managing these ABC and critical inventory categories? 3. Can you think of any other inventory management systems besides health care where some SKUs might be defined as "critical"? EXHIBIT 12.27 Margate Hospital Study Data Total Annual Usage SKU 2 3 4 5 6 7 B 9 70 212 210 117 77 60 48 33 27 19 Critical Average Unit Cost 52400 52.00 $50.00 $28.00 $58.00 $55.00 $73.00 $210.00 SM.00 $45.00 $33.00 $65.00 $41.00 $20.00 572.00 $67.00 $8.00 $134,00 $34.00 $29.00 Critical 12 13 12 7 4 Critcal 14 15 16 17 18 19 20 Margate Hospital ost-containment activities have become particularly important to hospital operations managers, stimulated by major revisions in health care reimbursement policies and significant growth in marketing activities by private sector health care organizations. Recognizing that poor inventory control policies reflext ineffective use of orga- nizational assets, many hospital managers have sought to institute more systematic approaches to the control of sup- ply inventories. At Margate Hospital, analysts collected data of 20 dis- posable SKUs in a pulmonary therapy imit. These data are shown in Exhibit 12.27 (these data are available in the work- sheet Margate Hospital Case Data in MindTap). Three of the SKUs are designated as critical to patient care. The hospital administrator wants to develop better inventory management policies for these items Case Questions for Discussion: 1. Using the case data, propose a breakdown for an ABC analysis, and clearly outline how each category of items might be managed by the hospital. (Use the Excel ABC template in MindTap:) 2. How do you recommend managing these ABC and critical inventory categories? 3. Can you think of any other inventory management systems besides health care where some SKUs might be defined as "critical"? EXHIBIT 12.27 Margate Hospital Study Data Total Annual Usage SKU 2 3 4 5 6 7 B 9 70 212 210 117 77 60 48 33 27 19 Critical Average Unit Cost 52400 52.00 $50.00 $28.00 $58.00 $55.00 $73.00 $210.00 SM.00 $45.00 $33.00 $65.00 $41.00 $20.00 572.00 $67.00 $8.00 $134,00 $34.00 $29.00 Critical 12 13 12 7 4 Critcal 14 15 16 17 18 19 20