Project Management HW

SCM 304 Spring 2017 – Homework 3 Budgeting
A. Given the following data about a project:
1. Prepare a table in Excel showing the time-phased budget for the project. Assume the budgeted
cost is linearly distributed over the duration of the activity, e.g., if the budgeted cost of an
activity is $100 and the duration of the activity is 2 weeks, then budgeted cost/week=100/2=
$50.
All calculations should be done within the Excel spreadsheet. Do not copy paste answers into
Excel (as much as possible).
2. Use graphs to illustrate the weekly budget as well as the cumulative budget for the project.
3. All your files must have your name as part of the saved name.
Activity Predecessor Budgeted cost ($) Duration (weeks)
A – 1250 4
B A 1350 2
C A 1600 3
D A 850 2
E C, D 2050 5
F B, E 1500 4
G E 700 2
H F, G 1250 3

Project Management HW

SCM 304 Spring 2017 – Homework 3 Budgeting
A. Given the following data about a project:
1. Prepare a table in Excel showing the time-phased budget for the project. Assume the budgeted
cost is linearly distributed over the duration of the activity, e.g., if the budgeted cost of an
activity is $100 and the duration of the activity is 2 weeks, then budgeted cost/week=100/2=
$50.
All calculations should be done within the Excel spreadsheet. Do not copy paste answers into
Excel (as much as possible).
2. Use graphs to illustrate the weekly budget as well as the cumulative budget for the project.
3. All your files must have your name as part of the saved name.
Activity Predecessor Budgeted cost ($) Duration (weeks)
A – 1250 4
B A 1350 2
C A 1600 3
D A 850 2
E C, D 2050 5
F B, E 1500 4
G E 700 2
H F, G 1250 3