Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. A small company gathered sales data over the last 7 months as follows: Month Sales January 273 February 225 March 276 April 219 May

1.

image text in transcribedimage text in transcribed
A small company gathered sales data over the last 7 months as follows: Month Sales January 273 February 225 March 276 April 219 May 288 June 228 July 225 August Download CSV Do not round answers. a) What is the 3-month moving average forecast for May? b) What is the 2-month weighted moving average forecast for May using weights 3 and 2? Assign higher weight to the most recent period. c) Given that the exponentially smoothed forecast for February is 273, what is the simple exponential smoothing forecast for March with o = 0.3?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 1, 2 and 5. Do not round answers. Year Demand Forecast 252 2 236 228 4 230 5 268 6

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Tutor For Serways Essentials Of College Physics,

Authors: Raymond A Serway, Chris Vuille

1st Edition

0495171646, 9780495171645

More Books

Students also viewed these Mathematics questions