1 / 8

Team 3 Alex Killian Jigar Jani Andrew Demske Zac McGee Lanh Thi An Nguyen

Team 3 Alex Killian Jigar Jani Andrew Demske Zac McGee Lanh Thi An Nguyen. Eastman Machine Company, manufacturing company, which manufactures and sells cutting machines Located in downtown Buffalo; open for 125 years.

gavril
Download Presentation

Team 3 Alex Killian Jigar Jani Andrew Demske Zac McGee Lanh Thi An Nguyen

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Team 3 Alex Killian JigarJani Andrew Demske Zac McGee LanhThi An Nguyen

  2. Eastman Machine Company, manufacturing company, which manufactures and sells cutting machines • Located in downtown Buffalo; open for 125 years. • We are creating this database to help keep track of costs that associate with selling machine’s( flight, hotel reservation, etc)

  3. Business problem • Time wasted Manually looking up past records by going to the file cabinets. Making the file for each individual technician and looking into the different expense sheets for the information. • Difficult to analyze and make conclusions . • analysis tool for past per diums given.

  4. Identification of business value • Allows examining of the different costs, and details about the services that go along with selling of the automated cutting machines • Save time Ex: Helping the secretary find which hotel has the best rates as well as locations in accordance to the customers location.

  5. Identification of business value • Creating the analysis on • the expenses incurred by the technicians • the break down of these expenses. • total costs for a customer/technician. • the average per dium rates Ex: Helping Upper management know what the costs where, why they were charged to the company credit card

  6. Database design overview

  7. Project demonstration • Explanation through the database

  8. Conclusion • Eastman’s business becomes more efficient • Efficienttool for managers to see trends of costs • Giving ease of retrieval by many different people who will use it to add, view and delete data. • Providing useful reports that show expenses for customers, and job shipments and service dates, per diums for specific location, locations details, including hotel information.

More Related