John's Bait and Fish Shop has had the monthly sales amounts listed below for the last four years. Year: 2017 2018 2019 2020 January February $ 417,633 113,438 $ 586,553 139,298 $ 335,025 165,694 $ 588,874 114,815 March 140,194 178,518 87,201 138,941 April 428,277 392,579 513,038 458,111 May 437,370 927,265 535,878 851,534 June 743,147 1,084,375 598,750 742,302 July 1,449,729 1,249,471 1,564,574 1,579,008 August 1,429,902 1,794,586 1,849,815 1,591,403 September 1,179,382 1,022,239 684,731 725,323 October 369,988 466,563 483,173 651,532 November 257,050 390,912 261,735 310,920 December 322,543 387,203 235,024 372,236 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.

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter7: Budgeting
Section: Chapter Questions
Problem 11EA: Dream Big Pillow Co. pays 65% of its purchases in the month of purchase, 30% the month after the...
icon
Related questions
Question

Baghiben 

John's Bait and Fish Shop has had the monthly sales amounts listed below for the last four years.
Year:
2017
2018
2019
2020
January
February
$ 417,633
113,438
$ 586,553
139,298
$ 335,025
165,694
$ 588,874
114,815
March
140,194
178,518
87,201
138,941
April
428,277
392,579
513,038
458,111
May
437,370
927,265
535,878
851,534
June
743,147
1,084,375
598,750
742,302
July
1,449,729
1,249,471
1,564,574
1,579,008
August
1,429,902
1,794,586
1,849,815
1,591,403
September
1,179,382
1,022,239
684,731
725,323
October
369,988
466,563
483,173
651,532
November
257,050
390,912
261,735
310,920
December
322,543
387,203
235,024
372,236
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.
Transcribed Image Text:John's Bait and Fish Shop has had the monthly sales amounts listed below for the last four years. Year: 2017 2018 2019 2020 January February $ 417,633 113,438 $ 586,553 139,298 $ 335,025 165,694 $ 588,874 114,815 March 140,194 178,518 87,201 138,941 April 428,277 392,579 513,038 458,111 May 437,370 927,265 535,878 851,534 June 743,147 1,084,375 598,750 742,302 July 1,449,729 1,249,471 1,564,574 1,579,008 August 1,429,902 1,794,586 1,849,815 1,591,403 September 1,179,382 1,022,239 684,731 725,323 October 369,988 466,563 483,173 651,532 November 257,050 390,912 261,735 310,920 December 322,543 387,203 235,024 372,236 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.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College