Suppose you are given the task of comparing labor costs of meetings for systems development projects to budgets. Download the Word file Ch12Ex01_E7e.

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 costs for different categories of employees.

Assume your company uses the traditional SDLC and each step requires two types of meetings: working and review. 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.

b. Using the file you created in part

a, compute the total labor for each type of employee for each phase of the project.

c. Combine your answer in part b with the data in the Excel file Ch12Ex01_E7e.xlsx to compute the total cost of meetings of each phase of the project.

d. Use a graphic chart of the type you think best to show the differences between meeting cost and budget.

e. Comment on your choice of Excel or Access for your work file. If you were to do this exercise over, would you use that same tool again? Why or why not?