Question: 3 9 - 4 2 . If you had forecast 2 0 0 for January, what would you forecast for each month following, if you

39-42. If you had forecast 200 for January, what would you
forecast for each month following, if you used the exponential
smoothing method with a smoothing constant of .20?
ANSWER FOR FEBRUARY
39-42. If you had forecast 200 for January, what would you

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

The Tusquittee Company is a retail company that began operations on October 1, 2018, when it incorporated in the state of North Carolina. The Tusquittee Company is authorized to issue 100,000 shares...

Q:

Problem 2 2 Dave Fletcher, general manager of North Carolina Engineering Corporation (NCEC) wants to forecast the demand for his firm's engineering services to highway construction contracted to...

Q:

1) The actual demands for the huckleberry ice cream in the past 10 days were as follows: Day 1 2 3 4 5 6 7 8 9 10 Demand 120 143 143 195 212 200 246 230 251 232 a) In Excel, use the scatter plot to...

Q:

PLEASE RESPOND ASAP IN EXCEL SHEET WITH EXCEL FORMULA. THANKS, HST400 Week 4 Exercise Please use the posted Excel template for this question and submit your completed Excel file. Provide your answers...

Q:

Please answer question in Excel and provide explanation. HST400 Week 4 Exercise Please use the posted Excel template for this question and submit your completed Excel file. Provide your answers to...

Q:

3. (16 points) Given the actual sales of an item in the past 5 months, and the forecast of month 1, as in the table. (1) Calculate the forecasts of month 2 through month 6, using the Exponential...

Q:

4. (16 points) Given the actual sales of an item in the past 5 months, and the forecast of month 1, as in the table. (1) Calculate the forecasts of month 2 through month 6, using the Exponential...

Q:

HST400 Week 4 Exercise Please use the posted Excel template for this question and submit your completed Excel file. Provide your answers to each of the following parts on a different worksheet (in...

Q:

The following are the sales and forecasts for 10 Months: Month Sales Forecast 1 770 769 2 789 787 3 794 792 4 780 798 5 768 774 6 772 770 7 760 759 8 775 775 9 786 788 10 790 788 Required: For...

Q:

HST400 Week 4 Exercise Please use the posted Excel template for this question and submit your completed Excel file. Provide your answers to each of the following parts on a different worksheet (in...

Q:

Hello! Please answer using excel. Thank you in advance! The ABC Corporation has collected the following data on its daily sales in the past 4 weeks. The company only operates from Monday to Friday....

Q:

1. What are the three signs Pat Lencioni uses to identify a miserable job, and how do they reduce productivity? 2. When the three signs of a miserable job are present, which of the needs identified...

Q:

The beginning inventory for Matt Meyer Office Supplies and data on purchases and sales for a two-month period are shown in Problem 6-1B. Round the average cost to two decimal places. In Problem 6-1B...

Q:

Which manager is demonstrating preventative internal controls? Dwight, who is correcting employee errors Gilbert, who is conducting an internal audit Emie, who is counting an employee s cash register...

Q:

A company reports basic earnings per share of $3.50, cash dividends per share of $1.25, and a market price per share of $64.75. The company's dividend yield equals: 01.93%. 2.14%. 4.67%. 5.41%. 18.50%