Question: all of these are same question, please help! 2 Check my work Requirea informavon [The following information applies to the questions displayed below.) George Caloz

all of these are same question, please help!
all of these are same question, please help! 2 Check my work
Requirea informavon [The following information applies to the questions displayed below.) George
Caloz & Frres, located in Grenchen, Switzerland, makes luxury custom watches in

2 Check my work Requirea informavon [The following information applies to the questions displayed below.) 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: ROOM Week 1 2 3 Unite Total Etching cost 11 $ 22 29 12 24 10 20 13 24 14 26 75 $145 5 Print rences 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 - CVR. Required: 1. Use Excel to prepare a scatter-graph that puts labor hours on the X-exs and overhead expenses on the Yaxis. Add a trend line, 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 totalfired etching cost per week. 2.1. From our results in Dart A shove express the estimates in the form YhX Check my work 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 foxed etching cost per week. 2.6. From your results in part 2a above, express these estimates in the form Y = a + bx. nes Complete this question by entering your answers in the tabs below. Reg 2A Reg 25 Using the least squares regression method, estimate the variable etching cost per unit and the total fixed etching cost per wiek. (Round your answers to decimal places) Fored etching cost per week Variable etching cost per unit Reg 28 ) Excel to prepare a scatter-graph that puts labor-hours on the X-axls and overhead expenses on the Y-axis. Add a trendine, 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. Complete this question by entering your answers in the tabs below. Req 2A Req 28 Express these estimates in the form Y = a + bx. (Round your answers to 2 decimal places.) Y MacBook Pro

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!