A vintage restaurant on captiva island near fort

Assignment Help Accounting Basics

Reference no: EM13611324

A Vintage Restaurant, on Captiva Island near Fort Myers,Florida, is owned and operated by Karen Payne. The restaurant justcompleted its third year of operation. During that time, Karensought to establish a reputation for the restaurant as ahigh-quality dining establishment that specializes in freshseafood. Through the efforts of Karen and her staff, herrestaurant has become one of the best and fastest-growingrestaurants on the island.

Karen believes that to plan for the growth of the restaurantin the future, she needs to develop a system that will enable herto forecast food and beverage sales by month for up to one year inadvance. Karen compiled the following data (in thousands ofdollars) on total food and beverage sales for the threee years ofoperation.

Month 1styear 2ndyear 3rdyear
January 242 263 282
February 235 238 255
March 232 247 265
April 178 193 205
May 184 193 210
June 140 149 160
July 145 157 166
August 152 161 174
September 110 122 126
October 130 130 148
November 152 167 173
December 206 230 235
Managerial Report

Perform an analysis of the sales data for the VintageRestaurant. Prepare a report for Karen that summarizes yourfindings, forecasts, and recommendations. Include thefollowing:

1. A graph of the time series.
2. An analysis of the seasonality of the data. Indicate theseasonal indexes for each month and comment on the high and lowseasonal sales months. Do the seasonal indexes make intuitivesense? Discuss.
3. A forecast of sales for January through December of thefourth year.
4. Recommendations as to when the system that you developshould be updated to account for new sales data.
5. Any detailed calculations of your analysis in the appendizof your report.
Assume that January sales for the fourth year turn out to be$295,000. What was your forecast error? If this error is large,Karen may be puzzled about the difference between your forecast andthe actual sales value. What can you do to resolve her uncertaintyin the forecasting procedure?

Reference no: EM13611324

Questions Cloud

Determine the vertical component of the reaction at the : the compound beam is fixed at a and supported by a rocker at b and c. there are hinges pins at d and e. take f 14kn.

Sillyfoot4489 answer rating percentage70 - 5h 41m left to : sillyfoot4489 answer rating percentage70 - 5h 41m left to answer determine the gross matgin for pacific states.

The drum rolls without slipping on the surface of the : a drum rools on a conveyor with is moving at a constant velocity of 3fts. the drum rolls without slipping on the

Bixbys fiscal year runs from january 1 to december 31 : the following selected data were taken from the records of the bixby box company the company uses a job costing system

A vintage restaurant on captiva island near fort : a vintage restaurant on captiva island near fort myersflorida is owned and operated by karen payne. the restaurant

Calculate the distance that the person needs to walk to get : during a simple orienteering exercise a person walks 250 m south then 620 m at an angle of 30 north of east and finally

The mean income per person in the united states is 37500 : the mean income per person in the united states is 37500 and the distribution of incomes follows a normal distribution.

In october 2009 ace consulting performed services for a : in october 2009 ace consulting performed services for a customer for 18000 on account. on july 31 2010 after several

Identify the null hypothesis ho and the alternative : identify the null hypothesis ho and the alternative hypothesis h1. a cereal company claims that the mean weight of the

User Account

All Pages