Answered step by step
Verified Expert Solution
Question
1 Approved Answer
II. Quantitative Problems (25%) A project manager is working to finalize the total spending by reviewing the payroll data. (The data is attached as an
II. Quantitative Problems (25\%) A project manager is working to finalize the total spending by reviewing the payroll data. (The data is attached as an Excel file.) Please help this manager identify the following information. a. Create a time-phased cash outflow curve. (Hint: you need to create a YTD spending or running total column) b. Calculate how much money was spent on the work done during the weekend throughout the year. c. Which month was the slowest month judging by the total number of hours worked? d. Who was the busiest person in June? e. Critical thinking problem: Assuming that back in June, you had a work package that required 7 hours to complete, and you could have assigned the package to multiple people. To whom and how are you going to assign the work? By the regulation XYZ, no more than 20 hours of work should be done each month on this type of project. Looking back at the record, was there any violation in this case? What is the proposed fix
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started