Question

PLEASE SHOW ALL WORK IN EXCEL!!!!!!!

SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!!

HW 4- All work must be completed in 1 excel file that, when necessary, includes cells that make calculations. 1) Information on a projects activities is shown in the following table ctivity Immediate Predecessor Activity Time (wks) Total Budgeted Cost 25,000 4 28,000 16,000 10 44,000 36,000 B, D, E 55,000 B, D, E 80,000 21,000 30,000 G, H 4 60,000 60,000 G, H 20,000 a. Create a Gantt chart based on earliest start times. (20 pts) b. Create a budget cost chart, using earliest start times. (20 pts)

PLEASE SHOW ALL WORK IN EXCEL!!!!!!!

SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!!

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answers are mentioned in images

Answer a: Gantt chart

x ﹀ 丘 =Table1l@Duration]+Tablell@[Early start]] ЕЗ Gantt Chart duration 1Activity Early start Duration Series 3 Early finish 27 31 27 20 20 15 15 28 34 31 26 27 19 20 6 31 10 15 10 10 0 15 21 24 7 30 33 12 18 12 13 Duration 15 Early start Max [early finish of preceeding activity] +duration 16 Early finish Early start+duration 17

Answer b: Cost budget chart according to early start

Add a comment
Know the answer?
Add Answer to:
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! PLEASE SHOW ALL WORK...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
Active Questions
ADVERTISEMENT