Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question B (SK3: 5 Marks] A pharmaceutical company would like to make an accurate forecast about vitamins sales in 2022. Ten-year sales data Year 2012
Question B (SK3: 5 Marks] A pharmaceutical company would like to make an accurate forecast about vitamins sales in 2022. Ten-year sales data Year 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Sales (Smillions) 7.84 12.26 13.11 15.78 21.29 25.68 23.80 26.43 29.16 33.06 ? Using sales as the Y variable and time ( year) as the x variable, 1.Determine the slope and the intercept of the trend equation. 2 marks 2. Provide a forcast of the sales for the period 2015-2022 using the 3 year- mooving average method. 1 mark 3. Compute the accuracy measure MAPE for the nave and the 3-year mooving average. Conclude about which method to advise. 2 marks
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started