We will take the project plan for the Jack and Jill Caf time to…
Question We will take the project plan for the Jack and Jill Caf time to… 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. 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 below***Image transcription textEstimated Hourly Onsite Activity Task Name Time Total Cost Tranportat Insurance Equipmen Printing Rate ionLunch TOTAL COST (hours) 105,000.00 1 Inspection IN Review Design Purchase Testing Equipment A Receiveequipment Arrange the delivery time Arrange the resources to receive delivery Detailed inspectio… Show more… Show more Provide an aggregated (total) budget on first sheet of excel.Provide the time phase budget on the second sheet of excel. Business Management Project Management MAN 400 Share QuestionEmailCopy link Comments (0)
