Excel Homework Question

Please answer on Microsoft Excel Spreadsheet

INFS 401-11: 23750 Information Resource Management Spring 2018 EXCEL PROJECT - GolfRUS You have been employed as a consultant to Golf R Us, Inc. The company has been having problems with acc receivables and they want to use various dunning methods to better their receivables. But first, they need t compile all the customers who have not paid so that they can demand payment that includes finance charg Two files which contain what products were bought, how many balls were bought, when the balls have bee bought, and payment history have been extracted out of different database tables. Rong Wright, the manar Golf R Us, has asked you to combine the different files to one Excel worksheet and clean up the data. He w. to name the worksheet as "Customers". One of the files contains a Customer ID column. The Customer_ID is a result of an algorithm that is employ the company. The algorithm used by the company is as follows: The format of io for each customer needs to be "lastnome" followed by an underscore followed by a numbe starting with "0001". The company odded the character "D" to the end of a created ID if there is a repeot or last name. (For example, let us say that we have an ID "Madigan_0001"; if there are multiple Madigan as I names, the first Madigan will be "Madigan_0001", the next Modigan will be "Madigan_00020", the follow will be "Modigan_00030", and so on. The next name Moe will be Moe_0004). The finance charges for delinquent accounts as of February 14, 2018 are as follows (assume that the day wa mrenarino the delinguent charge is February 14,2018 ): Note: To colculate the finance charges, you moy need to find the number of days (NDays) between purch and the doy that you ore preparing the delinquent charge. 1. Set up the excel model using the data (20 points) which contains worksheets named "Title", "Assumptions", "Customers", "FC_Model" Please list any assumptions you have made in the MANAGEMENT 17E MANAGING the DIGITAL FIRM P Kenneth C. Laudon | Jane P. Laudon INFS 401-11: 23750 Information Resource Management Spring 2018 EXCEL PROJECT - GolfRUS You have been employed as a consultant to Golf R Us, Inc. The company has been having problems with acc receivables and they want to use various dunning methods to better their receivables. But first, they need t compile all the customers who have not paid so that they can demand payment that includes finance charg Two files which contain what products were bought, how many balls were bought, when the balls have bee bought, and payment history have been extracted out of different database tables. Rong Wright, the manar Golf R Us, has asked you to combine the different files to one Excel worksheet and clean up the data. He w. to name the worksheet as "Customers". One of the files contains a Customer ID column. The Customer_ID is a result of an algorithm that is employ the company. The algorithm used by the company is as follows: The format of io for each customer needs to be "lastnome" followed by an underscore followed by a numbe starting with "0001". The company odded the character "D" to the end of a created ID if there is a repeot or last name. (For example, let us say that we have an ID "Madigan_0001"; if there are multiple Madigan as I names, the first Madigan will be "Madigan_0001", the next Modigan will be "Madigan_00020", the follow will be "Modigan_00030", and so on. The next name Moe will be Moe_0004). The finance charges for delinquent accounts as of February 14, 2018 are as follows (assume that the day wa mrenarino the delinguent charge is February 14,2018 ): Note: To colculate the finance charges, you moy need to find the number of days (NDays) between purch and the doy that you ore preparing the delinquent charge. 1. Set up the excel model using the data (20 points) which contains worksheets named "Title", "Assumptions", "Customers", "FC_Model" Please list any assumptions you have made in the MANAGEMENT 17E MANAGING the DIGITAL FIRM P Kenneth C. Laudon | Jane P. Laudon