Question: Question 3 Demand data for a product over the last 5 months are given below. Calculate forecasts for months 3 through 6 using two-month moving

Question 3 Demand data for a product over the last 5 months are given below. Calculate forecasts for months 3 through 6 using two-month moving averages. Do not round answers. Month Demand Forecast 1 135 2 151 3 149 4 144 5 126 6 Download CSV\fQuestion 4 Demand data for trucks at a dealership over the last 5 years are given below. Calculate forecasts for years 4 through 6 using three-year weighted moving averages with weights 2, 2 and 4. Do not round answers. Year Demand Forecast 1 208 2 226 3 272 4 210 5 260 6 Download CSV\f. Question 5 Actual sales for a product over the last 4 periods are given below. Given a = 0.9, calculate simple exponential smoothing forecasts for periods 3 to 5. Do not round answers. Period Actual Forecast 1 300 2 210 300 3 240 4 230 5\f. Question 6 A small company gathered sales data over the last 7 months as follows: Month Sales January 249 February 210 March 204 April 201 May 207 June 255 July 285 August Download CSV Do not round answers. a) What is the 3-month moving average forecast for August? b) What is the 2-month weighted moving average forecast for August using weights 3 and 2? Assign higher weight to the most recent period. c) Given that the exponentially smoothed forecast for February is 249, what is the simple exponential smoothing forecast for March with a = 0.2?

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 Mathematics Questions!

1. Demand data for a product over the last 5 months are given below. Calculate forecasts for months 4 through 6 using three-month moving averages. Do not round answers. Month Demand Forecast 171 2...

Block 5: Forecasting Instruction : Use the following information to answer questions 23 to 25 Demand data for a product over the last 4 months are given below. Block 5: Forecasting Instruction: Use...

The University of Southern Mississippi College of Science & Technology IET 670 Section: G001 Supply Chain Design & Management Midterm Exam Full Points: 100 Student ID: Name: Closed book closed notes...

4. Assume that the operating results for last year were as follows: Sales 5 333,303 Less: Variable expenses 243,363 Contribution margin 553,303 Less: Fixed expenses 423,303 Net operating income 5...

X CW211.pdf - Adobe Acrobat Reader DC File Edit View Window Help Home Tools CW2-170393.pdf CW2-170393 (002)... CW211.pdf X ? Sign In 4 / 6 o 82.1% 2 do Share Search 'Rotate Page Po Export PDF 11 13...

1 Stratford Company distributes a lightweight lawn chair that sells for $30 per unit. Variable expenses are 40% of sales, and fixed expenses total $313,200 annually. 10 points Required: Answer the...

please answer this question asap NOTE: Show and use excel formulas for each and all calculations and round to two decimals Q 1 Use the Historical demand data below to calculate THREE forecasts. [3...

PUTEX CORPORATION: CORPORATE PLANNING PROCESS It was early morning of Monday, March 24, 2014, Gupta was driving to his office located on outskirts of the city. His mind was totally occupied with the...

Question 1Mary has decided to restate Cecil?s original profit statement by using the additional informationshe has collected and by employing a marginal costing approach.Required:(a) Prepare a new...

Student | Student | MyPark X Question 1 + Unit S Assignment x Chapter 8.docx x MG315 Unit 8 Homework.docx x ezto.mheducation.com/ext/map/index.html?_con= constexternal_browser =08:launchUrl=https...

You are a bank examiner and have concerns that the bank you are examining may have a solvency problem. On examining the banks assets, you notice that the loan sizes of a significant portion of a...

Consider an exchange economy with two consumers (A and B) and two goods (1 and 2). Consumer A has 60 units of good 1 and 40 units of good 2, consumer B has 40 units of good 1 1 and 60 units of good...

Assume a monopolists marginal cost and marginal revenue curves intersect and the demand curve passes above its average total cost curve. The firm will a. make an economic profit. b. stay in operation...

What are the major decisions that impact the strategic management of technology and innovation?

4. Think of two units of information you have received during the course of the day. Connect these two units of information and try to create completely new information that did not exist in the...

5. What do you think is meant by the phrase giving priority to what we already know?

2. You are asked to provide information to the board of the company you work for. How would you convey this information if the aim is: a) That they will remember the information for a long time. b)...