Given the information in the Wedding Cost Estimates table below, calculate the estimated costs for a wedding with 250 guests and a bridal party of six.

• Note that members of the bridal party are already counted as guests, you dont need to add them twice.

1) Calculate costs using the methods indicated:

a) Parametric estimate

b) Bottom-up estimate

c) Analogous cost estimate

3) Show your work

• Use MS Excel of Google Sheets

4) Anaylze estimations

• Provide short responses to the following questions:
  • You will probably notice some differences in the estimated values. Are these differences significant? What might cause the differences? If you were estimating a significant project in the future, which method(s) would you use and why?
  • Your mother points out you should probably have valet parking, which will cost $500. Which estimate(s) will change?

Wedding Cost Estimates
Item	Dollars
Grooms brothers wedding, last year, 175 guests, similar venue and style	$20,300
Catering	$65 per person
Photographer	$1,500
Rental of hall	$500
Clothing, bride	$2,000
Clothing, groom	$750
Flowers	$800
Other dcor items	$500
Cake	$500
Gifts for bridal party	$80 each
Wedding planner	$2,000
Wedding planners estimate of typical cost for this kind of wedding	$10,000 plus $75 per guest

5) Submit worksheet with calculations and question answers