OVERVIEW

David Wong and Kiran Sidhu are business partners and the current owners of a relatively young new car dealership in Surrey called Excellence New Cars. Excellence has grown quickly from a small car sales only dealership to a company which provides new car sales and service, financing solutions and parts sales. Currently they do not have a pre-owned sales department, but they will soon expand into this business as well.

The dealership has four main departments as described above: new car sales, service, parts sales, and new car financing. Each department has a manager as well as staff, and there is a dealership general manager as well. There are six sales representatives, four service advisers and six technicians, two parts sales reps, three financing agents, as well as a number of support staff. With the success of their Surrey dealership, David and Kiran are now considering opening another dealership in Richmond.

David and Kiran recently decided that the information system provided by the car manufacturer (which shall remain nameless for this project, but it could be an Asian car manufacturer) is not perfectly suited to their needs. They would like you to build a custom information system to support its business needs. The new system would replace a mix of paper-based and digital systems. The business partners have asked you to design an information system that would support the dealerships current operations and future growth.

In your first meeting, Kiran provided an overview of the dealerships business processes and staff members. She identified the managers within the dealership: Rohit Dhaliwal is general manager, Frank Johnson is new car sales manager, Wendy Hanyu is service manager, Janu Richards is parts manager, and Lynn Chan is financing manager. Stuart Young is office manager for the dealership. Stuarts employees include Hannah Zhou and Parm Sidhu, who look after human resources and payroll. Tim Brown, Olivia Wong and Emma OBrien report to Stuart looking after salaries, benefits and employment details for the dealerships staff.

The sales department has six sales reps: Harjit Sandhu, Karnveer Singh, Phil Wright, Brenda Dong, Jane Edmundsen and Alan Koenig. The service department has four service advisors who set up service appointments and deal with customers who are having their cars serviced. The advisors are Lindsay Carter, Ricky Sherwani, Jason Pruett and Kim Connor. The parts department has two sales reps, Sara Jamshidi and Vicki Ng, who take in-person and over-the-phone orders. The finance agents are Bill Picardo, Nancy Tan, and Gurjit Manhas.

Each of the people mentioned in the above section should have their own workstation, and of course their own user account. The sales department shares two pooled printers. The service department has two pooled laser printers as well at the reception area, but there are also two printers in the service bay area. The service bay area also has two computers that are able to access the service work orders. Technicians do not have personal user accounts; generic technician accounts should be set up for their use. The parts department has one printer, and one printer is shared by everyone in the financing department. The dealership also has a workstation for the dealerships receptionist, who reports to Stuart (the receptionist uses a generic user account). Stuarts administrative department shares two printers.

Internet access via a broadband connection with a local Internet service provider. Guest WiFi is provided for customer convenience, but this does not need to be implemented in your project.

Network Diagram and Plan

Complete a Network Diagram (using Microsoft Visio, for example) showing all devices (router, Network Printers, SAN if any, etc) and their IP addresses (specific addresses for static IP addresses, or DHCP for any dynamically allocated addresses). Also include approximate costing information for the network devices and software. Remember to cost out Windows Server 2012 R2 and the Client Access Licenses for the workstations. Please include all Organization Units and Groups that you would use as well.