BSOP 330 Week 4_Course Project Part 2_Data

BSOP 330 Week 4_Course Project Part 2_Data - Inventory...

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

View Full Document Right Arrow Icon
Inventory Economic Order Quantity Model Data Demand rate, D 300,000 Setup/order cost, S 1000 Holding cost, H 10 (fixed amount) Unit Price, P 200 Daily demand rate, d 0 Lead time in days, L 0 Results Optimal Order Quantity, Q* 7745.9666924148 Maximum Inventory 7745.9666924148 Average Inventory 3872.9833462074 Number of Orders 38.7298334621 Holding cost $38,729.83 Setup cost $38,729.83 Unit costs $60,000,000.00 $60,077,459.67 Reorder Point 0 COST TABLE Start at 1936.4917 Increment by 645.49722 Q Setup cost Holding costTotal cost 1936.4916731037 154919.33 9682.4584 164601.79 2581.9888974716 116189.5 12909.944 129099.44 3227.4861218395 92951.6 16137.431 109089.03 3872.9833462074 77459.667 19364.917 96824.584 4518.4805705753 66394 22592.403 88986.403 5163.9777949432 58094.75 25819.889 83914.639 5809.4750193111 51639.778 29047.375 80687.153 6454.972243679 46475.8 32274.861 78750.661 7100.4694680469 42250.727 35502.347 77753.075 7745.9666924148 38729.833 38729.833 77459.667 8391.4639167827 35750.616 41957.32 77707.935 9036.9611411506 33197 45184.806 78381.806 9682.4583655186 30983.867 48412.292 79396.159 10327.9555898864 29047.375 51639.778 80687.153 10973.4528142543 27338.706 54867.264 82205.97 11618.9500386222 25819.889 58094.75 83914.639 12264.4472629902 24460.947 61322.236 85783.184 12909.9444873581 23237.9 64549.722 87787.623 13555.441711726 22131.333 67777.209 89908.542 14200.9389360939 21125.364 71004.695 92130.058 14846.4361604618 20206.87 74232.181 94439.05 15491.9333848297 19364.917 77459.667 96824.584 16137.4306091976 18590.32 80687.153 99277.473 16782.9278335655 17875.308 83914.639 101789.95 Total cost, T c 1936.4916731037 6454.972243679 10973.4528142543 15491.9333848297 0 20000 40000 60000 80000 100000 120000 140000 160000 180000 Inventory: Cost vs Quantity Setup cost Holding cost Total cost Order Quantity (Q) Cost ($) Enter the data in the shaded area
Image of page 1

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

View Full Document Right Arrow Icon
Hardman Inventory Quantity Discount Model 450000 44999990.0% 45000 405250 Data Demand rate, D 200,000 Setup cost, S 1,000 Holding cost %, I 40.00% (percentage) Range 1 Range 2 Range 3 Range 4 Minimum quantity 10,000 30,000 60,000 250,000 Unit Price, P 2 1.9 1.8 1.5 Results Range 1 Range 2 Range 3 Range 4 Q* (Square root formula) 22360.68 22941.57 23570.23
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