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

Pls do fast within 5 minutes and i will give like for sure Solution must be in typed form
What is the importtance of forecasting room availability and room revenue for Front Office Managers.
write Each variable in the table below has a corresponding indicator (measurement) from the literature? Nb: independent variable:awareness,convenience and benifit, transection mode of online,preventive management dependent variable: cybercrime, development of ecommerce
For the following data, calculate 'MAPE' Month Forecast Actual 1 1100 950 1100 1050 6. 3 1100 1100 4 1100 1200 5 1100 1090 б 1100 1070
QWE Inn has recorded the following number of rooms sold for the first quarter of the year: January 2100 February 2500 March 2550 What is the 3-month moving average forecast of rooms sold equal to for the month April?
B. The owner of a small hardware store has noted a sales pattern that seems to parallel the number of break-inns reported each week in newspaper. The 08 02 05 Sales: 50 22 24 18 35 42 13 Break-inns: 9 04 04 06 08 03 7 Estimate sales when break-inns is 7
Utah Utensil has developed a new kitchen utensil. The firm has conducted significant market research and estimated the following pattern for sales of the new product: Year Expected Volume Expected Price per Unit 1 48,000 units $19 2 48,000 units $20 3 90,000 units $16 4 40,000 units $12 If the firm desires to net $3.50 per unit in profit over the life of the product, and selling and administrative expenses are expected to average $50,000 per year, what is the target cost to produce the new utensil?
Mary Beth Marrs, the manager of an apartmentcomplex, feels overwhelmed by the number of complaints sheis receiving. Below is the check sheet she has kept for the past12 weeks. Develop a Pareto chart using this information. Whatrecommendations would you make?
A small local grocery has seen a decline in sales in the past few months. The owner has made no changes to the store in the last year. In the beginning, the owner thought the sales drop might be seasonal. However, looking at the past few years of sales data, the owner noticed that there had not been any decrease in sales during the same time in the previous years. Design a study to identify what might be the probable ultimate cause/s of the decline in sales for a grocery. For looking at the different causes, consider the box and arrow diagram given. Note the following things about the box and arrow diagram: If the arrow’s head is towards a box, that means the variable in the box (where the arrow’s head is) affects the variable in the box from where the arrow originated. E.g “Revenue/Sales” is affected by the “Number of shoppers/customers”. The boxes in grey are the variables you as a firm/owner can directly expect to affect which can further affect other variables in the model. E.g.…
Given the following sales data: week 1: 203 week 2: 185 week 3: 164 week 4: 151 week 5: 115 Forecast sales for week 6 using Holt's model with: alpha = 0.3 beta = 0.4 Use L(2) = A(2) and T(2) = A(2) - A(1) to initialize the model. %3D Your Answer: Answer
1. The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Part 2 Week Of Pints Used August 31 350 September 7 372 September 14 412 September 21 381 September 28 366 October 5 378 Part 3 a) The forecasted demand for the week of October 12 using a 3-week moving average LOADING... = _____________pints (round your response to two decimal places).
a. Using POM for Windows' least squares-linear regression module, develop a relationship to forecast production ratings from test scores. (Round your responses to three decis and include a minus sign if necessary.) Y= - 23 + .945 x where Y = Production rating and X = Test score. b. If a worker's test score was 54, what would be your forecast of the worker's production rating? 51. (Enter your response as an integer.) c. Comment on the strength of the relationship between the test scores and production ratings. The coefficient of correlation for the least-squares regression model is and the coefficient of determination is (Enter your responses rounded to three decimal places.) More info Test Score Production Rating Production Test Worker Worker Rating Score A 55 43 K 58 57 B 38 43 75 75 93 87 67 48 D 86 77 31 26 E 88 82 62 49 F 66 68 24 25 G 55 47 Q 78 84 Clear all Check 50 46 34 32 41 41 51 58 J 69 74 T 39 30 Print Done LLMN OPoRS

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