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 th1234678912136718151222324C627Assignment: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:1. From the attached data (separate excel file), prepare the S-Curves (Planned and Actual)for the projcct.2. Prepare Labor Forccasting Graphs (Manpower Loading) for both the planncd and actualaverage workers per month (i.e. Actual vs. Planned # of Workers on Site per m onth)3. Prepare both a Bar Plot of OT Hours worked per Period and a Cumulative OT HoursPlot.Period4. 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 S-Curves provide a good overall picture of the time overwhich the project went awry.)73Screenshot of Data (excel file provided)2190Planned Labor-Hours73014602190189021901789220051256198725080308150438058402920219030003650a. How many labor-hours were lost during the project?365b. If thc average wage rate was $65.35, what is the total amount of the lost labor-hours?730730a. What is the Planned Peak/Average Ratio?1095b. What was the Actual PeakAverage Ratio?730CunalativeActual Labor-HomrsPeriod708212661410001650137019901570200045677500S0007276F0004200S050410025001200215458013950222CumnlaivePlann ed # of Actual # ofWorkersWorkersR/Mon th)(Avg/Mon th)(Avg24:6789101112131415171819.3204212222211991814.810.82488101115152022222.2425231610Period00044724514272027399113149121762OT Hours0Camulati 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
 Mon th1234678912136718151222324C627Assignment:Badger Banking Co. wanted to expand its main building to

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!