Spreadsheet: 116577d1311929849-formula-for-calculating-forward-weeks-cover-forward-weeks-cover-example
Sheet: Sheet1

PERIOD END INVENTORY | Year | FY11 |  |  |  |  |  |  |  |  |  |  |  | FY12
 | Period | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12
 | Country 1 | 88210 | 97283 | 87574 | 79330 | 71007 | 59519 | 61998 | 78127 | 116462 | 152052 | 91058 | 68194 | 74804 | 91448 | 84421 | 83958 | 74683 | 58077 | 57155 | 72996 | 113383 | 148049 | 90553 | 60678
 | Country 2 | 38324 | 37770 | 38213 | 38093 | 35251 | 29718 | 29018 | 38031 | 48276 | 63676 | 45037 | 35301 | 37931 | 39655 | 39655 | 42064 | 39392 | 29253 | 27450 | 34434 | 41940 | 51927 | 38287 | 29760
 | Country 3 | 44063 | 51503 | 50532 | 50161 | 48720 | 39854 | 42262 | 56874 | 68027 | 91093 | 73873 | 40180 | 51847 | 64488 | 60687 | 57274 | 49514 | 37819 | 38213 | 45837 | 56837 | 70525 | 67003 | 35760
 | Country 4 | 79857 | 78807 | 78315 | 79582 | 76955 | 63427 | 68583 | 77511 | 92228 | 141153 | 100470 | 68061 | 73254 | 77303 | 70212 | 70212 | 68959 | 58842 | 63814 | 73015 | 92614 | 122575 | 91113 | 61016
 | Country 5 | 29188 | 32984 | 29941 | 30101 | 21450 | 14905 | 16160 | 17643 | 19650 | 24442 | 15338 | 11863 | 14663 | 18659 | 18184 | 18423 | 17974 | 16506 | 17593 | 19887 | 21894 | 25118 | 16633 | 15423
 | Country 6 | 39430 | 43520 | 40355 | 37613 | 36790 | 34658 | 34557 | 40365 | 47205 | 62212 | 58237 | 42230 | 41479 | 47343 | 41120 | 39901 | 40168 | 36720 | 36720 | 39306 | 47927 | 56978 | 44478 | 45341
 | Year | 2010/11 (FY11) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011/12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011/12
 | Period | P1 |  |  |  | P2 |  |  |  |  | P3 |  |  |  | P4 |  |  |  | P5 |  |  |  |  | P6 |  |  |  | P7 |  |  |  | P8 |  |  |  |  | P9 |  |  |  | P10 |  |  |  | P11 |  |  |  |  | P12 |  |  |  | P1 |  |  |  | P2 |  |  |  |  | P3 |  |  |  | P4 |  |  |  | P5 |  |  |  |  | P6 |  |  |  | P7 |  |  |  | P8 |  |  |  |  | P9 |  |  |  | P10 |  |  |  | P11 |  |  |  |  | P12 |  |  |  | P1 |  |  |  | P2 |  |  |  |  | P3 |  |  |  | P4 |  |  |  | P5 |  |  |  |  | P6 |  |  |  | P7 |  |  |  | P8 |  |  |  |  | P9 |  |  |  | P10 |  |  |  | P11 |  |  |  |  | P12
 | Weeks | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
