Reference no: EM131015084
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.
|
Results of a study on vitamins
: The data set vitamin .txt contains the results of a study on vitamins. Three groups of test subjects each received a different treatment (three different vitamin formulations). Each subject's calcium levels before and after treat ment were record..
|
|
How does culture affect innovation
: Describe the different steps in planning for innovation? Why is planning so important in today's business world to ensure that you stay on top?
|
|
Explain free and forced vibration
: Explain free and forced vibration - free and forced vibration of simple harmonic motion in physics.
|
|
Amount of the formulation component
: Describe how the max load is affected by the amount of the formulation component and how the substrate affects that relationship.
|
|
Article - tweaking the numbers
: 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). F..
|
|
Explain the term natural frequency
: Explain the term natural frequency - This problem related to natural frequency of simple harmonic motion in physics.
|
|
Effect of formulation changes for a lens coating
: The data set odor .txt contains three responses gathered from a factorial design (described in Chapter 9). The purpose of the experiment was to study the effect of formulation changes for a lens coating on three primary responses:
|
|
Prepare a chart comparing the unit costs
: Prepare another schedule showing the total costs attached to each of the completed jobs using the pool rates above to apply the overhead and the prime costs found in part 1. Break the information down into unit cost for material, labor and overhea..
|
|
Corresponding moisture levels for raw material
: The ratings discussed in Problem 3 were constructed because the company felt that the moisture levels in the raw material were causing them to have problems in their plant. The data set rat ings2 . txt contains both the ratings and the correspondi..
|