What report writer software is embedded

Assignment Help Finance Basics
Reference no: EM13907176

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: EM13907176

Questions Cloud

Find example most current year in each of funds were used : discuss when the government and nonprofit organizations would use each of the following funds:- Capital projects fund and Debt service fund
Explain the management advantages of outsourcing : Explain the management advantages of outsourcing
Amount of the order for computer : Decision Tree Using the SOS, EraTech sends out invoices monthly and will gi,e discounts if payments are made within 10 days, The discount policy is as follows:
Worst-case and best-case running times : a. Write a pseudocode for this algorithm. b. What are the worst-case and best-case running times for this sorting algorithm?
What report writer software is embedded : 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 a only the client program : If the command is ADD then the details roll number and name will be added to a file. After adding the current request the file is sent back to the client. Write a only the client program.
Set of integer numbers and another single number : Write an algorithm called locate (with running time log n, that accept a set of integer numbers and another single number and finds out whether the number is found in the set of integers. If it exist, it should print its index in the list otherwis..
What is the maximum duration : A computer on a 10Mbps network is regulated by a token bucket. The token bucket is filled at a rate of 2Mbps. It is initially filled to capacity with 16Megabits. What is the maximum duration for which the computer can transmit at the full 10Mbps?
What can you expect from negotiators : What can you expect from negotiators

Reviews

Write a Review

 

Finance Basics Questions & Answers

  Computing cost of capital

A company is applying capital budgeting to a foreign investment opportunity in England. The risk free rate in England is 3.83% and risk free rate in the US is 3.56%.

  Find the value per share of the company''scommon stock

Find the value per share of the company'scommon stock

  A firm has inventory of 11000 accounts payable of 9800

a firm has inventory of 11000 accounts payable of 9800 cash of 850 net fixed assets of 12150 long term debt of 9500

  What is the pv of the project

a project has a forecast cash flow of $128 in 1 year and $139 in year 2. The interest rate is 7%, the estimated risk premium on the market is 12.00% and the project has a beta of .68.

  What is the ebitda coverage ration

What is the EBITDA coverage ration?

  What are the two definitions of cash and why do corporate

what are the two definitions of cash and why do corporate treasurers often use the second

  Objective type questions on cost of capital

Objective type questions on cost of capital and capital budgeting and rule states that a typical investment project with an IRR that is less than the required rate should be accepted

  Imagine that you are a financial manager researching

imagine that you are a financial manager researching investments for your client that align with its investment goals.

  Permitting hobbies on capital

It was chosen in April 2011 that benefits ought to be disseminated just as in the wake of permitting hobbies on capital @ 6%per annum with impact from first April, 2010.

  Which is riskier to the company

Is the agreement between the company and its investment banker an example of a negotiated or a best-efforts deal? Why? Which is riskier to the company? Why?

  Benefit package provided by a health maitenance organization

The benefit package provided by a Health Maitenance organization differs from major medical indemnity policy in that it -encourages preventative care -usually provides prescription benefits

  Another european vanilla call option with stike price k2 gt

the riskless interest rate rgt0the underlier is trading at a spot price s and all options are european vanillas on the

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