Hilal Builders, Inc. (HB), is a small firm, that specializes in the construction of private home dwellings HB uses a standardized project format for cach assignment of house construction projects. Only activity times and unusual circumstances change the standard network. Faisal Al Lamki has been assigned to a latest rich elient as project manager and has compiled the network information and activity times for this project of a luxury villa that are given in Tables and 2 as follows: Table 1. Network information mmediate 14 Table 2. Activity times in workdays Given the project network derived in part A, Faisal also wants to be prepared to answer any questions concerning compressing the project duration. To be ready for the compression question, Faisal has prepared the following data, shown in Table 3, in case it is necessary to crash the project (Use your weighted average times computed in part A above as normal times for completing the Table 3. Normal cost, crash cost, crash time, and crash cost/day for each activity Normal cost Questions Part B Using the data provided, Faisal wants you to: a. Determine which activities and how much should each activity be crashed to meet the target of 120 workdays. Include the project network after crashing to 120 workdays. Note the activities crashing should be based on a least-cost criterion Model the network in linear programming for crashing the project to 100 workdays and solve using Excel SOLVER. Attach the model and the solution done in Excel. Find the optimal completion time of crashing the network if the rich client is willing to pay S1600 per workday for every workday reduced from its original schedule. b. c. Hilal Builders, Inc. (HB), is a small firm, that specializes in the construction of private home dwellings HB uses a standardized project format for cach assignment of house construction projects. Only activity times and unusual circumstances change the standard network. Faisal Al Lamki has been assigned to a latest rich elient as project manager and has compiled the network information and activity times for this project of a luxury villa that are given in Tables and 2 as follows: Table 1. Network information mmediate 14 Table 2. Activity times in workdays Given the project network derived in part A, Faisal also wants to be prepared to answer any questions concerning compressing the project duration. To be ready for the compression question, Faisal has prepared the following data, shown in Table 3, in case it is necessary to crash the project (Use your weighted average times computed in part A above as normal times for completing the Table 3. Normal cost, crash cost, crash time, and crash cost/day for each activity Normal cost Questions Part B Using the data provided, Faisal wants you to: a. Determine which activities and how much should each activity be crashed to meet the target of 120 workdays. Include the project network after crashing to 120 workdays. Note the activities crashing should be based on a least-cost criterion Model the network in linear programming for crashing the project to 100 workdays and solve using Excel SOLVER. Attach the model and the solution done in Excel. Find the optimal completion time of crashing the network if the rich client is willing to pay S1600 per workday for every workday reduced from its original schedule. b. c
