Reference no: EM13949318
Moonlight Distributors is a 10-year-old transportation firm that specializes in pickup and delivery from a wide range of businesses. There is a corporate office in Chicago, IL and three regional offices in Pittsburgh, PA, Omaha, NE, and San Francisco, CA.
Diane, the CEO, has been seeing sales and profits slip for the past three years. Tony from billing says that the problem lies in getting accurate and timely information from the regional offices. Because of all the paper work involved, the three regional managers complain that they can't get the information to Tony any faster.
Every shipment, about 10,000 per month per region, requires a pickup document with the shipper information, a description of the goods to be shipped, where these goods are going, and who is paying the freight. Once the pick up is made and brought back to the terminal, the goods need to be checked against the manifest and then set up for delivery. Once the drivers come back off the delivery route, they fill out delivery documentation including when the goods were signed for.
You are the IT Director for Moonlight, and have been mandated by Diane to create a system that would reduce the overhead at the regional terminals. You suggest putting in a distributed computer system, having computers at each of the regional offices and corporate headquarters. You created a conceptual design for the shipping information system and will eventually link it to the Billing, Finance, and Marketing Systems.
Some of the information that is needed is - status of every pick up and delivery, weekly reports for On-Time-Delivery, a monthly report on new customers, profitability, market share gains and losses, the number of new customers, the volume and charges, and how many problems occurred that cut into profits (such as late delivery, damage delivery, and refused shipments).
Assignment
Your supervisor requested a short memo identifying each of the five W's and the H (Who, What, Where, When, Why, and How) and how each could influence the design of the logical database model. Compose an 600-word e-mail to your supervisor.
Question:
I need help idenfiting the five W's and the H (Who, What, Where, When, Why, and How) of the database.
|
How many different products are there in the hospital
: How many different products are there in the hospital? How do you assign the costs of the support departments to individual products?
|
|
Dividends are expected to grow-what is projected dividend
: ACME is growing fast. Dividends are expected to grow at 30% per year during the next 3 years, 18 % over the following year, and then 8% per year indefinitely. The discount rate is 13%, and the stock currently sells for $65 per share. What is the proj..
|
|
What is the ip address and tcp port number
: What is the IP address and TCP port number used by the client computer that is transferring the file - What is the IP address and TCP port number used by your client computer to transfer the file to gaia.cs.umass.edu?
|
|
Repurchasing all of the outstanding shares
: ACME is a very cyclical type of business which is reflected in its dividend policy. The firm pays a $2.00 a share dividend every other year. The last dividend was paid last year. Five years from now, the company is repurchasing all of the outstanding..
|
|
How each influence the design of the logical database model
: Your supervisor requested a short memo identifying each of the five W's and the H (Who, What, Where, When, Why, and How) and how each could influence the design of the logical database model. Compose an 600-word e-mail to your supervisor.
|
|
Why do we use foretasted cash flows instead
: Why do we use foretasted cash flows instead of foretasted accounting earnings in estimating the NPV of a project?
|
|
Introduce new portable camper to fill out its product line
: Winnebagel Corp. currently sells 23,000 motor homes per year at $61,000 each, and 8,500 luxury motor coaches per year at $98,000 each. The company wants to introduce a new portable camper to fill out its product line; it hopes to sell 18,000 of these..
|
|
Prepare a production budget for the first quarter
: Prepare a production budget for the first quarter. Prepare a direct materials purchases budget for the first quarter. Prepare a direct labor budget for the first quarter.
|
|
Rolling papers typically sold in convenience stores
: Everyone knows that almost all rolling papers typically sold in convenience stores are used for smoking marijuana, as are most pipes, bongs, bowls, and bats that are sold in head-shops. Should marijuana paraphernalia be legal? What would happen in..
|