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

Taryn would like to open a new business as an interior designer, to funds her ambition she sold some of thefollowing assets:1. Antique Painting that was given to Taryn by her father 5 years ago. Taryn’s father bought it on 20 August1984 for $2,500. Taryn sold it on 1’st June 2020 for $25,0002. Taryn sold her car (Toyota Corolla) for the amount of $12,000 on 20’th May 2020, she bought on 1’stJanuary 2015 for the amount of $20,0003. Taryn sold her Harry Potter’s collection for the amount of $1,500 on 4’th January 2020, she bought itsecond hand on 10’th October 2018 for $350.4. Taryn sold her gold necklace for $2,000 on 20’th March 2020, she bought it for $1,200 on 8’th August20185. Taryn sold a sculpture for $6,000 on 1 January 2020, she bought it on December 1994Advise the Capital Gain Tax Consequences
Nature cosmetics is a new business in Nizwa, which manufactures cosmetic products using organic raw materials. Salma is the owner of the business and she proudly says, all their products are made from natural and organic raw materials and won’t have any side effects on skin and hair. In SWOT analysis, this will come under a. Opportunities of business b. Threats of the business c. weakness of business d. Strengths of business
2. Chapter 5--Assume you are hired as a consultant for Cinnabon. You are asked to consider a SWOT model to determine their strengths and weaknesses. Using the Course Outcome 4.1 decide and objectively recommend next steps for Cinnabon
8.__________As a process of self-examination during her senior year of college, Sara decides to develop a SWOT analysis of her prospects relative to getting a job.2. Sara realizes that she has a personal characteristic that suggests she is not comfortable interacting with strangers. She interprets this as a(n) ___________ if she is to get a job as a salesperson. alternative strength weakness opportunity B only
Identify Netflix’s current pestle analysis?
Mishap has a gross income of $43,360. She owns a condominium and donates to charity, but there's no way her tax deductible expenses come close to the standard deduction of $12,000. During a cold snap in the winter she donates an extra $500 to the local homeless shelter, a registered charity. How much will this donation save her on her taxes?
Read the following case and answer questions that follow.Jill Kearns was in her first year of college, and was running low on money. She needed to makeat least $500 to cover her expenses. She considered getting a full-time job, but realized that shedid not have enough time to do her studies and keep the job. Her solution was to start a smallbusiness venture with the members of a jazz band to which she belonged. They would hold jazzconcerts and sell tickets to Jill's performances.Jill's idea for this venture came from her and a friend's interest in jazz. As the popularity of jazzhas grown, she would have seen the potential for a business venture expanding. The idea of usingher interest in music to earn the money was very appealing. Currently, the group members have$500 in the bank. In order to give a concert, Jill anticipated that they would have the followingstart-up expenses: an advertising cost of printing posters, rent on a concert hall, cost of printingtickets, and incidental…
Read the following case and answer questions that follow.Jill Kearns was in her first year of college, and was running low on money. She needed to makeat least $500 to cover her expenses. She considered getting a full-time job, but realized that shedid not have enough time to do her studies and keep the job. Her solution was to start a smallbusiness venture with the members of a jazz band to which she belonged. They would hold jazzconcerts and sell tickets to Jill's performances.Jill's idea for this venture came from her and a friend's interest in jazz. As the popularity of jazzhas grown, she would have seen the potential for a business venture expanding. The idea of usingher interest in music to earn the money was very appealing. Currently, the group members have$500 in the bank. In order to give a concert, Jill anticipated that they would have the followingstart-up expenses: an advertising cost of printing posters, rent on a concert hall, cost of printingtickets, and incidental…
SMITHFIELD'S CUSTOM FURNITURE: It is 1901. Alicia Smithfield, daughter of the founder of Smithfield Custom Furniture, just inherited the company. She is the only surviving heir to the furniture empire her father built. Headquartered in upstate New York, the company has grown significantly over the past 60 years. Began in a shed built next to his log cabin, Jonas Smithfield's quality furniture developed a huge following among New York City's wealthiest residents. After being educated in the best business schools in Europe and America, Alicia has run the business side-by-side with her father for the past 15 years. When there were many issues confronting the business, a tree being felled took an unexpected route and brought Jonas' life to a surprising end. The company had just moved to a facility large enough to house its workers: 10 carpenters; 5 furniture designers; 5 wood finishers (varnish and dye experts); 10 machine operators to assist with the various equipment needed to cut the…
SMITHFIELD'S CUSTOM FURNITURE It is 1901. Alicia Smithfield, daughter of the founder of Smithfield Custom Furniture, just inherited the company. She is the only surviving heir to the furniture empire her father built. Headquartered in upstate New York, the company has grown significantly over the past 60 years. Began in a shed built next to his log cabin, Jonas Smithfield's quality furniture developed a huge following among New York City's wealthiest residents. After being educated in the best business schools in Europe and America, Alicia has run the business side-by-side with her father for the past 15 years. When there were many issues confronting the business, a tree being felled took an unexpected route and brought Jonas' life to a surprising end. The company had just moved to a facility large enough to house its workers: 10 carpenters; 5 furniture designers; 5 wood finishers (varnish and dye experts); 10 machine operators to assist with the various equipment needed to cut the…
SMITHFIELD'S CUSTOM FURNITURE: It is 1901. Alicia Smithfield, daughter of the founder of Smithfield Custom Furniture, just inherited the company. She is the only surviving heir to the furniture empire her father built. Headquartered in upstate New York, the company has grown significantly over the past 60 years. Began in a shed built next to his log cabin, Jonas Smithfield's quality furniture developed a huge following among New York City's wealthiest residents. After being educated in the best business schools in Europe and America, Alicia has run the business side-by-side with her father for the past 15 years. When there were many issues confronting the business, a tree being felled took an unexpected route and brought Jonas' life to a surprising end. The company had just moved to a facility large enough to house its workers: 10 carpenters; 5 furniture designers; 5 wood finishers (varnish and dye experts); 10 machine operators to assist with the various equipment needed to cut the…
SMITHFIELD'S CUSTOM FURNITURE: It is 1901. Alicia Smithfield, daughter of the founder of Smithfield Custom Furniture, just inherited the company. She is the only surviving heir to the furniture empire her father built. Headquartered in upstate New York, the company has grown significantly over the past 60 years. Began in a shed built next to his log cabin, Jonas Smithfield's quality furniture developed a huge following among New York City's wealthiest residents. After being educated in the best business schools in Europe and America, Alicia has run the business side-by-side with her father for the past 15 years. When there were many issues confronting the business, a tree being felled took an unexpected route and brought Jonas' life to a surprising end. The company had just moved to a facility large enough to house its workers: 10 carpenters; 5 furniture designers; 5 wood finishers (varnish and dye experts); 10 machine operators to assist with the various equipment needed to cut the…