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

  Economics assignment

This document contains various important questions and their appropriate answers in the subject field of Economics.

  Demand and supply curves

Economics is the study of the principles governing the allocation of scarce means among competing ends when the objective of the allocation is to maximize the attainment of the ends.

  Long-run perfectly competitive equilibrium for the firm

Evaluate Government intervene and correct this situation?(a) Explain the concept of a concentration ratio. A rise in the price of magarine Explain the impact of external costs and external benefits on resource allocation long-run perfectly c..

  Supply and demand diagrams

Explain each of the following using supply and demand diagrams,  With the use of a graph, explain how these two programs affect cigarette consumption and the price of cigarettes.

  Case study: fisher-price toys

The case study of the Fisher-Price Toys, Inc., a popular case in basic economics and management from the prestigious Harvard Business School.

  Draw the production possibility curve

Draw the production possibility curve and a. Define consumer surplus and producer surplus.

  Tax revenue

The Australian government administers two programs that affect the market for cigarettes

  Maximize total welfare

How many tickets to sell to maximize total welfare.

  Difference between the cv and the ev

The change in consumer surplus (?CS) is not "theoretically" justifiable like the CV and EV but it continues to be the most widely used measure of consumer welfare change. Explain how this can be reconciled

  Depict von neumann-morgenstern utility index u in a diagram

Depict the von Neumann-Morgenstern utility index u in a diagram

  What is the market solution

What is the market solution (market price and quantity) and What is the total surplus of the society under the market solution

  Calculate gross national product and net national product

Calculate gross national product and net national product

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