Read the article -tweaking the numbers

Assignment Help Other Subject
Reference no: EM131017213

a. Read the article "Tweaking the Numbers," by Theo Callahan in the June 2001 issue of the Journal of Accountancy (either the print edition, likely available at your school's library, or access the Journal of Accountancy archives at www.aicpa.org). Follow the instructions in the article to create a spreadsheet with graphs that do what-if analysis.

b. Now create a spreadsheet to do graphical what-if analysis for the "cash gap." Cash gap represents the number of days between when a company has to pay its suppliers and when it gets paid by its customers. Thus, Cash gap = Inventory days on hand + Receivables collection period - Accounts payable period.

The purpose of your spreadsheet is to display visually what happens to cash gap when you "tweak" policies concerning inventory, receivables, and payables.

c. Set the three spin buttons to have the following values:

Spin button for Inventory Spin button for Receivables Spin button for Payables
Linked cell C2 C3 C4
Maximum 120 120 90
Minimum 0 30 20
Value 30 60 20
Small change 10 10 10

D. In addition, conduct research and seek out an ERP accounting system. Briefly summarize what report writer software is either embedded in it or which one would work to provide management with a production report. Include links to your source.

Reference no: EM131017213

Questions Cloud

Paper - the protection of educational rights for children : Can you do a research paper (20.pg) about (the protection of the educational rights for children with special education in CALIFORNIA)
Safety of motor carriers on the road : Demonstrate how the paraphrase would appear in your research paper - The Relationship between Motor Carrier Financial Performance and Safety Performance.
What is the rationale for accounting for non expendable : What is the rationale for accounting for non expendable endowment funds on a full, rather than a modified, accrual basis? Why is it important that depreciation be charged on long-term assets held as fiduciary fund investments?
How planning-programming budgeting could be implemented : Explain how Zero-Based Budgeting could be implemented to the program(s) you chose. Explain how Planning-Programming Budgeting could be implemented to the program(s) you chose
Read the article -tweaking the numbers : Now create a spreadsheet to do graphical what-if analysis for the "cash gap." Cash gap represents the number of days between when a company has to pay its suppliers and when it gets paid by its customers. Thus, Cash gap = Inventory days on hand + ..
Write about the case atkins vs virginia : Write about the case Atkins v. Virginia (#171). It is a case that discusses whether or not it is constitutional to put to death those people who are guilty of a serious crime but suffer from a mental handicap or a mental illness
How can you create and maintain the chart of accounts : Describe them. What are some key reports one can generate to measure the firm's financial performance?
Judy a cash basis taxpayer leases office buildings to : Judy, a cash basis taxpayer, leases office buildings to commercial tenants. During 2015, she receive $10,000 from various tenants a refundable damage deposits, $300,000 for 2015 rents, and $50,000 for 2016 rents. How much should Judy include in 2015 ..
Explain how to calculate the allowance for doubtful accounts : Explain how to calculate the allowance for doubtful accounts and the bad-debt expense in a hospital.

Reviews

Write a Review

Other Subject Questions & Answers

  Discuss the principles of holistic care

Discuss the principles of holistic care and the four principles of the holistic caring process

  How much time do americans spend eating or drinking suppose

how much time do americans spend eating or drinking? suppose for a random sample of 1001 americans age 15 or older the

  Physiology or anatomy-electron cell tissue alive organ

Which one can be used physiology or anatomy. electron cell tissue alive organ. brain stomach heart liver epithelium. epithelium heart muscle tissue nervous tissue connective tissue

  Would you notice any change in your pulse

If you were moving away from Earth at nearly lightspeed without acceleration, according to Einstein's special theory of relativity, would you notice any change in your pulse? Any change in your breathing rate? Anything unusual about your clocks? W..

  How can a request for information assist a health care

how can a request for information assist a health care organization with the selection of a new health information

  Where strategic planning comes as we deal with change

Have you thought about where strategic planning comes as we deal with change? HR is right at the front door because of all the data collected. Which role will have more emphasis, administrative or strategic?

  Stealing out of necessity

In a 2 page paper, describe a personal experience in which you or someone you know had to make a moral decision-for example, cheating on an exam, stealing out of necessity, or being forced to give up a personal freedom. Include the following in yo..

  Limitation on the number of emergency

Manageable Span-of-Control within SEMS/ICS is a limitation on the number of emergency response personnel who can effectively be supervised or directed by an individual supervisor. The type of incident, the nature of the response or task, distance,..

  Create a fictional adolescent character

Identities Paper: In this paper, you will create a fictional adolescent character (between 14 and 16). This character may be as similar to or different from you as you like

  Morewell-constructed paragraphs

Answer ONE of the following intwo or morewell-constructed paragraphs.

  Embassy motorcycle manufactured-optimal solution

Embassy Motorcycle (EM) manufactured two lightweight motorcycles designed for easy handling and safety. The EZ-Rider model has a new engine and a low profile that make it easy to balance. The Lady-Sport model is slightly larger, use a more traditiona..

  What technology would you put on your list to purchase

what technology would you put on your list to purchase? Be specific about which systems you would purchase by doing some research.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd