Excel Project. Accountants should help managers understand trends in revenue cycle activities. One important issue concerns...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Excel Project. Accountants should help managers understand trends in revenue 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 BADA/WO 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 c) 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.)" Excel Project. Accountants should help managers understand trends in revenue 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 BADA/WO 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 c) 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.)"
Expert Answer:
Answer rating: 100% (QA)
Solution a Material purchase price variance 34590 U SP AP AQ Purchased 34590 5 5... View the full answer
Related Book For
Cornerstones of Financial and Managerial Accounting
ISBN: 978-1111879044
2nd edition
Authors: Rich, Jeff Jones, Dan Heitger, Maryanne Mowen, Don Hansen
Posted Date:
Students also viewed these accounting questions
-
Ed Walker wants to save some money so that he can make a down payment of $ 3,000 on a car when he graduates from college in four years. Required: If Ed opens a savings account and earns 3 percent on...
-
Fred wants to save enough money each year so that he can purchase a sports car in January 2013. Fred receives a large bonus from his employer every December 31. He anticipates that the car will cost...
-
Three years ago, you founded your own company. You invested $100,000 of your money and received 5 million shares of Series A preferred stock. Since then, your company has been through three...
-
Which type of philosophical reasoning begins with one example and varies it to see how dramatic the change is, which uncovers its most crucial characteristics?
-
A Canon black-and-white multifunction laser printer costs $49 and sells for $119.99. Find the rate of markup based on the selling price.
-
Management at Transco Company is considering a proposal to install a third production department in its factory building. With the company's existing production setup, direct materials are processed...
-
In the past five years, there have been significant innovations in technology such as smartphones and tablets. Technology companies rely on intellectual property (IP) rights, such as patents,...
-
The following misstatements are included in the accounting records of the Joyce Manufacturing Company: 1. A shipment to a customer was not billed because of the loss of the bill of lading. 2. A sales...
-
You are the Director of the 6 ICU units at your facility. You have an all RN staff and CNA's in each of the units. Your CNO has recently informed you that he has performed a supply audit and has...
-
Cutler Corporation has a target capital structure of 55 % common stock, 5 % preferred stock, and 40 % debt. Its cost of equity is 16 %, the cost of preferred stock is 10 %, and the cost of debt is 9...
-
A ray of light falls perpendicular to face AB of a prism whose cross section is an isosceles rectangle. The ray follows the path shown in the figure. About the refractive index of the prism material...
-
Every company has its own set of needs and priorities, and when it comes to HR technology, there is no one-size-fits-all tool. At this point, there are already a lot of HR platforms and tools to...
-
Adolescents are on a journey to discover an identity that is separate from their family. Erikson called the psychological conflict of adolescence identity versus role confusion. Current theorists no...
-
Analyse issues concerning the imbalance of digital access that have becoming common fact among society in most developing countries. Your analysis should also include to what extent the phenomenon of...
-
1) Determine why your subject is important to your audience and what your objective is 2) Select a theme; if one is assigned, analyze it 3) Gather informative, helpful material 4) Identify your main...
-
Criss Cross, Inc. produces flair pens that they sell for $7 each. Disney has offered Criss Cross, Inc. $4 per pen for a one-time order of 20,000 pens with a Mickey Mouse sticker on them. Disney would...
-
Prepare an Orientation Plan for the select position utilizing the theories discussed in the text. Discuss appropriate and effective orientation plans and your decision-making process for selecting a...
-
Suppose the S&P 500 futures price is 1000, = 30%, r = 5%, = 5%, T = 1, and n = 3. a. What are the prices of European calls and puts for K = $1000? Why do you find the prices to be equal? b. What...
-
How can there be interest expense each period for non-interest bearing bonds if there are no interest payments?
-
Shortly after July 31, Morse Corporation received a bank statement containing the following information: July cash transactions and balances on Morses records are shown in the following T-account:...
-
Shortly after July 31, Towanda Corporation received a bank statement containing the following information: July cash transactions and balances on Towandas records are shown in the following...
-
Souvenir Sales. The file SouvenirSales.csv contains monthly sales for a souvenir shop at a beach resort town in Queensland, Australia, between 1995 and 2001. [Source: Hyndman and Yang (2018).] Back...
-
Analysis of Canadian Manufacturing Workers Workhours. The time plot in Figure 18 . 22 describes the average annual number of weekly hours spent by Canadian manufacturing workers...
-
Toys R US Revenues. Figure 18 . 23 is a time plot of the quarterly revenues of Toys R US between 1992 and 1995 (thanks to Chris Albright for suggesting the use of these data, which are available in...
Study smarter with the SolutionInn App