George Caloz & Frres, located in Grenchen, Switzerland, makes luxury custom watches in small lots. One of the companys products, a platinum diving watch, goes through an etching process. The company has recorded etching costs as follows over the last six weeks:

George Caloz & Frres, located in Grenchen, Switzerland, makes luxury custom watches in small lots. One of the company's products, a platinum diving watch, goes through an etching process. The company has recorded etching costs as follows over the last six weeks: Week 1 2 3 4 5 6 Units Total Etching Cost 9 $ 27 6 20 11 31 5 20 7 24 10 30 48 $ 152 For planning purposes, management would like to know the variable etching cost per unit and the total fixed etching cost per week. Important Note! Before attempting this problem, be sure you have completed the Unit 2 Interactive Video Lesson #2 - CVP. Required: 1. Use Excel to prepare a scatter-graph that puts labor-hours on the X-axis and overhead expenses on the Y-axis. Add a trend line, display the cost formula, and R2 value. 2-a. From your results in part 1 above, Using the least-squares regression method, estimate the variable etching cost per unit and the total fixed etching cost per week. 2-b. From your results in part 2a above, express these estimates in the form Y = a + bx