Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using Excel, build a critical path analysis table for each type of structure (Wood Frame and BONE). The information in the table and notes below

Using Excel, build a critical path analysis table for each type of structure (Wood Frame and BONE). The information in the table and notes below define the two processes. Create in Excel and use the formula in column P. Please provide answer in Excel.

image text in transcribedimage text in transcribed
P7 X V fx =MAX(B7:07) A B C D E F G H I J K L M N O P Q Critical Path Method Wood Frame Project 7 2 Order Site Work Framing & Install 12 13 1 Order Doors Interior and 5 Roof Doors and 8 Rough- 10 11 Interior Exterior 14 Activity Permitting and Windows Finishes Foundation Slab Work Trusses Windows Roofing In Insulation Drywall Finishes Finishes Landscaping Predecessor Activity Duration - Wood Frame Time to Early Start [ES] Complete Early Finish [EF] 0 Successor Activity [SA] Late Start [LS] 0 Late Finish [LF] 1 Slack Critical Activities 14 BONE Project Order 4 5 Install 10 11 12 1 Order Doors Interior Install BONE Slab Doors and 7 Rough- 9 Interior Exterior Landscap 6 Activity Permitting and Windows Finishes Structure Work Windows Roofing In Drywall Finishes Finishes ing 7 Predecessor Activity 8 Duration - BONE Time to 9 Early Start [ES] Complete Early Finish [EF] 0 1 Successor Activity [SA] Late Start [LS] Late Finish [LF] 4 Slack Critical Activities 6Structu re Type Wood Frame BONE Immediate Duration Duration Activity Predecessor\" ** (days) (days) City Government 1 Permits 13 13 ProCurement Orderfdellvery lead time: doors 1 57 57 and windows -Orde-r/de-||yery lead time: 6 48 48 Interior finishes (countertops) Construction 4 Site work and foundation 1 45 5 Slab 4 8 45 6 Framing and trusses\" 5 70 3* 7 Install doors and windows 2,6 9 7 8 Roofing 6 25 5 9 Rough-in\" 6 14'\" 7'\" 10 Insulation 9 11 * 11 Drywall 10 11 11 12 Interior finishes 3,11 101 101 13 Exterior finishes 7,8 85 85 14 Landscaping 13 42 42 Notes: * A BONE structure includes frame, roof panels, and insulation, and can be assembled on site in an estimated 3 days. ** At the rough-in stage, the basic electrical, plumbing, and HVAC lines are laid in, without making final conncections to interior fixtures. \"* Using a BONE structure changes the precedence constraints as well as the activity durations. The dimensional accuracy of the BONE structure eliminates the precedence constraint that interior finishes (countertops) must be ordered after framing; instead, interior finishes can be ordered immediately after obtaining a building permit. With BONE, the slab is poured after installation of the BONE structure (the order of activities 5 and 6 are reversed). The slab must be completed before any of the following activities can occur: installation of dorrs, windows, plumbing, electricals, HVAC, and roofing

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

Exploring The Hospitality Industry

Authors: John R Walker, Josielyn T Walker

3rd Edition

0133762777, 9780133762778

More Books

Students also viewed these General Management questions

Question

What three variables affect the time for the basic motion 'move'?

Answered: 1 week ago

Question

Let A and B be two events in a sample space with A B. Then, A B = .

Answered: 1 week ago

Question

3. Im trying to point out what we need to do to make this happen

Answered: 1 week ago

Question

1. I try to create an image of the message

Answered: 1 week ago