We will take the project plan for the Jack and Jill Caf time to determine how much it will cost to deliver this project's scope. In other words, WE are building a new Caf's project's budget.

Provide a budget using Excel. You will use the data in the chart below including; tasks, predecessors and duration. ** Below**

Jack and Jill Patio Setup Project
WBS #	Task	Predecessors	Duration (in days)
1.1	Requirements Gathering	None
1.1.1	Meet with Stakeholders	None	4
1.1.2	Analyze requirements	3	2
1.1.3	Document requirements	4	2
1.1.4	*Project Scope Statement Approved	5	0
1.2	Construction Permits	None
1.2.1	Measurements Taken	6	1
1.2.2	Draft Design	8	2
1.2.3	Finalize Complete	9	1
1.2.4	Submit applications	10	1
1.2.5	*Construction Permits Secured	11	0
1.3	Site Preparation	None
1.3.1	Clear site	12	3
1.3.2	Delivery of equipment and materials	14	5
1.3.3	Complete initial layout	15	1
1.3.4	*Ready for Inspection	16	0
1.4	Acceptance Test	None
1.4.1	Preliminary testing	17	3
1.4.2	Customer feedback	19	4
1.4.3	Revisions and improvements applied	20	1
1.4.4	*Handover to Customer	21	0
			0

1) Provide the structure of your budget in Microsoft Excel.

2)Estimate the labour and non-labour costs, and use the duration estimates provided.

a) Determine hourly rates

b) Consider non-labour costs of this project, computer equipment, permit fees, furniture and supplies.

3) Create the total (aggregate) budget a) Sum up the costs of each major deliverable b) Create subtotals at the major deliverable level c) Create subtotals for the labour and non-labour costs d) Use formulas whenever possible so you fully harness the power of Microsoft Excel. e) Establish a reasonable contingency for this project f) You are free to make any assumptions you like; simply ensure they are well documented

4) Provide the time-phased budget a)Consider when the work will be done. b)Contingency can be spread across the project's duration c)Ensure your time-phased budget has the same total cost as your aggregate budget.

*** I have provided a sample Budget Example Template format***

Estimated Hourly Onsite Activity Task Name Time Total Cost Tranportat Insurance Equipmen Printing Rate ion Lunch TOTAL COST (hours) 105,000.00 1 Inspection IN Review Design Purchase Testing Equipment A Receive equipment Arrange the delivery time Arrange the resources to receive delivery Detailed inspections 5,403.50 Inspect equipment Labor Cost Non Labor Cost 1,079.50 Develop Inspection Critera 1.50 50.00 75.00 75.00 Agree on Criteria Inernally 1.00 75.00 75.00 75.00 Present criteria to customer 0.50 75.00 37.50 Discuss porposed changes 0.50 75.00 37.50 37.50 Finalize Inspection documents 1.00 75.00 75.00 75.00 Conduct Inspection 3.50 100.00 350.00 150.00 150.00 80.00 730.00 Sign off 0.50 75.00 37.50 12.00 49.50 Update powe 1,824.00 Review of the design 4.00 48.00 192.00 192.00 Evaulate the current power supply 4.00 48.00 192.00 192.00 Purchase new power supply 2.00 48.00 96.00 96.00 Installation and testing 8.00 48.00 384.00 384.00 inal inspectiona and approvals 8.00 120.00 960.00 960.00 8 Inspect radiation barriers 2500.00 Develop Inspection Critera 4.00 150 600.00 500.00 Conduct tests to create radtionals 0.50 150 75.00 1,000.00 1075 Get the radiations readings/measures 0.50 150 75.00 75.00 Measure the resturs against standards 1.00 150 150.00 150.00 Validate results and sign off 4.00 150 600.00 500.00 9 Lab ready for installation 10 Lab setup 1: Mark floors for equipment Move equipment in 13 Install MRI monitors 14 Install Testing Equipment 1 Replace desks 16 Lab ready for training Certification 1 Schedule training 1 Conduct full test 20 Adjust equipment 21 Conduct training 22 Ready for Testing