I am doing a case study where I have to generate a sales forecast for the next 6 months. I have information from the last 4 years for the north and south locations regarding sales and orders for each for two types of yogurt. There was a price increase in year 5 of 30%. I have to decide what methods to use and which data to use.

I just added the data though I believe there are errors in the databput there on purpose for the case.

In the case, that information was left out due to poor previous management.

Baltimore Dairy Student Data file ge Layout Formulas Date what you want A Times New Romt1 B I U 0 00 A Merge $ . % Center 9 Conditional Format as Formatting Table Number North Sales Month YoCream GreeCream YoCream 963.104 909.626 551.807 585 520 $59.160 570.151 S124 550 SIOL 514 S107,612 $85 655 $76,408 $65 $35 1.171 $11.487 1.400 18 58.126 595.797 575 398 SI51.524 $52,593 548,429 58145 558.200 $80,845 S104.75 $89.40 SI21.159 SI10.001 $85.075 $120.151 587.826 571037 582.121 South Sales! Orders? YoCream GreeCream YoCream $54,711 521 259 1.040 $56.341 $26.417 $47,941 $25,450 2.244 1,205 549,892 $26, 547 1.254 $50,990 1102 $45 374 525.887 2.222 1.253 $52.824 2,533 1522 $19.955 2,392 1.585 531 568 2086 1,497 $41.168 527018 2,067 1.288 $45.495 $79569 $52,620 $15.535 1.702 $44,745 $30036 1,410 $48571 531.292 2.385 1.519 $4385 $12213 $42.078 2,033 541.642 2,010 $52.193 2.522 $19.051 5420 2,021 $41.058 1,965 545.223 2.15$ S81409 1,585 $38,196 536,492 1,735 $17.663 537,245 $36,550 1.961 $43,376 $14.257 $44,745 1.575 Ja $145 248 My TESOLIS 6.900 $125.126 $76278 $74.443 S100512 S126,336 Feb MA 5174,144 1.3.15 1.178 S145,728 $99.900 S103.488 594,176 590 202 $28,510 S18238 $22.092 520.057 521,714 556,930 S35,460 557,785 562.556 $58,742 $121.075 Data Baltimore Dairy Student Data file spa Page Layout Formulas Data Review View Tell me what you want to do Times New Rom. 11 A Wrap Test BIU. Condronal Formats Merge & Center - S - 96 9 North Orders | YoCream GreeCream YeCream S145248 $53396 SI10 531 $143 374 S125 126 S103.192 S102,816 $76,278 $42.000 South Sales! Orders? GreeCream YoCream GreeCream $42.078 SES 859 $41.642 910363 $52,193 $39,051 582.761 ST 806 $41,058 536 033 $45.223 $20.791 $41.536 $38.1965 536 492 $17.68 $36,950 $41015 538 429 $43.376 $14.287 544,746 SI21 159 S114,003 $83.075 $120.151 587826 571,037 SX2,171 $$9.74 583.3571 $74,443 5100 512 $13.49 3.954 3.612 4.845 $174.144 SIM.665 $147 558 $133,888 $121.075 395,828 $21.114 S102342 530,147 3.111 574,366 $281,183 $256,761 $145,728 $99.900 S101.488 $94.176 590,202 574.660 566517 $72,592 $178, 546 $226,980 $219,532 $242,798 $253,165 $177,002 SIERO $133,456 $117 OR? 528510 556,920 S18.238 $57,785 520.057 562.556 $$8.742 522,452 $23,336 568.939 566,120 $25,298 $26,737 577.332 $21.717 $75 $39 $19,466 $99.277 $19,279 $15.09 $14.815 $75,808 SI7095 $75,537 $160489 2,864 2,770 2.519 2.570 $71.101 $203.573 5276,221 $263,577 5241,194 SINU231 S170,732 6.790 2,743 501? Data Ee ta file sp 2020 (3) - Excel Accent1 Accent2 Accent3 mat as Accent Accent Comma Comma [0] Insert Delete ble Styles Cell Sales Sales from the respective DCs to retail customers, valued at wholesale prices All order figures are reported in cases of 12 units * Orders Baltimore Dairy Student Data file ge Layout Formulas Date what you want A Times New Romt1 B I U 0 00 A Merge $ . % Center 9 Conditional Format as Formatting Table Number North Sales Month YoCream GreeCream YoCream 963.104 909.626 551.807 585 520 $59.160 570.151 S124 550 SIOL 514 S107,612 $85 655 $76,408 $65 $35 1.171 $11.487 1.400 18 58.126 595.797 575 398 SI51.524 $52,593 548,429 58145 558.200 $80,845 S104.75 $89.40 SI21.159 SI10.001 $85.075 $120.151 587.826 571037 582.121 South Sales! Orders? YoCream GreeCream YoCream $54,711 521 259 1.040 $56.341 $26.417 $47,941 $25,450 2.244 1,205 549,892 $26, 547 1.254 $50,990 1102 $45 374 525.887 2.222 1.253 $52.824 2,533 1522 $19.955 2,392 1.585 531 568 2086 1,497 $41.168 527018 2,067 1.288 $45.495 $79569 $52,620 $15.535 1.702 $44,745 $30036 1,410 $48571 531.292 2.385 1.519 $4385 $12213 $42.078 2,033 541.642 2,010 $52.193 2.522 $19.051 5420 2,021 $41.058 1,965 545.223 2.15$ S81409 1,585 $38,196 536,492 1,735 $17.663 537,245 $36,550 1.961 $43,376 $14.257 $44,745 1.575 Ja $145 248 My TESOLIS 6.900 $125.126 $76278 $74.443 S100512 S126,336 Feb MA 5174,144 1.3.15 1.178 S145,728 $99.900 S103.488 594,176 590 202 $28,510 S18238 $22.092 520.057 521,714 556,930 S35,460 557,785 562.556 $58,742 $121.075 Data Baltimore Dairy Student Data file spa Page Layout Formulas Data Review View Tell me what you want to do Times New Rom. 11 A Wrap Test BIU. Condronal Formats Merge & Center - S - 96 9 North Orders | YoCream GreeCream YeCream S145248 $53396 SI10 531 $143 374 S125 126 S103.192 S102,816 $76,278 $42.000 South Sales! Orders? GreeCream YoCream GreeCream $42.078 SES 859 $41.642 910363 $52,193 $39,051 582.761 ST 806 $41,058 536 033 $45.223 $20.791 $41.536 $38.1965 536 492 $17.68 $36,950 $41015 538 429 $43.376 $14.287 544,746 SI21 159 S114,003 $83.075 $120.151 587826 571,037 SX2,171 $$9.74 583.3571 $74,443 5100 512 $13.49 3.954 3.612 4.845 $174.144 SIM.665 $147 558 $133,888 $121.075 395,828 $21.114 S102342 530,147 3.111 574,366 $281,183 $256,761 $145,728 $99.900 S101.488 $94.176 590,202 574.660 566517 $72,592 $178, 546 $226,980 $219,532 $242,798 $253,165 $177,002 SIERO $133,456 $117 OR? 528510 556,920 S18.238 $57,785 520.057 562.556 $$8.742 522,452 $23,336 568.939 566,120 $25,298 $26,737 577.332 $21.717 $75 $39 $19,466 $99.277 $19,279 $15.09 $14.815 $75,808 SI7095 $75,537 $160489 2,864 2,770 2.519 2.570 $71.101 $203.573 5276,221 $263,577 5241,194 SINU231 S170,732 6.790 2,743 501? Data Ee ta file sp 2020 (3) - Excel Accent1 Accent2 Accent3 mat as Accent Accent Comma Comma [0] Insert Delete ble Styles Cell Sales Sales from the respective DCs to retail customers, valued at wholesale prices All order figures are reported in cases of 12 units * Orders