You are a supply chain analyst for a corporate hospital network that owns multiple hospitals throughout the Chicago metro area. It is 2023 and Covid-19 has subsided. You have been tasked to create a risk assessment for the company's supply chain. The risk categories that your team has decided to assess are: 1. Macro / EPIC Risks 2. Intellectual Property 3. Sourcing Risk 4. Recovery Time 5. Supplier Financial Risk a. In the excel file, rate the above risk categories (1- least important, 5 -most important) and state the reasons for your decisions (note that you can have risk categories with the same rating, however, not all of them should be equall). b. In the excel file, for the suppliers below, rate each supplier in each risk category. Note that a high risk should be rated as a 4 or 5 , and a low risk as a 1 or 2 . fizer, Inc: Large multinational pharmaceutical corporation (over $50 billion revenue). Many manufacturing locations, however, new medicines usually manufactured at one location until volume warrants multiple sites. Pfizer sells many patented medicines used by the hospital. Financially stable company. Baguio Medical Supplies: Family-owned Filipino company that sells face masks and medical gowns to distributors in the U.S. Sales of $75 million annually. Manufactures in two buildings located on the same campus in The Philippines, an active typhoon and earthquake region. TID Medical Devices, LLC: Start-up company with innovative MRI technology. Developed an imaging technology that has significantly lowered the equipment cost of MRI machines. The hospital network has purchased 3 machines, however, due to hiccups in the start-up's new supply chain, TDD has only delivered one thus far. The machine delivered is impressive when working but has breakdowns frequently. TTD leadership is looking for investors support their forecast of significant growth. Meds R Us, Inc: Small business that develops medicines for many different types of cancer. The company is twelve years old and has a strong financial record. All its medicines are patented. The company is located in San Francisco, California, but does not manufacture its own medicines. It uses a small company in indonesia to manufacture all of its medicines. The Moving Congigge, LIC: Jeff Relen owns this small business which specializes in company moves. Your hospital has used this company to move furniture and equipment multiple times during the past 10 vears when a hospital expanded. Jeff is willing to share financial information and the company's Altman-Z is 2.65. IOTA: Intergffice \& Design, Inc. (IODI) is a $1 billion office fumiture company located in Grand Rapids. IOTA provides patient room furniture (patient beds, patient/visitor chairs, lighting). IOTA is the only supplier for this type of furniture to the hospital network, although there are many companies that provide this product. IOTA assembles its furniture in Grand Rapids, but uses suppliers in the U.S., Asia and Europe. IODI is a privately held company and will not share much of its financial information. Risk Category Weight Mleasoning Summary for each supplier. You are a supply chain analyst for a corporate hospital network that owns multiple hospitals throughout the Chicago metro area. It is 2023 and Covid-19 has subsided. You have been tasked to create a risk assessment for the company's supply chain. The risk categories that your team has decided to assess are: 1. Macro / EPIC Risks 2. Intellectual Property 3. Sourcing Risk 4. Recovery Time 5. Supplier Financial Risk a. In the excel file, rate the above risk categories (1- least important, 5 -most important) and state the reasons for your decisions (note that you can have risk categories with the same rating, however, not all of them should be equall). b. In the excel file, for the suppliers below, rate each supplier in each risk category. Note that a high risk should be rated as a 4 or 5 , and a low risk as a 1 or 2 . fizer, Inc: Large multinational pharmaceutical corporation (over $50 billion revenue). Many manufacturing locations, however, new medicines usually manufactured at one location until volume warrants multiple sites. Pfizer sells many patented medicines used by the hospital. Financially stable company. Baguio Medical Supplies: Family-owned Filipino company that sells face masks and medical gowns to distributors in the U.S. Sales of $75 million annually. Manufactures in two buildings located on the same campus in The Philippines, an active typhoon and earthquake region. TID Medical Devices, LLC: Start-up company with innovative MRI technology. Developed an imaging technology that has significantly lowered the equipment cost of MRI machines. The hospital network has purchased 3 machines, however, due to hiccups in the start-up's new supply chain, TDD has only delivered one thus far. The machine delivered is impressive when working but has breakdowns frequently. TTD leadership is looking for investors support their forecast of significant growth. Meds R Us, Inc: Small business that develops medicines for many different types of cancer. The company is twelve years old and has a strong financial record. All its medicines are patented. The company is located in San Francisco, California, but does not manufacture its own medicines. It uses a small company in indonesia to manufacture all of its medicines. The Moving Congigge, LIC: Jeff Relen owns this small business which specializes in company moves. Your hospital has used this company to move furniture and equipment multiple times during the past 10 vears when a hospital expanded. Jeff is willing to share financial information and the company's Altman-Z is 2.65. IOTA: Intergffice \& Design, Inc. (IODI) is a $1 billion office fumiture company located in Grand Rapids. IOTA provides patient room furniture (patient beds, patient/visitor chairs, lighting). IOTA is the only supplier for this type of furniture to the hospital network, although there are many companies that provide this product. IOTA assembles its furniture in Grand Rapids, but uses suppliers in the U.S., Asia and Europe. IODI is a privately held company and will not share much of its financial information. Risk Category Weight Mleasoning Summary for each supplier