Case Study: Seneca Construction is a non for profit organization. The organization does different social projects in Ontario. This year Seneca Constructions is helping restaurant owners to set up for patio dining at a 50% discounted rate. You have been hired as a team member for one of such projects. We are meeting the customer this week.

A patio set up project will typically involve: Phase # 1: Where we meet customers, collect requirements and covert these requirements into the project scope. Phase # 1 is completed when Seneca Construction and the customer scope statement of the project. Phase # 2: Involves getting all design and drawings completed. It may also have back and forth communication with customers to make improvements to the drawings. Customer-approved drawings are submitted to the govt. agencies for the construction permits related to the makeover. The milestone to mark the end of Phase # 2 is to secure approvals and permits. Phase # 3: Is considered closed when all the work is completed according to the scope statement. This would involve, site preparation, site improvements, furniture installation and setting up al decorations. Phase # 4 is where preliminary testing and final testing is performed. All documents are signed between two parties and the project is handed over to the customer.

Your team 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're building the project's budget.

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

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 Budget Example Template below***

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