[NAME] | Country 1 | 7441 | 8435 | 10239 | 8996 | 10299 | 10419 | 7980 | 9734 | 11636 | 8714 | 8231 | 6907 | 8167 | 8323 | 7254 | 8298 | 8619 | 9064 | 7047 | 6387 | 5897 | 6157 | 6362 | 11688 | 8175 | 8578 | 7620 | 7246 | 6882 | 8299 | 7964 | 6172 | 11747 | 9050 | 12373 | 9696 | 9042 | 9880 | 13384 | 10601 | 28450 | 16896 | 19171 | 21403 | 26253 | 28810 | 36382 | 27462 | 11910 | 7884 | 7469 | 7721 | 7611 | 6940 | 6645 | 9120 | 8480 | 7528 | 7368 | 14652 | 9729 | 7675 | 9448 | 13000 | 9315 | 7305 | 7302 | 9260 | 9084 | 9524 | 9212 | 8968 | 6898 | 7497 | 7381 | 7519 | 7214 | 7616 | 6404 | 6212 | 5936 | 7650 | 12348 | 9731 | 8639 | 14781 | 17123 | 12659 | 12059 | 10979 | 14687 | 23681 | 32581 | 22717 | 24158 | 26440 | 27880 | 30101 | 37696 | 28659 | 8689 | 7253 | 7024 | 7808 | 7611 | 6940 | 6645 | 9120 | 8480 | 7528 | 7368 | 14652 | 9729 | 7675 | 9448 | 13000 | 9315 | 7305 | 7302 | 9260 | 9084 | 9524 | 9212 | 8968 | 6898 | 7497 | 7381 | 7519 | 7214 | 7616 | 6404 | 6212 | 5936 | 7650 | 12348 | 9731 | 8639 | 14781 | 17123 | 12659 | 12059 | 10979 | 14687 | 23681 | 32581 | 22717 | 24158 | 26440 | 27880 | 30101 | 37696 | 28659 | 8689 | 7253 | 7024 | 7808
 | Country 2 | 1978 | 2076 | 1788 | 1932 | 2386 | 2516 | 2078 | 2016 | 1924 | 1774 | 1853 | 1442 | 1256 | 1956 | 2033 | 2267 | 1726 | 1725 | 1823 | 1651 | 1403 | 1858 | 1959 | 2221 | 1844 | 1979 | 1852 | 1642 | 1526 | 1576 | 1532 | 1690 | 1923 | 1638 | 3209 | 2263 | 2301 | 1933 | 2789 | 2380 | 5120 | 3573 | 3568 | 4383 | 5212 | 6455 | 7254 | 4089 | 2752 | 2272 | 2199 | 1825 | 1297 | 1388 | 1393 | 1558 | 2005 | 1575 | 1392 | 2466 | 1767 | 1571 | 1483 | 1528 | 1558 | 1535 | 1510 | 1771 | 1524 | 1717 | 1872 | 1666 | 1524 | 1959 | 1865 | 1717 | 1633 | 1837 | 1822 | 1704 | 1611 | 1707 | 1917 | 2431 | 1967 | 1816 | 3662 | 2584 | 2373 | 2084 | 2601 | 3129 | 4793 | 4502 | 3510 | 4758 | 5689 | 6996 | 8786 | 4635 | 2647 | 2830 | 2441 | 1972 | 1297 | 1388 | 1393 | 1558 | 2005 | 1575 | 1392 | 2466 | 1767 | 1571 | 1483 | 1528 | 1558 | 1535 | 1510 | 1771 | 1524 | 1717 | 1872 | 1666 | 1524 | 1959 | 1865 | 1717 | 1633 | 1837 | 1822 | 1704 | 1611 | 1707 | 1917 | 2431 | 1967 | 1816 | 3662 | 2584 | 2373 | 2084 | 2601 | 3129 | 4793 | 4502 | 3510 | 4758 | 5689 | 6996 | 8786 | 4635 | 2647 | 2830 | 2441 | 1972
 | Country 3 | 2641 | 2999 | 2666 | 2814 | 2955 | 3868 | 3841 | 3526 | 3308 | 2944 | 2923 | 2764 | 2543 | 3701 | 3228 | 3193 | 2882 | 2661 | 2964 | 2752 | 3203 | 3592 | 3136 | 3333 | 3203 | 3394 | 3159 | 2886 | 2590 | 2590 | 2775 | 2593 | 2737 | 3410 | 6262 | 3953 | 3763 | 2795 | 3242 | 4815 | 5708 | 4758 | 5909 | 6130 | 8001 | 8704 | 12827 | 10285 | 14681 | 4216 | 3015 | 2842 | 2623 | 2389 | 2270 | 2939 | 3372 | 2934 | 2646 | 3996 | 2926 | 2446 | 2629 | 2839 | 3405 | 3090 | 2952 | 3595 | 2672 | 3010 | 3017 | 2887 | 3176 | 3604 | 3403 | 3351 | 3159 | 3100 | 3224 | 3027 | 2781 | 2976 | 3116 | 3455 | 3108 | 3557 | 6752 | 4498 | 4978 | 3182 | 3859 | 5238 | 7215 | 5944 | 5710 | 7256 | 7835 | 8867 | 15338 | 11302 | 12905 | 4319 | 3250 | 3041 | 2623 | 2389 | 2270 | 2939 | 3372 | 2934 | 2646 | 3996 | 2926 | 2446 | 2629 | 2839 | 3405 | 3090 | 2952 | 3595 | 2672 | 3010 | 3017 | 2887 | 3176 | 3604 | 3403 | 3351 | 3159 | 3100 | 3224 | 3027 | 2781 | 2976 | 3116 | 3455 | 3108 | 3557 | 6752 | 4498 | 4978 | 3182 | 3859 | 5238 | 7215 | 5944 | 5710 | 7256 | 7835 | 8867 | 15338 | 11302 | 12905 | 4319 | 3250 | 3041
 | Country 4 | 4908 | 4917 | 4819 | 6382 | 7820 | 6697 | 5816 | 6755 | 6227 | 5120 | 4367 | 4601 | 4606 | 4469 | 4918 | 4995 | 5661 | 4102 | 5359 | 4951 | 4217 | 5551 | 5398 | 6282 | 6973 | 6636 | 5782 | 5066 | 4804 | 5537 | 5145 | 5055 | 7880 | 5891 | 9459 | 5783 | 5424 | 5397 | 6665 | 6093 | 11741 | 7252 | 7365 | 8733 | 13357 | 14753 | 19422 | 11991 | 7091 | 4472 | 4758 | 5457 | 4769 | 3623 | 3863 | 4820 | 4967 | 4677 | 3823 | 7551 | 4899 | 4223 | 3956 | 5341 | 3837 | 3653 | 3583 | 4553 | 5167 | 4045 | 4095 | 4517 | 3596 | 4501 | 4201 | 4215 | 4494 | 4263 | 4666 | 4439 | 4366 | 5659 | 5538 | 5357 | 7536 | 6546 | 9319 | 5965 | 5709 | 5699 | 8011 | 7102 | 10238 | 7490 | 7852 | 8093 | 11846 | 14417 | 22542 | 14648 | 7398 | 4701 | 4740 | 5669 | 4769 | 3623 | 3863 | 4820 | 4967 | 4677 | 3823 | 7551 | 4899 | 4223 | 3956 | 5341 | 3837 | 3653 | 3583 | 4553 | 5167 | 4045 | 4095 | 4517 | 3596 | 4501 | 4201 | 4215 | 4494 | 4263 | 4666 | 4439 | 4366 | 5659 | 5538 | 5357 | 7536 | 6546 | 9319 | 5965 | 5709 | 5699 | 8011 | 7102 | 10238 | 7490 | 7852 | 8093 | 11846 | 14417 | 22542 | 14648 | 7398 | 4701 | 4740 | 5669
 | Country 5 | 1046 | 1222 | 1172 | 1112 | 1192 | 1537 | 1387 | 1376 | 1433 | 1612 | 1600 | 1324 | 1253 | 1203 | 1108 | 1596 | 1462 | 1265 | 1434 | 2463 | 3466 | 2974 | 2385 | 1827 | 1624 | 1752 | 886 | 848 | 854 | 934 | 1091 | 922 | 1805 | 1253 | 1496 | 1136 | 1205 | 1323 | 1442 | 1164 | 2914 | 2229 | 2068 | 2008 | 2503 | 3138 | 3523 | 2139 | 1347 | 1096 | 1058 | 947 | 667 | 697 | 769 | 1028 | 863 | 1025 | 1043 | 1106 | 1629 | 999 | 1058 | 1482 | 1273 | 1018 | 1024 | 1261 | 1009 | 900 | 1143 | 990 | 1655 | 1670 | 1634 | 1604 | 1760 | 1627 | 1349 | 1275 | 1445 | 1508 | 1625 | 1553 | 1719 | 1856 | 2132 | 1992 | 1620 | 1722 | 1651 | 2064 | 3342 | 2644 | 2028 | 2548 | 3222 | 4126 | 5509 | 4215 | 2564 | 2017 | 1652 | 1517 | 667 | 697 | 769 | 1028 | 863 | 1025 | 1043 | 1106 | 1629 | 999 | 1058 | 1482 | 1273 | 1018 | 1024 | 1261 | 1009 | 900 | 1143 | 990 | 1655 | 1670 | 1634 | 1604 | 1760 | 1627 | 1349 | 1275 | 1445 | 1508 | 1625 | 1553 | 1719 | 1856 | 2132 | 1992 | 1620 | 1722 | 1651 | 2064 | 3342 | 2644 | 2028 | 2548 | 3222 | 4126 | 5509 | 4215 | 2564 | 2017 | 1652 | 1517
 | Country 6 | 2337 | 2476 | 2543 | 2346 | 2936 | 2876 | 2984 | 2023 | 2039 | 2113 | 2980 | 2151 | 1768 | 2015 | 2367 | 2355 | 1964 | 2138 | 1842 | 2404 | 2388 | 2837 | 2293 | 2371 | 2698 | 3540 | 2621 | 2602 | 2502 | 4770 | 3254 | 2351 | 3351 | 2800 | 3561 | 2550 | 3438 | 2935 | 3004 | 2706 | 6033 | 5558 | 6295 | 5931 | 8875 | 12015 | 11688 | 4550 | 3368 | 3751 | 2707 | 2838 | 3145 | 2803 | 2708 | 2603 | 2476 | 2833 | 3265 | 3496 | 2611 | 2258 | 2590 | 2331 | 2229 | 2085 | 2312 | 2854 | 2404 | 2347 | 2395 | 2549 | 2542 | 2860 | 2327 | 2565 | 2939 | 3785 | 2724 | 2797 | 2719 | 5231 | 3415 | 2453 | 3476 | 2934 | 3839 | 2750 | 3778 | 3251 | 3218 | 2891 | 6487 | 5862 | 6519 | 6039 | 9013 | 12275 | 13510 | 4707 | 2913 | 4199 | 3028 | 3166 | 3145 | 2803 | 2708 | 2603 | 2476 | 2833 | 3265 | 3496 | 2611 | 2258 | 2590 | 2331 | 2229 | 2085 | 2312 | 2854 | 2404 | 2347 | 2395 | 2549 | 2542 | 2860 | 2327 | 2565 | 2939 | 3785 | 2724 | 2797 | 2719 | 5231 | 3415 | 2453 | 3476 | 2934 | 3839 | 2750 | 3778 | 3251 | 3218 | 2891 | 6487 | 5862 | 6519 | 6039 | 9013 | 12275 | 13510 | 4707 | 2913 | 4199 | 3028 | 3166
 |  | FY11 |  |  |  |  |  |  |  |  |  |  |  | FY12
 | Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
