Question: What excel function should i use here? Sequencing Two Phase Jobs Dewey Cheetum & How is a law firm. They currently have ten projects waiting

What excel function should i use here?

Sequencing Two Phase Jobs Dewey Cheetum & How is a law firm. They currently have ten projects waiting to be done. They work in teams, some specializing in preparations, some in litigation execution. Each team has estimated how many days it will take them to complete their phase of the work. Team 1 must complete its phase of the work before Team 2 can begin. A In what sequence should the projects he done? Answer: B Construct a simple Gantt chart to illustrate the completion times for each team (you can do cell by cell or on a chart). C How long before Team 1 will be available for a new set of projects? Answer: D How long before Team 2 will be available for a new set of projects? Answer: (Hint - your answer should be beween 60 and 70 days.) Estimated Days to Complete Each Team's Phase of the Projects Project Team 1 Team 2 A 4 6 10 LU-b 13 EDOONIO'lU'I-bU-INH HIm'nl'l'lonm NLnNLnLomLoan 00$me H O

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 Mathematics Questions!

Discuss how the respective organizations' relations with stakeholders could have potentially been affected by the events that took place at Enron and how the situation could have been dealt with...

Discuss how the respective organizations relations with stakeholders could have potentially been affected by the events that took place at Enron and how the situation could have been dealt with...

What role could the governance of ethics have played if it had been in existence in the organization? Assess the leadership of Enron from an ethical perspective. THE FALL OF ENRON: A STAKEHOLDER...

HI GOOD AFTERNOON, IS IT POSSIBLE THAT I MAY GET SOME ASSISTANCE WITH THIS ASSIGNMENT. SEE ATTACHMENT INSTRUCTIONS ARE AS FOLLOWS: ONLY THE RELEVANT HISTORY IS IMPORTANT, IN TERMS OF A PROBLEM...

CASE 25 Southwest Airlines in 2014: Culture, Values, and Operating Practices Arthur A. Thompson John E. Gamble The University of Alabama Texas A&M University-Corpus Christi n 2014, Southwest Airlines...

As she drove, Beck reflected on all that had transpired in her career since she earned her MBA in 2002. She had started her business, Beck Consulting Corporation (BCC) a year after graduation. Over...

I could not link the case since they are protected so I copied the entire case study in pictures. I have included the links just in case...

What kind of HRM system/model is in place at Socit de transport de Montral? Feel free to use any relevant HRM system/model with critical analysis and back your argument with academic sources. (Case...

Drawing upon suitable theoretical models, analyze the type of HRM system operating within Socit de transport de Montral. Employ critical evaluation to assess the overall HRM approach adopted by...

atter? 7.8 AD-ROBIC EXERCISES A. Briefing for New Business Select a business in your town that is of interest to you. This can be a retail business with competition in the market. Or it can be a...

On September 12, Olympia Construction trades a truck with a historical cost of $24,000 and a fair market value of $18,000 for a cement cuter. The cement cutter belonged to Chi Brothers Construction...

(a) Assume that SMC decides to apply fair value hedge accounting under SFRS(I) 1-39. Illustrate the accounting for the company?s hedging transactions by preparing all the relevant journal entries to...

AAR? Your firm is considering purchasing a machine with the following annual, end-of-year, book investment accounts. Year @ Year 1 Year 2 Year 3 Year 4 Gross investment $ 62,000 $ 62,000 $ 62,000 $...

Assume Larry's Manufacturing was contracted to build a 5 story building for $2,250,000. The project began in 2016 and was completed in 2017. Data relating to the contract are summarized below: 2016...