Auto Parts Selection Site II

Scope of Work- Auto Bulb Parts Selection Site Date: 12/20/2008 Revision: - CL (CL): Service SP (SP): TBD Summary of overall Goals: Develop a new website that incorporates vehicular bulb reference data for each model year, model and make. 1. This website will allow users to look up a list of parts for their vehicle by selecting as follows: 1. Part Category 2. Make and Model Year 3. Model The parts categories will be selectable. 2. After these selections are made, a list of the correct parts for that combination of Part Category, Make, Model Year and Model will be displayed using a graphic image. 3. Each page will display frames to allow the administrator to display links to other pages and banner advertisements. The main data frame showing the search results will be static, but the administrator can change and update the frames by changing a single file. Other frames will be dynamic and display up to 10 banner advertisements that appear randomly from a master list that is controlled by the administrator. 4. All pages must appear in HTML format so that they can be crawled by the search engines for content. 5. The initial phases (Phase I and II) of the project will only set up the Automotive Light Bulbs Data. This scope shall set up the framework to look up other part categories, but it will not populate the data for other part categories, such as Automotive Oil Filters, etc… The initial bid (Phase I) shall only include populating the data for model year 2007. Phase II shall be a separate project and shall be bid after the completion of phase I. Phase II shall be to populate all data for the remaining light bulbs used in all models and makes for 1950-2006 and 2008 model years. 6. Data accuracy for this project is extremely important. Extra emphasis must be placed to assure that the data that is looked up accurately, thoroughly precisely and translated into the new website Overview: i. Part Categories. The initial page will contain Part Categories as follows: A. Automotive Light Bulbs B. Automotive Oil Filters C. Automotive Air Filters D. Etc… This list of Part Categories shall be a simple HTML page that can be updated easily using any HTML editor. The initial phase of the project will only set up the Automotive Light Bulbs Data. This scope shall set up the framework to look up other part categories, but it will not populate the data for other part categories, such as Automotive Oil Filters, etc… Each page shall be formatted exactly the same so that the frames can be updated from a single page. We refer to the parts of the pages as follows: Body Frame: The body frame shall contain the main page content. Header Frame: The header frame shall contain the graphic banner displaying the new website name and also contain an area for links to other web pages. These links should appear as drop down menus with 5 categories. Each category shall have multiple link names that act as hyperlinks to various web pages. These category names, link names and hyperlinks shall be changeable from the MAP (Master Administration Panel). Right Hand Margin Frame: The right hand margin frame shall contain an area for banner advertising. The frame banner advertisements shall allow a space for a banner ad, a hyper link to the website and a description field that describes the website. This combination shall be referred to as an advertising campaign. The right hand margin frame will be dynamic and display up to 10 banner advertisements that appear randomly from a master list that is controlled by the administrator. The administrator can add, delete, activate or deactivate any of the advertising campaigns from the MAP. Each advertising campaign shall consist of three components: 1. Image with a hyperlink. 2. Description Field Below the image will be a Description Field that will describe the CLs website: Example: For LVD Bulbs 3. Text Hyperlink Below that will be displayed a Text Hyperlink that links to the CL website: [login to view URL] The active banner ad image, link and description shall be able to be changed added and deleted from the MAP. In addition, each banner ad can be deleted, activated or deactivated from the MAP. This will allow older banner ads to be retained but deactivated so that they will not appear on the web pages. The administrator can also reactivate any banner advertising campaign from the MAP so that they will again appear on the web pages ii. Make and Model Year. After selecting the Part Category, the user will be presented with a list of all the vehicle Makes and Model years. The data for these drop-down menus shall be 1950-2008 and be capable of being extended for subsequent model years to come.: This list must also be able to be updated from the MAP to allow new model years and models to be added. iii. Model. After selecting the Make and Model Year, the user will be presented with a list of all Models for that make and model year. iv. Bulb Part List. After selecting the Model, the user will be presented with a list of all of the light bulbs used in that make and model year. This list shall be complied using the data available on the Internet. Each part number and text shall have a substitute text displayed that shall be provided to you in advance. As an example: The 2007 BMW bulbs list page looks like this: 2007 BMW 500 Series (With replaceable halogen capsules) Low beam headlamp H7LL H7SU Silverstar ULTRA for Ultra Night Vision - The Whitest and Brightest Halogen H7ST Silverstar High Performance Lighting: The Whiter and Brighter Halogen H7XV XtraVision Halogen - The Brighter Light H7CB Cool Blue Halogen - The Whiter Light High beam headlamp H7LL H7SU Silverstar ULTRA for Ultra Night Vision - The Whitest and Brightest Halogen H7ST Silverstar High Performance Lighting: The Whiter and Brighter Halogen H7XV XtraVision Halogen - The Brighter Light H7CB Cool Blue Halogen - The Whiter Light Parking light 2825LL Front turn signal 7507 7507AST Silverstar Signal Lighting: Complete the Look: Crisp, Clean, Style 7507LL Long Life Upgrade: Up to twice the life of the standard lamp 2827 Rear turn signal 7507 7507AST Silverstar Signal Lighting: Complete the Look: Crisp, Clean, Style 7507LL Long Life Upgrade: Up to twice the life of the standard lamp Tail light 7506LL Stop light 7506LL High mount stop light Assembly Fog/Driving light 9006 9006SU Silverstar ULTRA for Ultra Night Vision - The Whitest and Brightest Halogen 9006ST Silverstar High Performance Lighting: The Whiter and Brighter Halogen 9006XV XtraVision Halogen - The Brighter Light 9006CB Cool Blue Halogen - The Whiter Light License plate 6418 6418LL Long Life Upgrade: Up to twice the life of the standard lamp Back up light 921LL Glove box 6418 6418LL Long Life Upgrade: Up to twice the life of the standard lamp Map light 6486X Dome light 6486X Step/Courtesy light 6411 6418 6418LL Long Life Upgrade: Up to twice the life of the standard lamp 6486X Trunk/Cargo area 6411 Instead, the new page would look like this: Tabular display: [login to view URL] Graphic display: [login to view URL] The admin panel shall be set up to operate as follows: 1. Each location shall have the identical Locations identified as follows: Bulb Location Low beam headlamp High beam headlamp Low/High beam headlamp Parking light Front turn signal 1 Front turn signal 2 Rear turn signal 1 Rear turn signal 2 Front side marker Rear side marker Tail Light 1 Tail Light 2 Stop Light 1 Stop Light 2 High mount stop light Fog/Driving light License plate Back up light Glove box Map light 1 Map light 2 Dome light 1 Dome light 2 Step/Courtesy light 1 Step/Courtesy light 2 Step/Courtesy light 3 Trunk/Cargo area Ash Tray Under hood light Instrument-general 1 Instrument-general 2 Instrument-general 3 Instrument-general 4 Instrument-general 5 Directional signal indicator Radio Dial Clock Hi-beam indicator Seat belt indicator Brake warning Ignition switch Automatic transmission indicator Check engine indicator 2. For each bulb location for each model, model year, and make, a bulb part number shall be entered. 3. The remaining columns shall be automatically populated from a lookup table that is keyed from the bulb part number. Example: Only the part numbers are entered like this: Bulb Location Part Number Low beam headlamp H7 High beam headlamp H7 Low/High beam headlamp N/A Parking light 2825 Front turn signal 1 7507 Front turn signal 2 N/A Rear turn signal 1 7507 Rear turn signal 2 N/A Front side marker 2827 Rear side marker N/A Tail Light 1 7506 Tail Light 2 N/A Stop Light 1 7506 Stop Light 2 N/A High mount stop light Assembly Fog/Driving light 9006 License plate 6418 Back up light 921 Glove box 6418 Map light 1 6486X Map light 2 N/A Dome light 1 6486X Dome light 2 N/A Step/Courtesy light 1 6411 Step/Courtesy light 2 6418 Step/Courtesy light 3 6486X Trunk/Cargo area 6411 Ash Tray N/A Under hood light N/A Instrument-general 1 N/A Instrument-general 2 N/A Instrument-general 3 N/A Instrument-general 4 N/A Instrument-general 5 N/A Directional signal indicator N/A Radio Dial N/A Clock N/A Hi-beam indicator N/A Seat belt indicator N/A Brake warning N/A Ignition switch N/A Automatic transmission indicator N/A Check engine indicator N/A From this information, the remaining fields shall be populated from the lookup table. For example: Entering Part Number H7 calls up the remaining columns associated with Part Number H7: Bulb Location Part Number Common Part Number & Description Part Number Cross References Image (click to enlarge) Link to Specs. Purchase Bulbs Low beam headlamp H7 H7 H7 PX26d Specifications Buy Now The entire list for a model, model year, and make may look like this: Bulb Location Part Number Common Part Number & Description Part Number Cross References Image (click to enlarge) Link to Specs. Purchase Bulbs Low beam headlamp H7 H7 H7 PX26d Specifications Buy Now High beam headlamp H7 H7 H7 PX26d Specifications Buy Now Low/High beam headlamp N/A N/A N/A N/A N/A N/A Parking light 2825 194 194 W5W 147 152 158 159 161 168 184 192 193 259 280 285 447 464 555 558 585 655 656 657 1250 1251 1252 2450 2652 2921 2825 Specifications Buy Now Front turn signal 1 7507 7507 7507 Bau15s PY21W Specifications Buy Now Front turn signal 2 N/A N/A N/A N/A N/A N/A Rear turn signal 1 7507 7507 7507 Bau15s PY21W Specifications Buy Now Rear turn signal 2 N/A N/A N/A N/A N/A N/A Front side marker 2827 194 194 W5W 147 152 158 159 161 168 184 192 193 259 280 285 447 464 555 558 585 655 656 657 1250 1251 1252 2450 2652 2921 2825 Specifications Buy Now Rear side marker N/A N/A N/A N/A N/A N/A Tail Light 1 7506 1156 1156 P21W 1073 1093 1129 1141 1159 1295 1459 1619 1651 1680 7506 7527 Specifications Buy Now Tail Light 2 N/A N/A N/A N/A N/A N/A Stop Light 1 7506 1156 1156 P21W 1073 1093 1129 1141 1159 1295 1459 1619 1651 1680 7506 7527 Specifications Buy Now Stop Light 2 N/A N/A N/A N/A N/A N/A High mount stop light Assembly N/A N/A N/A N/A N/A Fog/Driving light 9006 9006 9006 Specifications Buy Now License plate 6418 35mm festoon 6413 6418 6421 6429 6450 C5W Specifications Buy Now Back up light 921 921 579 901 904 908 909 912 914 915 916 917 918 920 921 922 923 926 927 928 939 Specifications Buy Now Glove box 6418 35mm festoon 6413 6418 6421 6429 6450 C5W Specifications Buy Now Map light 1 6486X 35mm festoon 3423 3425 6411 6423 6486x Specifications Buy Now Map light 2 N/A N/A N/A N/A N/A N/A Dome light 1 6486X 35mm festoon 3423 3425 6411 6423 6486x Specifications Buy Now Dome light 2 N/A N/A N/A N/A N/A N/A Step/Courtesy light 1 6411 41mm festoon 3423 3425 6411 6423 6486x Specifications Buy Now Step/Courtesy light 2 6418 35mm festoon 6413 6418 6421 6429 6450 C5W Specifications Buy Now Step/Courtesy light 3 6486X 35mm festoon 3423 3425 6411 6423 6486x Specifications Buy Now Trunk/Cargo area 6411 41mm festoon 3423 3425 6411 6423 6486x Specifications Buy Now Ash Tray N/A N/A N/A N/A N/A N/A Under hood light N/A N/A N/A N/A N/A N/A Instrument-general 1 N/A N/A N/A N/A N/A N/A Instrument-general 2 N/A N/A N/A N/A N/A N/A Instrument-general 3 N/A N/A N/A N/A N/A N/A Instrument-general 4 N/A N/A N/A N/A N/A N/A Instrument-general 5 N/A N/A N/A N/A N/A N/A Directional signal indicator N/A N/A N/A N/A N/A N/A Radio Dial N/A N/A N/A N/A N/A N/A Clock N/A N/A N/A N/A N/A N/A Hi-beam indicator N/A N/A N/A N/A N/A N/A Seat belt indicator N/A N/A N/A N/A N/A N/A Brake warning N/A N/A N/A N/A N/A N/A Ignition switch N/A N/A N/A N/A N/A N/A Automatic transmission indicator N/A N/A N/A N/A N/A N/A Check engine indicator N/A N/A N/A N/A N/A N/A Additional requirements: The Service SP (SP) shall be responsible to provide the CL (CL) the following: Software to accomplish the following tasks: 1. Code for each of the web pages as defined in the Overview section. 2. Software for the MAP as described in the Overview section. 3. Populate the automotive bulb sections with data using the Osram site as a reference. The software will be provided so that it is easily transferable to any hosting service and can be transferred anytime with no restrictions. Confidentiality Agreement: The software and all data be provided to the CL and become the sole property of the CL. In order to complete the project the CL must give the SP certain data The SP must assure that CL that the software and data provided and generated shall not be sold of offered to any other CL. The data to be provided is considered proprietary, and is the sole possession of the CL. The CCES will not require any licensing agreements, monthly fees or copy write protections applied. The SP shall provide any consulting service required to assure that the CCES is functioning on the SP’s hosting service. The SP shall identify all files and directories required to be transferred so that the CL is able to transfer, backup, restore or propagate the required CCES and all customer and order data to allow any hosted server to function using this software. The SP shall provide support and training to the CL on how to propagate, backup and transfer the CCES and all customer and order data to each of the CL’s hosted servers for use on each of the CL’s websites. The SP agrees to provide free technical support for one year after completion of the project. The project shall consist of two phases: Phase I: Complete software and MAP including full data population for all light bulbs used in all models and makes for 2007 model year only. Payment terms and milestones for Phase I: 50% escrow to GAF to start project. 50% payment released upon demonstration of all software, and functionality of the administration panel on the SP’s server. 25% payment released upon demonstration of all, data entry for model year 2007 accuracy verification and functionality on the SP’s server. 25% payment released upon demonstration of all software and functionality on the CL’s server. Phase II: Populate all data for the remaining light bulbs used in all models and makes for 1950-2006 and 2008 model years. Phase II shall be considered a separate project. The SP can provide a bid for that work after the completion of phase I.