2. The production and corresponding costing of a product in a factory is givenbelow:Production Cost(units)(Dollars)100500020060003008000400900050010000(a) Find the expected costing for the production of 600 units of the productusing linear regression model.

Answered: Image /qna-images/answer/142a0cd7-76e7-46f9-b5ba-78d9055a7368.jpg

Answered: 2. The production and corresponding…

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

Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: Year -1 2 Registrations (000) 5.0 5.0 Year Forecast 4 4.3 This exercise contains only parts a and b. a) Using a 3-year moving average, the forecasted registrations (in thousands) for years 4 through 12 are (round your responses to one decimal place): 5 4.6 4 3 3.0 5 6 6.6 7 8 4 5 6 9 10 6.0 11.0 9.0 7.0 9.0 13.0 16.0 6 7 8.7 8 9 7 9 8.3 b) Using a 3-year weighted moving average in which the registrations in the most recent year are given a weight of 2, and registrations in the other 2 years are each given a weight of 1, the forecasted registrations (in thousands) for years 4 through 12 are (round your responses to one decimal place): Year Forecast 8 10 9.6 9 11 12.6 10 12 15.3 11 11 17.0 12
Hi, need help solving for part B. Thank you.
Sarah has been custom manufacturing sweaters now for 7 years. Her annual sales are shown below. Year Sales 1 178 2 215 3 233 4 301 5 337 6 330 7 361 What are her forecasted sales for year 8 using a 5 year weighted average where w1=.4, w2=.3, w3=.15, w4=.1, w5=.05? What are her forecasted sales for year 8 using exponential smoothing? Assume year 7 forecast was 323. Select your own alpha. Which forecast method is the best for Sarah to use based on MAD? Why?
The number of internal disk drives (in millions) made at a plant in Taiwan during the past 5 years follows: F Year 4 Disk Drives 142 164 196 204 216 B a) Using simple linear regression, the forecast for the number of disk drives to be made next year-isk drives (round your response to one decimal place)
A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are SR₁ = 0.9, SR₂ = 0.95, SR3 = 1.05, and SR₁ =1.1, The trend equation is: Fr=9+ 41. Over the past nine quarters, demand has been as follows: Period, t: Demand: Click here for the Excel Data File Compute the MAD and tracking signal for each period. (Negative values should be indicated by a minus sign. Round your intermediate calculations and final answers to 3 decimal places.) Period, t 1 2 3 4 5 6 7 1 2 3 4 5 6 7 В 9 14 18 20 22 28 30 36 42 45 89 Demand 14 18 20 22 28 30 36 42 45 MAD Tracking signal
Roger Co. implemented activity-based costing in the current year. To select the appropriate driver for Cost Pool A, Roger performed regression analyses for two independent variables, Driver 1 and Driver 2, using monthly operating data. The monthly levels of Cost Pool A were the dependent variables in both regressions. Output results from the regression analyses were as follows: Driver 1 R squared Intercept X variable (slope) At the budgeted production level for next month, the levels of Driver 1 and Driver 2 are expected to be 5,880 and 7,000, respectively. Based on this information, what is the budgeted amount for Cost Pool A for next month? O A. $3,280 OB. $2,624 O C. $3,464 O D. $3,785 0.46 $551.00 Driver 2 $0.55 0.80 $970.00 $0.33
Da
The demand data for Double T Computer Services appears below. The company wants you to forecast the demand for period 4. What is your forecast using the least squares method? Period Demand 1 37 2 40 3 40
Mop and Broom Manufacturing has tracked the number of units sold of their most popular mop over the past 24 months. This is shown. Month 1 2 3 4 5 6 7 8 Sales Month 238 249 254 267 277 282 402 296 9 10 11 12 13 14 15 16 Sales 300 327 346 349 353 364 373 363 Month + 17 18 19 20 21 22 23 24 Sales 361 381 375 383 384 401 409 403 a. Develop a linear trend line for the data. (Round your answers to 2 decimal places, e.g.,25.28.) Sales = (month) b. Compute a correlation coefficient for the data and evaluate the strength of the linear relationship. (Round your answer to 2 decimal places, the tolerance is +/-0.01.) Correlation coefficient is . It indicates linear relationship. (Use not rounded amounts to answer this question.) c. Using the linear trend line equation, develop a forecast for the next period,month 25. (Round your answer to 2 decimal places, the tolerance is +/-0.01. Do not round intermediate results used to achieve this answer.) Forecast for month 25 =
Below is data of lobster sales volume from a seafood company. We are using exponential smoothing (α = 0.5) and 3-year moving average to forecast it. Please fill the blanks above and write your processes below. What are the mean absolute deviations (MADs) of the two methods? Which method will you choose based on the results?
A ski resort has recorded its recent sales as follows (in $$). Season 2 years ago Last year This year Spring 700 950 900 Summer 450 500 400 Fall 1,150 1,100 1,350 Winter 1,400 1,500 1,600 The resort estimated that the annual demand for the next year will be 4,800. What would be the forecast for next Fall? Answer: _______
The following table shows the actual demand observed over the last 11 years: Year 1 Demand 8 2 9 3 5 This exercise contains only parts b, c, and d. b) Using the 3-year moving average, provide the forecast from periods 4 through 12 (round your responses to one decimal place). Year Forecast 4 5 4 10 6 5 13 7 6 7 8 7 11 9 8 14 10 9 8 11 10 13 12 11 8

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. The production and corresponding costing of a product in a factory is given below: Production (units) 100 200 300 400 500 Cost (Dollars) 5000 6000 8000 9000 10000 (a) Find the expected costing for the production of 600 units of the product using linear regression model.