Question 16You work for BMW as a planner. BMW is expecting to increase its annual sales for BMW- X5 in year 2021 by 10 % comparedto year 2020 annual sales. Find the quarterly forecast for year 2021, given the following data:(You need to consider the Quarterly seasonal effect)QuarterActual Car Sales (2019)Actual Car Sales (2020)Quarter 18000088000Quarter 2100000110000Quarter 3120000132000Quarter 49000099000000Attach you solutions.Write your results of the 1st Q Forecasted sales in Field.

BMW-X5 sales are increasing by 10% every quarter looking at as per the given data. let us clarify…

Answered: You work for BMW as a planner. BMW is…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Question 2Chad and James are two veteran sales executives who have been working for a well-established car distributor selling new cars. About six years ago, believing that there were good prospects in starting a business in selling used cars, both gentlemen left their employment to venture out.Since the beginning of their company, sales had been quite positive, but the owners now wanted to know more about future sales using an appropriate forecasting method. For a start, they wanted to focus on the quarterly sales of a popular brand of used cars.The sales figures over the last five years were used for the forecast. They are presented in the table below. (c) Explain why forecasting, despite its usefulness or sophistication, should only be considered a useful tool for decision making in any business. What are other factors that need to be considered? (d) The business of selling cars in Singapore, like many businesses, is subject to uncertainties.Discuss three (3) external factors,…
QUESTION 1The table below shows the sales figures for a brand of shoe over the last 12 months.Months SalesJanuary 69February 75March 86April 92May 95June 100July 108August 115September 125October 131November 140December 150 a. Using the following, forecast the sales for the months up to January the following year:-i. A simple three month moving average
QUESTION 1The table below shows the sales figures for a brand of shoe over the last 12 months.Months SalesJanuary 69February 75March 86April 92May 95June 100July 108August 115September 125October 131November 140December 150 a. Using the following, forecast the sales for the months up to January the following year:- iii. Exponential Smoothing when α= .6 and the forecast for March is 350.
Question 2 i. Differentiate between independent and dependent variable in forecasting. ii. The last seven weeks of sales at KC car dealership can be seen in Table 2 below. Table 2 Week Sales 1 25 2 30 3 27 4 31 5 27 6 29 7 30 8 a. Use a three-period weighted-moving average forecast to determine a forecast for the 8th week using weights of 3, 2, and 1 (where the most recent week receives the highest weight). (Round all forecasts to the nearest whole unit.) b. Calculate the MAD for this forecast. c. What does the MAD indicate?
QUESTION 1 Sales of Fat Lips Burgers for 2012 are shown in the table below. 1. Do the 2 month SMA forecast 2. Do 2 month WMA forecast using the information below WMA – 2: last month, 1 – last 2 months 3. For the month of January 2012, the forecast was 438. Do the EMA forecast with the smoothing constant = 0.3. What is the forecast for Jan 2013? 4. Compare the forecasts above using MAD, MSE and MAPE. Which forecast method gives the least errors? Month Actual Sales Forecast Jan 2012 438 Feb 420 March 414 Apr 318 May 306 June 240 July 240 Aug 216 Sep 198 Oct 225 Nov 270 Dec 315 Jan 2013 - QUESTION 2Dayang sells 5 kg bags of fertilizer to local farmers in Tg Karang. The sales data for the past 11 months is shown below. Month Demand (10s of bags) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 1. Find the forecast for the month 12 using the methods below: a. Simple 4 month moving average (SMA) b.…
QUESTION 1The table below shows the sales figures for a brand of shoe over the last 12 months.Months SalesJanuary 69February 75March 86April 92May 95June 100July 108August 115September 125October 131November 140December 150a. Using the following, forecast the sales for the months up to January the following year:-i. A simple three month moving average. ii. A three period weighted moving average using weights of 1, 2 and 3. Assign thehighest weight to the most recent data. iii. Exponential Smoothing when α= .6 and the forecast for March is 350.iv. Determine which of the three forecasting technique is the most accurate usingMAD. b. The following table shows the number of televisions sold over the last ten years at alocal electronic store.YEAR TV SALES1 1502 3003 4804 6005 6306 6407 7008 8259 90010 980i. Using trend projection, develop a formula to predict sales for years 11 and 12. Youhave to show all working. You will need to develop a table to calculate the slope andthe intercept.…
QUESTION 1The table below shows the sales figures for a brand of shoe over the last 12 months. Months SalesJanuary 69February 75March 86April 92May 95June 100July 108August 115September 125October 131November 140December 150 a. Using the following, forecast the sales for the months up to January the following year:- ii. A three period weighted moving average using weights of 1, 2 and 3. Assign thehighest weight to the most recent data.
Question 18 A tire company needs a forecast for studded tires in the next forecast period. The company typically uses an exponential smoothing forecast using a smoothing constant of alpha = 0.20. The demand for the most recent period was 100 and the forecast for the same period was 110. Based on this information, what is the tire company's forecast for the next period? Group of answer choices a. 100 tires b. 102 tires c. 108 tires d. 110 tires e. Impossible to determine
Question #2 Month Demand 1 45 2 48 3 43 4 48 5 49 6 54 7 47 8 50 9 46 10 47 Using the table above, calculate two forecasts using the following method:- First, for periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (F3) of 45.0 and an alpha of 0.4. ii. Calculate the weighted moving average for periods 4 through 10, using weights of .70, .20, and .10, with 0.70 applied to the most recent data. iii. Calculate the mean absolute deviation (MAD) for each forecasting procedure. Which forecasting procedure would you select? Why?
Question 1. The table below shows the sales figure for a brand of shoe over the last 12 months. Months Sales January 69 February 75 March 86 April 92 May 95 June 100 July 108 August 115 September 125 October 131 November 140 December 150 a. Using the following, forecast the sales for the months up to january the following year:- i. A simple three month moving average ii. A three period weighted moving average using weights of 1, 2, and 3. Assign the highest weight to the most recent data iii. Exponential smothing when α = .6 and the forecast for march is 350 vi. Detemine which of the three forecasting technique is the most accurate using MAD N.B. Only answer IV
Question 1. The table below shows the sales figure for a brand of shoe over the last 12 months. Months Sales January 69 February 75 March 86 April 92 May 95 June 100 July 108 August 115 September 125 October 131 November 140 December 150 a. Using the following, forecast the sales for the months up to january the following year:- i. A simple three month moving average ii. A three period weighted moving average using weights of 1, 2, and 3. Assign the highest weight to the most recent data iii. Exponential smothing when α = .6 and the forecast for march is 350
QUESTION 2:The manager of YTL Computers wants to develop next year’s quarterly forecasts of salesrevenue for its brand laptops. The sales are seasonal and the company believes that thefollowing most recent eight quarters of sales should be representative of next year’ssales: Year Quarter Sales (millions of dollars) 1 1 9.2 1 2 5.4 1 3 4.3 1 4 14.1 2 1 10.3 2 2 6.4 2 3 5.4 2 4 16.0 Determine the forecast of next year’s quarterly sales revenue for this line of laptops.Show all your workings.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS