Question

George Caloz & Frères, located in Grenchen, Switzerland, makes prestige high-end custom watches in small lots. One of the company’s products, a platinum diving watch, goes through an etching process. The company has observed etching costs as follows over the last six weeks:

Week	Units			Total Etching Cost
1		14			$	27
2		11			$	20
3		16			$	30
4		10			$	20
5		12			$	25
6		15			$	28
		78			$	150

For planning purposes, management would like to know the amount of variable etching cost per unit and the total fixed etching cost per week.

Required:

1.	Prepare a scattergraph plot. (Place etching costs on the vertical axis and units on the horizontal axis.)

  

Instructions:
1.	On the graph below, use the point tool (Week 1) to plot units on the horizontal axis and total etching cost on the vertical axis.
2.	Repeat the same process for the plotter tools (Week 2 to Week 6).
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 and fixed elements of etching cost. (Round your answers to 2 decimal places.)

     

  

2(b).

Express the cost data in (2a) above in the form Y = a + bX. (Round your answers to 2 decimal places.)

     

         

3.	If the company processes thirteen units next week, what would be the expected total etching cost? (Round your intermediate and final answers to 2 decimal places.)

     

Answer 1

The least squares regression line is