project manager- yu xia li project manager assistant- melissa monserrate data modeler assistant-...

10
Project Manager- Yu Xia Li Project Manager Assistant- Melissa Monserrate Data Modeler Assistant- Natalie Torres Data Modeler- Janni Ramirez Our mission is to help keep the environment safer and cause less damage to the Earth. nited States ndrew Woodbridge [email protected]

Upload: silvester-collins

Post on 18-Dec-2015

221 views

Category:

Documents


0 download

TRANSCRIPT

Project Manager- Yu Xia LiProject Manager Assistant- Melissa MonserrateData Modeler Assistant- Natalie TorresData Modeler- Janni Ramirez

Our mission is to help keep the environment safer and cause less damage to the Earth.

United StatesAndrew [email protected]

Our Quote

“Green Energy is ready for anything!” “Green Energy reducing your impact!”

Green Energy is a established retailer of biofuels. We sell biofuels that are manufactured in many different countries. We sell the most efficient biofuel in the United States and around the world. Our goal is to help countries around the world cut back on the amount of natural gas and fossil fuels being used by changing they fuel to our biofuel. Our company buys the oil online and make trips to different restaurants to collect grease and bring it back to the company. Our company and transportation are power by our biofuel. We buy our equipments online from the biodiesel solutions.

Our company is divide into the 7 continent: North America, South America, Africa, Europe, Asia, central America, and Australia. Each sales region has a unique region id. Each continent is then divided into sales districts. Each district has a unique district id. Each district is made up of sales territories. Then each sales territory is broken down into sales areas. Each territories and sale area have unique id.

Each salesperson is responsible for one or more sales areas and has a specific sales quota. We also have sales managers who are responsible for one or more sales districts and sales directors who are responsible for one or more sales regions. Each sales manager is responsible for the territories with his/her districts. Each sale person keep track of the biofuel being brought. We identify all our sales personnel by their employee IDs. We keep track of the employee address, name, phone number, and salary. For our company we keep track of how much we spend on the materials. They are pay $800 a month and are giving health benefit. We are opened Mondays through Fridays from 8:00 am to 8:00 pm and on Saturdays from 8:00 am to 6:00 pm. Our company is closed on Sundays and main holidays like Christmas and Thanksgiving.

Our company keep track of our suppliers and buyers. For every supplier and

buyer we keep track of the company name, address, phone number, and we also assign each company an id. The ID make it easier to find the companies in our database. The biofuel are sold for $3.40 per gallon. We also keep track of how many gallons each company buys from us and when they buy it. The factory make the biofuel and sent it to the warehouse where the shipping company would ship it into different part of the world.

The environment is being damaged by chemicals, pollution and other issues.

We are selling Biofuels to other companies to reduce the damage being caused towards the environment.

Problem Solution

ProceduralBusiness Rules

The biofuel are sold for $3.40 per gallon. Prices of raw material must be recorded and the date it is brought and

where. We are opened Mondays through Fridays from 8:00 am to 8:00 pm

and on Saturdays from 8:00 am to 6:00 pm. Is closed on Sundays and main holidays like Christmas and

Thanksgiving. Employee are pay $700 a month and are giving health benefit. Our company buys the oil online and make trips to different restaurants

to collect grease and bring it back to the company. Our company and transportation are power by our biofuel. Equipments are brought online from the Biodiesel solutions. The biofuel are make in biofuel factory.

StructuralBusiness Rules

We keep track of suppliers and buyers company name, phone number, email and we also assign each company an id.

Each buyer need to give us they address. Each supplier website must be recorded. Each buyer and supplier log need to include price, amount brought/sold and date brought/sold. For every employee we keep track of their address, name, phone number, and salary. Sales personnel by their employee IDs. Each sales region has a unique region id. Each continent is then divided into sales districts. Each district has a unique district id. Each district is made up of sales territories. Each sales territory is broken down into sales areas. Each territories and sale area have unique id. Each salesperson is responsible for one or more sales areas and has a specific sales quota. Each sales manager is responsible for the territories with his/her districts. Sales personnel by their employee IDs. Sales directors are responsible for one or more sales regions. Each sale person keep track of the biofuel being brought. The factory make the biofuel and sent it to the warehouse where the shipping company would ship it

into different part of the world.

BIOFUEL FACTORY

#name*address

*telephone*e-mail

BIOFUEL SUPPLIER

*name◦website

*phone number#id

*email

BIOFUEL BUYER

*name*address

*phone number#id

*email

BUYER LOG

*date sold*price

*amount sold

SUPPLIER LOG

*date brought*price

*amount brought

SALE REGION

#code

SALEPERSON

*specific sales quota#employee ID

*name*address

*phone number*salary

SALE AREA

#id

TERRITORY

#id

SALE DISTRICT

#id

SALE MANAGER

#employee ID*name

*address*phone number

*salary

SALE DIRECTOR

#employee ID*name

*address*phone number

*salaryreceive biofuel from

send biofuel to

be divided into

be divided into

be divided into

belong to

belong to

belong to

be responsible for

be the responsibility of

be responsible for

be the responsibility of

be responsible for

be the responsibility of

be on

be for

be on

be on

be on

be for

be for

be for

WAREHOUSE

#id*address

*telephone

SHIPPING COMPANY

#name*address

*phone number

deliver the product to

send product to a

receive product from

receive biofuel from a

Suppliers

References

http://www.bulkoil.com/index.asp http://www.alnoroil.com/oil.htm http://www.biodieselsolutions.com/default.as

px