Help us with our assignment. We are ought to make a case study about this. The task was written in the bottom part. Thank you so much

GROUP CASE STUDY 1: (ELECTRICAL WORKS) SITUATION: One of Utility Company plans to install temporary power supply cables from existing Electrical Sub-station No. 210 to a temporary firewater pump located in existing seawater intake area. In view of this, your company (M/s Al-Makabayan Est.), an electrical contracting company has been requested to submit a fixed lumpsum bid for the following scope of work: Manual excavation for cable trench 0.6 m (W) x 0.8 m (D) x 2 km on Class A soil. Excavated material will be reused for backfilling. All excess material will be cleared by others. Machine excavation for cable trench 0.6 m (W) x 0.8 m (D) x 3 km on Class B soil. Excavated material will be reused for backfilling. All excess material will be cleared by others. o Supply and install 1-run 5 km 30x4/0AWGx1C armored cable, 5000V, ethylene-propylene rubber insulated with interlock armor and outer PVC jacket Supply and install of (sweet) sand as cable bedding (0.3m). Supply and install cable warning tapes and protection tiles over the underground cables. ASSUMPTIONS/CONDITIONS: Excavation Works: Class A site material was considered 'easy digging', consists of loose, soft, free running material, the swell factor for this type of material is 15%. . Class B site material, considered "medium digging", consists of harder materials that can be excavated without ripping or blasting. Class B material breaks up with bulkiness causing some voids in the dipper of bucket of excavators. The swell factor for this type of material is 25%. Manual Excavation Productivity: 0.6 Hour/CY (Class A) 0.8 Hour/CY (Class B) 1.0 Hour/CY (Class C) Structural excavation using CASE 580 Loader-Backhoe Bucket Width, 12 = 5.46 CY/HR Bucket Width, 18 = 10.22 CY/HR Bucket Width, 24 = 15.84 CY/HR Bucket Width, 30% = 21.28 CY/HR Bucket Width, 36 = 27.39 CY/HR Labor Rates: Labour AED 20.00/HR Operator: AED 35.00/HR Spotter: AED 25.00/HR Civil F/M: AED 40.00/HR Electrician: AED 40.00/HR Electrical F/M: AED 55.00/HR Equipment Rate: CASE 580 Loader-Backhoe = AED 200.00/HR (excluding Operator) Conversion Factor. CY = 0.76 M3 o Backfilling: Sweet Sand delivered to site by others) = AED 50/m3 3Cx4/0AWGx1C armored cable Unit price: USD 984.80/100 Installation productivity: 10 MH/100 Cable warning tapes and protection tiles (subcontracted): AED 75.00/LM YOUR TASK: Prepare a detailed fixed lump sum bid estimate Estimate project duration, manpower & Equipment requirement To obtain fixed lumpsum price, you have been advised by your General Manager to include the following in your assumptions: Add 5% allowance for purchases Add 40% on productivity rate since the works to be performed inside operating plant Add 15% on base estimate as contingency Add 20% on base estimate as company Profit Add 10% on base estimate to cater indirect costs GROUP CASE STUDY 1: (ELECTRICAL WORKS) SITUATION: One of Utility Company plans to install temporary power supply cables from existing Electrical Sub-station No. 210 to a temporary firewater pump located in existing seawater intake area. In view of this, your company (M/s Al-Makabayan Est.), an electrical contracting company has been requested to submit a fixed lumpsum bid for the following scope of work: Manual excavation for cable trench 0.6 m (W) x 0.8 m (D) x 2 km on Class A soil. Excavated material will be reused for backfilling. All excess material will be cleared by others. Machine excavation for cable trench 0.6 m (W) x 0.8 m (D) x 3 km on Class B soil. Excavated material will be reused for backfilling. All excess material will be cleared by others. o Supply and install 1-run 5 km 30x4/0AWGx1C armored cable, 5000V, ethylene-propylene rubber insulated with interlock armor and outer PVC jacket Supply and install of (sweet) sand as cable bedding (0.3m). Supply and install cable warning tapes and protection tiles over the underground cables. ASSUMPTIONS/CONDITIONS: Excavation Works: Class A site material was considered 'easy digging', consists of loose, soft, free running material, the swell factor for this type of material is 15%. . Class B site material, considered "medium digging", consists of harder materials that can be excavated without ripping or blasting. Class B material breaks up with bulkiness causing some voids in the dipper of bucket of excavators. The swell factor for this type of material is 25%. Manual Excavation Productivity: 0.6 Hour/CY (Class A) 0.8 Hour/CY (Class B) 1.0 Hour/CY (Class C) Structural excavation using CASE 580 Loader-Backhoe Bucket Width, 12 = 5.46 CY/HR Bucket Width, 18 = 10.22 CY/HR Bucket Width, 24 = 15.84 CY/HR Bucket Width, 30% = 21.28 CY/HR Bucket Width, 36 = 27.39 CY/HR Labor Rates: Labour AED 20.00/HR Operator: AED 35.00/HR Spotter: AED 25.00/HR Civil F/M: AED 40.00/HR Electrician: AED 40.00/HR Electrical F/M: AED 55.00/HR Equipment Rate: CASE 580 Loader-Backhoe = AED 200.00/HR (excluding Operator) Conversion Factor. CY = 0.76 M3 o Backfilling: Sweet Sand delivered to site by others) = AED 50/m3 3Cx4/0AWGx1C armored cable Unit price: USD 984.80/100 Installation productivity: 10 MH/100 Cable warning tapes and protection tiles (subcontracted): AED 75.00/LM YOUR TASK: Prepare a detailed fixed lump sum bid estimate Estimate project duration, manpower & Equipment requirement To obtain fixed lumpsum price, you have been advised by your General Manager to include the following in your assumptions: Add 5% allowance for purchases Add 40% on productivity rate since the works to be performed inside operating plant Add 15% on base estimate as contingency Add 20% on base estimate as company Profit Add 10% on base estimate to cater indirect costs