Question: 3. a) Using the data given in Question 2, forecast the sales of NationalTires tire repair product for the month 11 using linear trend projection

3. a) Using the data given in Question 2, forecast the sales of NationalTires tire repair product for the month 11 using linear trend projection forecast using the least squares method.

b) What is the resulting MAE, MSE and MAPE values?

c) Compare moving average forecast with trend projection forecast. Which method is better? Why?

(ANSWER QUESTION 3 ONLY)

(QUESTION 2 DETAILS GIVEN BELOW)

The sale of NationalTires tire repair product for the past 10 months is as shown below. If NationalTire uses 3- month moving average to forecast sales:

Month 1 2 3 4 5 6 7 8 9 10

Sales 175 178 179 178 179 181 183 190 195 194

a) What are the forecasts for months 4-11?

b) What is the resulting MAE, MSE and MAPE values?

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!

3. a) Using the data given in Question 2, forecast the sales of NationalTires tire repair product for the month 11 using linear trend projection forecast using the least squares method. b) What is...

below are the details and need answer for top three a/b/c a) Using the data given in Question 2, forecast the sales of NationalTire's tire repair product for the month 11 using linear trend...

a) Using the data given in Question 2, forecast the sales of HomeMarts asphalt repair product for the month 11 using linear trend projection forecast using the least squares method. b) What is the...

The sale of EpoxyShields asphalt repair product for the past 10 months is as shown below. If EpoxyShield uses 3- month moving average to forecast sales: Month 1 2 3 4 5 6 7 8 9 10 Sales 305 315 320...

want answer for 3 and the data is given in other picture a) Using the data given in Question 2, forecast the sales of HomeMart's asphalt repair product for the month 11 using linear trend projection...

The sale of EpoxyShield's asphalt repair product for the past 10 months is as shown below. If EpoxyShield uses 3- month moving average to forecast sales: Month 1 2 3 4 5 6 7 9 10 Sales 305 315 320...

Please show your work. A B C D E F G H J K L M N o F 1 Q1: 2 An important task in performing business valuations is normalizing the historical financial statements. (a). Using the information...

Chapter 4 Internet Homework Problems 4.50 Registration numbers for an accounting seminar over the past 10 weeks are shown below: Week 1 2 3 4 5 6 7 8 9 10 22 Registrations 21 25 27 35 29 33 37 41 37...

If a good brokerage forecasts that a stock is likely to rise, many investors tend to buy that stock and there could be a substantial increase in demand for that stock because of the forecast. Look at...

19 Name: ____________________________________ 1. Your friend has a credit card with an APR of 49.9% ! What would his finance charge be on a $500 charge for just 1 month? 2. Your friend has 2 credit...

An analyst at a local bank wonders if the age distribution of customers coming for service at his branch in town is the same as at the branch located near the mall. He selects 100 transactions at...

A population consists of the following five values: 2, 2, 4, 4, and 8. a. List all samples of size 2, and compute the mean of each sample. b. Compute the mean of the distribution of sample means and...

Jazz Corporation owns 5 0 percent of the Vanderbilt Corporation stock. Vanderbilt distributed a $ 1 0 , 0 0 0 dividend to Jazz Corporation. Jazz Corporation's taxable income before the dividend was $...

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...