Chapter AE, Problem AE12.2

Explanation of Solution

a.

Using excel or Access import the word data into a work file and compute the total labor for each type of employee for each meeting:

The work file and total labor for each type of...

Explanation of Solution

b.

Using the file created in part a, compute the total labor for each type of employee for each phase of the project:

The file created in part a represents the work file for each type of employee for each meeting...

Explanation of Solution

c.

Compute the total cost of meetings in each phase of project by combining data in part b and the excel file:

The file created in part b represents the total labour for each type of employee for each type of project...

Explanation of Solution

d.

Use a graphic chart to show the differences between meeting cost and budget:

A graphic chart to show the differences between me...

Explanation of Solution

e.

Comments whether excel or access would be the best choice to solve this problem:

• Excel is more appropriate for this type of problems as it is more suitable for calculation oriented situations as present in this problem...