Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please show working The table below shows the sales figures for a brand of shoe over the last 12 months. a. Using the following, forecast
please show working
The table below shows the sales figures for a brand of shoe over the last 12 months. a. Using the following, forecast the sales for the months up to January the following year:- i. A simple three month moving average. ii. A three period weighted moving average using weights of 1, 2 and 3. Assign the highest weight to the most recent data. iii. Exponential Smoothing when =.6 and the forecast for March is 350 . iv. Determine which of the three forecasting technique is the most accurate using MAD. b. The following table shows the number of televisions sold over the last ten years at a local electronic store. i. Using trend projection, develop a formula to predict sales for years 11 and 12. You have to show all working. You will need to develop a table to calculate the slope and the intercept. ii. Use that formula to forecast television sales for years 11 and 12
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