formula sheet [Compatibility Mode] - Microsoft Word Mailings Review View 12 Home Insert Page Layout References *Cut En Copy Paste Times New Roman BIU abe x, x Aa Format Painter Clipboard Font 2-- --- --- --- -- ID#: F AaBbCcDc AaBbC AaBbC AaBbCcDc AaBbCcDd AaBbCcI AaBb( AaBbCcDc A Find ab Replace Emphasis Heading 1 1 Heading 4 Normal Strong Subtitle Title 1 No Spaci... Change Styles Select Paragraph Styles Editing 3456 Formula Sheet - Final Exam MGT606 - Operations Management ID#: I 1. Efficiency - Actual output/Effective capacity 2. R-B-a (AB) 3.8-2-68 Productivity - Output Input Order amount (Q) = T QOH + Back orders (X^is Xaverage) a Y-bX (Yi Yaverage) 4. b = (n Exy-Exy)/[n Ex-(Ex] 5. FIT new forecast (F) + trend correction(T) 6. Mini (LT x Usage) 7. Maxi EOQ+(ROL Min) & TIC (Q2)H+(D/QJOC 9. Interval - Annual Work Days/ # of Orders 10. MAD (forecasters In b=([XY-XX") (x-X^) ROL (LT x Usage) x Buffer Number of Orders - D/EOQ BOQ=(2xDxOC)/H 35. Utilization Time activated/Time available MSE-(forecast errors/n 11. Total Cost FC+VC 25. Cycle time Production time / Production units 26. Line Efficiency- Task time / # of Stations x Cycle time 27. Utilization Actual output/Design capacity 28. Expected output-Effective capacity x Efficiency Avg. Co. time Flow time / of jobs 29. Avg. # of jobs - Flow time/ work time 30. R, -R, x R x R x ... R Efficiency Actual output/Effective Capacity P-F/(1+i) P-FX Utilization Total processing time Flow time Avg. job lateness = Late days # of jobs FR (%) # of Failures / # of Units tested x 100 31. FR (N) # of Failures/# of Unit-hours of operation time MTBF-1/FR(N) 32. Redundancy (Probability of 1" component working) + (Prob. of 2 working) x (Prob, of needing 2) 33. E/distance- 34. Ridistance= d4B = |xxg|+|-| Q-Number of pieces per order EOQ-Optimum order quantity (0) D-Aral demand in units S-Setup or ordering cost for each onder H Holding or carrying cost per unit per p-Daily production P-Price I-Aalstory carrying cost as a percentage of price -Mean demand d-Standard deviation x-Mean demand Safety stock Z-Standardized value under the normal ROP-Expected demand + safety stock year in dollars d-Daily demand rate Z value @ 99% -2.33 EOQ: 12. Z value @95% = 1.645; Z value @ 97% -1.88; 13. Seasonal Index - Average 2009-2010 monthly demand/Average monthly demand 14. S(-) / (n 2) 15. r = (QLXX-ELX)/ [n[x - (Ex)'] [n[y - ()'] 16. Utilization Actual output/Design capacity 17. Expected output = (Effective capacity) (Efficiency) 18. Contribution - Selling price - Variable cost 19. B.E.PFixed cost/Contribution per unit SE-Ey-b/(n-2) NPV: P=F/(1+i) Q*=2DS/IP TC = (D/QJOC+(QH)/2+ PD H-IP Quantity discount EOQ model 206 (12-1) (12-10) EOQ production order quantity model Probability model 200 HI-(p (12-7) Safety stock 20-x- (12-14) Total cost for the EOQ and quantity discount EOQ models TC-Total cost -Setup cost Holding cost+Product cost (12-9)- 36. Discount Factors 20. B.E.P., (Fixed cost x Selling price)/Contribution per unit Year 5% 6% 7% 10% 12% 15% 20% 21. Sales for target profit=(Fixed cost+ Target profit) / Contribution per unit 1 0.952 0.943 0.935 0.909 0.893 0.869 0.833 2 0.907 0.890 0.873 0.826 0.797 0.756 0.694 22. EMV = (Payoff of 1" state) x (Probability of 1" state) + (Payoff of 2 state) x (Probability of 2 state)+---- (Payoff of last state) x (Probability of last state) 3 0.864 0.840 0.816 0.751 0.712 0.658 0.579 4 0.823 0.792 0.763 0.683 0.636 0572 0.482 23. SMA Demand/n WMA (Demand x Weight)/ Weight 3 0.784 0.747 0.713 0.621 0.567 0.497 0.402 Page: 1 of 4 Words: 581 60% formula sheet [Compatibility Mode] - Microsoft Word Mailings Review View 12 AaBbCcDc AaBbC AaBbC AaBbCcDc AaBbCcDd AaBbCcI AaBb( AaBbCcDc A Find ab Replace Emphasis Heading 1 T Heading 4 Normal Strong Subtitle Title 1 No Spaci... Change Styles Select F Paragraph Styles Editing Home Insert Page Layout References *Cut Times New Roman En Copy Paste BIU abe x, x Aa Format Painter Clipboard Font Page: 3 of 4 Words: 581 ID#: Table - Normal Distribution 2 Page 3 of 4 ID#: 20 32 14 16 00 " 5000 5040 5120 5160 5199 5139 5219 5319 5359 5398 508 5478 5517 5557 35% 5636 3475 5714 5353 5193 5812 5871 SHI 4036 4141 179 4217 4293 3 443 4517 A 554 451 4700 4736 4772 1879 3 4954 S 7019 3854 2008 3057 3190 7224 3291 3334 7151 3389 3422 3454 3406 2549 362 7671 3704 3734 3794 7823 2012 3939 347 1995 3051 3116 3212 3264 3340 145 389 13 301 3461 3415 3500 1531 1554 3571 3599 3421 3445 M 20 790 3849 3904 1942 1980 3997 015 13 012 300 9003 9099 9115 9131 3147 177 9001 3232 3234 9251 9265 3292 9306 13 3045 9953 9330 9383 3406 3411 14 9452 1474 3434 3415 9505 9515 9535 9545 9554 3544 3571 9582 350 3616 425 3449 1454 3664 3471 9678 20 399 3004 L 9713 3726 9732 3750 3754 904 20 3172 9793 8006 9812 21 3821 9024 9830 9834 3046 3850 3854 22 3844 3848 9021 9815 3890 30% 9901 9904 3906 3909 9913 9916 24 9930 9922 9925 9932 9934 9936 9940 9941 3948 390 3951 9952 9953 9955 9956 971 992 9943 1964 27 95 9966 3967 9970 9972 9973 M14 28 9974 9915 9913 9978 9979 9982 3982 9906 3986 10 5987 3990 9990 9991 9992 9992 9993 994 994 3994 9995 9995 9995 13 9995 3995 9996 3996 3996 99% 9997 14 9990 3997 9993 Transportation Matrix Demand For Supply From Period 1 Period 2 Period 3 Beginning inventory Regular time Overtime Subcontract Regular time Overtime Subcontract Regular time Overtime Subcontract Total Demand Total Unused Capacity Capacity Available (Dummy) (Supply) Page 4 of 4 60%