View the step-by-step solution to:

INTRODUCTION Your project will illustrate just how dramatically the reduced cost of very fast computing power has contributed to the growth of supply...

INTRODUCTION
Your project will illustrate just how dramatically the reduced
cost of very fast computing power has contributed to the
growth of supply chain–related systems. For your project
example, you’ll use the stock price for Oracle, a publicly
traded firm.
The primary motivation for this project is to have you go
through replication steps, which will give you some historical
perspective on just how significant supply chain management
(and the related software and decreased computing power
costs) has been in recent decades. Clearly, the meteoric rise
in the price per share for Oracle, a major provider of relational
data base software, represents a proxy for the growth
in this field of expertise.
INSTRUCTIONS
This project is what we call a “compliance” project.
Effectively, we’re giving you the solution, in advance, and
you’re “replicating” the results. You’ll create a spreadsheet
and graph.
First, review Figure 12.1 on page 379 of your text.
Figure 12.1 provides a timeline of supply chain–related
information systems.
Second, review the table in Figure 1 and the graph in
Figure 2, which approximate the reduction of cost associated
with the cost of computing power, per megabyte. Note that
the decline is so dramatic, in nominal dollars, that it was
necessary to redo (splice) the table into two separate tables,
which still doesn’t completely display the graphics from 1980
through 2004.
Several firms enjoyed rapid stock price growth during the
1990s, due to the sale of their software. Go to Yahoo! Finance
and download the history of the daily stock price for Oracle
(ORCL) and create a graphic or line graph. You’ll notice that,
from 1989 through early 2000, the stock price increased from
about $10 per share to about $3,751 per share, after adjusting
for stock splits. Effectively, investing $1,000 in 1989
turned into about $250,000 in early 2000. Figure 2 covers
January 1989 through August 2008, and is made available
for reference and Figure 3 represents the project solution.
PROCEDURE
Step 1: Go to the Yahoo! Finance Web site:
http://finance.yahoo.com/
Step 2: Enter the stock ticker symbol for Oracle (ORCL)
and click Get Quotes.
Step 3: Click the Historical Prices link on the left.
Step 4: Scroll down, click the Download link, and save this
data to your computer.
You now have an Excel spreadsheet, the starting point for
creating a graph. You can delete all columns other than the
“Date” and “Close” (i.e., closing stock price) columns. You’ll
have to adjust the stock prices for stock splits. The stock
splits and dates are located on the “Historical Chart” page.
Click Basic Chart, and next to Range, click max. The chart
for the entire history of Oracle will display, along with stock
split information.
If you have any problems creating a chart using the downloaded
information, us the “Help” function in the Excel
toolbar. The completed chart should look like the chart in
Figure 2.
Grading Criteria
The following is a breakdown of how your project will be
graded:
Locate, identify, and correctly
download the stock price
information from Yahoo! Finance 20 points
Locate, identify, and correctly
adjust stock prices for stock splits 40 points
Create a well-organized Excel
spreadsheet for instructor review 20 points
Create an Excel graph or replication 20 points
Total 100 points

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question