CIS 6208: Unit 5 part 2 of Assignment

Activity-­‐based  Budgeting  Exercise      

1

CIS 6208 IT Project Management

Exercise Name Activity-based Budgeting Purpose Activity-based budgeting is an industry standard approach toward project budgeting. Use of Microsoft Project in developing an activity-based budget is also an industry standard. Developing skills in activity-based costing and Microsoft Project will help to develop real world knowledge and experience that can be leveraged by all project managers regardless of industry or project type. Description Students will create an activity-based project plan and budget based on the information provided in the project exercise Work Breakdown Structure (WBS). This is a continuation of the PERT Estimation & Project Plan Creation exercise. Students will update a MS Project plan based on the activity cost and resource data. Students will submit the following in support of this assignment.

Microsoft Project – Updated Plan Incorporate and submit your updated MS project plan with the updated cost and resource data. Each resource must be entered with the correct cost data (hourly or flat fee). Each task or activity must be updated to reflect the assigned resources and effort (resource hours).

Entering Resources 1. Go to Resource Sheet 2. Enter three (3) resources – Bill, Susan, and Pat 3. For each resource, enter group = 1, Std. Rate = $50, Ovt. Rate = $50

Entering Resource Cost Estimates 1. Go to Gantt Chart View 2. On each task, right click and select “Assign Resources” 3. For each resource (Bill, Pat, Susan) click “Assign” button 4. Enter hours in units column as *h (e.g. 40h to represent 40 hours). Entering Fixed Cost Estimates 1. Go to Cost Table (right click the Select All” button - top upper left cell). 2. Enter fixed costs (Hardware and Software) related to appropriate tasks.

Microsoft Project - Reports Create the following reports in MS Excel (visual reports) format and submit with your updated MS Project plan.

Activity-­‐based  Budgeting  Exercise      

2

Visual Reports (MS Excel Format)

- Budget Cost Report - Budget Work Report - Cash Flow Report - Resource Work Summary Report

Reports Interpretation Students will write an interpretation (MS Word Format) of the data provided in the following MS Project reports.

- Budget Cost Report - Budget Work Report - Cash Flow Report - Resource Work Summary Report

In addition, submit answers to the following questions (MS Word Format).

- What is the total project cost? - Which tasks have over allocated resources? - Which resources are over allocated?

Note: Assignments with spelling and/or grammar errors will be returned for correction and resubmission which may result in a late penalty. Rubric

Criteria Exemplary Accomplished Developing Beginning MS Project – Updated Plan

All resources and costs entered as specified in WBS . 30 Points

All resources entered with some cost data entered as specified in WBS. 25 Points

Some resources and costs entered as specified in WBS. 20 Points

Resources entered as specified in WBS with limited, incorrect, or incomplete cost data. 10 to 0 Points

MS Project – Reports

All required reports included in assignment submission. 10 Points

Most required reports included in assignment submission. 5 Points

Some reports submitted. 2 Points

No reports submitted. 0 Points

MS Project – Report Interpretation

Clearly interprets report data in depth.

Accurately interprets report data but to limited

Interpretation of report data is incomplete.

Unclear or incorrect interpretation of

Activity-­‐based  Budgeting  Exercise      

3

20 Points

depth

15 Points

10 Points

report data.

5 to 0 Points MS Project – Report Questions

Provides correct answers to all reporting questions. 10 Points

Provides correct answers to 2 of 3 reporting questions. 5 Points

Provides correct answers to 1 of 3 reporting questions. 2 Points

No reporting question answers submitted or answered correctly. 0 Points

Timeliness Exercise is submitted by end of day on Sunday (upon completion of unit). 10 Points

Exercise is submitted by end of day on Monday (after completion of unit). 8 Points

Exercise is submitted by end of day on Wednesday (after completion of unit). 5 Points

Exercise is submitted on Thursday or later (after completion of unit). 0 Points

Total Assignment Points: 80