Table of Contents

Case Study

Second Time Around Movie Rentals…Page 3

Application Exercise

Priceline.com Financial Analysis…Page 6

Internet Skills Exercise

Online Shopping Comparison…Page 8

To:Taylor and Berkley Daniels

From:Holmes, Nicholas, and Walker Associates

Date:April 8th, 2008

Re:Customer Information Database Alterations

Company Background

The Daniel’s twins have created an offshoot of their grandmother’s movie rental chain, an online video membership group. The rental service allows members in several states to select the titles they want, and hold on to them for a certain period of time, before returning them by mail. The service offers varying levels of membership, each allowing its own maximum set of rentals.

Case Objective

The owner’s are satisfied with their current set up, but are looking to expand. Therefore they have requested that a series of detailed reports and database changes be implemented in order to better assess the clientele with which they are dealing. Through the collection of data about publicity, location, and various demographics we will be able to give the business a better picture of where they need to focus their business efforts.

Information Alterations and Reports

Figure 1.1- This report serves to show, by state, how the customers are hearing about the service, and totals it by state. These numbers will allow Second Time to see how they can best advertise to each of their markets.

Count by State
InitialContactDescription / State / Total State
Another Web Site / AR / 5
Another Web Site / KS / 5
Another Web Site / LA / 5
Another Web Site / TX / 5
Friend / AR / 12
Friend / LA / 12
Friend / OK / 12
Friend / TX / 12
Magazine / KS / 5
Magazine / LA / 5
Magazine / TX / 5
Newspaper / OK / 3
Newspaper / TX / 3
Other / AR / 4
Other / KS / 4
Other / OK / 4
Radio / AR / 7
Radio / KS / 7
Radio / OK / 7
Radio / TX / 7
Search Engine / AR / 3
Search Engine / KS / 3
Television / KS / 6
Television / OK / 6
Television / TX / 6

Figure 1.2- This report will assist Second time in determining who among their users is currently subscribing to their newspapers. This will allow them to go back to those publishers and give them feedback about the customers level of satisfaction with their product.

Newspaper Recipients
LastName / FirstName / Email
Kelly / Val /
Michaels / Baylee /
Randolph / Danette /
Viaze / Joan /
Wu / Tan /
Lavender / Omar /
Sharman / Debra /
Hsieh / Katie /
Kopochesky / Paul /
Brady / Paul /
Wolfe / Dean /
Ewing / Bryce /
Naron / Mike /
Morimota / Yosheto /
Chinyere / Vadnais /
Kyoko / Kokotan /
Peter / Kowalski /

Figure 1.3- This chart shows the distribution of tastes among the various plans offered by Second Time Around Movies, as divided by percentages among the whole of the user base.

Customer Demographic Data

  1. The twin’s best approach would be to approach both Visa and Mastercard. Those are the two most frequently used by the customers, and both is used across state boundaries in enough frequency to warrant involvement in both.
  2. This report shows conveniently which customers are using hotmail accounts.

Hotmail Users
LastName / State / Email
Kelly / TX /
Michaels / AR /
Randolph / TX /
Lavender / KS /
Burgerman / OK /
Parish / KS /
McMann / LA /
Wallace / TX /
Burma / TX /
Peter / OK /
  1. This report lists all the members in Texas towns.

Texas Members
City / State
College Station / TX
Commerce / TX
Dallas / TX
Midland / TX
Midland / TX
Midland / TX
Sherman / TX
Sherman / TX
Sherman / TX
Silver / TX
Waco / TX

Case Summary

This case was a very straightforward exercise in creating tables, reports, and forms. The main challenge in this case was merely keeping the information organized, so as to access it in an efficient way. The information was readily accessible to us, and it was easy to read. Reports were simple to create thanks to thorough tables. Overall it was a simple database exercise.

To: Professor Cindy Stevens

From: Holmes, Nicholas, and Walker Associates

Date: April 8, 2008

Re: Application Exercise

Priceline.com

Success or Failure?

After looking at the income statements of Priceline Com Inc. the company is a success. It is a success because its gross profits have increased over the past three years. The margins it works in have also increased, but that should be expected with any growing business. Though the net income for stockholders has shifted, and is lower in 2007 than it was in 2005, I still feel the company is still a success.

If Priceline wanted to increase its success, it could potentially expand its offered services. It could also diversify and create smaller businesses to increase total profits across the board. By focusing more into customer service and decreasing prices, it would also be able to turn a higher profit.

On the attached page is a detailed spreadsheet which helps to prove this indefinitely.

Year End (Value in Thousands, Except Shares)
2007 / 2006 / 2005
Total revenues / $1,409,409.00 / $1,123,103.00 / $962,660.00
Total costs of revenues / $769,997.00 / $722,004.00 / $694,797.00
Gross profit / $639,412.00 / $401,099.00 / $267,863.00
Total operating expenses / $501,477.00 / $339,113.00 / $231,979.00
Operating income / $137,935.00 / $61,986.00 / $35,884.00
Total other income (expense) / $12,088.00 / $3,646.00 / (181
Income tax benefit (1) / $12,059.00 / $12,388.00 / $156,277.00
Equity in income (loss) of investees and minority interests / $5,000.00 / $3,554.00 / $749.00
Net income (1) / $157,082.00 / $74,466.00 / $192,729.00
Net income applicable to common stockholders (1) / $155,527.00 / $72,539.00 / $190,875.00
Net income applicable to common stockholders per basic common share (1) / $4.13 / $1.88 / $4.87
Net income applicable to common stockholders per diluted share (1) / $3.42 / $1.68 / $4.21
Total assets / $1,350,856.00 / $1,105,648.00 / $754,028.00
Long-term obligations, minority interest and redeemable preferred stock (2) / $646,702.00 / $656,420.00 / $313,942.00
Total liabilities (3) / $754,713.00 / $721,136.00 / $347,828.00
Total stockholders’ equity / $579,107.00 / $348,556.00 / $369,071.00

To: Cindy Stevens

From: Holmes, Nicholas, and Walker Associates

Date: April 7, 2008

Re: Building Internet Skills

Yahoo! Store has a good backing of people and allows you to communicate with other people to find the cheapest product possible that you need. Yahoo has been around for a long time and the technology they have on their site makes it easier to use. I like yahoo because its user friendly and it makes my job easier finding the products and learning how to set my business up online more sufficient.

Freemerchant.com is a company that many people do not know about but they have products on there that you can find it just takes you a little bit longer to find because not many people use it like they do with yahoo. Freemerchant.com is easier sometimes because they do not have all the other things like yahoo has for example email, IM, games and auto store. Freemerchant.com just deals with things that you could buy in a mail or a local retail store. For me though I like yahoo because it has a better reputation and I know how to use it because I have been using yahoo ever since dot coms came into the internet.

Page | 1