assignment Cost Classification and Analysis 1 1 11 15 12 10 13 14 75 $ 22 29 24 20 24 20 5145 6 For planning purposes, management would like to know the variable etching cost per unit and the total fixed etching cost per week Important Notel Before attempting this problem, be sure you have completed the Unit 2 Interactive Video Lesson 82.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 ine. display the cost formula, and R2 value 2... 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+abX Complete this question by entering your answers in the tabs below. es 2A The 25 Express these estimates in the form yox toond your answers to decimal places RA

O E - SCEPTRE George Caloz & Freres, 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 Uniti 11 15 12 12 13 14 75 Total Ecling Co 522 29 24 20 24 3 4 5 5145 For planning purposes, management would like to know the variable etching cost per unit and the total fedetching cost per week Important Notel Before attempting this problem, be sure you have completed the Unit 2 Interactive Video Lesson 12-CUP. Required: UveExcel to prepare a scater craph that puts tabor hours on the Xaws and overhead expenses an the Yam Add a trendine 2. From your results in part 1 above. Using the least squares regression method estimate the variable etching cost per unit and the 2-5. From your results in part 2 bove, express these estimates in the form Yax Complete this question by entering your answers in the tabs below. R2A 20 Ung the squares regression method, stimate the variable etching cost per unit and the wing out week 2 Faching cost per week Vatla ating cost peson 15.00 75.00 O E - SCEPTRE George Caloz & Freres, 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 Uniti 11 15 12 12 13 14 75 Total Ecling Co 522 29 24 20 24 3 4 5 5145 For planning purposes, management would like to know the variable etching cost per unit and the total fedetching cost per week Important Notel Before attempting this problem, be sure you have completed the Unit 2 Interactive Video Lesson 12-CUP. Required: UveExcel to prepare a scater craph that puts tabor hours on the Xaws and overhead expenses an the Yam Add a trendine 2. From your results in part 1 above. Using the least squares regression method estimate the variable etching cost per unit and the 2-5. From your results in part 2 bove, express these estimates in the form Yax Complete this question by entering your answers in the tabs below. R2A 20 Ung the squares regression method, stimate the variable etching cost per unit and the wing out week 2 Faching cost per week Vatla ating cost peson 15.00 75.00