Question: Given the demand and forecast values below: Period Demand April 100 May 105 June 97 July 102 August 99 September Forecast 97 103 98 105

Given the demand and forecast values below:

Given the demand and forecast values below: Period Demand April 100 May 105 June 97 July 102 August 99 September Forecast 97 103 98 105 102 1. What is the naive forecast for September 2. What is the 3 months moving average of September 3. What is 4 months weighted moving average forecast for September Using 0.1, 0.2, 0.3, 0.4 heaviest weight applied to the most recent months 4. What is the exponential smoothing forecast for September using an alfa of 0.4

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Lets go through each of the forecast calculation steps for September based on the data provided 1 Naive Forecast for September The naive forecast meth... View full answer

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!

Complete this question by entering your answers in the tabs below. Show how Pulaski determined the $415,112 Investment in Sheridan account balance. Assume that Pulaski defers 100 percent of...

Period Demand April 100 May 105 June 97 July 102 August 99 Given the demand values above, answer the following two question by filling in the two blanks: The last period value forecast for September...

Need help with answers in EXCEL formula! B D 1 Excel formulas must be used. Please be sure to submit your file as an Excel file. Any submissions in 2 numbers format will receive a 0. 3 4 MASTER...

Coffee Trends Altachet Files Tafers Coffee Data Fe 2018.xlsx (11796 KB) Cotechums Hannah Batran and Tyler Pullips are working en opening in therd espresso drive through stand in Hands Ranch Colorado,...

A B Excel formulas must be used. Please be sure to submit your file as an Excel file. Any submissions in numbers format will receive a 0 MASTER Student Name => Section Number => D B D E 1,500 1,000...

just solve the missing answers please which are the rest of question 2 and question 3 and 4 only the rest is correct and thank you Given Data Case 08-29: 1 CRAVAT SALES COMPANY S Minimum ending cash...

Case 10.2 Abruzzi Olive Oil Company (LO1) The Abruzzi Olive Oil Company is a small producer of premium olive oil. Cheryl Sounders, the owner of Abruzzi, is currently developing a budget spreadsheet...

Listen Given the demand and forecast values below: Period January February March April May June Demand 100 105 97 102 99 Forecast 97 103 98 105 102 1. What is the 3 months moving average of June ? (1...

need help with preparing budget on excel and cant put direct answers so please explain how to get each answer. Will rate positively ! Required: Prepare a master budget for the three-month period...

The following is the sales figures for Product over the past 4 8 months ( assume that we are at the end of December of year 4 ) 1 : Month / Year 1 2 3 4 January 2 8 4 3 1 5 3 4 0 3 6 0 February 2 7 7...

How will relating product contribution margin s to the amount of the constrained resource they consume help a company maximize its profits?

15 gram of methyl alcohol is dissolved in 35 gram of water. What is the mass percentage of methyl alcohol in solution? (a) 30% (b) 50% (c) 70% (d) 75%

Which one of the following conditions will prevent a corporation from making a valid S election? A corporation that has an estate as a shareholder. A corporation that is a member of an affiliated...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...