Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

help ASAPpppp please please (Forecasting Problem) Not all the items in your office supply store are evenly distributed as far as demand is concerned, so

help ASAPpppp please please
image text in transcribed
(Forecasting Problem) Not all the items in your office supply store are evenly distributed as far as demand is concerned, so you decide to forecast demand to help plan your stock. Past 5-week data for legal-sized yellow tablets is shown in the table below. (round your answer to integer) 20 pts 300 Week 1 Week 2 Week 3 Week 4 Week 5 400 500 700 800 (a) Using a 3-week simple moving average, what would you forecast the week 6 to be? (5 points) (b) Calculate the weighted 3-week moving average using weights of 0.5, 0.3, and 0.2, what would you forecast the week 6 to be? (5 points) (c) Using simple exponential smoothing with a = 0.20, if the exponential forecast for week 5 was estimated as 750, that is F5 = 750, what would you forecast week 6 to be? (5 points) (d) Using exponential smoothing with trend to forecast week 6. Given a=0.20, 8 = 0.30, the exponential forecast for week 5 (F5) was estimated as 750, trend forecast for week 5 (T5) as 200. (5 points) Edit View Insert Format Tools Table

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

Real Estate Post Pandemic And Digital Real Estate

Authors: Fred Nickerson

1st Edition

979-8834591344

More Books

Students also viewed these Finance questions