ASSIGNMENT: For two of the major deliverables or project elements you identified for the Disney World project, develop a detailed cost estimate in a spreadsheet.. Your goal is to make the cost estimate as accurate as possible. Explain the approach you adopted in developing the estimate and the strategies you used to increase the accuracy of the estimate. Also list any assumptions on which your estimates are based. How confident are you in the accuracy of these cost estimates? Why?

Deliverables	KPI-1	KPI-2	KPI-3
Movement (Maximization of enjoyment and fun for the family)	3 full days at Dinsey world and Covering all the planned attractions	4 nights at Orlando	Grand Dinner at 5 star
Ordering (Minimization of cost)	Selection of airlines which gives the best price	No unplanned purchase of daily consumable items during the trip.	No loss or theft of money during the trip
Preparation	Total cost of purchase must not exceed $1300	No information asymmetry among the family members	All formalities must be completed by time

Hours

2

4

6

8

10

12

14

16

18

20

22

24

26

28

30

32

34

36

38

40

42

44

46

48

50

52

54

1. Planning stage: Trip for vacation

Fund Raising

Research regarding expenses

$1

Estimating all expenses

$1

Adjusting in demand if resource is scarce

$1

2. Ordering

Hotel Booking

Purchase Online

$500

Print ticket

$1

Airline Ticket purchase

Purchase Online

$600

Print ticket

$1

Ticket purchase for Disney World

Purchase Online

$600

Print ticket

$1

3. Preperation

Complete Formalities

Passport

$50

Personal ID

$20

Family ID

$20

Buy Belongings

Camera

$400

Medicines

$100

Clothes

$400

Books

$200

Swimwear

$200

Movements

Day 1

Move to Airport

$100

Find the hotel and reside in Orlando

$100

Day 2

Site scenes at Orlando

$100

Search map for best route to Disney world

$1

Identify 10 best attractions at Disney world

$1

Contact of nearest healthcare from hotel

$1

Day 3

Cover attraction 1

$100

Cover attraction 2

$100

Cover attraction 3

$100

Cover attraction 4

$100

Day 4

$100

Cover attraction 5

Cover attraction 6

$100

Cover attraction 7

$100

Cover attraction 8

$100

Day 5

Cover attraction 9

$100

Cover attraction 10

$100

Have a Grand dinner at 5 star Resturaunt

$600

Return to Hotel

$1

Total Expense

1

1

552

601

651

20

20

0

400

100

400

200

400

103

100

100

100

100

100

100

100

100

0

100

100

600

$1