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 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
Get step-by-step solutions from verified subject matter experts
