Due to its strong performance and growth, Hillbilly Hiking Inc. has brought you on board as its firstmarketing manager. Youve come to realize that the owner makes the decisions by the seat of his pants. You want to bring a more systematic approach based upon data. The business is a hiking and camping supply store based in Cleveland, TN, and has been in operation for three years.

To better plan for future growth of the store, you will develop a system that allows you to forecast sales by month for up to one year in advance. The table below (and attached file) shows the value of store sales ($1000s) for the first three years of operation.

Store Sales for the Hillbilly Hiking ($1000s)

Perform an analysis of the sales data for Hillbilly Hiking, LLC. Prepare a report for the owner (Marc Gilbert) that summarizes your findings, forecasts, and recommendations in order to get him on board for your strategic shift. (Remember, he has been pretty successful with his approach.) Include the following:

4.Provide summary tables of your calculations and any graphs in the appendix of your report.

Second Third First Month Year Year Year January 56 80 67 February 83 58 71 March 71 87 103 April 74 87 105 May 82 104 118 June 118 97 141 July 93 133 111 August 87 61 72 September 44 55 63 October 52 59 74 November 61 75 87 December 94 107 128 Second Third First Month Year Year Year January 56 80 67 February 83 58 71 March 71 87 103 April 74 87 105 May 82 104 118 June 118 97 141 July 93 133 111 August 87 61 72 September 44 55 63 October 52 59 74 November 61 75 87 December 94 107 128