Problem 12-15 (Algo)Given the data shown below, calculate the slope and interceptusing simple linear regression. (Round your intermediatecalculations and final answers to 1 decimal place.)Period:Demand:123456222942505461SlopeIntercept

Step 1: Create a table like this∑X = 21∑Y = 258∑X2= 91∑XY = 1042N = 6 Slope =…

Answered: Problem 12-15 (Algo) Given the data…

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

shipped and total shipping costs: Number of Units Shipped 75 60 40 20 70 80 50 Month January February March April May June July Required: 3. Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit. 4. Perform a least-squares regression analysis on Odessa's data. 5. sing the regression output, create a linear equation (y= a + bx) for estimating Odessa's shipping costs. Complete this question by entering your answers in the tabs below. Required 3 Required 4 Total Shipping Cost $3,250 2,300 1,700 1,200 2,300 2,700 2,000 Required 5 Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit. Fixed cost Variable cost per unit Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required 5 Intercept X Variable Perform a least-squares regression analysis on Odessa's data. Note: Use Microsoft Excel or a statistical package to find the coefficients using to 2…
Q 6 Identify two business situations where the Delphi method might be used to generate forecasts. Can you think of any difficulties and pitfalls associated with using the Delphi method?
Kuwait-Arab Medical Supplies - started in January 2020 to help in protecting against COVID19. KAMS seasonal distribution of its products were: 1, 4. 2, 5 thousand boxes per season/ a season is 3 months. KAMS needs to know what is the expected production distribution in the first season of 2021.KAMS also requested the forecast for the first 2021 season if weights were recorded to be: 0.3, 0.4, 0.1, 0.2
Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Year Sales 1 450 2 502 3 520 4 570 5 575 a) Forecasted sales for year 6 using the trend projection (linear regression) method aresales (round your response to one decimal place). b) The MAD for a linear regression forecast is nothing sales (round your response to one decimal place).
XYZ Chips Inc. (XCI) produces Centrino-type chips. The market has been inclining with ups and downs during the last eight years because of its new chips. The demands over the last 12 periods were 95, 115, 130, 122, 105, 125, 140, 134, 125, 142, 160, and 153 thousand pieces. Forecast the demand for the next 4 periods (periods 13 to 16) using an appropriate forecasting technique.
part c
Calculate the mean square error, mean absolute deviation and the Period Year Call Volume forecast Error 1 1 30 45 -15 2 2 25 15 10 3 2 55 65 -10 4 3 15 20 -5 Your answer?
The following table shows the actual demand observed over the last 4 years: 1 Year Demand 8 Year Forecast (ES) 1 7.0 Using exponential smoothing with a = 0.30 and a forecast for year 1 of 7.0, provide the forecast from periods 2 through 5 (round your responses to one decimal place). 3 5 Provide the forecast from periods 2 through 5 using the naive approach (enter your responses as whole numbers). Year Forecast (NA) 2 10 2 2 3 4 3 4 4 9 4 5
Tucson Machinery, Inc., manufactures numerically controlled machines, which sell for an average price of $0.5 million each. Sales for these NCMS for the past two years were as follows: Use Exhibit 18.10. LAST YEAR QUANTITY QUARTER (UNITS) THIS YEAR QUANTITY QUARTER (UNITS) 15 15 II III 21 II 27 31 29 19 III IV IV 15 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.)
The following table shows the actual demand observed over the last 11 years: Year Demand 1 7 Year Forecast 2 8 2 3 4 3 4 10 4 Using exponential smoothing with a = 0.30 and a forecast for year 1 of 6.0, provide the forecast from periods 2 through 12 (round your responses to one decimal place). 3 2 4 5 6 T 8 9 Year 1 Forecast 6.0 Provide the forecast from periods 2 through 12 using the naive approach (enter your responses as whole numbers) 5 12 5 6 7 6 7 8 11 14 7 8 9 10 9 10 10 10 13 11 11 11 8 12 12
An electrical contractor's records during the last five weeks indicate the number of job requests: Week: Requests: 1 2 3 5 25 27 25 26 27 Click here for the Excel Data File Predict the number of requests for week 6 using each of these methods: a. Naive. Number of requests b. A four-perlod moving average. (Round your answer to 2 decimal places.) Number of requests
Give typed answer Question: Use an exponential smoothing model with a =.4 to forecast issues remediated for periods 6-10. (Assume a beginning forecast of 320 for period 5). 1. Forecast Period 6 (August) : ? 2. Forecast Period 7 (September) : ? 3. Forecast Period 8 (October) : ? 4. Forecast Period 9 (November) : ? 5. Forecast Period 10 (December) : ?

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

Problem 12-15 (Algo) Given the data shown below, calculate the slope and intercept using simple linear regression. (Round your intermediate calculations and final answers to 1 decimal place.) Period: Demand: 1 2 3 4 5 6 22 29 42 50 54 61 Slope Intercept