1. Suppose you are given the task of keeping track of the number of labor hours invested...

Question:

1. Suppose you are given the task of keeping track of the number of labor hours invested in meetings for systems development projects. Assume your company uses the traditional SDLC and that each phase requires two types of meetings:

Working meetings involve users, systems analysts, programmers, and PQA test engineers. Review meetings involve all of those people, plus level-1 and level-2 managers of both user departments and the IT department

a. Construct a spreadsheet that computes the total labor hours invested in each phase of a project. When a meeting occurs, assume you enter the project phase, the meeting type, the start time, the end time, and the number of each type of personnel attending. Your spreadsheet should calculate the number of labor hours and should add the meeting’s hours to the totals for that phase and for the project overall.

b. Change your spreadsheet to include a budget of the number of labor hours for each type of employee for each phase. In your spreadsheet, show the difference between the number of hours budgeted and the number actually consumed.

c. Change your spreadsheet to include the budgeted cost and actual cost of labor.

Assume that you enter, once, the average labor cost for each type of employee.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Experiencing MIS

ISBN: 9780136078685

2nd Edition

Authors: David Kroenke

Question Posted: