Alvin Cheah is a marketing analyst for Rockstar Travel Company. He wants to analyze the trend ofinternational tourist arrival in Tawau by using international tourist arrival rate and flight delayed rate overthe past 10 years as given in Table 2 below: (Hint: Provides your answers in two decimal points)Table 2Year2010201120122013201420152016201720182019Arrival35.528.030.336.049.556.072.471.079.396.0C000)Delayed4.23.83.83.54.64.54.64.64.74.5rate(1) Propose ONE (1) forecasting model that can be used by Alvin. Why would you proposed thatparticular model?(5 marks)(ii) Develop the forecasting model that you suggest in (i). Briefly explain your model.(20 marks)

arrival rate b delayed rate a we can seen from the…

Alvin Cheah is a marketing analyst for Rockstar Travel Company. He wants to analyze the trend of international tourist arrival in Tawau by using international tourist arrival rate and flight delayed rate over the past 10 years as given in Table 2 below: (Hint: Provides your answers in two decimal points) Table 2 2013 Year 2010 2011 2012 2014 2015 2016 2017 2018 2019 Arrival C000) Delayed 35.5 28.0 30.3 36.0 49.5 56.0 72.4 71.0 79.3 96.0 4.2 3.8 3.8 3.5 4.6 4.5 4.6 4.6 4.7 4.5 rate () Propose ONE (1) forecasting model that can be used by Alvin. Why would you proposed that particular model? (5 marks) (i) Develop the forecasting model that you suggest in (i). Briefly explain your model. (20 marks)

Alvin Cheah is a marketing analyst for Rockstar Travel Company. He wants to analyze the trend of international tourist arrival in Tawau by using international tourist arrival rate and flight delayed rate over the past 10 years as given in Table 2 below: (Hint: Provides your answers in two decimal points) Table 2 2013 Year 2010 2011 2012 2014 2015 2016 2017 2018 2019 Arrival C000) Delayed 35.5 28.0 30.3 36.0 49.5 56.0 72.4 71.0 79.3 96.0 4.2 3.8 3.8 3.5 4.6 4.5 4.6 4.6 4.7 4.5 rate () Propose ONE (1) forecasting model that can be used by Alvin. Why would you proposed that particular model? (5 marks) (i) Develop the forecasting model that you suggest in (i). Briefly explain your model. (20 marks)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.3: Simple Regression Models

Problem 9P

See similar textbooks

Similar questions

Freight car loadings over a 12-year period at a busy port are as follows:Week Number Week Number Week Number1 220 7 350 13 4602 245 8 360 14 4753 280 9 400 15 5004 275 10 380 16 5105 300 11 420 17 5256 310 12 450 18 541a. Determine a linear trend line for expected freight car loadings.b. Use the trend equation to predict expected loadings for weeks 20 and 21.c. The manager intends to install new equipment when the volume exceeds 800 loadings per week.Assuming the current trend continues, the loading volume will reach that level in approximatelywhat week?
Alvin Cheah is a marketing analyst for Rockstar Travel Company. He wants to analyze the trend of international tourist arrival in Tawau by using international tourist arrival rate and flight delayed rate over the past 10 years as given in Table 2 below: (Hint: Provides your answers in two decimal points) (i) Propose ONE (1) forecasting model that can be used by Alvin. Why would you proposed that particular model? (ii) Develop the forecasting model that you suggest in (i). Briefly explain your model.
Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week Number Week Number 1 410 7 460 13 540 2 420 8 480 14 550 3 430 9 500 15 570 4 420 10 490 16 580 5 430 11 510 17 590 6 440 12 530 18 600 Click here for the Excel Data File a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) b. Use the above trend equation to predict expected loadings for Weeks 20 & 21. (Round your final answers to 2 decimal places.) c. The manager intends to install new equipment when the volume exceeds 990 loadings per week. Assuming the current trend continues, in which week (at the earliest) should the loading volume reach that level? (Use the rounded answers, as required, from any previous part of this problem. Do not round any other intermediate calculations. Round your final answer to 2 decimal places.)
Using the information provided below, answer the following questions.INFORMATIONThe data in the table below shows the number of Next-generation Rangers exported to over 100 countries through Durban’s roll-on roll-off (RORO) vehicle terminal during 2022 and the first quarter of 2023. A demand planner wants to compare the relative performance of the weighted moving average method against the simple exponential method in forecasting the volume of export of the next-gen Ranger from the Silverton Assembly Plant.Required:5.1. Using the simple exponential smoothing method (SESM), compute the forecasts for the February 2022 to March 2023 period.Use a smoothing constant of 0.2 and assume a forecast of 7 000 units for January 2022.5.2. Compute the three-month weighted moving average (3MWMA) forecasts for the April 2022 to March 2023 period, using weights of 0.2, 0.3, and 0,5 (oldest data to newest data, respectively).5.3. Using the forecasts calculated for the April 2022 to March 2023 period,…
Eurotronics manufactures components for use in small electronic products such as computers, CD players, and radios at plants in Belgium, Germany, and France. The parts are transported by truck to Hamburg, where they are shipped overseas to customers in Mexico, South America, the United States, and the Pacific Rim. The company has to reserve space on ships months and sometimes years in advance. This requires an accurate forecasting model. Following are the number of cubic feet of container space the company has used in each of the past 18 months: Month Space (1,000s ft.3) 1 10.6 2 12.7 3 9.8 4 11.3 5 13.6 6 14.4 7 12.2 8 16.7 9 18.1 10 19.2 11 16.3 12 14.7 13 18.2 14 19.6 15 21.4 16…
Alvin Cheah is a marketing analyst for Rockstar Travel Company. He wants to analyze the trend ofinternational tourist arrival in Tawau by using international tourist arrival rate and flight delayed rate overthe past 10 years as given in Table 2 below: (Hint: Provides your answers in two decimal points) (i) Propose ONE (1) forecasting model that can be used by Alvin. Why would you proposed that particular model?(ii) Develop the forecasting model that you suggest in (i). Briefly explain your model.
The Tech power plant burns coal and natural gas to generate steam and electricity for all campus buildings. The annual coal consumption at the plant has increased annually for the past 6 years due to an aggressive campus building program. The following table shows the annual coal consumption: Year Coal Consumption (tons) 1 25000 2 23000 3 28000 4 35000 5 37000 6 42000 Develop a linear trend model to forecast coal consumption for the 7 th year. Don't answer by pen paper and don't use chatgpt otherwise we will give dounvote