Question
Prepare a table in Excel showing the time-phased budget for the project. Assume the budgeted cost...
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 a Task is
$100 and the duration of the Task is 2 weeks, then budgeted
cost/week=100/2= $50.
All calculations should be done within the Excel spreadsheet.
| Task | Predecessor | Budget Cost ($) | Duration (weeks) | |||
| A | - | $ 1,500 | 4 | |||
| B | A | $ 1,350 | 2 | |||
| C | A | $ 1,260 | 3 | |||
| D | A | $ 950 | 2 | |||
| E | C, D | $ 1,650 | 5 | |||
| F | B, E | $ 1,200 | 4 | |||
| G | E | $ 700 | 2 | |||
| H | F, G | $ 1,770 | 3 |
Homework Answers
Answer #1
The Fomula used is =QUOTIENT(E2,G2)
Not the answer you're looking for?
Similar Questions
Using the following information about work package budgets, complete the overall time-phased budget for the following...
Using the following information about work package budgets,
complete the overall time-phased budget for the following project.
Which weeks have the greatest budget expense?
TASK
Budget
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Week 7
Week 8
A
5
3
2
B
8
1
4
3
1
C
12
2
7
3
D
7
3
3
1
E
14
5
5
2
2
F
6
1
2
3
Plan
52
4
8
Cumulative
4
12
Use the following data for question below. Activity Normal Time (weeks) Crash Time (weeks) Normal Cost...
Use the following data for question below.
Activity
Normal Time (weeks)
Crash Time (weeks)
Normal Cost
Total Cost with Crashing
Pred 1
Pred 2
A
10
7
$200
$400
B
15
10
$250
$600
C
13
8
$600
$1,500
A
B
D
14
10
$800
$1,200
A
B
E
8
4
$1,000
$3,000
C
D
F
12
6
$1,200
$1,800
C
D
G
7
6
$700
$1,400
E
F
H
5
3
$500
$900
E
F
If the project must...
Consider the table below, which includes time and activity data for a Small IT Project. All...
Consider the table below, which includes time and activity data
for a Small IT Project. All duration estimates or estimated times
are in days. Perform a critical path analysis for this project.
Activity
Duration (Days)
Predecessor
A
8
-
B
10
A
C
18
A
D
4
A
E
28
B, D
F
2
C, E
G
32
E
H
18
B
I
12
F
J
2
H, G, I
Draw a network diagram representing the project. MS PowerPoint
or...
Problem #5 An IT project requires 6 activities. The table below displays the expected time and...
Problem #5 An IT project requires 6 activities.
The table below displays the expected time and budgeted cost for
each activity.
Activity
Expected time (weeks)
Budgeted Cost
Immediate Predecessors
A
3
$2,000
None
B
4
$6,000
None
C
2
$7,000
A
D
5
$9,000
B
E
3
$3,000
C
F
6
$8,000
B,D
Develop a budget for the 15 weeks of the project using LS
times.
Ralph wants to build a new two (2) car garage. The contractor Ralph hired provided the...
Ralph wants to build a new two (2) car garage. The contractor
Ralph hired provided the following schedule and cost estimate. What
is the budget at completion (BAC) for Ralph’s garage? At the end of
week 1, the contractor completed 80% of the footing, framing, and
siding. He spent 3,000 on concrete, lumber and vinyl siding. He
also paid 1,500 in wages to laborers to complete the footing,
framing, and siding. what is the earned value (EV) for Task A...
London Fletcher of Fabriscan Diagnostic, is the project manager. He measured the following information with commutative...
London Fletcher of Fabriscan Diagnostic, is the project manager.
He measured the following information with commutative completed
times for four periods of the project.
Completed%
Activity ID
Activity Predecessors
Estimated Duration(Weeks)
Budget ($)
Actual Spend ($)
1
2
3
4
Crash time
Crash cost$
A
7
7,000
9,000
20
40
100
100
6
8,000
B
A
2
5,000
5,000
20
60
100
100
1
7,000
C
A
4
9,000
6,000
0
40...
Do the following crashing problem “from scratch” Develop the time reduction and cost per unit time...
Do the following crashing problem “from scratch”
Develop the time reduction and cost per unit time columns in
the table. Units: Time is in days, cost is in $.
Activity
Immediate predecessor(s)
Time
Cost
Crash Time
Crash Cost
Time Reduction
Cost to Crash
A
--
10
5000
10
5000
B
A
12
1200
11
1300
C
A
11
3600
9
4800
D
B
5
300
4
600
E
C
8
1000
6
2000
F
E
9
2400
7
5400
G...
1. It is time for Jung So Min Corp. to begin its annual budget preparation for...
1. It is time for Jung So Min Corp. to begin its annual budget
preparation for its upcoming fiscal year, which ends on December
31, 2021. They are in need of temporary assistance in their
accounting office, and have hired you to carry out the task of
preparing the budgets. Jung So Min prepares quarterly budgets, and
then from this information prepares an annual budget.
To assist you in this task, Jung So Min has gathered the
following information:
1)...
Mega Mart Store is a discount department store badly in need of renovation. To avoid loss...
Mega Mart Store is a discount department store badly in need of
renovation. To avoid loss of sales and disruption of customer
shopping habits, Mega Mart wants to complete this renovation
without closing the store itself, by temporarily co-locating goods
from one area of the store into another, creating open spaces for
renovation and re-occupation. Mega Mart is divided into four basic
areas of goods: Clothing, Electronics, House Wares and Foodstuffs.
Each of these areas will need to be temporarily...
Sales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets The budget director of Gourmet Grill...
Sales, Production, Direct Materials Purchases, and Direct Labor
Cost Budgets
The budget director of Gourmet Grill Company requests estimates
of sales, production, and other operating data from the various
administrative units every month. Selected information concerning
sales and production for July is summarized as follows:
a. Estimated sales for July by sales territory:
Maine:
Backyard Chef
310 units at $700 per unit
Master Chef
150 units at $1,200 per unit
Vermont:
Backyard Chef
240 units at $750 per unit
Master...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 6 minutes ago
asked 11 minutes ago
asked 28 minutes ago
asked 31 minutes ago
asked 33 minutes ago
asked 45 minutes ago
asked 45 minutes ago
asked 45 minutes ago
asked 45 minutes ago
asked 45 minutes ago
asked 45 minutes ago
asked 46 minutes ago