Professor John Morton has just been appointed chairperson of the Finance Department at Westland University. In reviewing the department’s cost records, Professor Morton has found the following total cost associated with Finance 101 over the last several terms:

Term Number of
Sections Offered Total
Cost
Fall, last year 7 $ 13,500
Winter, last year 3 $ 8,000
Summer, last year 6 $ 12,000
Fall, this year 2 $ 6,500
Winter, this year 4 $ 10,000
Professor Morton knows that there are some variable costs, such as amounts paid to graduate assistants, associated with the course. He would like to have the variable and fixed costs separated for planning purposes.

Required:

1. Prepare a scattergraph plot. (Place total cost on the vertical axis and number of sections offered on the horizontal axis.)

Instructions:

1. On the graph below, use the point tool (Fall last year) to plot number of sections offered on the horizontal axis and total cost on the vertical axis.

2. Repeat the same process for the plotter tools (winter last year to winter this year).

3. To enter exact coordinates, click on the point and enter the values of x and y.

4. To remove a point from the graph, click on the point and select delete option.

2(a). Using the least-squares regression method, estimate the variable cost per section and the total fixed cost per term for Finance 101. (Round your fixed cost and variable cost to nearest whole dollars.)

2(b). Express these estimates in the linear equation form Y = a + bX. (Round your fixed cost and variable cost to nearest whole dollars.)

3a. Assume that because of the small number of sections offered during the Winter Term this year, Professor Morton will have to offer ten sections of Finance 101 during the Fall Term. Compute the expected total cost for Finance 101. (Do not round your intermediate calculations. Round your final answer to nearest whole dollar.)