Answered step by step
Verified Expert Solution
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.
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 roofingStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started