Question
George Caloz & Frres, located in Grenchen, Switzerland, makes prestige high-end custom watches in small lots. One of the companys products, a platinum diving watch,
George Caloz & Frres, located in Grenchen, Switzerland, makes prestige high-end custom watches in small lots. One of the companys products, a platinum diving watch, goes through an etching process. The company has observed etching costs as follows over the last six weeks: |
Week | Units | Total Etching Cost | |||||
1 | 12 | $ | 32 | ||||
2 | 3 | $ | 20 | ||||
3 | 8 | $ | 26 | ||||
4 | 8 | $ | 27 | ||||
5 | 8 | $ | 25 | ||||
6 | 11 | $ | 30 | ||||
|
|
| |||||
50 | $ | 160 | |||||
|
|
| |||||
|
For planning purposes, management would like to know the amount of variable etching cost per unit and the total fixed etching cost per week. |
Required: |
1. | Prepare a scattergraph plot. (Place etching costs on the vertical axis and units on the horizontal axis.) |
Instructions: | |
1. | On the graph below, use the point tool (Week 1) to plot units on the horizontal axis and total etching cost on the vertical axis. |
2. | Repeat the same process for the plotter tools (Week 2 to Week 6). |
3. | To enter exact coordinates, click on the point and enter the values of x and y. |
4. | To remove a point from the graph, click on the point and select delete option. |
2(a). | Using the least-squares regression method, estimate the variable and fixed elements of etching cost. (Round your answers to 2 decimal places.) |
2(b). | Express the cost data in (2a) above in the form Y = a + bX. (Round your answers to 2 decimal places.) |
3. | If the company processes fourteen units next week, what would be the expected total etching cost? (Round your intermediate and final answers to 2 decimal places.) |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started