It can be assumed that we drink coffee the first thing in the morning. There is something romantic about brewing a pot of coffee, holding a freshly bought cup close, sipping it while reading the news, first thing in the morning. This gets better during winter! There is also something practical about it: Sipping piping hot caffeine as soon as possible prepares us for the day-or, at the very least, for the coming few hours. Where does this coffee come from and how it lands in your pot is Supply Chain Management at its very best! Make sure your answer is detailed as to include transportation, logistics, Internal and external processes, other ingredients that are necessary to make this coffee drinkable and enjoyable by you! Research the Internet to understand the supply chain networks behind this coffee, and write down the SCM part of coffee. Problem 2: Use Microsoft ACCESS (Please See ACCESS FILES). Please practice Access before you do this part of the assignment Note: if you do not have Microsoft Access database on your computer you have one of these options: 1. If you have a PC, then Access is available from the Office 365 suite. 2. If you have a Mac, a. You can connect to the University Labs remotely (please talk to IT help) b. You can go to a University Lab and use that computer to do the database assignments 11harcity Lab and use that computer to do the INFS 401-11 HW 4 1. answers. Please write the answers for the questions. You can use the Internet to research and find It can be assumed that we drink coffee the first thing in the morning. There is something romantic abc brewing a pot of coffee, holding a freshly bought cup dose, sipping it while reading the news, first thin in the morning. This gets better during winter! There is also something practical about it: Sipping piping hot caffeine as soon as possible prepares us for the day-or, at the very least, for the coming few hours. Where does this coffee come from and how it lands in your pot is Supply Chain Management at its very best! Make sure your answer is detailed as to include transportation, logistics, Internal and external processes, other ingredients that are necessary to make this coffee drinkable and enjoyable by you! Research the Internet to understand the supply chain networks behind this coffee, and write down the SCM part of coffee. Problem 2: Use Microsoft ACCESS (Please See ACCESS FILES). Please practice Access before you do this part of the assignment Note: if you do not have Microsoft Access database on your computer you have one of these options: 1. If you have a PC, then Access is available from the Office 365 suite 2. If you have a Mac, a. You can connect to the University Labs remotely (please talk to IT help) b. You can go to a University Lab and use that computer to do the database assignments 3. If you have a chrome, then you can go to a University Lab and use that computer to do the database assignments CloudNine, Inc. uses an ERP system and one of its products is Cheese that is sold to retail stores. This exercise is to understand how ERP systems une databases. Ms. Claudine Cher, the CEO of Cloud wants to know the answers to following questions 1. A list of customers with order dates, shipped dates, payment dates, how they paid, and the amount of payments. 2. Average consumer rating of Cheese Types such as Colby, Cheddar, etc. 3. The supplier's name whose supplier contact begins with the letter "" 4. The revenues of customers with their orders and Products, who have been customers since Year 2011. She also wants a report of Cheese Inventory Be. WeekSupply) grouped by Chilype e Hard, Sem hand etc.). She also wants you to show Proform and the Producto in the report