Case7_Western_Pharmaceutical_B_Data - Western Pharm B Data...

Info icon This preview shows pages 1–3. Sign up to view the full content.

Western Pharm B Data.xls Page 1 Page 1 Product Total Demand ATL Dmd NB Dmd Mech Dmd Standard Total Atl Inven NB Inven Mech Inv Atl Std NB Std Mech Std (Weekly) (Weekly) (Weekly) (Weekly) Cost Inventory (Average) (Average) (Average) P 001 452.9 210.1 55.3 187.6 423.761 2,179 997 550 632 798 182.7 41.3 126.1 P 002 1937.8 797.0 330.7 810.0 43.818 12,377 5,153 2,458 4,766 4,122 408.0 150.1 361.6 P 003 272.4 29.1 16.2 227.1 80.927 5,689 2,242 1,727 1,720 1,793 52.5 33.6 390.1 P 004 1651.9 659.9 274.1 717.9 47.489 10,829 3,842 1,789 5,198 3,074 279.6 116.2 237.2 P 005 3630.0 1234.2 665.0 1730.8 8.165 56,654 17,004 9,500 30,149 13,603 1,082.9 421.6 1,231.4 P 006 1767.2 719.6 308.6 739.0 35.222 13,506 4,462 3,002 6,042 3,570 289.5 137.6 288.0 P 007 153.2 53.4 29.7 70.0 31.382 12,555 3,124 2,364 7,067 2,499 126.1 64.3 154.9 P 008 452.8 167.3 82.9 202.5 13.505 28,920 8,637 6,639 13,645 6,909 478.5 136.0 320.3 P 009 1489.5 643.2 285.9 560.4 52.817 9,017 3,618 1,529 3,870 2,894 589.2 213.4 441.9 P 010 1413.6 504.6 246.0 663.0 14.446 25,651 10,352 6,125 9,174 8,282 447.2 217.8 590.5 P 011 379.2 63.5 29.4 286.3 74.637 5,162 2,802 950 1,409 2,242 101.4 53.6 373.2 P 012 3390.5 1314.2 628.0 1448.3 8.605 44,778 12,849 8,700 23,230 10,279 755.1 371.1 927.5 P 013 1467.5 617.0 252.8 597.6 32.464 12,063 4,902 2,783 4,377 3,922 307.9 99.0 237.7 P 014 200.8 61.6 35.1 104.1 35.021 9,554 3,100 1,678 4,776 2,480 111.2 62.8 187.9 P 015 440.5 186.8 65.7 187.9 34.406 9,832 3,623 1,775 4,434 2,898 92.8 32.6 78.7 P 016 1654.6 655.5 277.7 721.3 38.319 9,840 3,801 2,090 3,948 3,041 276.7 110.0 258.1 P 017 9022.5 3120.3 1902.5 3999.7 7.600 50,412 16,843 10,897 22,672 13,475 1,173.2 605.3 1,273.8 P 018 969.7 405.6 194.5 369.7 43.115 7,909 1,284 930 5,695 1,028 160.5 95.4 198.9 P 019 704.5 255.5 134.7 314.3 19.727 15,024 5,845 2,726 6,453 4,676 263.3 150.6 317.6 P 020 339.5 85.2 93.1 161.3 144.076 2,422 623 328 1,471 499 61.3 90.8 90.2 P 021 1472.6 487.1 234.7 750.9 23.741 13,686 3,416 1,734 8,535 2,733 206.7 103.0 496.7 P 022 313.8 69.6 85.8 158.4 99.547 3,246 769 382 2,095 615 49.5 63.4 88.3 P 023 920.7 349.8 196.1 374.8 76.076 4,683 1,444 1,049 2,190 1,155 168.8 69.8 135.6 P 024 5753.3 2166.7 1477.7 2108.9 5.054 52,382 15,969 8,915 27,497 12,776 1,018.1 731.5 747.7 P 025 2488.9 1035.5 409.2 1044.2 19.853 14,971 5,624 2,910 6,437 4,499 377.3 130.0 335.9 P 026 1625.8 628.0 281.4 716.4 28.826 10,233 4,030 2,086 4,117 3,224 290.9 147.0 307.4 P 027 2932.1 818.7 895.2 1218.3 13.219 21,032 5,014 7,018 9,000 4,011 292.9 305.1 393.6 P 028 350.4 160.3 41.2 148.9 48.025 4,788 2,396 491 1,901 1,917 91.5 23.0 63.1 P 029 2641.7 1025.2 355.9 1260.6 13.786 18,602 6,045 2,401 10,156 4,836 424.7 128.1 540.2 P 030 814.7 292.4 140.2 382.2 19.727 11,044 4,085 2,950 4,010 3,268 290.1 140.6 342.9 P 031 2221.6 559.0 733.3 929.2 14.530 15,999 6,523 4,639 4,837 5,219 245.8 278.4 343.1 P 032 5749.8 2439.1 895.8 2414.8 8.709 24,710 8,853 4,817 11,040 7,082 1,539.4 517.7 1,560.1 P 033 1304.6 525.5 197.3 581.8 14.172 13,807 5,255 2,976 5,575 4,204 538.6 194.2 585.2 P 034 365.1 146.5 63.7 154.9 35.106 5,857 1,496 1,143 3,218 1,197 141.1 54.7 131.0 P 035 721.2 281.2 144.8 295.3 44.870 4,659 808 713 3,138 646 150.8 101.6 150.2 P 036 1037.9 415.6 201.9 420.4 22.063 9,000 2,313 3,598 3,089 1,851 201.2 99.0 202.1 P 037 2046.5 851.0 275.2 920.3 21.171 10,413 4,343 1,873 4,197 3,475 302.1 96.8 262.5 P 038 466.9 154.3 75.0 237.6 43.667 4,266 1,346 652 2,267 1,077 112.2 52.7 132.0 P 039 478.0 179.7 102.6 195.7 47.834 3,925 1,210 800 1,915 968 117.8 60.0 156.5
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Western Pharm B Data.xls Page 2 Page 2 Product Total Demand ATL Dmd NB Dmd Mech Dmd Standard Total Atl Inven NB Inven Mech Inv Atl Std NB Std Mech Std (Weekly) (Weekly) (Weekly) (Weekly) Cost Inventory (Average) (Average) (Average) P 040 572.0 80.7 34.6 456.7 17.451 10,255 5,383 2,200 2,672 4,306 136.6 80.2 641.8 P 041 5892.2 2091.7 1428.7 2371.8 16.350 14,206 2,146 353 11,706 1,717 2,239.1 1,430.7 2,920.6 P 042 1055.3 363.3 227.7 464.3 16.045 10,473 4,334 1,179 4,960 3,467 188.9 100.5 208.1 P 043 1731.3 368.3 646.1 716.9 13.629 14,230 2,402 5,639 6,190 1,922 212.2 265.3 271.2 P 044 2423.8 669.7 647.5 1106.6 13.644 14,334 4,772 5,008 4,554 3,817 295.2 239.2 391.3 P 045 289.5 132.1 60.9 96.5 41.253 3,865 2,252 915 698 1,801 71.0 47.9 56.3 P 046 252.3 75.7 77.4 99.2 22.902 6,859 2,119 2,383 2,357 1,696 241.8 163.6 223.6 P 047 1108.1 404.1 277.9 426.1 15.470 10,716 4,902 1,829 3,986 3,921 404.3 203.8 440.0 P 048 5928.3 1924.0 1669.1 2335.2 10.204 17,508 3,805 3,084 10,618 3,044 705.3 623.8 930.1 P 049 3385.2 1183.7 752.8 1448.6 8.002 20,301 3,464 3,730 13,107 2,771 1,135.5 564.1 1,201.3 P 050 1249.0 461.6 192.7 594.7 19.323 8,762 2,847 1,777 4,137 2,278 239.7 76.9 286.6 P 051 1710.2 661.4 325.2 723.5 11.703 14,769 2,252 3,516 9,001 1,801 620.5 237.9 499.4 P 052 3867.2 1381.1 687.2 1799.0 10.915 17,964 2,341 3,144 12,478 1,873 794.1 271.8 903.1 P 053 257.8 70.8 43.9 143.1 9.155 14,607 7,905 1,716 4,985 6,324 84.0 119.2 167.9 P 054 863.3 347.8 109.7 405.8 18.713 7,779 2,910 1,072 3,796 2,328 169.1 57.1 198.4 P 055 1063.6 383.6 204.8 475.3 24.755 6,446 1,533 1,278 3,636 1,226 164.5 97.1 216.2 P 056 1105.9 456.6 209.8 439.5 22.957 6,785 2,117 1,266 3,402 1,694 226.1 80.6 154.2 P 057 1464.8 654.8 218.3 591.7 15.777 9,503 2,681 1,240 5,582 2,145 285.0 88.7 230.6 P 058 2943.6 1066.0 557.1 1320.5 9.114 14,973 4,652 3,555 6,766 3,722 811.0 340.6 1,131.6 P 059 496.4 120.8 210.7 164.9 13.303 9,545 2,844 3,431 3,270 2,275 307.2 415.3 359.0 P 060 163.1 64.3 34.7 64.2 20.885 5,849 1,934 1,144 2,771 1,548 46.0 21.9 36.0 P 061 910.7 36.4 392.9 481.4 16.275 8,250 302 3,191 4,757 242 89.1 511.0 413.7 P 062 644.2 227.3 130.6 286.2 18.032 7,509 1,310 995 5,205 1,048 129.0 56.8 114.0 P 063 720.3 217.1 99.8 403.4 23.675 5,830 1,324 843 3,662 1,059 86.4 44.5 400.3 P 064 3581.2 1205.6 976.5 1399.1 8.464 15,951 3,797 4,131 8,023 3,038 746.7 588.0 767.4 P 065 10673.1 3723.3 1996.9 4952.9 10.302 22,867 6,588 4,032 12,247 5,271 1,459.3 643.6 1,530.6 P 066 572.1 236.3 110.3 225.5 42.151 3,427 826 610 1,992 661 102.7 52.6 89.7 P 067 289.5 108.7 52.3 128.5 45.832 2,678 775 622 1,281 620 73.5 38.5 68.7 P 068 833.8 322.4 177.5 333.9 16.045 7,618 2,022 1,173 4,422 1,618 175.6 79.9 136.8 P 069 392.3 166.8 70.6 155.0 39.000 3,341 1,042 882 1,417 834 67.0 34.5 53.6 P 070 306.5 99.8 62.0 144.7 22.063 5,524 1,433 1,889 2,202 1,146 48.4 36.8 93.7 P 071 185.4 43.4 55.4 86.5 78.846 1,671 377 234 1,061 302 31.5 24.9 40.0 P 072 410.1 131.6 99.4 179.1 20.885 5,865 1,244 923 3,699 995 100.9 60.8 151.8 P 073 1021.5 379.2 228.9 413.5 10.805 10,694 3,538 3,000 4,156 2,830 334.6 155.8 335.0 P 074 753.4 304.3 128.2 320.9 21.175 6,095 1,675 788 3,632 1,340 316.8 122.4 264.6 P 075 2510.1 795.9 672.3 1041.9 11.821 10,118 3,650 1,261 5,208 2,920 354.4 260.6 555.2 P 076 901.9 339.5 180.2 382.2 12.319 9,653 2,615 1,961 5,077 2,092 168.9 89.2 236.9 P 077 3079.0 1181.0 531.9 1366.1 11.020
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern