construct time-phased budget and cumulative budget line chart.
Description
I have attached the Recourse cost estimate table below (word document).
Project Budget
This section describes the breakdown of the work package cost over its duration. Include a time-phased budget in a spreadsheet format showing the cost of work packages spread over the timeline of the project AND a cumulative budget line chart – use Excel or Google sheets to create these requirements. If you are using MS Project as a scheduling tool, the cash flow chart shows the required cumulative budget line chart.
I have attached an example of how it should look like below. Let me know if there is any problem.
Unformatted Attachment Preview
? Resource Cost Estimates – this section describes the
resources needed for each work package (labor and
material) and their estimated cost. Describe your
sources in the introduction to this section and use a
reference list to list citations, as needed. Summarize the
resources and their cost in a table (based on the
template provided in the module resources).
ID
1) Work
Package
2) Resources
needed (title
of
professional(
s) you would
recruit to the
project team
for this task)
3) Resource
cost per day
(Do some
research!
Find out their
cost and
calculate a
daily rate)
4) Does this
work package
require nonlabor
resources?
(e.g. Consider
significant onetime purchases
of materials or
supplies. It is
OK for a work
package to
have no other
costs)
5) What is the
cost of the
identified nonlabor
resources?
(zero if no nonlabor resources
are needed)
(IN
THOUSANDS
(IN
THOUSANDS)
1.0
Get
Approval
Time,
money,
Project
Time (days):
90
Project
manager
(300)
no
0
1.1
Acquire
Support
1.11 Ensure
funding
available
Time,money, Time (days):
90
people
no
Time,money, Time (days):
30
people
no
Money (0)
1.12 Acquire
organization
s
Time,money, Time (days):
30
people
no
Money (100)
1.13 Submit
%ch-free
requestime,money, Time (days):
30
people
no
Money (5)
2.0
Receive
Funding
Time,money, Time (days):
45
people
no
Project tea m
(300)
2.1
Provide
account
number
Time,money, Time (days):
45
people
no
Money (0)
2.11 Create
budget
amount
Time,money, Time (days):
10
people
no
Money (300)
2.12 Request
Cost
Estimate
Time,money, Time (days):
35
people
Money (150)
no
3.0
Engineer
Time,money, Time (days):
Construction people
803
yes
Materials
(10,000)
Money
Outsource
Contractors
Time,money, Time (days):
803
people
no
3.11 Implement
Time,money, Time (days):
200
people
Yes
Materials
(5,000)
Yes
Materials
3.1
Energy
Efficiency
Money
(10,000)
3.12 Create
renewable
energy
source
3.13 Feature
indoor air
quality
Time,money, Time (days):
201
people
(5,000)
Money (3000)
Time,money, Time (days):
201
people
Yes
Materials
(1,000)
Money (5000)
3.14 Manage
effective
waste
disposal
4.0
Finalize site
sustainabilit
y
Time,money, Time (days):
201
people
Yes
(500)
(5000)
Time,money, Time (days):
65
people
Factory
manager
(200)
Materials
no
4.1
Undergo
review
4.11 Equip
factory
manager
4.12 Ensure
Safety
testing
Time,money, Time (days):
65
people
no
Time,money, Time (days):
22
people
no
Time,money, Time (days):
21
people
no
(5)
4.13 Get LEED
Certification
Time,money, Time (days):
22
people
no
(0)
2.
Project Budget
The project budget below describes the breakdown of our work package cost over its
duration. Our team included a time-phased budget in the following spreadsheet format
to show cost of work spread over the timeline of the project and a cumulative budget
line chart using Excel. With this breakdown it makes it easier for us to understand how
costs are going to be spread into our project. We found this breakdown helpful to
visually see the numbers of cost.
INSERT EXCEL BUDGET****
Purchase answer to see full
attachment
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."