+1 (208) 254-6996 essayswallet@gmail.com
  

See attached Word documents for Microsoft Project and questions based on Project Charter

ITP-2 – Project Resources and Costs (Individual Project)

(PMBOK 7)

Addresses Course Outcome #6c

Please be sure to read the Individual Assessment and Grading of Individual Assignments and the Project Documentation Requirements sections of the ITP Master Document.

Don't use plagiarized sources. Get Your Custom Essay on
Microsoft Project Resources
Just from $13/Page
Order Essay

Assignment for the ITP-2 Project Deliverable

By now, your project team should have a well-fleshed out WBS in MS Project with a schedule and durations and dependencies. This is what is described in the textbook and LEO Conferences. So start by reviewing your previous deliverable assignments and by looking at what the other teams have posted in the SHARED LEARNING ENVIRONMENT Discussion for both the Project Charter and the Project Schedule with Dependencies.

This assignment includes 3 Parts.

1. Adding Resources to the WBS (use the WBS consolidated by your team for this Individual Assignment)– Part 1

· In Microsoft Project, add resources to each task at each level of the WBS. Remember that resources are persons, places and things necessary to complete each task. EVERY task will have a resource. Remember that WORK is done at the lower level tasks, so your labor and non-labor resources will be more heavily utilized at those levels.

· PLEASE use the RESOURCE SHEET View in Project to list the resources and then use the pull-down menu in the Gantt View to add the resources. Resources must be categorized as labor or as the proper non-labor category on the Resources Sheet in Microsoft Project. For non-labor resources, make sure that they are properly categorized as expendable material resources and supplies, or as non-expendable equipment and other costs. Then add a descriptive label showing a useful resource type or sub-category. CONTRACTORS ARE NON-LABOR because we typically pay one price for the whole job. If you have a reason to list contractors as labor, please contact me so we can discuss it.

· Microsoft Project defaults labor to an 8 hour a day, 5 day a week work schedule. You may (and should) change this schedule, if you find a need. If you, for example, assign James to review a one-day duration decision point, remember that Microsoft Project will allocate 8 hours of James’s time to that decision point. If the decision point is a meeting, the duration should reflect 2 hours, not 1 day. Some labor might not work full-time on tasks. In those cases, you might want to assign that labor resource to something less than 100% (8 hours a day/5 days a week). This is particularly important when you are assigning resources to the Major Task level. There is, typically, very little actual “work” at this level – more monitoring, controlling, and reviewing.

· When you finish assigning resources, go to the RESOURCE GRAPH to see if any resource is over-allocated (working more than 8 hours a day on assigned tasks shows as a RED bar). Try to resolve the over-allocations.

· Make sure that all the tasks are covered, that none are left out—both lowest level leaf-node (sub-sub).

2. Adding costs to the WBS – Part 2a – Excel

In Microsoft Excel, duplicate the Work Breakdown Structure and the resources. 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)

Do not 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).

· Do not 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:

TaskLaborHours x RateSuppliesUnit x costTotal
4.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.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.

Adding costs to the WBS – Part 2b – Project

· Assign costs (units and extensions) to all resources and then to all tasks in the WBS.

· In MS Project, make sure to insert the columns as needed, into the appropriate views (e.g., Resource Sheet, Gantt chart, etc.), to show the data required here (e.g., total costs, unit costs, rates, cost type, etc.). Remember that your version of MS Project may use different names or labels for those data items / columns than the textbook or tutorials.

Example

So, for example, for a task to buy the paint to paint a bathroom, your resources might include:

         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) 

Tips

· Enter resources and costs for each lowest level leaf node task. Add them up for higher level roll-up summary and major task groups or phases. Do not directly enter costs for such summary and major task groups individually except by adding up the costs of the lower level tasks subordinate to the summary and major task group and except for the task manager for the summary and major tasks. MS Project should do the math at the higher levels automatically.

· For all cost categories with unit costs or rates (e.g., for labor costs, expendables and 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).

· Do not forget to include expendable materials and supplies (e.g., paint, brushes, etc.), non-expendable 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 along with their labor rates, hours, and costs per person. 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.

· Do not forget to include the costs the costs of project management, change control processes, risk management processes, etc.

· Make sure that there is a clear bottom line total of all project costs so that you and your stakeholders can tell whether your plan/proposal is within the project budget or not. (MS Project will do this for you automatically, but you should check the appropriate views to make sure that it does and that it includes everything you want.) And make sure that all required data (fields, columns) are included. Make sure to read the rubrics, below.

