You have been employed as a consultant to Golf R Us, Inc. The company has been having problems with account receivables and they want to use various dunning methods to better their receivables. But first, they need to compile all the customers who have not paid so that they can demand payment that includes finance charges. Two files which contain what products were bought, how many balls were bought, when the balls have been bought, and payment history have been extracted out of different database tables. Rong Wright, the manager of Golf R Us, has asked you to combine the different files to one Excel worksheet and clean up the data. He wants you 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 employed by the company. The algorithm used by the company is as follows: The format of ID for each customer needs to be "lastname" followed by an underscore followed by a number starting with "0001". The company added the character "D" to the end of a created ID if there is a repeat of any last name. (For example, let us say that we have an ID "Madigan_0001"; if there are multiple Madigan as last names, the first Madigan will be "Madigan_0001", the next Madigan will be "Madigan_0002D", the following one will be "Madigan_00030", and so on. The next name Mae will be Mae_0004). The price catalog of the products is as follows: Products Titleist Pro V1 Golf Balls Titleist Pro V1 Recycled Golf Balls PGSI Assorted Mid-Grade Recycled Golf Balls Recycled Top-Flite Gold Balls Recycled Golf Balls Callaway Recycled Golf Balls Balls per pack 50 12 12 24 12 15 Pack Price 49.99 17.99 14.99 11.99 9.99 9.99 The finance charges for delinquent accounts as of February 14, 2018 are as follows (assume that the day that you are preparing the delinquent charge is February 14, 2018): No of Days Finance charges