Obtain the linear trend equation. Forecast the seasonally adjusted sales for 2014.

Question

Want to see the full answer?

Answer 1

Question

Chapter 18, Problem 14E

To determine

Obtain the linear trend equation.

Forecast the seasonally adjusted sales for 2014.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Create a 2-D line chart of Cash Sales for months 1-18. Add a trend line with a forward forecast of 3 periods to the chart. Be sure to include the R-squared value on the chart. Using =TREND(), complete the forecast table for months 19-21 1 $ 2,145,600 19 2 $ 2,175,200 20 3 $ 2,255,200 21 4 $ 2,505,600 5 $ 2,748,800 6 $ 2,358,000 7 $ 3,165,200 8 $ 3,253,600 9 $ 3,484,000 10 $ 3,731,200 11 $ 3,741,200 12 $ 3,558,800 13 $ 3,771,200 14 $ 3,787,600 15 $ 3,813,600 16 $ 3,822,800 17 $ 3,828,000 18 $ 3,897,200

The analysis of Earnings Per Share (EPS) is as follows: 2015: $5.70 2016: $3.30 2017: $6.21 2018: $6.20 2019: $4.91 a. What is the trend analysis for that EPS and why it is increasing and decreasing?

In Colorado, sales of medical marijuana began in November 2012; however, the Department of Revenue did not report tax collection data until February of 2014. The accompanying data file includes monthly revenue from medical and retail marijuana tax and fee collections as posted in the Colorado state accounting system. Use the linear trend model (no seasonality) to forecast the tax revenue for November and December of 2018. Date Revenue February/14 3,519,756 March/14 4,092,575 April/14 4,980,992 May/14 5,273,355 June/14 5,715,707 July/14 6,522,085 August/14 7,407,450 September/14 7,741,167 October/14 7,232,870 November/14 7,642,800 December/14 7,465,568 January/15 8,558,141 February/15 8,802,295 March/15 9,099,395 April/15 9,979,643 May/15 10,617,311 June/15 11,326,452 July/15 10,856,584 August/15 12,811,437 September/15 13,181,758 October/15 11,656,736 November/15 11,290,012 December/15 12,231,410 January/16 13,247,434 February/16…