1. Please write the answers for the questions. 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) .

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 use databases. Ms. Claudine Chez, the CEO of CloudNine, 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 suppliers name whose supplier contact begins with the letter J 4. The revenues of customers with their orderIDs and ProductIDS, who have been customers since Year 2011. She also wants a report of Cheese Inventory (i.e. WeekSupply) grouped by ChType (like Hard, Semi-hard, etc..) . She also wants you to show ProForm and the ProductID in the report.