John's Bait and Fish Shop has had the monthly sales amounts listed below for the last four years. Year: January February 2017 $ 417,367 114,545 2018 $ 585,933 138,297 2019 $ 335,245 165,396 2020 $ 588,897 113,395 March 139,034 177,978 86,250 138,526 April May June 429,362 393,873 513,433 458,349 437,360 926,902 535,096 852,201 743,720 1,085,600 597,872 742,567 July 1,449,487 1,250,939 1,565,689 1,579,033 August 1,429,071 1,794,208 1,850,060 1,591,397 September 1,178,451 1,023,376 683,722 724,766 October 368,124 466,386 483,745 651,886 November 257,130 390,803 261,611 310,905 December 322,404 386,984 235,939 371,431 Assuming that there are both seasonality and a trend, estimate monthly sales for each month of the coming year. Note: Round your answers to the nearest whole dollar amount. January February March April May June July August September October November December 2021

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

Bhupatbhai 

John's Bait and Fish Shop has had the monthly sales amounts listed below for the last four years.
Year:
January
February
2017
$ 417,367
114,545
2018
$ 585,933
138,297
2019
$ 335,245
165,396
2020
$ 588,897
113,395
March
139,034
177,978
86,250
138,526
April
May
June
429,362
393,873
513,433
458,349
437,360
926,902
535,096
852,201
743,720
1,085,600
597,872
742,567
July
1,449,487
1,250,939
1,565,689
1,579,033
August
1,429,071
1,794,208
1,850,060
1,591,397
September
1,178,451
1,023,376
683,722
724,766
October
368,124
466,386
483,745
651,886
November
257,130
390,803
261,611
310,905
December
322,404
386,984
235,939
371,431
Assuming that there are both seasonality and a trend, estimate monthly sales for each month of the coming year.
Note: Round your answers to the nearest whole dollar amount.
January
February
March
April
May
June
July
August
September
October
November
December
2021
Transcribed Image Text:John's Bait and Fish Shop has had the monthly sales amounts listed below for the last four years. Year: January February 2017 $ 417,367 114,545 2018 $ 585,933 138,297 2019 $ 335,245 165,396 2020 $ 588,897 113,395 March 139,034 177,978 86,250 138,526 April May June 429,362 393,873 513,433 458,349 437,360 926,902 535,096 852,201 743,720 1,085,600 597,872 742,567 July 1,449,487 1,250,939 1,565,689 1,579,033 August 1,429,071 1,794,208 1,850,060 1,591,397 September 1,178,451 1,023,376 683,722 724,766 October 368,124 466,386 483,745 651,886 November 257,130 390,803 261,611 310,905 December 322,404 386,984 235,939 371,431 Assuming that there are both seasonality and a trend, estimate monthly sales for each month of the coming year. Note: Round your answers to the nearest whole dollar amount. January February March April May June July August September October November December 2021
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education