1. National mixer, Inc. sells can openers. Monthly sales fo a seven-month. period were as follows:SalesMonth(000 units)Feb---19March-18AprilMayJune-152018JulyAug.---2220a. Forecast September sales volume using each of the following:1. A five month-moving average2. The naïve approach3. A weighted using .60 for August, .30 for July, and .10 for June.b. Which method seems least appropriate? And Why?c. What does use of the term sales rather than demand presume?

Find the Given details below: Given details: Month Sales (000 units) Feb 19 March 18…

Answered: National mixer, Inc. sells can openers.…

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

5- When a forecast is too high in a company, it means that the company has allocated more resources which makes the company suffer. How would you classify a situation? a. High inventory cost b. High quality product c. High dissatisfaction from customers d. High employee turnover
q1- Daily highs in Sacramento for the past week (from least to most recent) were: 95, 102, 101, 96, 95, 90 and 92. Develop a forecast for today using a weighted moving average, with weights of .6, .3 and .1, where the highest weights are applied to the most recent dataq2- Consider the following demand and forecast. Period Demand Forecast 1 7 10 2 12 15 3 18 20 4 22 If MAD = 2, what is the forecast for period 4? Answer 21 22 23 none of the aboveq3- A normal distribution has a mean of 500 and a standard deviation of 50. A manager wants to simulate one value from this distribution, and has drawn the number 1.4 randomly. What is the simulated value?Q4- The local operations manager for the IRS must decide whether to hire 1, 2, or 3 temporary workers. He estimates that net revenues will vary with how well taxpayers comply with the new tax code. The following payoff table is given in thousands of dollars (e.g. 50 = $50,000). If he thinks the chances of low, medium, and high compliance are…
Al Maha Plastic manufacturing Companies last Six weekly values of Sales were 90, 110, 115, 135, 140, 150 and 160 units. Forecasts (same for all the six weeks) were 110 units for all the weeks. Calculate MAD, and Tracking Signal for these six weeks. Wee k Actual Sales Forecaste d Sale Error Cumulative Error Absolute Error Cumulative Absolute Error MAD Tracking Signal 1 2 3 4 5 6 7
8. Calculate (a) MAD and (b) MSE for the following forecast versus actual sales figures: Forecast 100 110 120 130 Actual 95 108 123 130 Part 2 a) MAD= __________ (round your response to one decimal place).
The table shows the values found in the error analysis. What method of forecasting would be best to use? What is the forecasted value? MSE forecast for week 13 Time Series 1.08 14.76 3-week MA 3.04 13.67 exp smoothing 11.04 9.5 Group of answer choices A.) Time Series, forecasted value = 14.76 B.) 3-week MA, forecasted value = 13.67 C.) exp smoothing, forecasted value = 9.5 D.) Time Series, forecasted value = 1.08 E.) 3-week MA, forecasted value = 3.04 F.) exp smoothing, forecasted value = 11.04
which of the following are charactersitics of qualitative forecasting methods? 1. Function of past data,2. Non numerical data , 3. useful when past data is avaialable , based on 4. broad range of knowledge , personal judgement, and intuition?
Do you think that Hard Rock Cafemakes use of time horizons when forecasting?
Indicate how and why each of these factors is important to thesuccessful operation of a supermarket:b. Forecasting
This a 4 part question that am confused about. Please show the work by hand not excel. 4-1 Sales of a particular product (in the thousands of dollars) for the years 2015 through 2018 have been $48,000, $64,000, $67,000 and $83,000 respectively. (a)What sales would you predict for 2019, using simple four-year moving avaerage? (b) What sales would you predict for 2019, using a weighted moving average with weights of 0.50 for the immediate preceding year and 0.3, 0.15, and 0.05 for the three years before that? (I am able to calculate and know the answer for (a) $65,000 and (b) $73,000. What I don't understand is the following : 4-2 Using exponential smoothing with a weight of 0.6 on actual values: (a) If sales are $45,000 and $50,000 for 2017 and 2018, what would you forecast for 2019 ? (The first forecast is equal to the value of the preceding year.) (b) Given this forecast and actual 2019 sales of $53,000, what would you then forecast for 2020? 4-3 In Problem 4-1, taking…
q 1 An analyst must decide between two different forecasting techniques for weekly sales of roller blades. Based on the following data, answer the below questions. time Units sold 1 147 2 148 3 151 4 145 5 155 6 152 7 155 8 157 9 160 10 165 What's the MAD if the exponential smoothing technique with alpha 0.4 is used?
3- What are the different Forecasting Approaches? Explain each in detail
1. Omar has heard from some of his customers that they will probably cut back on order sizes in thenext quarter. The company he works for has been reducing its sales force due to falling demand andhe worries that he could be next if his sales begin to fall off. Believing that he may be able to convince his customers not to cut back on orders, he turns in an optimistic forecast of his next quartersales to his manager. What are the pros and cons of doing that?

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