Exercise SA-5 (Algo) Least-Squares Regression (LO5-11George Caloz & Frères, located in Grenchen, Switzerland, makes luxury custom watches in small lots. One of thecompany's products, a platinum diving watch, goes through an etching process. The company has recorded etching costsas follows over the last six weeks:Week1234Units14111610121578Total EtchingCost$ 272030202528$150For planning purposes, management would like to know the variable etching cost per unit and the total fixed etching costper week.Exercise 5A-5 Part 2 (Algo)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.

First, let me state the given data, WeekUnits or XTotal etching cost or…

Answered: 2-a. Using the least-squares regression…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Write Comments on the Use of Linear Regression Analysis?
Arnold Tofu owns and operates a chain of "hamburger" restaurants in northern Louisiana. Sales figures and profits for the stores are provided in the table below. Sales are given in millions of dollars; profits are in hundreds of thousands of dollars. Using associative forecasting, calculate a regression line for the data. Profits 14 11 15 16 Sales 6 5 5 1) Using Excel, find the linear regression chart and the line regression equation. 2) What is your forecast of sales for a store with profit of $24?
Pls answer b and c
When testing the IFE (International Fisher Effect), we run a linear regression, R^2 could be used to measure
Data on 10 mid-level managers in insurance industry is given below, in the box. Employees refer to number of employees supervised and salary refer to annual salary in 1000$.Employees 28 31 38 38 43 47 48 49 53 56Salary 99 102 136 127 157 121 173 197 200 176a. Create the regression equation.b. Forecast the salary of a manager who supervises 90 employees by using the regression equation you created.
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Explain the compromise between responsiveness and stability in a predictive system using data from time series.
25. Consider the following time series data: Quarter 1 234 Year 1 4 4235 2 5 Year 2 6357 5 7 Year 3 7 6 6 8 a. Construct a time series plot. What type of pattern exists in the data? b. Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. c. Compute the quarterly forecasts for next year.
Please help with correct answers: step by step: last time submitted- answers were incorrect A statistical program is recommended. The quarterly sales data (number of copies sold) for a college textbook over the past three years follow. Quarter Year 1 Year 2 Year 3 1 1,690 1,800 1,850 2 940 900 1,100 3 2,625 2,900 2,930 4 2,500 2,360 2,615 a) Use a regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. (Round your numerical values to the nearest integer.) Qrt1 = 1 if quarter 1, 0 otherwise; Qrt2 = 1 if quarter 2, 0 otherwise; Qrt3 = 1 if quarter 3, 0 otherwise t = b) Using the equation developed in part (b), compute the quarterly forecasts for year 4. (Round your answers to the nearest ten.) quarter 1 forecast____? quarter 2 forecast____? quarter 3 forecast ____? quarter 4 forecast ____? c) Let t = 1 refer to the observation in Quarter 1 of Year 1; let t = 2 refer to the observation in Quarter 2 of Year…
An example of the Quantitative Method of forecasting is O Multiple Regression Market Research O the Delphi Methode O Jury of Executive Opinion
1- A pharmacist has been monitoring sales of certain over-the-counter pain reliever. Daily sales during the last 15 days were as follows: Day 1 2 3 4 7 8 9 Number sold 36 38 42 44 48 49 50 49 52 Day 10 11 12 13 14 15 Number sold 48 52 55 54 56 57 a: By using linear regression method predict the future sales for the next 5 days (please do all calculations in excel and send the excel file with answers included as your response) b: calculate the MSE for the prediction of these 15 days. (again by using Excel) 1- Explain how QFD can be employed for designing a new restaurant in your region in Iraq? (at least 100 words) 2- A producer of inkjet printers is planning to add a new production line of printers, and you have been asked to balance the process, given the following task times and precedence relationships. Assume the cycle time is to be minimum possible (based on the bottleneck). Immediate Length (minutes) Task (Predecessor) a 0.2 b 0.4 a 0.3 d 1.3 b, c e 0.1 f 0.8 e g 0.3 d, f 1.2 g a…
data table below shows the number of computers sold at the Best Buy Store in a week, based on online ads. Online Ad Computers Sold 2 25 1 10 4 30 1 10 2 25 sigma)x=10 sigma)y=100 draw the graph of the regression equation, showing the slope and y intercepts?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

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.