The trend and the seasonal index for each quarter

Assignment Help Financial Management

Reference no: EM131845404

ABC Corporation has given you the following information sales history.

Quarter Demand ____________ 2012 2013 2016

1 10 12 17

2 20 25 32

3 15 17 19

4 9 10 15

a) Plot the quarterly sales data for each year

b) What are the trend and the seasonal index for each quarter?

c) Assume exponential, trend and seasonal smoothing with α = 0.2, β = 0.3 and γ = 0.4. Forecast the demand for the 2nd and 3rd quarter of 2017.

If actual demand during the 1 quarter of 2017 is 50, find the updated seasonality index, level and trend for 1 quarter 2017 and forecast the second quarter of 2017.

Reference no: EM131845404

Questions Cloud

Match the yield to maturity to the terms of the bond : Match the yield to maturity to the terms of the bond. All of these bonds pay interest twice a year.

What are marx teleology of communism : What are Marx's teleology of communism and the role of the state. Also, the idea of base-superstructure interrelationship

Prepare a 3-sigma control chart for both production process : Prepare a 3-sigma control chart for both production processes, using the new and standard material .

What options are there for the us to diplomatically : What options are there for the U.S to diplomatically diffuse North Korea's nuclear arms? Is there a peaceful option?

The trend and the seasonal index for each quarter : Plot the quarterly sales data for each year. What are the trend and the seasonal index for each quarter?

Growing threat of north korea nuclear capabilities : How should the United States handle the growing threat of North Korea's nuclear capabilities?

Define aspects of compensation and benefits plan design : What are the most challenging aspects of compensation and benefits plan design for organizations doing business globally?

What was the most challenging aspect for your research : What was the most challenging aspect of using the Library for your research as opposed to Google or other Internet searches? List the pros and cons.

Advancement of technology : With the advancement of technology how has war today no longer restricted to air water and ground but also through a fourth element

User Account

All Pages