User Account

All Pages

Compute the quarterly forecasts for next year

Assignment Help Finance Basics
Reference no: EM131668712

Qusetion: The quarterly sales data (number of copies sold) for a college textbook over the past three years follow:

1740_39.png

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

b. Use a regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 5 1 if quarter 1, 0 otherwise; Qtr2 5 1 if quarter 2, 0 otherwise; Qtr3 5 1 if quarter 3, 0 otherwise.

c. Based on the model you developed in part b, compute the quarterly forecasts for next year.

d. Let t 5 1 to refer to the observation in quarter 1 of year 1; t 5 2 to refer to the observation in quarter 2 of year 1; and t 5 12 to refer to the observation in quarter 4 of year 3. Using the dummy variables defined in part b and t, develop an equation to account for seasonal effects and any linear trend in the time series.

e. Based upon the seasonal effects in the data and linear trend, compute the quarterly forecasts for next year.

f. Is the model you developed in part b or the model you developed in part d more effective? Justify your answer.

Reference no: EM131668712

Questions Cloud

Calculate the efficiency of each pump : Determine the nature of the relationship between variables - Determine the operating point for this pump with system - Calculate the efficiency of each pump
Find total volume by each zone and by each product : The SUMIF looks for matches of "Malaysia" in column A and, if a match is found, adds the volume to the total. Use the SUMIF function to get total volume.
Identify three potential dam sites along any of water ways : Identify three potential dam sites along any of the water ways found within the map for a dam of approximately 200m x 100m x 5m.
Discuss the transportation model in the file williamson : Consider the transportation model in the file Williamson, which is very similar to the Foster Generators model discussed in the chapter.
Compute the quarterly forecasts for next year : Based upon the seasonal effects in the data and linear trend, compute the quarterly forecasts for next year.
What else do you think we have learned from the holocaust : The tragedy reminds us that those who practice religion are definitely prone to persecution. Perhaps even severe persecution.
International marketer who is introducing a new product : Which do you think is more important for an international marketer who is introducing a new product: a push strategy or a pull strategy? Why?
Determine their investment plan for the year : It is January 2nd. Senior management of Digby meets to determine their investment plan for the year.
Develop an equation to account for seasonal effects : Using the dummy variables defined in part b and ts, develop an equation to account for seasonal effects and any linear trend in the time series.

Reviews

Write a Review

Finance Basics Questions & Answers

  Weighted average cost of capital

What weight should be given to the debt when Acme, Inc. computes their weighted average cost of capital?

  What is the future value of contribution

The next payment will be made exactly one year from today. The hitter will play for 10.00 more seasons and expects to hit 35.00 homeruns per year. If the charity can earn 6.00% for this investment, what is the future value of his contribution?

  Explain scenario analysis and any problems

Explain scenario analysis and any problems, issues, or concerns that surround this type of projection. Define simulation analysis, and discuss its principal advantages and disadvantages.

  What are the 30 equal annual payments

If you buy a factory for $250,000 and terms are 20 percent down,the balance to be paid off over 30 years at a 12% rate of intereston the unpaid balance. What are the 30 equal annual payments?

  Explain the exchange rate system

Explain the exchange rate system that existed during the 1950s and 1960s. How did the Smithsonian Agreement in 1971 revise it?

  Are compensation consultants suf?ciently independent

Are compensation consultants suf?ciently independent? Does the current empirical evidence show that the use of consultants leads to excess CEO pay and/or poorly designed pay packages?

  What does an net present value of zero imply

What does an net present value of zero imply?

  What will her monthly house payments

1. An investor wants to save for 5 years for a down payment on a house. She deposits $200 per month into her savings account paying 7% compound monthly. At the end of the 5 years, she places the balance of the savings account as a down payment on a h..

  What semiannual rate of return did an investor make

What semiannual rate of return did an investor make who purchased a $5000 bond 4 years ago and held it until it was called 4 years later?

  Compound interest

Old Time Savings Bank pays 4% interest on its savings accounts. If you deposit $1,000 in the bank and leave it there, how much interest will you earn in 1st year?

  Find the interest rate

A loan with a quarterly payment of $1,500 has an unpaid balance of $10,000 after 27 quarters and an unpaid balance of $9,000 after 28 quarters.

  What is the alpha of john s stock

"John purchased a stock that has a beta of 1.2, a standard deviation of 13%, and returned 16% this year. The market s return was 12% with a standard deviation of 14%. If the risk free rate of return is 3%, what is the alpha of John s stock?"

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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