12.6) Excel Project. Accountants should help managers understand trends in rever cycle activities. One important issue concerns granting credit to customers. Trends in bad debt expense (BDE) to write-offs (WO) provide insights into the accuracy of credit granting policies. It is also important to monitor how long it will take to write off the current balance in the allowance for doubtful accounts (BADA Exhaustion Rate). REQUIRED a. Create a spreadsheet that contains the following data: YEAR BDE/ WO BADA/WO BADA Exhaustion Rate (years) 2010 1.81 1.42 1.33 2011 0.98 1.73 1.81 2012 1.08 1.89 1.67 2013 1.27 1.48 1.35 2014 0.94 1.26 1.20 b. Create a two-dimensional columnar chart that displays the data values for each vari- able for the five years 2012-2016. c. Create a new chart that will display a two-dimensional columnar chart that shows a rolling five-year window of the variables. Add the following data for 2017 and 2018 to your spreadsheet to demonstrate that the new chart shows only 2014-2018 values: YEAR BDE/WO BADAWO BADA Exhaustion Rate (years) 2017 1.1 1.3 1.5 2018 1.3 1.1 1,6 (Hint: Read the article "Simplify Your Future with Rolling Charts." by James A. Weisel in the July 2012 issue of the Journal of Accountancy for an explanation of the how to create a rolling chart (step e) and take care to follow Excel's rules for naming ranges. Read the article "As- sessing the Allowance for Doubtful Accounts: Using historical data to evaluate the estimation process," by Mark E. Riley and William R. Pasewark in the September 2009 issue of the Jour- nal of Accountancy for an explanation of how the variables used in this problem can help you evaluate a company's process for estimating the allowance for doubtful accounts. The Journal of Accountancy is available either in print or online at www.aicpa.org.)