Read, understand and solve each item carefully. Use Microsoft Excel as a tool and properly label your answer. Submit a softcopy of your answer following the format: surname_section_EA6a.

The Vintage Restaurant, on Captiva Island near Fort Myers, Florida, is owned and operated by Karen Payne. The restaurant just completed its third year of operation. During that time, Karen sought to establish a reputation for the restaurant as a high-quality dining establishment that specializes in fresh seafood. Through the efforts of Karen and her staff, her restaurant has become one of the best and fastest-growing restaurants on the island. To better plan for future growth of the restaurant, Karen needs to develop a system that will enable her to forecast food and beverage sales by month for up to one year in advance. The following table shows the value of food and beverage sales ($1,000s) for the first three years of operation:

First Second Third First Second Third Month Year Year Year Month Year Year Year January 247 268 287 July 145 157 166 February 235 238 255 August 152 161 174 March 237 252 270 September 110 122 126 April 178 193 205 October 130 130 148 May 184 193 210 November 157 172 178 June 135 144 155 December 206 230 235