File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share A. Colors 2 Width: 1 page 1Height: 1 page Scale: 86% Gridlines Headings View View B A Fonts Themes Margins Orientation Size Print Breaks Background Print Area Titles Bring Send Forward Backward Selection Align Group Rotate Pane O Effects Print Print Themes Page Setup Scale to Fit Sheet Options Arrange F42 X fic A B D E F G H 1 M N o P P d R S T U V w 3 4 5 6 0.0753 0.1141 0.1517 0.1879 0.2224 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 0.1 0.0398) 0.0438 0.0478 0.0517| 0.2 0.0793 0.0832 0.0871 0.091 0. 0.1179 0.1217 0.1255 0.1293 0.4 0.1554 0.1591 0.1628 0.1664 0.5 0.1915 0.195 0.1985 0.2019 0.6 0.2257 0.2291 0.2324 0.2357 0.7 0.258 0.2611 0.2642 0.2673 0.8 0.2881) 0.291 0.2939 0.2967 0.9 0.3159 0.3186 0.3212 0.3238 0.3413 0.3438 0.3461 0.3485 1.1 0.3643 0.3665 0.3686 0.3708 1.2 0.3849 0.3869 0.3888 0.3907 1.3 0.4032 0.4049 0.4066 0.4082 1.4) 0.4192 0.4207 0.4222 0.4236 1.5 0.4332 0.4345 0.4357 0.437 1.6 0.4452 0.4463 0.4474 0.4484 1.7 0.4554 0.4564 0.4573 0.4582 1.8 0.4641 0.4649 0.4656 0.4664 1.9 0.4713 0.4719 0.4726 0.4732 0.4772 0.4778 0.4783 0.4788 2.1 0.4821 0.4826 0.483 0.4834 2.2 0.4861 0.4864 0.4868 0.4871 2. 0.4893 0.4896 0.4898 2.4 0.4918 0.492 0.4922 0.4925 2.5 0.4938 0.494 0.4941 0.4943 2.6 0.4953 0.4955 0.4956 0.4957 2.7 0.4965 0.4966 0.4967 0.4968 2.8 0.4974 0.4975 0.4976 0.4977 2.9 0.4981 0.4982 0.4982 0.4983 0.4987 0.4987 0.4987 0.4988 3.1 0.499 0.4991 0.4991 0.4991 3.2 0.4993 0.4993 0.4994 0.4994 3.3 0.4995 0.4995 0.4995 0.4996 3.4 0.4997 0.4997 0.49971 0.4997 Instructions Formulas Z table Prob 1 0.0557 0.0948 0.1331 0.17 0.2054 0.2389 0.2704 0.2995 0.3264 0.3508 0.3729 0.39251 0.4099 0.4251 0.4382 0.4495 0.459 0.4671 0.4738 0.4793 0.4838 0.487 0.4904 0.4927 0.4945 0.4959 0.4969 0.4977 0.4984 0.4988 0.4992 0.4994 0.4996 0.4997 Prob 2 0.0596 0.0636 0.0987 0.1026 0.1368 0.1406 0.173 0.1772 0.2088 0.2123 0.2422 0.2454 0.2734 0.2764 0.3023 0.3051 0.3289 0.3315 0.3531 0.3554 0.3749 0.377 0.3944 0.3962 0.4115 0.4131 0.4265 0.4279 0.4394 0.4406 0.4505 0.4515 0.4599 0.4608 0.4678 0.4686 0.4744 0.475 0.4798 0.4803 0.4842 0.4846 0.4878 0.4881 0.4906 0.4909 0.4929 0.4931 0.4946 0.4948 0.496 0.4961 0.497 0.4971 0.4978 0.4979 0.4984 0.4985 0.4989 0.4989 0.4992 0.4992 0.4994 0.4994 0.4996 0.4997 0.4997 Prob 3 0.0675 0.1064 0.1443 0.1808 0.2157 0.2486 0.2794 0.3078 0.334 0.3577 0.379 0.398 0.4147 0.4292 0.4418 0.4525 0.4616 0.4693 0.4756 0.4808 0.485 0.4884 0.4911 0.4932 0.4949 0.4962 0.4972 0.4979 0.4985 0.4989 0.4992 0.4995 0.4996 0.4997 0.0714 0.1103 0.148 0.1844 0.219 0.2517 0.2823 0.3106 0.3365 0.3599 0.381 0.3997 0.4162 0.4306 0.4429 0.4535 0.4625 0.4699 0.4761 0.4812 0.4854 0.4887 0.4913 0.4934 0.4951 0.4963 0.4973 0.498 0.4986 0.499 0.4993 0.4995 0.4996 0.4997 0.2549 0.2852 0.3133 0.3389 0.3621 0.383 0.4015 0.4177 0.4319 0.4441 0.4545 0.4633 0.4706 0.4767 0.4817 0.4857 0.489 0.4916 0.4936 0.4952 0.4964 0.4974 0.4981 0.4986 0.499 0.4993 0.4995 0.4997 0.4998 25 0.4901 26 27 28 29 30 31 32 33 34 0.4996 35 36 Ready Accessibility: Investigate Page: 1 of 1 709 File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share A Colors H Gridlines Headings A Fonts Width: Automatic 1| Height: Automatic [K] Scale: 97% View View Themes Margins Orientation Size Print Breaks Background Print Area Titles Selection Align Group Rotate Pane Bring Send Forward Backward V O Effects Print Print Themes Page Setup Scale to Fit Sheet Options Arrange D26 : X fx A B C D E F G . J K L M N 0 P Add header Add header Click to add data 2 3 4 5 Ross White's machine shop uses 2,500 brackets during the course of a year, and this usage is relatively constant throughout the year. These brackets are purchased from a supplier 100 miles away for $15 each, and the lead time is 2 days. The holding cost per bracket per year is $1.50 (or 10% of the unit cost) and the ordering cost per order is $18.75. There are 250 working days per year. ein Nm 0 0 0 6 7 8 9 a) What is the EOQ? b) Given the EOQ, what is the average inventory? c) What is the annual inventory holding cost? d) In minimizing cost, how many orders would be made each year? e) What would be the annual ordering cost? f) Given the EOQ, what is the total annual inventory cost (including purchase cost)? g) What is the time between orders? h) What is the ROP? 10 11 12 13 14 15 16 17 18 19 20 21 Instructions Formulas Z table Prob 1 Prob 2 Prob 3 (+ Ready Accessibility: Investigate Page: 1 of 1 100