Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Your Sacred Work A Call To Spiritual Entrepreneurship

Authors: Dru Dodson

1st Edition

979-8988712404

More Books

Students also viewed these General Management questions

Question

Gender identity is

Answered: 1 week ago

Question

7. LO.1, 2 Interpret this Regulation citation: Reg. 1.16310(a)(2).

Answered: 1 week ago