The company 'Investment4u' also wants to forecast how many contacts from clients there will be in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The company 'Investment4u' also wants to forecast how many contacts from clients there will be in January in order to decide how many financial advisors they should have available. They aim to provide excellent service to all the clients. For this reason, they have collected the weekly number of client contacts in the last three months of year 2021 and reported it in Table 2: Table 2: Number of client contacts Month Week No of client contacts October 1 2 3 4 November 1 2 4 December 1 2 3 301 295 340 370 312 296 376 397 335 298 409 433 Questions B.1 Use an appropriate moving average to identify the trend for number of client contacts. Plot the trend on a time-series graph, along with the actual data. Present this chart in your Word document along with comments on the trend. [15 marks] B.2 Use the additive model and the multiplicative model to calculate the seasonal indices and then the predicted number of client contacts. Present the two forecasts along with the actual data in a table in your Word document. Decide which model is the most appropriate and give justification for your decision in the Word document. [25 marks] B.3 Use the model chosen in question B.2 to forecast the number of client contacts for January (assume 4 weeks). Present the forecast for each week in January in a table in your Word document. [10 marks] B.4 There are many other models used for forecasting. Choose one method discussed in the literature and explain the benefits of your chosen method. Please remember to paraphrase, i.e. do not copy exactly from your sources. The company 'Investment4u' also wants to forecast how many contacts from clients there will be in January in order to decide how many financial advisors they should have available. They aim to provide excellent service to all the clients. For this reason, they have collected the weekly number of client contacts in the last three months of year 2021 and reported it in Table 2: Table 2: Number of client contacts Month Week No of client contacts October 1 2 3 4 November 1 2 4 December 1 2 3 301 295 340 370 312 296 376 397 335 298 409 433 Questions B.1 Use an appropriate moving average to identify the trend for number of client contacts. Plot the trend on a time-series graph, along with the actual data. Present this chart in your Word document along with comments on the trend. [15 marks] B.2 Use the additive model and the multiplicative model to calculate the seasonal indices and then the predicted number of client contacts. Present the two forecasts along with the actual data in a table in your Word document. Decide which model is the most appropriate and give justification for your decision in the Word document. [25 marks] B.3 Use the model chosen in question B.2 to forecast the number of client contacts for January (assume 4 weeks). Present the forecast for each week in January in a table in your Word document. [10 marks] B.4 There are many other models used for forecasting. Choose one method discussed in the literature and explain the benefits of your chosen method. Please remember to paraphrase, i.e. do not copy exactly from your sources.
Expert Answer:
Answer rating: 100% (QA)
B1 To identify the trend for the number of client contacts we can use a 4week moving average The 4week moving average is calculated by taking the average of the client contacts for the current week an... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Suppose that a September put option with a strike price of $130 costs $12.0. Under what circumstances will the holder of the option earn a profit? Let S equal the price of the underlying. S < 130...
-
Use additive models to forecast values for the time series in Problems 10.8 and 10.9.
-
a. Construct a time series graph for the years 2004 to 2007 showing the number of vehicles manufactured by each automotive company. Show the time series for all four manufacturers on the same graph....
-
Write a function my_ieee_2_dec(ieee), where icce is a string contains 64 char- acters of ones and zeros representing a 64-bit IEEE754 number. The output should be d, the equivalent decimal...
-
What risks does going global offer a small business owner?
-
Suppose, on December 31, 2017, when the market interest rate is 6 percent, an investor purchases $5,000,000 of Belmont Products Inc.'s six-year, 5.5 percent bonds at issuance for $4,873,675. Interest...
-
Two new product designs are to be compared on the basis of revenue potential. Marketing believes that the revenue from design A can be predicted quite accurately to be \(\$ 3\) million. The revenue...
-
Here are two useful rules of thumb. The Rule of 72 says that with discrete compounding the time it takes for an investment to double in value is roughly 72/interest rate (in percent). The Rule of 69...
-
Consider the following data set and the piecewise cubic function {(0,0), (1, 1), (2,5)}, - C(x): = { x+(181)x(x-1) + (81 +82 2)x2(x 1) - if x [0,1] 1+4(x-1)+(482) (x-1)(x-2)+ (82 + 83 - 8)(x-1)2(x-2)...
-
There is a parcel of land next to the Playful Paws, Inc. building. Ellen, the owner of this property, approached John to discuss the idea of selling it to him. John is interested. Ellen knows that...
-
Two moles of air in a piston-cylinder system undergo an isobaric transformation at 2 MPa that bring their volume from 0.1 m to 0.5m. Find the change of entropy of air during the transformation....
-
What is the critical variable in Altman's Z-score for iABC Ltd? What is underlying this variable? Justify your answer.
-
GDZ, a Norwegian firm, has systematic risk of 0.95 when measured against the MSCI World Market Index. Its systematic risk is 1.15 when measured against the Norwegian stock index. The expected returns...
-
Describe the sector/ industry in which Pfizer operates ? How is this sector/industry organized? What is happening within this pharmaceutical Industry? What opportunities and threats exist that Pfizer...
-
Define and discuss in detail the five functions performed by financial intermediaries with examples of each function.
-
Warner Tool Company President Dr. John Robinson wants to know the breakeven point in sales dollars for his company. The following is the partial Income Statement for the company: Sales Variable...
-
What does the custom Defined Field Filter allow you to do ? Custom fields to be added into invoices, bills, purchase orders and paychecks A report to be run for a specific value in the Custom defined...
-
The slopes of the tangents at the points where the curve y = x2 - 4x intersects the X-axis is 1) 1 2) +2 3) +3 4) +4
-
Consider that you are preparing to sell some antique items at auction. How might you design the auction so as to receive the highest possible sale price? What sorts of behavioral anomalies will be...
-
Consider two gambles, each with outcomes $10, $20, $30, and $40. Gamble 1 has probabilities for these outcomes and gamble 2 has probabilities and. Suppose that Gamble 2 stochastically dominates...
-
In this chapter, brief mention was made of the false consensus as a form of the availability heuristic. Consider an entrepreneur who has developed a product that she finds very useful in her own...
-
What is the activity in \(\mathrm{Bq}\) and in \(\mathrm{Ci}\) of a \(2.0 \mathrm{mg}\) sample of \({ }^{3} \mathrm{H}\) ?
-
The activity of a sample of the cesium isotope \({ }^{137} \mathrm{Cs}\) is \(2.0 \times 10^{8} \mathrm{~Bq}\). Many years later, after the sample has fully decayed, how many beta particles will have...
-
The technique known as potassiumargon dating is used to date volcanic rock and ash, and thus establish dates for nearby fossils, like this 1.8 -millionyear-old hominid skull. The potassium isotope...
Study smarter with the SolutionInn App