Determine the seasonality index by quarter

Assignment Help Business Management
Reference no: EM131637084

Assignment- Business Analysis

Forecast Modeling Exercise-Seasonal Index

The All You Can Eat Ice Cream Store believes there is seasonality to their sales. Below is their sales for the last 4 years measured in quarters. From the history, determine the sales projections for year 5.

Quarter               Sales
1            1            2100
              2            610
             3            1050
             4            1125
2            1            2850
             2            790
             3            1350
             4            1440
3            1            3600
             2            1000
             3            1675
             4            1750
4            1            4375
             2            1195
             3            2000
             4            2100

Answer the Questions below: (show your work in EXCEL)

1) Determine the Seasonality Index by Quarter

2) Project what the forecast number would have been for prior years and determine the accuracy of that forecast (BIAS, Absolute, Absolute %, Standard Error)

3) Project the forecast numbers for year 5

4) Does Sales appear to have a seasonality trend?

Reference no: EM131637084

Questions Cloud

Find the total number of aids-related deaths in the us : Find the total number of AIDS-related deaths in the United States between the beginning of 1988 and the end of 1996.
The president demand for further reforms : The president demand for further reforms, attended with the dislocation caused by the non-cooperation movement, led the British government to appoint.
What health issues and risks may be relevant to the child : Select one of the examples on which to focus for this Discussion. What health issues and risks may be relevant to the child you selected
The preamble says that the state in india will assure : The preamble says that the state in India will assure the dignity of the individual. The constitution seeks to achieve this object by guaranteeing.
Determine the seasonality index by quarter : Determine the Seasonality Index by Quarter. Project the forecast numbers for year 5. Does Sales appear to have a seasonality trend?
The goals of the social revolution : Aimed at furthering the goals of the social revolution or to foster this revolution by establishing the conditions necessary for its achievement"?
Find the approximate number of marijuana arrests in the city : Thousand/year, where t is measured in years, with t = 0 corresponding to the beginning of 1992. Find the approximate number of marijuana arrests in the city.
The specific characteristics of classical liberalism : The United States has utilized multiple forms of liberalism throughout its history. Please distinguish the specific characteristics of classical liberalism.
Discuss culture of safety : Based on the QSEN Competencies, identify interventions the RN can implement to promote a culture of safety across the continuum of patient care

Reviews

Write a Review

Business Management Questions & Answers

  Organization competitive advantage

Discuss and provide examples of best practices an organization can implement to leverage diversity in areas such as group management, recruiting, hiring, retention, and development practices to increase an organization's competitive advantage.

  Explain the operations of firm

Choose a perfectly competitive supplier or industry. Briefly explain the operations of this firm or the firms within the industry.

  Calculate the descriptive statistics of the data

Calculate the descriptive statistics of the datafor the years 2013/14, 2014/15 and 2015/16. Discuss the result and dispersion you would choose to best represent the data.

  Conduct several searches using any of the databases in us

Conduct several searches using any of the databases in the University Library. Write a complete summary of the information presented in each article.

  Motivation techniques and traditional techniques

Overall, what do you think the main advantages and disadvantages are of these new and unusual motivation techniques as compared to more traditional techniques

  Social media for business intelligence

How will organizations know what to look for when using social media for business intelligence?

  Is there anything they be able to do about it

Should Mary as well as the others accept the decision? Why or why not? Is there anything they be able to do about it? If yes, what?

  Taking turns ordered steps or a dancedo you see the

taking turns ordered steps or a dance?do you see the communication process working more like a turn-taking situation

  Locate four empirical studies that research change

Locate four empirical studies that research change. Give the APA-formatted citation and add the studies to your RefWorks list. What are the primary methodologies used in the four studies that you read?

  Ethical reflection and individual advancementyou have

ethical reflection and individual advancementyou have worked at this organization for over 10 years and feel totally

  Great britain uk stock market

How has the stock market in your reference country done over last five years? Based upon your analysis and findings, what would you recommend to other investors? Would you recommend other investors to spent in your references country's stock marke..

  Interview a health and wellness professional

You may locate one of these professionals by checking your local hospital, health clinic, doctor's offices, health department office, universities, or fitness facilities. Contact the individual through email or phone.  Introduce yourself and expla..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd