Please answer with Microsoft Excel
WFS 401-11: 23750 information Resource Management Spring 2018 exce. Pioutct - Gielthus You have been employed as a consulant to Golf R Us, hac. The company has been having problems with account. recelvables and they want to use various dunning methods to better their recehrables, Eut first, they aeed to comple al the customers who heve not paids so that they can demand payment that indudes finance charges. Two fles which contain what products were boughe, how mary balls were bought, when the balls have been bought, and payment history have been extracted out of different datahase tables. Rong Wright, the manager of Gelf RU, has asked you to combine the different files to ene Excel worksheet and dean up the data. He wants you to name the workheet as "Customers". One of the files containi a Customer io column. The Customer so is a rewit of an algorithm that is employed by the company. The algorithm used by the company is as followy: The formot of 10 for eoch custamer needs to be "lastname" followed by on underscere followed by a number starting with "ooor". The compony added the character " D " ro the ens of a created 10 if there is a repeot of any leit name. (for example, let us soy that we have an io "Madigan_0001"; if there ore multiple Modigon as lart names, the first Madigan will be "Madigan_0001", the next Modigon wail be "Modigan_00020"; the following one will be "Modigon__00030", and so on the next name Mae witt be Mot_0004l. are preparine the delinouent churne ic freberiasi to 20181 : mune no corcuate the finunce charges, you moy need to find the number of dops (NDayz) between purchesed date and the doy thot you ave greparing the dellinguent change. 1. Set up the cacell model using the data (20 points) which contains workuheets named "Title"; "Assumptions", "Custemers", "FC_Moder" Pleaie bst any assumptions you have made in the "Assumptions" worksheet. 2. Use input data that is avalable in two text files) (C0 points). The Excel model workiheet named "FC, Moder" should contalin the following data: 10, Nooftallipurchased, Product, PurchasedDate, Salestmountevotpaid, NDay, FinanceCharzedmount 3. Prepare an appropriate chart to compare the mumber of "paid" cuitomers and "not-pald" eustomers. 120 points) INF5 401-11: 23750 Infermatien Resource Maragnenent Spring 20us pxcr paoxict-Gulpus comple at the curtomen wha have not paid to that stey can denund pepment thut includes finance charges. Two flies weith contain what products were boople, hew many balk were bovete, when the balis have been to name the workisheet as "Custumers". the compary. The whorithm ased by the conguty in as followt: will be "Madpar_00030", and ss an The neut name ster all be Move oocell. "Hinminas" wotalleet. pental 1. Please write the answers for the questions. You can use the Internet to research and find answers. 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 winterl 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 bestl 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 youl 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 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 use databases. Ms. Claudine Chez, the CEO of CloudNine, 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 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 supplier's 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. WFS 401-11: 23750 information Resource Management Spring 2018 exce. Pioutct - Gielthus You have been employed as a consulant to Golf R Us, hac. The company has been having problems with account. recelvables and they want to use various dunning methods to better their recehrables, Eut first, they aeed to comple al the customers who heve not paids so that they can demand payment that indudes finance charges. Two fles which contain what products were boughe, how mary balls were bought, when the balls have been bought, and payment history have been extracted out of different datahase tables. Rong Wright, the manager of Gelf RU, has asked you to combine the different files to ene Excel worksheet and dean up the data. He wants you to name the workheet as "Customers". One of the files containi a Customer io column. The Customer so is a rewit of an algorithm that is employed by the company. The algorithm used by the company is as followy: The formot of 10 for eoch custamer needs to be "lastname" followed by on underscere followed by a number starting with "ooor". The compony added the character " D " ro the ens of a created 10 if there is a repeot of any leit name. (for example, let us soy that we have an io "Madigan_0001"; if there ore multiple Modigon as lart names, the first Madigan will be "Madigan_0001", the next Modigon wail be "Modigan_00020"; the following one will be "Modigon__00030", and so on the next name Mae witt be Mot_0004l. are preparine the delinouent churne ic freberiasi to 20181 : mune no corcuate the finunce charges, you moy need to find the number of dops (NDayz) between purchesed date and the doy thot you ave greparing the dellinguent change. 1. Set up the cacell model using the data (20 points) which contains workuheets named "Title"; "Assumptions", "Custemers", "FC_Moder" Pleaie bst any assumptions you have made in the "Assumptions" worksheet. 2. Use input data that is avalable in two text files) (C0 points). The Excel model workiheet named "FC, Moder" should contalin the following data: 10, Nooftallipurchased, Product, PurchasedDate, Salestmountevotpaid, NDay, FinanceCharzedmount 3. Prepare an appropriate chart to compare the mumber of "paid" cuitomers and "not-pald" eustomers. 120 points) INF5 401-11: 23750 Infermatien Resource Maragnenent Spring 20us pxcr paoxict-Gulpus comple at the curtomen wha have not paid to that stey can denund pepment thut includes finance charges. Two flies weith contain what products were boople, hew many balk were bovete, when the balis have been to name the workisheet as "Custumers". the compary. The whorithm ased by the conguty in as followt: will be "Madpar_00030", and ss an The neut name ster all be Move oocell. "Hinminas" wotalleet. pental 1. Please write the answers for the questions. You can use the Internet to research and find answers. 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 winterl 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 bestl 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 youl 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 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 use databases. Ms. Claudine Chez, the CEO of CloudNine, 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 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 supplier's 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
