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 and review 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 IS department.

a. Import the data in the Word file Ex36 from this text’s Web site into a spreadsheet.

b. Modify your spreadsheet to compute 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.

c. Modify your spreadsheet to include the budgeted number (in the source data) 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.

d. 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, as stipulated in the source data.