4. Suppose the following costs and units of work completed were recorded on an activity:

Answer the following questions:

1. For each month, determine the cumulative cost, the cumulative work completed, the average cumulative cost per unit of work, and the monthly cost per unit of work.
2. For each month, prepare a forecast of the eventual cost-to-complete the activity based on the proportion of work completed.
3. For each month, prepare a forecast of the eventual cost-to-complete the activity based on the average productivity experienced on the activity.
4. For each month, prepare a forecast of the eventual cost-to-complete the activity based on the productivity experienced in the previous month.
5. Which forecasting method (b, c or d) is preferable for this activity? Why?

Month Number of Work Units Completed 1 2 . " Monthly Expenditure $1,200 $1,250 $1,260 $1,280 $1,290 $1,300 30 35 45 48 52 54 5