Suppose you are given the task of keeping track of the number of labor hours in- vested in meetings for systems development projects. Assume your company uses the traditional systems-first process illustrated in Figure AE-12. Further assume that each SDLC step requires two types of meetings. Working meetings involve users, business analysts, 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. Copy and paste the data in the Word file Ch12Ex01_source1 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 meetings 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. This data is in Ch12Ex01_ source2. 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.

Source for Ch12Ex01 Tasks a & b Systems Development Labor Hours Lvl-2 Lvl-2 Lv-2Lvl-2 ype Time End Time Meeting 22:05 11:30 15:25 1:25 22:30 13:30 20:25 12:25 20:00 11:30 1:30 20:00 12:00 1:30 1:00 15:25 0:55 20:45 11:20 14:25 0:25 1:30 22:25 13:25 22:25 0:25 1:30 16:30 2:30 17:00 2:00 Project Meeting| Start Date Phase et Users SAs Prams PQAs UseUser ISIS Length 10:35 14:00 9:00 8:00 8:30 19:00 8:00 14:00 16:00 14:30 9:25 14:00 15:30 9:00 22:00 16:30 14:00 15:00 5-Mar SD 7-Mar SD 24-Mar RA 27-Mar RA 28-Mar RA 25-Mar RA 28-Mar CD 30-Mar CD 3-Apr CD 5-Apr CD 7-Apr CD 9-Apr ClD 20-Apr CD 22-Apr IM 25-Apr IM 26-Apr IM 22-Apr IM 23-Apr IM 20:30 15:30 17:00 17:00 18:00 Source for Ch12Ex01 Tasks c& d Budgeted Costs and Hours of Development Lvl-2 User Mgr Lvl-2 User Mgr Lvl-2 IS Mgr Lvl-2 IS Mgr Users SAs Prgms POAs Cost Per Hour35.0 43.0 38.0 40.0 58.0 47.0 56.0 47.0 Costs Hrs Costs Hrs Costs Hrs Costs HrCostsHrCosts Hrs Costs Hrs Costs Hrs Budgeted SD 350.00 10:00 430.00 10: Budgeted RA 350.00 10:00 516.00 12: Budgeted CD 525.00 15:00 645.00 15:00 190.0 Budgeted IM 140 0 0: 0:00 200.0 5:00 480.00 12:0 0 0:00! 348.0g 6:00| 188.0g 4:00! 336.0g 6:00 188.0g 4: 47.00 1: 47.00 1: 0.00 0: 5:00 232.00 4:00 0 94.00 2:00 112.00 2: 47.0g 1:001 112.002: 0.00 0:00 112.00 2: 232.00 4:0 116.00 2:0 4:00 344.008:00 570.00 15:00 480.00 12: FIGURE AE-12 BusinessSystem Need Planning Design portions of business processes here, as needed, to use information system ProcessProject Plan Define System Approved Determine Requirements Requirements System CreateDesign Information System Implement Problem or Need for Change Maintain System System Users Source for Ch12Ex01 Tasks a & b Systems Development Labor Hours Lvl-2 Lvl-2 Lv-2Lvl-2 ype Time End Time Meeting 22:05 11:30 15:25 1:25 22:30 13:30 20:25 12:25 20:00 11:30 1:30 20:00 12:00 1:30 1:00 15:25 0:55 20:45 11:20 14:25 0:25 1:30 22:25 13:25 22:25 0:25 1:30 16:30 2:30 17:00 2:00 Project Meeting| Start Date Phase et Users SAs Prams PQAs UseUser ISIS Length 10:35 14:00 9:00 8:00 8:30 19:00 8:00 14:00 16:00 14:30 9:25 14:00 15:30 9:00 22:00 16:30 14:00 15:00 5-Mar SD 7-Mar SD 24-Mar RA 27-Mar RA 28-Mar RA 25-Mar RA 28-Mar CD 30-Mar CD 3-Apr CD 5-Apr CD 7-Apr CD 9-Apr ClD 20-Apr CD 22-Apr IM 25-Apr IM 26-Apr IM 22-Apr IM 23-Apr IM 20:30 15:30 17:00 17:00 18:00 Source for Ch12Ex01 Tasks c& d Budgeted Costs and Hours of Development Lvl-2 User Mgr Lvl-2 User Mgr Lvl-2 IS Mgr Lvl-2 IS Mgr Users SAs Prgms POAs Cost Per Hour35.0 43.0 38.0 40.0 58.0 47.0 56.0 47.0 Costs Hrs Costs Hrs Costs Hrs Costs HrCostsHrCosts Hrs Costs Hrs Costs Hrs Budgeted SD 350.00 10:00 430.00 10: Budgeted RA 350.00 10:00 516.00 12: Budgeted CD 525.00 15:00 645.00 15:00 190.0 Budgeted IM 140 0 0: 0:00 200.0 5:00 480.00 12:0 0 0:00! 348.0g 6:00| 188.0g 4:00! 336.0g 6:00 188.0g 4: 47.00 1: 47.00 1: 0.00 0: 5:00 232.00 4:00 0 94.00 2:00 112.00 2: 47.0g 1:001 112.002: 0.00 0:00 112.00 2: 232.00 4:0 116.00 2:0 4:00 344.008:00 570.00 15:00 480.00 12: FIGURE AE-12 BusinessSystem Need Planning Design portions of business processes here, as needed, to use information system ProcessProject Plan Define System Approved Determine Requirements Requirements System CreateDesign Information System Implement Problem or Need for Change Maintain System System Users