Spreadsheet: 767923d1644737768-index-match-offset-sumproduct-formula-for-forecasting-formula-for-forecasting-ans
Sheet: Units (2)

 |  |  |  |  | 1:CY: 2:BOY |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2
 |  |  |  |  | Month |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  | QTR |  | 1 | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 3 | 4 | 4 | 4 |  |  | 1 | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 3 | 4 | 4 | 4 |  |  | 1 | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 3 | 4 | 4 | 4
 |  |  |  |  |  |  | 2021 Actual |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021 Budget
BU | CC | Acct | Acct Desc | Bus Category | Freight Category | Sub Category | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
JOY | 12312 | 540042 | Freight Pd US Imports | Retail | Inbound | International | 225953 | 380475 | 500217 | 594435 | 438840 | 270211 | 207833 | 453729 | 409054 | 230116 | 520618 | 248655 |  |  | 164226 | 246978 | 189056 | 313264 | 564837 | 173867 | 536681 | 253454 | 122502 | 288947 | 521566 | 185315 |  |  | 225953 | 246978 | 189056 | 313264 | 564837 | 173867 | 536681 | 253454 | 122502 | 288947 | 521566 | 185315
JOY | 12312 | 540003 | [NAME] Overseas | Retail | Inbound | International | 136834 | 155821 | 430587 | 502837 | 120181 | 174681 | 163453 | 319974 | 158939 | 390755 | 286283 | 244330 |  |  | 112809 | 518722 | 500053 | 198931 | 497798 | 312817 | 357820 | 315885 | 303523 | 586795 | 197059 | 438272 |  |  | 136834 | 518722 | 500053 | 198931 | 497798 | 312817 | 357820 | 315885 | 303523 | 586795 | 197059 | 438272
JOY | 12312 | 540041 | Demurrage | Retail | Inbound | International | 455622 | 196180 | 462068 | 308008 | 556207 | 552608 | 291928 | 397498 | 358876 | 374514 | 562323 | 379080 |  |  | 499200 | 560914 | 260265 | 427365 | 412745 | 485562 | 303777 | 532382 | 320404 | 404411 | 426419 | 216158 |  |  | 455622 | 560914 | 260265 | 427365 | 412745 | 485562 | 303777 | 532382 | 320404 | 404411 | 426419 | 216158
JOY | 12312 | 540032 | Livingston Intl-Import Costs | Retail | Inbound | International | 583877 | 469179 | 445131 | 575852 | 400399 | 231985 | 118337 | 279667 | 282245 | 305187 | 474059 | 480898 |  |  | 415647 | 569324 | 344355 | 467212 | 125297 | 554533 | 238537 | 200031 | 244468 | 498848 | 340603 | 247410 |  |  | 583877 | 569324 | 344355 | 467212 | 125297 | 554533 | 238537 | 200031 | 244468 | 498848 | 340603 | 247410
JOY | 12312 | 540032 | COS-Freight-Oth | Retail | Inbound | International | 526139 | 562200 | 261994 | 149369 | 196606 | 521349 | 375500 | 358813 | 309897 | 447617 | 598008 | 187884 |  |  | 537153 | 540539 | 531447 | 312408 | 147849 | 365310 | 457495 | 242409 | 363782 | 463657 | 222910 | 278726 |  |  | 526139 | 540539 | 531447 | 312408 | 147849 | 365310 | 457495 | 242409 | 363782 | 463657 | 222910 | 278726
JOY | 12312 | 540012 | Freight Pd Air Overseas | Retail | Inbound | International | 582267 | 162091 | 102301 | 339206 | 104550 | 413391 | 174518 | 164971 | 219480 | 432672 | 527898 | 553425 |  |  | 594385 | 374462 | 458865 | 397805 | 207017 | 588903 | 183319 | 272229 | 271356 | 277166 | 411898 | 304061 |  |  | 582267 | 374462 | 458865 | 397805 | 207017 | 588903 | 183319 | 272229 | 271356 | 277166 | 411898 | 304061
JOY | 12312 | 540022 | [NAME] | Retail | Inbound | Domestic | 504803 | 585719 | 292861 | 424909 | 152616 | 545481 | 277177 | 375892 | 553753 | 310252 | 538192 | 234316 |  |  | 510577 | 263308 | 264758 | 151829 | 502830 | 409154 | 110734 | 404315 | 233712 | 124458 | 474764 | 438784 |  |  | 504803 | 263308 | 264758 | 151829 | 502830 | 409154 | 110734 | 404315 | 233712 | 124458 | 474764 | 438784
JOY | 12312 | 540034 | Vitran Vend to Consolidation | Retail | Inbound | Domestic | 217534 | 451230 | 124340 | 238944 | 123644 | 238924 | 410746 | 201812 | 246540 | 242599 | 430656 | 199575 |  |  | 318123 | 512920 | 217458 | 370595 | 258302 | 420302 | 112175 | 572112 | 376121 | 294912 | 291163 | 572973 |  |  | 217534 | 512920 | 217458 | 370595 | 258302 | 420302 | 112175 | 572112 | 376121 | 294912 | 291163 | 572973
JOY | 12312 | 540042 | Vitran Consol to Store | Retail | Outbound | Outbound | 147293 | 252659 | 230350 | 426663 | 346216 | 224638 | 508009 | 243694 | 403007 | 410671 | 159253 | 138017 |  |  | 174174 | 358186 | 528865 | 594595 | 544701 | 556648 | 116103 | 366293 | 121368 | 434524 | 272540 | 584802 |  |  | 147293 | 358186 | 528865 | 594595 | 544701 | 556648 | 116103 | 366293 | 121368 | 434524 | 272540 | 584802
JOY | 12312 | 540020 | DC to DC Freight | Retail | Inbound | Domestic | 412362 | 278315 | 370257 | 589264 | 258818 | 215799 | 512081 | 555060 | 435218 | 287786 | 280461 | 453802 |  |  | 232488 | 486997 | 525274 | 300903 | 106138 | 308433 | 195982 | 411100 | 516570 | 486078 | 312370 | 458515 |  |  | 412362 | 486997 | 525274 | 300903 | 106138 | 308433 | 195982 | 411100 | 516570 | 486078 | 312370 | 458515
JOY | 12312 | 540050 | Inbound DC Freight | Retail | Inbound | Domestic | 297166 | 585971 | 532975 | 417895 | 135345 | 405612 | 572288 | 205195 | 227670 | 299330 | 596231 | 467154 |  |  | 509656 | 570461 | 283777 | 255466 | 446869 | 596522 | 562531 | 495966 | 439676 | 422835 | 190216 | 264072 |  |  | 297166 | 570461 | 283777 | 255466 | 446869 | 596522 | 562531 | 495966 | 439676 | 422835 | 190216 | 264072
JOY | 12312 | 540030 | Drayage to 210 | Retail | Inbound | Domestic | 353371 | 329056 | 395355 | 433614 | 259489 | 597959 | 454713 | 128755 | 353551 | 345638 | 508051 | 519373 |  |  | 338940 | 302494 | 319949 | 139780 | 341118 | 273002 | 439013 | 353831 | 119163 | 407146 | 474429 | 289614 |  |  | 353371 | 302494 | 319949 | 139780 | 341118 | 273002 | 439013 | 353831 | 119163 | 407146 | 474429 | 289614
JOY | 12312 | 540006 | Freight [NAME] Delivery | eCommerce | eCommerce | eCommerce Recovery | 190645 | 207634 | 435329 | 242842 | 377217 | 197144 | 389359 | 112856 | 268823 | 331097 | 107344 | 525579 |  |  | 331808 | 379317 | 228181 | 434009 | 181275 | 392902 | 332209 | 437977 | 167855 | 492963 | 336785 | 410125 |  |  | 190645 | 379317 | 228181 | 434009 | 181275 | 392902 | 332209 | 437977 | 167855 | 492963 | 336785 | 410125
JOY | 12312 | 540006 | Fast Find & Web Sales Freight | eCommerce | eCommerce | Store cartons | 193659 | 181874 | 253263 | 464003 | 457803 | 296133 | 524378 | 229156 | 470544 | 124009 | 232827 | 386739 |  |  | 221734 | 503527 | 426685 | 515462 | 265118 | 358804 | 375076 | 227586 | 579312 | 245378 | 400363 | 291320 |  |  | 193659 | 503527 | 426685 | 515462 | 265118 | 358804 | 375076 | 227586 | 579312 | 245378 | 400363 | 291320
JOY | 12312 | 540020 | Fast Find & Web Sales Freight | eCommerce | eCommerce | DC | 176136 | 115668 | 176835 | 529689 | 338310 | 418258 | 310334 | 178829 | 408334 | 507090 | 428369 | 137505 |  |  | 402268 | 597345 | 414145 | 170533 | 171174 | 177531 | 478878 | 449926 | 590192 | 160387 | 270752 | 163047 |  |  | 176136 | 597345 | 414145 | 170533 | 171174 | 177531 | 478878 | 449926 | 590192 | 160387 | 270752 | 163047
JOY | 12312 | 540014 | Fast Find & Web Sales Freight | eCommerce | eCommerce | Vendor | 169395 | 320789 | 216213 | 466614 | 530176 | 148507 | 555590 | 110934 | 127971 | 240439 | 266753 | 133795 |  |  | 459125 | 389017 | 355200 | 367720 | 590092 | 218397 | 590409 | 575068 | 577279 | 142146 | 504052 | 247392 |  |  | 169395 | 389017 | 355200 | 367720 | 590092 | 218397 | 590409 | 575068 | 577279 | 142146 | 504052 | 247392
JOY | 12312 | 540028 | Freight Pd Transfers | Retail | Other | S2S Transfers | 550612 | 214717 | 105904 | 541558 | 123640 | 305747 | 450764 | 577257 | 293701 | 323334 | 472331 | 505597 |  |  | 358076 | 358793 | 368267 | 528316 | 443163 | 306121 | 105832 | 405164 | 420384 | 597468 | 178272 | 151286 |  |  | 550612 | 358793 | 368267 | 528316 | 443163 | 306121 | 105832 | 405164 | 420384 | 597468 | 178272 | 151286
JOY | 12312 | 540039 | Courier Vendor to Store | Retail | Outbound | Expedited | 135502 | 300969 | 345710 | 255079 | 160159 | 547902 | 210268 | 484649 | 290071 | 355518 | 437045 | 514843 |  |  | 202815 | 155750 | 451468 | 466106 | 388214 | 427220 | 177723 | 456791 | 466775 | 425069 | 561307 | 353541 |  |  | 135502 | 155750 | 451468 | 466106 | 388214 | 427220 | 177723 | 456791 | 466775 | 425069 | 561307 | 353541
JOY | 12312 | 540034 | ATS to Store Merchandise | Retail | Outbound | Expedited | 454012 | 301653 | 554644 | 369253 | 343933 | 492219 | 341026 | 500735 | 381299 | 492690 | 579610 | 416184 |  |  | 538324 | 484424 | 380260 | 109933 | 337387 | 180143 | 339281 | 227411 | 295112 | 486699 | 407322 | 563672 |  |  | 454012 | 484424 | 380260 | 109933 | 337387 | 180143 | 339281 | 227411 | 295112 | 486699 | 407322 | 563672
JOY | 12312 | 540044 | Other Vendor to Store | Retail | Outbound | Expedited | 117236 | 572578 | 530469 | 223884 | 387935 | 219941 | 588001 | 119357 | 419267 | 481256 | 567710 | 479557 |  |  | 348604 | 240794 | 139024 | 558395 | 513133 | 112874 | 205555 | 527554 | 115595 | 326177 | 164237 | 487999 |  |  | 117236 | 240794 | 139024 | 558395 | 513133 | 112874 | 205555 | 527554 | 115595 | 326177 | 164237 | 487999
JOY | 12312 | 540027 | Expedited Freight-MWW | Retail | Outbound | Expedited | 137464 | 105572 | 199036 | 471933 | 430115 | 591266 | 564283 | 550994 | 548390 | 395493 | 489608 | 241871 |  |  | 147981 | 400190 | 174568 | 498829 | 268431 | 386985 | 512252 | 129426 | 405503 | 440882 | 548535 | 498286 |  |  | 137464 | 400190 | 174568 | 498829 | 268431 | 386985 | 512252 | 129426 | 405503 | 440882 | 548535 | 498286
JOY | 12312 | 540029 | [NAME] | Retail | Outbound | Expedited | 116556 | 532293 | 399988 | 111291 | 393881 | 391906 | 560607 | 182884 | 419596 | 292227 | 543565 | 369397 |  |  | 411603 | 107812 | 530146 | 218170 | 225230 | 192780 | 218446 | 571300 | 551261 | 543481 | 566754 | 512297 |  |  | 116556 | 107812 | 530146 | 218170 | 225230 | 192780 | 218446 | 571300 | 551261 | 543481 | 566754 | 512297
JOY | 12312 | 540015 | [NAME] | Retail | Outbound | Expedited | 162672 | 324557 | 574561 | 129791 | 478468 | 105410 | 131314 | 283281 | 357132 | 256014 | 407973 | 314760 |  |  | 200808 | 289911 | 276635 | 497500 | 157226 | 598223 | 183646 | 308103 | 327374 | 157673 | 507142 | 540144 |  |  | 162672 | 289911 | 276635 | 497500 | 157226 | 598223 | 183646 | 308103 | 327374 | 157673 | 507142 | 540144
JOY | 12312 | 540024 | Freight Bus Acct Deliv | Retail | Other | [NAME]'s Commercial | 425599 | 394806 | 121519 | 500954 | 421337 | 543569 | 297278 | 399160 | 526094 | 530186 | 124603 | 183182 |  |  | 147358 | 559538 | 342856 | 569246 | 271103 | 335111 | 386798 | 484881 | 202987 | 546567 | 119235 | 330086 |  |  | 425599 | 559538 | 342856 | 569246 | 271103 | 335111 | 386798 | 484881 | 202987 | 546567 | 119235 | 330086
JOY | 12312 | 540033 | Freight on Embroidery | Retail | Other | [NAME]'s Commercial | 521843 | 402310 | 531485 | 238704 | 519621 | 579438 | 215814 | 515937 | 547582 | 451522 | 355713 | 530841 |  |  | 265047 | 598630 | 515997 | 282516 | 346016 | 371573 | 290241 | 143555 | 143545 | 264372 | 593090 | 189006 |  |  | 521843 | 598630 | 515997 | 282516 | 346016 | 371573 | 290241 | 143555 | 143545 | 264372 | 593090 | 189006
JOY | 12312 | 540021 | Fast Find & Web Sales Freight | eCommerce | eCommerce | eCommerce | 278347 | 560210 | 106737 | 287731 | 511640 | 104388 | 146002 | 144171 | 313380 | 367238 | 445070 | 223227 |  |  | 307913 | 520524 | 405188 | 330133 | 534000 | 233735 | 573253 | 368678 | 481917 | 572118 | 598695 | 451743 |  |  | 278347 | 520524 | 405188 | 330133 | 534000 | 233735 | 573253 | 368678 | 481917 | 572118 | 598695 | 451743