User Account

All Pages

Forecast the next four quarters

Assignment Help Business Economics
Reference no: EM133128515

The data in the table below are for retail sales in book stores by quarter. (c3p13)

U.S. Retail Book Sales (in Millions of Dollars, NSA)

Date

Sales

Mar-02

1,866

Jun-02

1,666

Sep-02

2,351

Dec-02

2,455

Mar-03

2,169

Jun-03

1,815

Sep-03

2,498

Dec-03

2,637

Mar-04

2,326

Jun-04

2,020

Sep-04

2,858

Dec-04

2,915

Mar-05

2,725

Jun-05

2,283

Sep-05

3,134

Dec-05

3,066

Mar-06

2,876

Jun-06

2,445

Sep-06

3,190

Dec-06

3,407

Mar-07

3,197

Jun-07

2,575

Sep-07

3,290

Dec-07

3,693

Mar-08

3,273

Jun-08

2,713

Sep-08

3,514

Dec-08

3,794

Mar-09

3,480

Jun-09

2,943

Sep-09

3,654

Dec-09

4,108

Mar-10

3,628

Jun-10

3,203

Sep-10

4,051

Dec-10

4,010

Mar-11

3,719

Jun-11

3,084

Sep-11

4,234

Dec-11

4,073

Mar-12

3,983

Jun-12

3,132

Sep-12

4,328

Dec-12

4,007

Mar-13

3,969

Jun-13

3,257

Sep-13

4,824

Dec-13

4,129

Mar-14

4,298

Jun-14

3,312

Sep-14

4,811

Dec-14

4,336

Mar-15

4,261

Jun-15

3,278

Sep-15

4,991

Dec-15

4,447

a. Plot these data and examine the plot. Does this view of the data suggest a particular smoothing model? Do the data appear to be seasonal? Explain.

b. Use an exponential smoothing method to forecast the next four quarters. Plot the actual and forecast values.

How do i do this in excel?The data in the table below are for retail sales in book stores by quarter. (c3p13)

U.S. Retail Book Sales (in Millions of Dollars, NSA)

Date

Sales

Mar-02

1,866

Jun-02

1,666

Sep-02

2,351

Dec-02

2,455

Mar-03

2,169

Jun-03

1,815

Sep-03

2,498

Dec-03

2,637

Mar-04

2,326

Jun-04

2,020

Sep-04

2,858

Dec-04

2,915

Mar-05

2,725

Jun-05

2,283

Sep-05

3,134

Dec-05

3,066

Mar-06

2,876

Jun-06

2,445

Sep-06

3,190

Dec-06

3,407

Mar-07

3,197

Jun-07

2,575

Sep-07

3,290

Dec-07

3,693

Mar-08

3,273

Jun-08

2,713

Sep-08

3,514

Dec-08

3,794

Mar-09

3,480

Jun-09

2,943

Sep-09

3,654

Dec-09

4,108

Mar-10

3,628

Jun-10

3,203

Sep-10

4,051

Dec-10

4,010

Mar-11

3,719

Jun-11

3,084

Sep-11

4,234

Dec-11

4,073

Mar-12

3,983

Jun-12

3,132

Sep-12

4,328

Dec-12

4,007

Mar-13

3,969

Jun-13

3,257

Sep-13

4,824

Dec-13

4,129

Mar-14

4,298

Jun-14

3,312

Sep-14

4,811

Dec-14

4,336

Mar-15

4,261

Jun-15

3,278

Sep-15

4,991

Dec-15

4,447

a. Plot these data and examine the plot. Does this view of the data suggest a particular smoothing model? Do the data appear to be seasonal? Explain.

b. Use an exponential smoothing method to forecast the next four quarters. Plot the actual and forecast values.

How do I do this in excel?

Reference no: EM133128515

Questions Cloud