· 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. (Again MS Project should do this for you, but you may need to make sure it’s set up properly, and you should check the appropriate views to make sure that it does and that it includes everything you want.) And do not forget those roll-up summary and major task groups or phases.

Please ensure that your (MS Project (.mpp) file includes at least the following fields (columns) visible in the left-hand table portion of the Gantt chart view or the Tracking Gantt view and also in the Resource Sheet view:

· All fields from ITP-2 and ITP-3

· Resource Name

· Material

· Type

· Group

· Standard Rate

· Cost per Unit

· Cost

· Work

3. Text Document – Part 3

Please be sure to include an APA format Cover Sheet and the Executive Summary with appropriate changes in the accompanying Word document or text discussing the following questions:

1. How did you determine the appropriate resources? Were other similar projects used to help determine resources that might be needed?

2. Was a salary website or the Department of Labor website used to help determine the hourly rate of the labor resources? If not, how were hourly rates determined?

3. Were other credible sources used to help the you determine what non-labor resources might be required?

4. Did you revisit the project charter to ensure resources were consistent with the SCOPE of the project? This is particularly important in the case of non-project team resources. For example, if a server or telecom closet is to be built, do the resources include construction types of resources? And did the you consider appropriate mountings or furniture for the IT equipment in the bakery areas?

5. Was some of the work contracted out? Why or why not?

6. What contractors or vendors might be involved in the project and what products or services would they provide?

7. Were the totals by task in Excel and the MS Project (.mpp) file the same? Was the total cost of the project the same? If not, why not?

· When done, if you have not yet done so, save the baselined project schedule as described in the textbook, or the various MSP tutorials, or Please http://polaris.umuc.edu/~kschank/MS-Project-Skills-Baselining.htm. Or if you had already saved a baseline, then update the baseline. In the text area of the Conference, include the title page information — team name and table of team roles. Then just attach the .mpp.

· submit the MS Project (.mpp) file, the Excel file, and the Word file to your Assignment Folder.

Approximate breakdown by areas include:

· General: Structure, Format, Mechanics, Style (~2%)

· Tasks (~15%)

· Resources (~15%)

· Non-labor costs (~35%)

· Labor / human resources costs (~17%)

· Vendor / contractor costs (~4%)

· Roll up (~5%)

· Other (~3%)

· Questions and rationale (~4%)

image1.png

Project Charter

Team “Eight Week Warriors”

Mamma’s Bakery and Sandwich Shoppe – Project Plan to Install IT System

IFSM 438: Project Management

ITP-1 Project Charter

Deanna BestTeam Leader
Ahmed AbdulhadiDeputy Team Leader
Tasian BerrymanEditor
Tupper ColeResearch Manager
Julicel CrisostomoDocumentation Manager
Mireilli BatubengeConfiguration Manager

A. General Information

Project Title:Mamma’s Bakery and Sandwich ShoppeInstall IT Project
Brief Project Description:
Prepared By:Team “Eight Week Warriors”
Date:March 2, 2021Version:1.0

Customer and Stakeholders:

Identify the customer/user/client. Who are the internal and external stakeholders and their influences or interest in this project.

B. Project Objective:

Explain the specific objectives of the project. For example: What value does this project add to the organization? How does this project align with the strategic priorities of the organization? What problem will this project solve? What results are expected? What are the deliverables? What benefits will be realized? What problems will be resolved?

C. Assumptions

List and describe the assumptions made in the decision to charter this project. Please note that all assumptions must be validated to ensure that the project stays on schedule and on budget.

D. Project Scope

Describe the scope of the project. The project scope establishes the boundaries of the project. It identifies the limits of the project and defines the deliverables.

List any requirements that are specifically excluded from the scope.

E. Project Milestones

What is the estimated schedule for the project (start to finish?)

List the major milestones and deliverables of the project.

.

MilestonesDeliverablesDate
Initiation Phase· Identify project members and roles· Gather requirements· Meet and speak with stakeholders/clients about business goals· Develop a clear scope of work/time frame2/17 – 3/2
Planning Phase· Develop a detailed schedule with milestones and deliverables· Develop a detailed scope of work including budget for all resources and materials· Assign tasks to members· Research ISPs in the area and compatible hardware and software that fulfill requirements· Research and determine the network and system configurations that fulfill requirements3/3 – 3/16
Execution Phase· Set up network infrastructure· Image and build IT systems and servers· Build an IT inventory system· Develop a website· Build an IT finance system· Ensure IT security· Test all systems with sample data· Revise, improve, or fix any found issues3/17 – 3/30
Closeout Phase· Perform training for client staff· Ensure all requirements have been met and client is satisfied3/31 – 4/6

F. Impact Statement

.

This project will be assessed to determine the impact it will have on current business processes, current operations, technology and all stakeholders (Hayes, 2000). As a small business the following impacts have been identified.

1. Implementing an IT system to accommodate business expansion will give Mamma Mia a competitive advantage in the bakery and café market.

2. Implementing an IT system will streamline business processes and vendor relationships.

a. Can result in a costs reduction over time.

b. Can speed up productivity.

3. Implementing an IT system will allow give data efficiencies.

a. Mamma Mia will have the ability to track peak customer sales.

i. Identify opportunities.

b. Steam line inventory management, process improvement, employee management.

4. Identifying key stakeholders and continuous communication is essential. This will need to remain throughout the life of the project.

G. Roles and Responsibilities

Describe the roles and responsibilities of project team members followed by the names and contact information for those filling the roles. The table below gives some generic descriptions. Modify, overwrite, and add to these examples to accurately describe the roles and responsibilities for this project.

Sponsor: Provides overall direction on the project. Responsibilities include: approve the project charter and plan; secure resources for the project; confirm the project’s goals and objectives; keep abreast of major project activities; make decisions on escalated issues; and assist in the resolution of roadblocks.
NameEmail / Phone
Mamma MiaSamuel.magambo@faculty.umgc.edu
Project Manager/Assistant Project Manager: Leads in the planning and development of the project; manages the project to scope. Responsibilities include: develop the project plan; identify project deliverables; identify risks and develop risk management plan; direct the project resources (team members); scope control and change management; oversee quality assurance of the project management process; maintain all documentation including the project plan; report and forecast project status; resolve conflicts within the project or between cross-functional teams; ensure that the project’s product meets the business objectives; and communicate project status to stakeholders.
NameEmail / Phone
Deanna BestDbest8@student.umgc.edu
Ahmed AbdulhadiAbdulhadi.a.ahmed@gmail.com
Team Member: Works toward the deliverables of the project. Responsibilities include: understand the work to be completed; complete research, data gathering, analysis, and documentation as outlined in the project plan; inform the project manager of issues, scope changes, and risk and quality concerns; proactively communicate status; and manage expectations.
NameEmail / Phone
Julicel Crisostomojulicelcrisostomo@gmail.com
Mireille Batubengemusmireille@hotmail.com
Tasian Berrymantasiangurl@gmail.com
Tupper Coletuppercole@gmail.com
Customer: The person or department requesting the deliverable. Responsibilities include: partner with the sponsor or project manager to create the Project Charter; partner with the project manager to manage the project including the timeline, work plan, testing, resources, training, and documentation of procedures; work with the project team to identify the technical approach to be used and the deliverables to be furnished at the completion of the project; provide a clear definition of the business objective; sign-off on project deliverables; take ownership of the developed process and software.
NameEmail / Phone
Mamma MiaSamuel.magambo@faculty.umgc.edu
Subject Matter Expert: Provides expertise on a specific subject. Responsibilities include: maintain up-to-date experience and knowledge on the subject matter; and provide advice on what is critical to the performance of a project task and what is nice-to-know.
NameEmail / Phone
Professor Samuel MagamboSamuel.magambo@faculty.umgc.edu

H. Resources

Identify the initial funding, personnel, and other resources committed to this project by the project sponsor.

ResourceConstraints
Project Budget$

I. Project Risks

Identify the high-level project risks and the strategies to mitigate or avoid them.

RiskMitigation Strategy

J. Success Measurements

What are the high level benefits of this project?

Identify metric and target you are trying to achieve as a result of this project. For example, overall cost savings of $50K or reduce processing time by 25 percent.

K. Signatures

The signatures of the people below document agreement and approval of the formal Project Charter. The project manager is empowered by this charter to proceed with the project as outlined in the charter. This charter will be

Customer:
NameSignatureDate
Project Sponsors:
NameSignatureDate
Project Manager:
NameSignatureDate

References

Hayes, D. S. (2000). Evaluation and application of a project charter template to improve the project planning process. Project Management Journal, 31(1), 14-23.

Project_Charter March 2021

Page 8 of 8

image1.png

Order your essay today and save 10% with the discount code ESSAYHELP