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
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.
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
First, review Figure 12.1 on page 379 of your text.
Figure 12.1 provides a timeline of supply chain–related
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
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.
Step 1: Go to the Yahoo! Finance Web site:
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
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
The following is a breakdown of how your project will be
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
- The following question is from the book Mischa Schwartz, "Telecommunication Networks: Protocols, Modeling, and Analysis," Addison Wesley, 1987. (ISBN-10:
- The Better-bit Construction Company has a series of equal, quarterly cash flows of $1,200, starting with a cash flow on January 1, 2013 and ending on July 1,
- Describe self-awareness, stranger wariness, and separation anxiety.