Cash gap analysis
Not what you're looking for?
xcel spreadsheet help
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.
Purchase this Solution
Solution Summary
Excel spreadsheet for graphical demonstration of change in inventory, receivables and payables on cash gap. Also included is document on ERP accounting system.
Solution Preview
MICROSOFT DYNAMICS ERP ACCOUNTING SYSTEM
Microsoft Dynamics is an enterprise resource planning (ERP) software that connects entire business together from financial and supply chain management and from manufacturing to operations. The benefit of Microsoft Dynamics is that it enables finances, sales and operations to run on applications which work together with Microsoft Office apps which are well known with users.
Microsoft FRx ...
Purchase this Solution
Free BrainMass Quizzes
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.