Can you please answer question #1 and #2 using excel? Sales Second Year MonthSales Third Year MonthSalesJanuary242January263January282February 235February238February 255March232March247March265April178April193April205May184May193May210June140June149June160July145July157July166August 152August 161August174September 110September 122September 126October 130October 130October 148November 152November 167November 173December 206December 230December 235First Year Month The Nine Roses Restaurant, in New Orleans, isowned and operated by Lana and Jeffrey Lee. Therestaurant just completed its third year ofoperations. Since opening Nine Roses, the Lees havesought to establish a reputation for the restaurantas a high-quality dining establishment thatspecializes in fresh seafood. Through the efforts ofLana and Jeffrey as well as their staff, Nine Roseshas become one of the best and fastest growingrestaurants in New Orleans.To better plan for future growth of the restaurant,Lana and Jeffrey needs to develop a system that willenable them to forecast food and beverage sales bymonth for up to one year in advance. The file "NineRoses" shows the value of food and beverage sales($1000s) for the first three years of operation.1. A time series plot. Comment on theunderlying pattern in the time series.2. An analysis of the seasonality of the data.Indicate the seasonal indices for each month,and comment on the high and low seasonalsales months. Do the seasonal indices makeintuitive sense? Discuss.

Time series analysis involves studying patterns in data and predicting future values based on past…

Answered: Can you please answer question #1 and…

Business

Operations Management

Can you please answer question #1 and #2 using excel?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

please answer all
Course dashboard Siemens Reduces Cost with the Use of Data Visualization swered Siemens is a German company headquartered in Berlin, Germany. It is one of the world's largest companies focusing on the areas of electrification, automation, and digitalization. It has an annual revenue of 76 billion euros. at of The visual analytics group of Siemens is tasked with end-to-end reporting solutions and consulting for all of Siemens internal BI needs. This group was facing the challenge of providing reporting solutions to the entire Siemens organization across different departments while maintaining a balance between governance and self- service capabilities. Siemens needed a platform that could analyze its multiple cases uestion of customer satisfaction surveys, logistic processes, and financial reporting. This platform should be easy to use for their employees so that they could use these data for analysis and decision making. In addition, the platform should be easily integrated with…
What are the advantages and disadvantages of using a manual guest check system to control revenue in nonautomated beverage operations?
The Porter’s Five Forces Model can help us understand why different firms in the same industry are more profitable than others Group of answer choices True False
Enhancing Customer Experience in E-Retailing ABC Electronics, a prominent e-retailer specializing in electronic gadgets and appliances, faces intensifying competition from traditional brick-and-mortar stores venturing into e-commerce and emerging startups in the market. As part of its strategic planning, ABC Electronics aims to elevate its customer experience to sustain its competitive advantage and foster customer loyalty. The company has noted a decline in customer satisfaction ratings and seeks to tackle the following key areas: Website Usability: Despite offering a diverse array of products, customers encounter challenges navigating the website and efficiently locating specific items. Customer Support: Complaints have arisen regarding prolonged response times from customer support representatives and a lack of personalized assistance during the purchasing journey. Delivery and Fulfillment: Instances of delays in product delivery and issues with order tracking have been…
Which type of lighting is preferred by photographers during outdoor portrait shoots?
The answer to the question is incorrect
list one example related to the use of statistics to improve a process.
Service Characteristics does not include Group of answer choices Intangibility Variability Perishability Separability
Evaluate how the quality of the guest experience can be affected by the role of Front Office operations and the implications this may have upon measuring service quality