Question: Please show how to solve the cost equation using excel, thank you so much for the help! Bethge & Shne, located in Pforzheim, Germany, makes

Please show how to solve the cost equation using excel, thank youPlease show how to solve the cost equation using excel, thank you so much for the help!

Bethge \& Shne, located in Pforzheim, Germany, makes luxury custom watches in 5 mall 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: 2-a. Using the least-squares regression method, estimate the variable etching cost per unit and the total fixed etching cost per week. 2-b. Express these estimates in the form Y=a+bX. Questions: Calculate the following: Require 4 individual answers: 1. Cost Equation 2. Fixed Cost 3. Variable Cost 4. R2 Bethge \& Shne, located in Pforzheim, Germany, makes luxury custom watches in 5 mall 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: 2-a. Using the least-squares regression method, estimate the variable etching cost per unit and the total fixed etching cost per week. 2-b. Express these estimates in the form Y=a+bX. Questions: Calculate the following: Require 4 individual answers: 1. Cost Equation 2. Fixed Cost 3. Variable Cost 4. R2

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!