Question: please solve the question without using excel (a) Table 2.1 presents the sales data for Company Excellent from 2012 to 2020. Year 2012 2013 2014

please solve the question without using excel

(a) Table 2.1 presents the sales data for Company Excellent from 2012 to 2020. Year 2012 2013 2014 2015 2016 2017 2018 2019 2020 Table 2.1 Sales (RM million) 10 14 18 20 22 24 26 28 32 (i) Find the forecast values of the sales from 2015 to 2020 by using simple moving average. (3 marks) Find the forecast values of the sales from 2015 to 2020 by using moving average of 2, MA(2) (3 marks) (iii) Compute Mean Square Error (MSE) for each forecasting method in parts (i) & (ii) above. Show all the relevant calculations. (4 marks) (iv) Forecast the sales for year 2021 using the best technique from part (iii)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

QUESTION: With reference to the article in question, critically assess the impact and potential impact of the ongoing Russia-Ukraine conflict on the economies of developing countries like Jamaica....

Zoom able COM Collaborate Pages The data below shows the annual net income (profit) of Facebook (in $ millions) since 2012 Backg Year 2012 2013 2014 2015 2016 2017 2018 Net Income 53 1,500 2,940...

What are the amounts and timing of the follow-up expansion investment opportunity's free cash flow from 2013 through 2022? What is the terminal value of the follow-up acquisition, as of 2022? What is...

Hi. Thanks for your help on the previous questions. This attached file was the first question that i didn't send. I was wondering if the npv and ire that you calculated can be reproduced in this...

Presented with qualitative and quantitative information regarding two projects, Match My Doll Clothing and Design Your Own Doll. A supplemental worksheet has been provide by your finance department...

MIDDLE EAST AND NORTH AFRICA Share how your country is doing ? X KUWAIT Score Score changes 2012 - 2023 46/100 What does the CPI score mean? 51 Rank Score change 48 45 63/180 1 +4 since 2022 42 39...

30 -20 % TOT. RETURN 3/21 THIS VLANITH STOCK INDEX 1.y. 62.0 99,7 3yt. 100.1 51.6 Syr. 128.6 100.0 2019 2020 2021 2022 VALUE LINE PUB. LLC 24-26 24.95 24.01 27.45 31.10 Sales per sh A 41.85 9.25 3.02...

WhatarethecashpaymentsassociatedwiththeSleepingBeauties?Whogetshowmuchandwhen,per$100ofbondsissued?Considerthefollowingdates:theissuedate,thedateofthefirst,second,etc.interestpayments,thematuritydate....

Chapter 11 Financial Planning Exercise 1 Calculate amount to invest to meet objectives APPLE INC. NDG-AAPL 212 NOX Prot 1125 1475 888 PE DVD VALUE PRICE Media 130 PERATO YLD LINE TIMELINESS 2 weed...

Can you get my NOPLAT to match the NOPLAT under reconciliation with net income? I don't know what the problem is. Thank you. Also explain what you did. (In millions, except par value data) March 31,...

Assume that you recently graduated and landed a job as a financial planner with Cicero Services, an investment advisory company. The Client presently owns a bond portfolio with $1 million invested in...

Do you think that there are exceptions to the nine requirements quality criteria? If so, explain under what circumstances and why.

1 . Which of the following is NOT a completed gift? Group of answer choices Sara pays her son's mortgage of $ 3 , 0 0 0 for 1 2 months John transfers ownership of his vacation home to his 3 sons...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...