AutoSave Home Insert Draw Design Layout Times New... 11 ' ' Paste B I U ab...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
AutoSave Home Insert Draw Design Layout Times New... 11 ' ' Paste B I U ab x, A Page 2 of 2 W= Assignment 1 OMGT2199 2024A BD References Aa D A Po abca A Mailings Review View Tell me Comments Editing Share A T AaBbCcDdEe AaBbCcDdEe > Normal No Spacing Styles Pane Dictate Sensitivity Add-ins Editor Update from Project 2 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 1 18 T 465 words Vietnamese Task 1: Bank Account Forecast A well-known commercial bank in Australia is interested in estimating the number of new bank accounts opened by customers each year. The number of new accounts opened in this bank has increased slowly over the years even during the global financial crisis (20082009). Top management strongly believes that they need a long-term strategic plan for the bank which is a 5-year forecast for the number of new accounts opened. To achieve this aim, the bank operations manager examined past account data and also extracted the employment rate over 30 years (1991-2020). The resulting data are shown in below table: No of new Year account(000) GDP Per Capita GDP Per No of new Capita (000A$) Year account(000) (000A$) 1991 3.336 18.8218 2006 6.207 36.04492 1992 3.609 18.57012 2007 6.026 40.96005 1993 4.003 17.63453 2008 8.466 49.60166 1994 7.107 18.04614 2009 7.528 42.77236 1995 2.686 20.31963 2010 9.470 52.02213 1996 4.843 21.86133 2011 11.719 62.51783 1997 3.111 23.4686 2012 11.635 68.01215 1998 2.753 21.31896 2013 9.558 68.15011 1999 4.622 20.53304 2014 10.618 62.51079 2000 3.913 21.67925 2015 10.759 56.75572 2001 4.148 19.49086 2016 7.528 49.97113 2002 3.647 20.08248 2017 9.204 54.02797 2003 4.207 23.44703 2018 8.759 57.35496 2004 4.271 30.43068 2019 8.776 55.0572 2005 6.866 33.99924 2020 8.835 51.81215 1. Using the following methods forecast for all possible periods. Provide the report with appropriate interpretations for each forecast and show the graph of actual and forecast (5 points) a. Moving average (n=3) (1 point) b. Exponential Smoothing (alpha = 0.6) (1 point) c. Linear trend (trend projection) (1 point) d. Linear regression (2 points) 2. Discuss which method fits best for the bank's strategic plan to forecast the number of new accounts. You need to justify the selection of one method over another (3 points). 3. Do you think that the exclusion of a part of data (for example, the first 5-10 years) would affect the accuracy of the forecast? Briefly explain. Would such exclusion change your choice of the forecasting method in Question 2? Briefly explain (2 points). Focus + 120% AutoSave Home Insert Draw Design Layout Times New... 11 ' ' Paste B I U ab x, A Page 2 of 2 W= Assignment 1 OMGT2199 2024A BD References Aa D A Po abca A Mailings Review View Tell me Comments Editing Share A T AaBbCcDdEe AaBbCcDdEe > Normal No Spacing Styles Pane Dictate Sensitivity Add-ins Editor Update from Project 2 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 1 18 T 465 words Vietnamese Task 1: Bank Account Forecast A well-known commercial bank in Australia is interested in estimating the number of new bank accounts opened by customers each year. The number of new accounts opened in this bank has increased slowly over the years even during the global financial crisis (20082009). Top management strongly believes that they need a long-term strategic plan for the bank which is a 5-year forecast for the number of new accounts opened. To achieve this aim, the bank operations manager examined past account data and also extracted the employment rate over 30 years (1991-2020). The resulting data are shown in below table: No of new Year account(000) GDP Per Capita GDP Per No of new Capita (000A$) Year account(000) (000A$) 1991 3.336 18.8218 2006 6.207 36.04492 1992 3.609 18.57012 2007 6.026 40.96005 1993 4.003 17.63453 2008 8.466 49.60166 1994 7.107 18.04614 2009 7.528 42.77236 1995 2.686 20.31963 2010 9.470 52.02213 1996 4.843 21.86133 2011 11.719 62.51783 1997 3.111 23.4686 2012 11.635 68.01215 1998 2.753 21.31896 2013 9.558 68.15011 1999 4.622 20.53304 2014 10.618 62.51079 2000 3.913 21.67925 2015 10.759 56.75572 2001 4.148 19.49086 2016 7.528 49.97113 2002 3.647 20.08248 2017 9.204 54.02797 2003 4.207 23.44703 2018 8.759 57.35496 2004 4.271 30.43068 2019 8.776 55.0572 2005 6.866 33.99924 2020 8.835 51.81215 1. Using the following methods forecast for all possible periods. Provide the report with appropriate interpretations for each forecast and show the graph of actual and forecast (5 points) a. Moving average (n=3) (1 point) b. Exponential Smoothing (alpha = 0.6) (1 point) c. Linear trend (trend projection) (1 point) d. Linear regression (2 points) 2. Discuss which method fits best for the bank's strategic plan to forecast the number of new accounts. You need to justify the selection of one method over another (3 points). 3. Do you think that the exclusion of a part of data (for example, the first 5-10 years) would affect the accuracy of the forecast? Briefly explain. Would such exclusion change your choice of the forecasting method in Question 2? Briefly explain (2 points). Focus + 120%
Expert Answer:
Posted Date:
Students also viewed these general management questions
-
How can students and logistics professionals cultivate good relations with Indigenous makers
-
Discuss which organizational structure (i.e. functional, product-market divisional, matrix) you would recommend Guelph General Hospital implement, assuming the hospital moves forward with the...
-
Explain how a policies and procedures manual guides the work of an agency's branch manager and all staff. The answer should explain: What is the purpose of the manual for staff? Why is a policies and...
-
Metlock Advertising Agency Inc. was founded in January 2000. Presented below are adjusted and unadjusted trial balances as at December 31, 2023 Cash Accounts receivable Supplies Prepaid insurance...
-
Consider the following information for Covolo Diving Gear: a. Calculate weighted planning values for machine hours and labor hours per gauge set. Interpret these planning values. b. Recalculate the...
-
Chen Group is in the process of adjusting and correcting its books at the end of 2022. In reviewing its records, the following information is compiled. 1. Chen has failed to accrue sales commissions...
-
Describe the global growth of stock markets.
-
At the advent of the social season, Aunt Lavinia purchased a hula skirt in Sadies dress shop. The salesclerk told her, This superior garment will do things for a person. Aunt Lavinias houseguest, her...
-
Mary From, single, owned rental real estate which generated a tax loss of $60,000. Mary materially participated in the rental activity. Mary's adjusted gross income before considering the $60,000...
-
What is a fact about quotations? Select a Choice Below current question choices OptionA They are also known as invoices. OptionB They are always considered to be legally binding offers. OptionC They...
-
Errors could occur on which of the following lines? 1 int x = 7; 2 int y &x; cout < < y < < endl; 4 cout < < y < < endl; 5 delete y;
-
Explain what farm-to-plate/table is to you. How does it positively affect our environment and economy? What do you do to try to be more farm-to-plate? Does a restaurant advertising Farm-to-plate draw...
-
You and your partner are assigned to investigate the disappearance of John Appling. Appling's roommate filed a missing person's report. The roommate was interviewed and provided the following...
-
Assume Gillette Corporation will pay an annual dividend of $0.68 one year from now. Analysts expect this dividend to grow at 12.8% per year thereafter until the 4th year. Thereafter, growth will...
-
Today, technology has changed everything. Individuals now buy drugs on the Internet and Tweet about their latest visit to the physician's office. They can rate their doctors on healthgrades.com. They...
-
Listed below are selected line items from the Cost of Quality (COO) report for Watson Products for last month: Category Amount $ 440 1,374 746 745 Rework Equipment maintenance Product testing Product...
-
Write an essay describing the differing approaches of nursing leaders and managers to issues in practice. To complete this assignment, do the following: 1. Select an issue from the following list:...
-
Search popular business magazines (Business Week, Fortune, Forbes) for an article that describes a dysfunctional behavior resulting from a poorly designed manager ial reporting and performance...
-
On the following Web sites you will find several online demonstrations for the SAP and Oracle ERP systems. Visit these Web sites ^nd explore their content by doing the following: a. The SAP Web site...
-
Shauna Washington started a business to sell art supplies and related curricula to home school families. The business grew quickly, with sales doubling three times during a five-year period. At that...
Study smarter with the SolutionInn App