ZuoTi.Pro
Question

22. Corporate has provided the following weights for the demand data below: most recent data .55, next most recent = .20, thi
business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Moving average forecast can be used to forecast long-term trends and can be calculated for any time period.

W = 0.55 : W₂ = 0·20 ; W3 = 0·15 ; WH = 0·10 Ę = W, At-4 + W₂ A 6-3 t Wg At-2 t Wy & At-1 - W, + W2 + Wz t Wy to 55 Fo= W, A

0 0
Add a comment
Know the answer?
Add Answer to:
22. Corporate has provided the following weights for the demand data below: most recent data .55,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Suppose that the Perpetual Help College of Rizal had the following record of its growth of...

    Suppose that the Perpetual Help College of Rizal had the following record of its growth of enrollment from 2011 -2020. Year Enrolment Year Enrolment 2011 5,200 2016 7,000 2012 5,500 2017 8,800 2013 6,000 2018 9,400 2014 6,500 2019 9,600 2015 6,800 2020 10,500 a) Develop a forecast of enrolment beginning 2014 to 2021 using 3-years moving average forecast model. b) Using weights of .50 for the most recent data, .30 to the second recent data, and .20 to the...

  • 1. Suppose that the Perpetual Help College of Rizal had the following record of its growth...

    1. Suppose that the Perpetual Help College of Rizal had the following record of its growth of enrollment from 2011-2020. Year Enrolment Year Enrolment 2011 2012 5,200 5,500 2016 2017 7,000 8,800 2013 2014 2015 6,000 6,500 6,800 2018 2019 2020 9,400 9,600 10,500 a) Develop a forecast of enrolment beginning 2014 to 2021 using 3-years moving average forecast model. (8 pts) b) Using weights of .50 for the most recent data, .30 to the second recent data, and .20...

  • Problem 1 The owner of MGM in Vegas wants to develop a forecast for the sale...

    Problem 1 The owner of MGM in Vegas wants to develop a forecast for the sale of its Beats speakers for the coming year based on the historical data. Year 2013 2014 2015 2016 2017 Sales 22 28 34 40 45 (a) Graph this series. Does there appear to be a trend? (2 marks) (b) Using the Trend Projection Method, develop an equation for the sales data (using formula). What is the average increase in sales per year for the...

  • Question 1 4 pts The actual demand for your sales merchandise is provided in the table...

    Question 1 4 pts The actual demand for your sales merchandise is provided in the table below. The weights for June, July, and August have historically been 20..35, and.45, respectively. Actual June July August 140 180 170 Using the weighted moving average format, what is the forecasted demand for September? O 140 163 O 170 O 168 O 270 Question 6 4 pts Assuming no safety stock, what is the reorder point (R) given an average daily demand of 50...

  • Consider the following gasoline sales time series data. Click onthe datafile logo to reference th...

    Consider the following gasoline sales time series data. Click onthe datafile logo to reference the data. Week Sales (1000s of gallons) 17 21 17 15 20 18 21 21 16 21 6 10 12 a. Using a weight of for the most recent observation, for the second most recent observation, and the time series (to 2 decimals). Enter negative values as negative numbers. third the most recent observation, compute a three-week weighted moving average for Forecast Weighted Moving Average Forecast...

  • Problem 1 The table below presents data for tire sales in the Costco Branch at South Dakota Avenue, Washington D.C. from the months of July through December of the Year 2017. Automobile Tire Sales 55...

    Problem 1 The table below presents data for tire sales in the Costco Branch at South Dakota Avenue, Washington D.C. from the months of July through December of the Year 2017. Automobile Tire Sales 550 576 590 602 622 664 689 905 860 869 886 920 Y ear 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 Month Janua Februar March April June Jul August September October November December a. Compute a two-month moving average. What is...

  • Consider the following gasoline sales time series data. Click on the datafile logo to reference the...

    Consider the following gasoline sales time series data. Click on the datafile logo to reference the data. Week Sales (1000s of gallons) 1     17    2     20    3     19    4     23    5     18    6     16    7     19    8     18    9     23    10     19    11     15    12     22    a. Using a weight of  for the most recent observation,  for the second most recent observation, and  third the most recent observation, compute a three-week...

  • A country import data shows the following. Using the data Calculate the straight line trend model...

    A country import data shows the following. Using the data Calculate the straight line trend model using the least square method and predict the total import for 2017 and 2018 Calculate a three year moving average for the data and show the same on separate column year import in billions $ 2007 21 2008 18 2009 16 2010 24 2011 23 2012 24 2013 39 2014 28 2015 12 2016 34

  • s Below is 10 years' data on the Manager's Salary Index (MSI). Year 2008 2009 2010...

    s Below is 10 years' data on the Manager's Salary Index (MSI). Year 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 MSI 93 100 Change in MSI 3.9% 5.0 115 126 1.2 8.3 5.1 12.0 4.5 138 145 170

  • (USE ONLY EXCEL SHEET FOR DATA,  FORMULAS, and the GRAPHS) Ø  For the following list of data (number...

    (USE ONLY EXCEL SHEET FOR DATA,  FORMULAS, and the GRAPHS) Ø  For the following list of data (number of sold cars in every year ) , apply “exponential smoothing with trend” for all the years below. (i.e find the Forecast including trend)   (20%): ---- case1  use :  α= 0.2     and β = 0.05 ---- case2  use:   for  α= 0.05     and β = 0.2 Calculate MAD for both cases. Decide which  case values are better and why? Assume trend is zero for the 2012 years. Year Number of sold cars 2012 150...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT