Question: Using the data provided create a Seasonally Adjusted Forecast for the upcoming year. You estimate that the annual profit for the upcoming year will be

Using the data provided create a Seasonally Adjusted Forecast for the upcoming year. You estimate that the annual profit for the upcoming year will be $210,000. Use your answers for the next four questions.

Month

Year1

Year2

Year3

Year4

January

$11,325

$15,137

$10,729

$11,708

February

$14,615

$14,808

$13,261

$14,196

March

$13,545

$16,287

$13,906

$16,893

April

$15,495

$16,108

$18,491

$17,326

May

$18,452

$20,366

$17,106

$18,130

June

$22,324

$19,582

$21,437

$17,545

July

$23,383

$22,291

$20,716

$23,018

August

$17,460

$21,953

$20,125

$18,786

September

$18,375

$19,696

$19,829

$19,263

October

$15,844

$13,625

$14,975

$16,117

November

$13,715

$15,805

$14,503

$14,435

December

$14,821

$11,095

$11,246

$15,934

What is the Seasonal Relative for January?

Format with 2 decimal places; enter a leading zero if needed, i.e .75 should be entered as 0.75.

What is the Seasonal Relative for July?

Format with 2 decimal places; enter a leading zero if needed, i.e .75 should be entered as 0.75.

What is the Seasonally Adjusted forecast for February?

Format as a whole number, no dollar sign.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!