Question: Mon th 1 2 3 4 6 7 8 9 1 2 1 3 6 7 1 8 1 5 1 2 2 2 3
Mon thCAssignment:Badger Banking Co wanted to expand its main building to meet the needs of its growing numberof clients. Philips Inc., was awarded the electrical subcontract with a work package including thesupply and installation of electrical and telecommunication equipment, wiring, and devicetermination.The other subcontractors mechanical system s plumbing, carpentry, eletc scheduled to completeAs a result, the start of the electrical work was delayed. In response to the situation, the generalcontractor directed the electrical contractor to accelerate the electrical schedule to meet theowner's contracted move in date.The clcctrical contractor implcmented overmanning with some overtime.Additionally, the project experienced a large number of change orders that were distracting inmagnitude, timing, and frequency.Please submit your answer the following questions: From the attached data separate excel file prepare the SCurves Planned and Actualfor the projcct Prepare Labor Forccasting Graphs Manpower Loading for both the planncd and actualaverage workers per month ie Actual vs Planned # of Workers on Site per m onth Prepare both a Bar Plot of OT Hours worked per Period and a Cumulative OT HoursPlot.Period Looking at the data as a whole, explain why the projcct experienccd an overrun in totalhours? In your answer, describe the project conditions over the course of the job andhow they changed over time. During which months was the project impacted byovemanning, ete.? Hint: The SCurves provide a good overall picture of the time overwhich the project went awry.Screenshot of Data excel file providedPlanned LaborHoursa How many laborhours were lost during the project?b If thc average wage rate was $ what is the total amount of the lost laborhours?a What is the Planned PeakAverage Ratio?b What was the Actual PeakAverage Ratio?CunalativeActual LaborHomrsPeriodSFSCumnlaivePlann ed # of Actual # ofWorkersWorkersRMon thAvgMon thAvg:PeriodOT HoursCamulati vework prior to the arrival of the electricians fell behind due to poor contract documents, lack ofcoordination betwccn tradcs, and the slow progress of other tradcs.
please do this urgently.
need to do according to the instructions in each question.please do it accordingly.
please do it urgently
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
