15799
n Microsoft Excel, the team is to duplicate the Work Breakdown Structure and the resources (USE TASK FROM PDF ATTACHED). Assign costs (units and extensions) to all resources and then to all tasks. So, for example, if your task is to buy the paint, your resources might include:Task Manager (Project Team Member) 4 hours @ $20.00 = $80.00Paint (5 gallons @$40/gallon = $200)Brushes (3 wall brushes, 3 trim brushes each at $4.00 = $24)Gas to get to paint store (12 miles is ½ gallon of gas @ $4.00 per gallon = $2.00)Dont forget to include equipment you might need (copiers, printers, carts to transport equipment), maybe facilities (such as a storage unit for staging equipment), and, of course the people who are doing the work. If you include a vendor/contractor on a contract or purchase order that has ONE price for the entire effort, you will include ONE contractor@ $xx,xxx.xx (contract price). Think about how you will address this contractor in the Resource Sheet labor or non-labor? Remember that the contractor is NOT likely to charge by the hour
! You must include EVERYTHING it takes to do every task at every level.TaskLaborHours x RateSuppliesUnit x costTotal4.2.5 Install computers in gymnasium1 Installer1 Software tester20 hrs x $40.006 hrs x $20.004 computers4 USB cables4 each x $15004 each x $30.00$7020.00The TEAM WBS should have corrections made to durations and predecessors as a result of sharing and looking at fellow classmates MS Project team efforts and in response to comments from the instructor. Durations, predecessors and resources are assigned for all tasks. Resources include all people, facilities, supplies, materials, facilities, and contractors, etc. required to accomplish EACH task at EVERY level. Anything that will be needed to accomplish the task is included as a resource for that task. The RESOURCE SHEET View shows labor and non-labor. Non-labor resources are properly categorized as expendable material resources and supplies, or as non-expendable equipment and other costs. The RESOURCES GRAPH shows no red bars for over-allocations. The accompanying Word document or text answers all questions, explaining how the team determined the appropriate resources, whether or not some work was contracted out and why, what vendors might be involved in the project and what products or services they would provide.Additionally, all costs are included for expendable materials and supplies, non-expendable equipment, facilities, and contractors or vendors. All people assigned to do the work of the tasks are identified, along with their labor rates, hours, and costs per person. Include EVERYTHING it takes to do every task at every level. Make sure that there is a clear bottom line total of all project costs. Include costs for each lowest level leaf node task. Add them up for higher level roll-up summary tasks or phases. Do not assess costs against such summary tasks individually except by adding up the costs of the lower level tasks subordinate to the summary task. Include subtotals by cost type (labor, supplies, equipment, etc); and/or by person if a person is assigned to work on than one task
.
