Computer Science Homework Help

In 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.00

Paint (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)

Don’t 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.

Details:

• Enter resources and costs for each task. Remember that ALL tasks must have resources; major level tasks must have a project team member assigned some small percentage of time to monitor and track the task.
• For all cost categories provide the unit costs or rates (e.g., for labor costs, supplies, etc.), then for each line item, make sure to include the unit costs (e.g., labor rates, costs per each, etc), and the quantities used (e.g., hours, quantities ordered or used, etc), and the extended costs (rates or unit costs times quantity).
• Don’t forget to include expendable materials and supplies (e.g., paint, brushes, construction materials, etc), non-expendable equipment you might need (copiers, printers, carts to transport equipment, computer furniture, etc.), maybe facilities (such as a storage unit for staging equipment), and, of course the people who are doing the work along with their labor rates, hours, and costs per person. A rough example is below:

Task	Labor	Hours x Rate	Supplies	Unit x cost	Total
4.2.5 Install computers in gymnasium	1 Installer 1 Software tester	20 hrs x $40.00 6 hrs x $20.00	4 computers 4 USB cables	4 each x $1500 4 each x $30.00	$7020.00

• 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? Which makes sense?
• You must include EVERYTHING it takes to do every task at every level. The project sponsor and project manager should be able to see how much EACH task (and lower level tasks) costs individually.
• Make sure that the spreadsheet includes a clear bottom line total of all project costs so that you and your stakeholders can tell whether your plan is within the project budget or not. And make sure that all required data are included. In Excel, there is an expectation that the math will be accomplished by the use of formulas.
• You may want to determine subtotals by cost type (labor, supplies, equipment, etc); and/or by person if a person is assigned to work on than one task. But you still must show the cost of each major task plus the total cost of the project.

• The Cover Sheet text document should include the SOURCES of your costs. For example, if you used a Department of Labor category, the discussion should include why you used this source and the appropriate citations.

The 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