Four equations of the harrod-domar model : Is on Aid and Growth: Filling the Gaps. I have a 2 part question that I need to respond to. This is in the context of the Savings Gap in the Harrod-Domar Model.
Prepare yin consolidated income statement for the year : During May of 2020, YANG sold a plot of Land to YIN for $40,000. Prepare YIN's Consolidated Income Statement for the Year ended June 30, 2020
What will happen to total revenue if price is decreased : If the demand for a product is inelastic, what will happen to total revenue if price is decreased? Explain this carefully. Provide your own numerical example to
Determine the depreciation rate : You are a hospital administrator and you have a very old CT Scan Machine. The cost of annual repairs and replacing worn out parts to keep the old machine runnin
Forecast the next four quarters : The data in the table below are for retail sales in book stores by quarter. (c3p13)
Analysing an accounting information system assessment : Articulate the various transaction cycles, financial reporting, management reporting systems, and e-commerce to technical and non- technical stakeholders
Analyze the positive versus normative arguments : Analyze the positive versus normative arguments in the following case. State two statements of positive economics used to support requiring air bags and two sta
What hall at the st louis worlds fair : What hall at the St. louis worlds fair? Describe what happened.
Return marr on the investment in the new equipment : Alpha Electronics can purchase a needed service for $90 per unit. The same service can be provided by equipment that costs $100,000 and that will have a salvage

Reviews

Write a Review

Business Economics Questions & Answers

  Demographic and an economic trend

Discuss a demographic and an economic trend related to China's power and its impact on marketers in your country. Support your discussion of these trends with statistics.

  What was taylors internal rate of return on this investment

In July of 2012, Taylor purchased 1,700 shares of XYZ common stock for $75,000. He then sold 1,000 shares of XYZ in July of 2013 for $37 per share. The remaining 700 shares were finally sold for $75.71 per share in July 2014.

  Tracking and analysis of realtime changes

You recently bought a mini-supercomputer for $10,000 to allow for tracking and analysis of realtime changes in stock and bond prices.

  Fixed cost-variable cost and average total cost

Patriots Inc. is a price-taking firm that produces Tricorns. Its short run cost function is c(y) = 5 + (y−3)3 30 . a) Derive the following functions for Patriots Inc.: i) fixed cost ii) variable cost iii) average total cost iv) average fixed cost 1 v..

  Re-construct a decision tree to capture the new conditions

Ambassador Automobiles (AA) is not sure of their order of 100 units to Diversitek (D). Based on the market research, there is only a 35% chance that AA purchases the order of 100 units of SS from D and a 65% chance that AA purchases the order of 50 u..

  Drug and cosmetic act-controlled substances act

Dewey Cheatham is the new Vice President of Marketing for a large online search engine company, Pottstown Innovative Enterprises (AKA, PIE). The shipment of prescription drugs from pharmacies outside the United States to customers in the United State..

  Demonstrate many of the strongpoints

Name some marketing techniques and styles that you have encountered that demonstrate many of the strongpoints we learned in this course.

  Why is there a social cost to monopoly power

Why is there a social cost to monopoly power? If the gains to producers from monopoly power could be redistributed to consumers, would the social cost of monopoly power be eliminated?

  Role of non-price competition within an oligopoly

Use the Keat and Young textbook as a basis for explaining the role of non-price competition within an oligopoly.

  Arguments for tariff protection--military self-sufficiency

"The potentially valid arguments for tariff protection--military self-sufficiency, infant industry protection, and diversification for stability--are also the most easily abused." Why are these arguments susceptible to abuse?

  What is the effect of this transaction

Suppose you receive $20 for your birthday and you deposit into your checking account. What is the effect of this transaction on M1 or M2? Explain.

  Indicate whether each of is counted in year GDP

Indicate whether each of the following is counted in this year’s GDP: You bought a new Wii at GameStop last year and resold it on eBay this year. You purchase an “Investing for Dummies” book at Barnes and Noble. Your physical therapist receives $300 ..

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