Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Table below represents the tasks for a project. The The Table below represents the tasks for a project. The labor column is in hours

The Table below represents the tasks for a project. The The Table below represents the tasks for a project. The labor column is in hours of effort. The labor rate is $80? hour. The purchase column is from supplier's quotes. The start and finish columns represent the planned start and finish date for each activity. Create a project budget and determine how much money is planned to be spent in each month.
\table[[#,Labor,Purchase,Start,Finish],[Task 1,30 hours,,Feb 15,Feb 28],[Task 2,80 hours,,Feb 20,Mar 1],[Task 3,50 hours,,Mar 2,Mar 14],[Task 4,10 hours,$100,000,Mar 15,Mar 31],[Task 5,100 hours,,Mar 15,Mar 31],[Task 6,45 hours,$350,000,Mar 15,Mar 31],[Task 7,60 hours,,Apr 1,Apr 19],[Task 8,210 hours,,Apr 20,Apr 27],[Task 9,140 hours,,Apr 10,May 2],[Task 10,90 hours,$50,000,May 3,May 9],[Task 11,160 hours,,May 10,May 22],[Task 12,240 hours,,May 10,May 29],[Task 13,200 hours,,May 10,Jun 7],[Task 14,310 hours,,May 10,Jun 21],[Task 15,270 hours,,Jun 22,Jun 29],[Task 16,375 hours,,Jun 30,Jul 14],[Task 17,60 hours,$75,000,Jul 15,Jul 31],[Task 18,150 hours,,Jul 15,Jul 31],[Task 19,120 hours,,Aug 1,Aug 9],[Task 20,80 hours,,Aug 10,Aug 25]]labor column is in hours of effort. The labor
rate is $80/hour. The purchase column is from suppliers quotes. The start and finish columns
represent the planned start and finish date for each activity. Create a project budget and determine
how much money is planned to be spent in each month.
# Labor Purchase Start Finish
Task 130 hours Feb 15 Feb 28
Task 280 hours Feb 20 Mar 1
Task 350 hours Mar 2 Mar 14
Task 410 hours $100,000 Mar 15 Mar 31
Task 5100 hours Mar 15 Mar 31
Task 645 hours $350,000 Mar 15 Mar 31
Task 760 hours Apr 1 Apr 19
Task 8210 hours Apr 20 Apr 27
Task 9140 hours Apr 10 May 2
Task 1090 hours $50,000 May 3 May 9
Task 11160 hours May 10 May 22
Task 12240 hours May 10 May 29
Task 13200 hours May 10 Jun 7
Task 14310 hours May 10 Jun 21
Task 15270 hours Jun 22 Jun 29
Task 16375 hours Jun 30 Jul 14
Task 1760 hours $75,000 Jul 15 Jul 31
Task 18150 hours Jul 15 Jul 31
Task 19120 hours Aug 1 Aug 9
Task 2080 hours Aug 10 Aug 25
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quality Auditing In Construction Projects

Authors: Abdul Razzak Rumane

1st Edition

1032570245, 978-1032570242

More Books

Students also viewed these Accounting questions

Question

Define Management or What is Management?

Answered: 1 week ago

Question

What do you understand by MBO?

Answered: 1 week ago

Question

What advice would you provide to Jennifer?

Answered: 1 week ago

Question

What are the issues of concern for each of the affected parties?

Answered: 1 week ago