What is the forecast of the percentage of stocks

Assignment Help Operation Management

Reference no: EM13918568

The following table reports the percentage of stocks in a portfolio for nine quarters from 2007 to 2009:

Quarter 1st-2007	Stock % 29.8
2nd-2007	31.0
3rd-2007	29.9
4th-2007	30.1
1st-2008	32.2
2nd-2008	31.5
3rd-2008	32.0
4th-2008	31.9
1st-2009	30.0

a. Construct a time series plot. What type of pattern exists in the data?

b. Use exponential smoothing to forecast this time series. Using Excel Solver or LINGO find the value of athat minimizes the sum of squared error.

c. What is the forecast of the percentage of stocks in a typical portfolio for the second quarter of 2009?

Reference no: EM13918568

Questions Cloud

Gross income : The nonbusiness bad debt of $15,300 would have been reported as a short term capital loss. How much would be included in Monty's gross income?

Partnership between law enforcement and community : write a 1,050- to 1,750-word paper discussing policing practices and operations. Include an assessment of the following:

Heart of corporate finance : ________ is at the heart of corporate finance, because it is concerned with making the best choices about project selection.

Slope of the line through : 1. (i) What is the slope of the line through (-1, -2)and (x,y) for y = x2 + x - 2 when:

What is the forecast of the percentage of stocks : Construct a time series plot. What type of pattern exists in the data? What is the forecast of the percentage of stocks in a typical portfolio for the second quarter of 2009?

Calculate your total percentage return : You purchase 1,000 shares of Spears Grinders, Inc. stock for $45 per share. A year later, the stock pays a dividend of $1.25 per share, and it sells for $49. Calculate your total dollar return. Calculate your total percentage return.

A deduction from agi : Belinda's casualty loss deduction (after any limitations) is $ and is treated as a deduction from AGI

Nature of the business market : Which of the following statements regarding the nature of the business market is true?

How is the explosion of information technology : How is the explosion of information technology and the way in which its advances in global communications affect strategic operational management functions? Provide thoughts on executive decision support systems.

User Account

All Pages