NOTE: I have attached the project introduction and the template as a picture.

Using the template attached to this assignment, create a parametric estimate for the development work that needs to be completed for a project. You may use the same project that you are using for your group homework or another project as approved by your instructor.

The template has been populated with the typical changes needed for a web development project You may add items. You must populate column B with your estimate of how many of each item will be needed. For example, if the project will create 5 new web pages, enter 5 in cell B14. Rating factors have been entered in column C. These values represent the number of work hours needed to develop the typical example of each item. If you believe an item will be more difficult than the typical example of that item, enter a number greater than 1 in column D -- Complexity Adjustment. If you believe an item will be easier than the typical example of that item, enter a number less than 1 and greater than 0 in column D. After completing your adjustments, save the file as YOUR NAME Parametric Estimate.xlsx. Attach the file to this assignment. Enter assumptions that you made in the submission text and then, submit this assignment.

Note: Your estimate will likely not match estimates submitted by other students in this class. The point of this exercise is to give you some experience working with a simple parametric estimating tool.

You have been selected as the project manager for the Global Treps project. You helped to run a local shark tank like event at your college last year as part of a class project, so you have a general idea of what is involved. The schedule goal is six months, and the budget is $120,000. Your favorite professor, Dr. K., and a few of her associates have agreed to fund the project. Your strengths are your organizational and leadership skills. You are a senior, live on-campus, and get free room and board by being a resident assistant in your dorm. Bobby, a computer whiz who funded a lot of his college expenses by building websites, will be your main technical guy on the project. He goes to your college and lives off-campus. Three other people will form your core project team: Kim, a new college grad now working for a non profit group in Vietnam; Ashok, a business student in India, and Alfreda, a student in the United States planning to visit her home town in Ethiopia for two months in a few months. You will hold most meetings virtually, but you can meet face-to-face with Bobby and Dr. K. as needed. You have all known each other for at least a year and are excited to make this project a success. You and your team members will do the work part-time while you finish school or work at other jobs, but you can use up to $50,000 total to pay yourselves. You estimate that you will need another $30,000 for travel expenses, $20,000 for hardware and software, and the other $20,000 will go toward organizing events, consultants, legal/business fees, etc. Your goal is to develop a fully functioning website and test it by holding four events in four different countries. You'll make improvements to the site after those events, develop plans to scale it up, and recommend how to transition the project results into a successful business. Recall from Chapter 4 that this system would include the following capabilities: Provide guidelines and templates for running a shark tank type event Accept donations from potential investors targeted toward specific schools or organizations wishing to host an event (similar to the popular www.donorschoose.org site, where people can fund teachers' requests) Accept ideas for needed new products or services Provide the ability for organizations to create their own custom site to solicit local participants and sharks, accept applications, and promote the winners as well as losers. A1 fac Company Name A B C D E F 1 2 Company Name Project Name Parametric Estimate 3 4 Parameter # Incl. Rating in Est Factor Cmplx Adjust Est. Comments 5 5.00 5.00 1.00 1.00 15.00 1.00 9 1.25 1.00 - 1.00 5.00 1.25 1.00 - 1.00 6 Environment 7 New URL 8 New Web Site New Instance of Environment/New Server 10 Style Sheet Modifications 11 Subtotal 12 13 New Pages 14 Page Creation - per page 15 New Data Fields per 25 fields 16 Changes to Existing Pages 17 Straight html 18 Field changes 19 Subtotal 20 21 Database 22 New Table 23 Add fields to or alter existing table 24 New stored procedure 25 Change existing stored procedure 26 Database (data) fix 27 Constraint changes 28 Add new index 29 Subtotal 30 31 0.50 1.00 1.00 0.50 0.25 5.00 2.50 1.00 0.50 0.50 1.00 1.00 1.00 1.00 1.00 1.00 1.00 - 32 33 You have been selected as the project manager for the Global Treps project. You helped to run a local shark tank like event at your college last year as part of a class project, so you have a general idea of what is involved. The schedule goal is six months, and the budget is $120,000. Your favorite professor, Dr. K., and a few of her associates have agreed to fund the project. Your strengths are your organizational and leadership skills. You are a senior, live on-campus, and get free room and board by being a resident assistant in your dorm. Bobby, a computer whiz who funded a lot of his college expenses by building websites, will be your main technical guy on the project. He goes to your college and lives off-campus. Three other people will form your core project team: Kim, a new college grad now working for a non profit group in Vietnam; Ashok, a business student in India, and Alfreda, a student in the United States planning to visit her home town in Ethiopia for two months in a few months. You will hold most meetings virtually, but you can meet face-to-face with Bobby and Dr. K. as needed. You have all known each other for at least a year and are excited to make this project a success. You and your team members will do the work part-time while you finish school or work at other jobs, but you can use up to $50,000 total to pay yourselves. You estimate that you will need another $30,000 for travel expenses, $20,000 for hardware and software, and the other $20,000 will go toward organizing events, consultants, legal/business fees, etc. Your goal is to develop a fully functioning website and test it by holding four events in four different countries. You'll make improvements to the site after those events, develop plans to scale it up, and recommend how to transition the project results into a successful business. Recall from Chapter 4 that this system would include the following capabilities: Provide guidelines and templates for running a shark tank type event Accept donations from potential investors targeted toward specific schools or organizations wishing to host an event (similar to the popular www.donorschoose.org site, where people can fund teachers' requests) Accept ideas for needed new products or services Provide the ability for organizations to create their own custom site to solicit local participants and sharks, accept applications, and promote the winners as well as losers. A1 fac Company Name A B C D E F 1 2 Company Name Project Name Parametric Estimate 3 4 Parameter # Incl. Rating in Est Factor Cmplx Adjust Est. Comments 5 5.00 5.00 1.00 1.00 15.00 1.00 9 1.25 1.00 - 1.00 5.00 1.25 1.00 - 1.00 6 Environment 7 New URL 8 New Web Site New Instance of Environment/New Server 10 Style Sheet Modifications 11 Subtotal 12 13 New Pages 14 Page Creation - per page 15 New Data Fields per 25 fields 16 Changes to Existing Pages 17 Straight html 18 Field changes 19 Subtotal 20 21 Database 22 New Table 23 Add fields to or alter existing table 24 New stored procedure 25 Change existing stored procedure 26 Database (data) fix 27 Constraint changes 28 Add new index 29 Subtotal 30 31 0.50 1.00 1.00 0.50 0.25 5.00 2.50 1.00 0.50 0.50 1.00 1.00 1.00 1.00 1.00 1.00 1.00 - 32 33