Mop and Broom Manufacturing has tracked the number of units sold of their most popular mop over the past 24 months. This is shown.Month12345678Sales Month238249254267277282402296910111213141516Sales300327346349353364373363Month+1718192021222324Sales361381375383384401409403a. 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 indicateslinear 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 =

Find the given details below: Given…

Answered: Mop and Broom Manufacturing has tracked…

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

From the following time series data of sale project the sales for the next three years. Year 2001 2002 2003 2004 2005 2006 2007 Sales (*000 units) 80 90 92 83 94 99 92
The following data was recorded while observing the increase in the number of butterflies in two different ponds, Pond A and Pond B. Number of Butterflies Present Over 5 Years Year Pond A Pond B 0 50 65 85 1 2 3 4 5 100 O 110 121 133 146 161 110 143 186 What is the rate of growth, r, for each pond and which pond has the fastest average rate of growth over the five years? TA = 1.1, TB = 1.3, mg = 3.72 butterflies/yr TA=0.9, TB=0.8, mg = 3.72 butterflies/yr TA=0.9, TB=0.8, mg=27.2 butterflies/yr TA = 1.1, TB = 1.3, mg=27.2 butterflies/yr
i need help with calculating rate of diffusion for 3 crystals and 6 crystals Diffusion Diffusion Diffusion Spot Spot Time Spot Diameter 1 Diameter 3 Diameter 6 (min) Crystal Crystals Crystals (mm) (mm) (mm) 10 15 0-15 0-15 20 16 0-16 0-16 30 18 0-18 0-18 Time Rate of Diffusion for Rate of Diffusion for 3 Crystals Rate of Diffusion for 6 Crystals (min) 1 Crystal (mm/hr) 0-10 90 0-20 48 0-30 36 (mm/hr) (mm/hr) Rate [mm/h] = (diameter [mm] / time [min]) x 60 [min] X
Tucson Machinery, Inc., manufactures numerically controlled machines, which sell for an average price of $14.0 million each. Sales for these NCMs for the past two years were as follows: Use Exhibit 3.10. QUARTER LAST YEAR I II III IV QUANTITY (UNITS) Y = 14 20 28 18 QUARTER THIS YEAR I II III IV QUANTITY (UNITS) 20 26 30 15 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.) > Answer is complete but not entirely correct. 18.535 X + 0.630 t
Given the attached data. Answer the following questions for a 7 period moving average. t At 1 5477 2 3338 3 4799 4 2852 5 6332 6 8385 7 4382 8 4184 9 14229 10 10385 11 11676 12 5271 13 8938 14 9279 15 13990 16 2890 17 13027 18 8970 19 6700 20 7065 21 12491 22 8748 23 8396 24 6102 25 7559 26 7997 27 11981 28 10680 29 5783 30 2501 31 7620 32 10194 33 7908 34 11985 35 5863 36 3024 37 8758 38 1640 39 6569 40 11728 41 6659 42 2830 43 10018 44 8448 45 12409 46 2083 47 6374 48 7438 49 4576 50 4795 MAD = Average(|A-F|) TS =SUM(A-F)/MAD MSE = Average(A-F)2 1. Compute your forecast for period 51. The potential answers are: A: 11221.6 units. B: 12461 units. C: 8020.83 units. D: 4414 units. E: 6589 units.
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 THIS YEAR QUANTITY (UNITS) QUANTITY QUARTER (UNITS) QUARTER I 11 I 16 II 17 II 23 III 25 III 27 IV 15 IV 18 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.) Y = b. Compute trend and seasonal factor from a linear regression line obtained with Excel. (Do not round intermediate calculations. Round your answers to 3 decimal places.) Period Trend Forecast Seasonal Factors Last Year II IV This Year II III IV
Fill the following blanks with appropriate abbreviations supplied: ________ =mean absolute percentage error, ________ = fixed cost, _______ = slope, _______ = correlation coefficient, _______ = smoothing constant, ________ = intercept, _________ = trend smoothing constant, α FC β MAPE b r a
South Africa Airways would like to monitor its airline’s performance. Each week for the past 20 weeks, they checked each week a random sample of 100 flight arrivals for “one-time” performance. The table that follows contains the number of flights that did not meet South Africa Airways definition of “one time”: Week Late flights 1 2 2 4 3 10 4 4 5 1 6 1 7 13 8 9 9 11 10 0 11 3 12 4 13 2 14 2 15 8 16 2 17 3 18 7 19 3 20 2 Which control chart is appropriate to analyze the above data? Justify your answer
South Africa Airways would like to monitor its airline’s performance. Each week for the past 20 weeks, they checked each week a random sample of 100 flight arrivals for “one-time” performance. The table that follows contains the number of flights that did not meet South Africa Airways definition of “one time”: Week Late flights 1 2 2 4 3 10 4 4 5 1 6 1 7 13 8 9 9 11 10 0 11 3 12 4 13 2 14 2 15 8 16 2 17 3 18 7 19 3 20 2 Calculate the upper and lower control limits for this chart.
The materials handling manager of a manufacturing company is trying to forecast the cost of maintenance for the company's fleet of over-the-road tractors. The manager believes that the cost of maintaining the tractors increases with their age. The following data was collected: Yearly Maintenance Yearly Maintenance Age (years) Age (years) Cost ($) Cost (S) 6.5 819 8.0 1,394 5.5 1,249 2.5 363 6.5 1,233 2.5 382 7.0 695 9.0 964 6.0 923 8.0 1,573 6.0 881 3.0 1,178 7.0 1,090 3.0 666 7.0 1,722 3.0 749 7.5 1,187 a. Use POM for Windows' least squares-linear regression module to develop a relationship to forecast the yearly maintenance cost based on the age of a tractor. (Enter your responses rounded to three decimal places and include a minus sign if necessary.) Y = 365.727 + 110,721 X where Y = Yearly maintenance cost in dollars and X= Age in years. b. If a section has 20 four-year-old tractors, what is the forecast for the annual maintenance cost? $ |- (Enter your response rounded to two…
Chart and Regression analysis : What does the intercept predict? X: C16 (number of cars on the sales lot) versus Y: C17 (cars sold per day) Equation: y=2.9x + 14.5 Slope:2.9 Intercept:14.5 Does the intercept mean the intercept is 14.5 means that the cars sold per day( Y) predicted number of cars on sale lot(X) to be 14.5, but this intercept has no meaning. So, I will not use to predict cars sold per day?
Consider the following given below: Week Sales('000) 1. 39 44 40 4 45 38 43 39 What is the Mean Absolute Percent error (MAPE)?

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