Solve it Suppose that you are given the following sales data for the last three years, with Q1 beingQuarter 1, etc.Golf SetsSoldQ1Q2Q3Q4201710015020182019175225300400150150200250250350a) Calculate the seas on al adjustment factor for Q1, Q2, Q3, and Q4.b) Take a prediction of 1300 units for 2020, and calculate for me my expected sales in Q1,2, 3, and 4 using the seas on al adjustmentfactors.

Solution a) 1. Calculate average demand per season by dividing annual demand by number of quarters…

Suppose that you are given the following sales data for the last three years, with Q1 being Quarter 1, etc. Golf Sets Sold Q1 Q2 03 Q4 2018 150 150 250 350 2017 2019 175 225 300 400 100 150 200 250 a) Calculate the season al adjustment factor for Q1, Q2, Q3, and Q4. b) Take a prediction of 1300 units for 2020, and calculate for me my expected sales in Q1, 2, 3, and 4 using the season al adjustment factors.

Suppose that you are given the following sales data for the last three years, with Q1 being Quarter 1, etc. Golf Sets Sold Q1 Q2 03 Q4 2018 150 150 250 350 2017 2019 175 225 300 400 100 150 200 250 a) Calculate the season al adjustment factor for Q1, Q2, Q3, and Q4. b) Take a prediction of 1300 units for 2020, and calculate for me my expected sales in Q1, 2, 3, and 4 using the season al adjustment factors.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section9.2: Elements Of Decision Analysis

Problem 2P

See similar textbooks

Similar questions

Under what conditions might a firm use multiple forecasting methods?
For the E-Commerce Retail Sales (Million$) data given in the table below, provide estimates from the 1st Quarter (Q1) of 2016 to the 3rd Quarter (Q3) of 2017 by using two models: 1) Single Exponential Smoothing with α=0.3 2) Moving Average with k=2. Calculate MAPE for each model. Quarter Year Actual Q1 2016 86802 Q2 2016 92004 Q3 2016 93795 Q4 2016 124651 Q1 2017 99491 Q2 2017 106590 Q3 2017 108291 Compare two models above (Single Exponential Smoothing and Moving Average) based on their accuracies. Which forecasting method appears to be better? Using the model you choose, provide forecast for the 4th Quarter (Q4) of 2017. Assuming that this model is overestimating, find the actual value of the Q4 of 2017 based on MAPE value. Some residual graphs from the first forecast model (including wider range of E-Commerce Retail Sales data) are given below. What do these graphs tell about the model? Explain each graph.
Sales of a particular product (in the thousands of dollars) for the year of 2015 through 2018 have been $48,000, $64,000, $67,000 and $83,000 respectively. (a) What sales would you predict for 2019, using a simple four year moving average? (b) What sales would you predict for 2019, using a weighted moving average with weights of 0.50 for the immediate preceding year 0.3, 0.15, and 0.05 for the three years before that?
Q2: An economist who estimated the Keynesian money demand function in logarithmic form using data from Sri Lankan economy, obtained the graph on the left by using predicted and actual money demand. While the model was very successful in predicting money demand until 2010 (small forecast errors), it predicts a consistently higher money demand than actually occurred since then (growing forecast errors each period). 48 Ln(M) 4.75 4.7 4.65 4.6 4.55 Actual 4.5 Predicted ...... 4.45 Help this economist who has trouble explaining this situation, even if you do not know anything about the economy in question. Can you answer this question with details please? 6toz Stor
Q3) You work for BMW as a planner. BMW sold 1,081,000 of its BMW-X5 cars in 2019 and sold 1,189,100 of its BMW-X5 cars in 2020. BMW is expecting to increase its annual sales for BMW- X5 in year 2021 by 10% compared to year 2020 (total sales volume = 1,308,010). Find the monthly forecast and seasonal indices for year 2021, given the following data: (Please considers the monthly seasonal effect) MONTH Actual Car Sales (2019) Actual Car Sales (2020) Forecasted Car Sales (2021) Jan 80,000 88,000 Feb 85,000 93,500 Mar 86,000 94,600 Apr 90,000 99,000 May 92,000 101,200 June 100,000 110,000 July 120,000 132,000 Aug 90,000 99,000 Sept 86,000 94,600 Oct 85,000 93,500 Nov 84,000 92,400 Dec 83,000 91,300
The treasury manager of a chain of clothing stores wants to develop a medium-term forecast. Management plans to open two new stores, and anticipates same-store sales to increase by 15%. Which of the following items can be predicted with the highest degree of certainty? Group of answer choices Taxes on the exercise of stock options fixed bond interest payments new product sales new franchise fees Loss exposures related to treasury management may include which of the following? Group of answer choices losses due to faulty investment of cash reserves product safety recalls litigation costs for intellectual property infringement bank consolidation
KTOC/ Kuwait-Tunis Oil Co. started 4 months ago. KTOC noticed that its production increased significantly. Production reported was: 5, 7, 20, 90 Liters respectively over the past 4 months. KOTC estimated weights for past 4 months were: 0.2, 0.3, 0.1, 0.4. KOTC is seeking your help to forecast its production for the following cycle. What is MAD and is it false or true value (statement)?
Sales of a particular product for the years 2017 through 2020 have been 43,466, 63,848, 51,112 and 79,210 respectively. What sales would you predict for 2021 using a simple four-year moving average?
10. Quarterly demand for Jaguar XJ8’s at a Tacloban Auto dealership is forecast with the equation, Y = 10 + 3x Where; X = time period (quarterly): Quarter 1 of 2021 = 0Quarter 2 of 2021 = 1Quarter 3 of 2021 = 2Quarter 4 of 2021 = 3 and so on...The demand for the luxury car is seasonal, and the weights of quarter 1, 2, 3, and 4 are 80%, 100%,130%, and 90% respectively. Using the trend projection, forecast the demand for each quarter of2023 and 2024. Then adjust each forecast with the weighted indices.
Given: Year Demand 1 7 2 9 3 5 4 9 5 Predict the value for Year 5: 2 year moving average What is MSE for 2 year moving average? 2 year moving average using 0.6 (weight for the oldest period) and 0.4(weight for most recent period Exponential smoothing, =0.2 and forecast for Year 1 = 5 Linear trend Which forecast method has the least amount of error using MAD? What is the coefficient?
Make a 15-year simple linear regression forecast. Example: Railroad Products Co. RPC Sales Car Loadings Year ($millions) (millions) 1 9.5 120 2 11.0 135 3 12.0 130 4 12.5 150 5 14.0 170 6 16.0 190 7 18.0 220
The following is a payoff table giving profits for various situations. Alternatives Alternative 1 Alternative 2 Alternative 3 Do Nothing 130 166 36 States of Nature A 160 200 120 0 B C The probabilities for states of nature A, B, and C are 0.3, 0.5, and 0.2, respectively. If a perfect forecast of the future were available, what is the expected value with this perfect information? 100 120 100 140 0 180 50 120 0