50 likes | 156 Views
Group E Presentation. Ch10 pg 417 #1 Application Exercise By: Hebbah Shehaiber , Lauren Zawacki , Matt Lyons, Lisa Brodie , Nima Samani. Scenario. Suppose you are given the task of keeping track of the number of labor hours invested in meetings for systems development projects.
E N D
Group E Presentation Ch10 pg 417 #1 Application Exercise By: HebbahShehaiber, Lauren Zawacki, Matt Lyons, Lisa Brodie, NimaSamani
Scenario • Suppose you are given the task of keeping track of the number of labor hours invested in meetings for systems development projects. • Assume that 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 IS department.
Questions • Import the data in the word file Ch10Ex01 from this text’s web site into a spreadsheet. • 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 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 of labor hours for each type of employee for each phase. In your spreadsheet, show the difference between the numbers 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.