MIS

MIS 3003 Chapter 12 Homework

Suppose you are given the task of comparing labor costs of meetings for system development projects to budgets. Download the Word file Ch12Ex02_U7e.docx and the Excel file with the same name. The Word file has records of meeting dates, times, and attendees. The document was created from informal notes taken at the meetings. The Excel file has the project budgets as well as labor cost for different categories of employees.

Assume your company uses the traditional systems-first process illustrated in Figure 10-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. Using either Access or Excel, whichever you think is better suited to the task, import the Word data to a work file and compute the total labor for each type of employee for each meeting. (1pt.)

b. Using the file you created in part a, compute the total labor for each type of employee for each phase of the project. (3pts.)

c. Combine your answer in part b with the data in the Excel file Ch12Ex02_U7e.xlsx to compute the total cost of meetings of each phase of the project. (3pts.)