FORWARD WEEKS COVER | Country 1 | 9.7 | 12.7 | 11.3 | 10.3 | 8.8 | 7.4 | 6.6 | 5.9 | 5.8 | 6 | 11.2 | 8 | 7.8 | 10 | 10.3 | 10.9 | 9.7 | 7.1 | 4.7 | 5 | 4.4 | 4.9 | 11.4 | 7.5
 | Country 2 | 20.2 | 21.3 | 21.1 | 20.2 | 17.6 | 14.3 | 11.6 | 10.7 | 11.6 | 25.9 | 26 | 21.6 | 22.2 | 23.1 | 21.7 | 21.2 | 18.2 | 13.3 | 10.6 | 9.7 | 8 | 16.2 | 21.6 | 18.4
 | Country 3 | 13.9 | 16.7 | 16.3 | 16.8 | 14.7 | 12.1 | 11 | 10.9 | 9.1 | 16.3 | 20.8 | 13.9 | 17.1 | 21 | 19.4 | 17.5 | 14 | 10.3 | 9.3 | 8.7 | 7.6 | 7.8 | 19 | 12.5
 | Country 4 | 14.7 | 15.6 | 14.6 | 14.7 | 12.7 | 10.6 | 10.5 | 10 | 8.3 | 20 | 21.3 | 15.1 | 16.1 | 18.1 | 16.3 | 15.3 | 12.8 | 9.9 | 9.6 | 9.6 | 8.2 | 15.5 | 19.2 | 13.2
 | Country 5 | 17.8 | 20.1 | 18.8 | 18.7 | 16.1 | 12.8 | 11.2 | 9.9 | 8 | 16.5 | 15 | 11.7 | 12.9 | 15 | 13.7 | 12.9 | 11.5 | 10 | 9.8 | 9.1 | 7.3 | 7.6 | 13.1 | 14.7
 | Country 6 | 17 | 18.3 | 16.3 | 13.8 | 12.5 | 11.3 | 10.8 | 9.2 | 7 | 11.2 | 21.2 | 15.9 | 16.2 | 18.4 | 15.6 | 13.6 | 12.7 | 11.2 | 10.7 | 8.8 | 6.9 | 8.4 | 15.2 | 17.1