Week 3 Assignment -- PART ONE You are the company's Supply Chain Manager -- solve the below questions to ensure an optimal ordering policy. Annual requirements (R) = Order cost (S) = Holding rate (k) = Unit cost (C) = Lead time (LT) = Number of days per year = 16,242 $58.00 28.0% $59.87 10 365 units per oder annually per unit days days $12 $10 $8 Compute the following: Annual cost, $ $6 P $4 a) EOQ = units $2 EOQ (rounded to nearest whole item) units b) total purchase cost = $0 0 200 c) annual holding cost = Quan d) annual order cost = e) total annual logistics cost = (without purchase cost) f) reorder point units g) number of orders placed per year = orders Note: You must include formulas for full credit h) time between orders = days i) plot cost curves -- holding cost, order cost and total cost. Use the layout below the questions, and the graph will be creat j) If you are required to order by the whole case, at 20-per case, what Q would you recommend? k) What is the additional Total Annual Logistics Cost of the Whole-Case Q? units Note: You must include formulas for full credit Note: You must include formulas for full credit l) Given your answer to K above, what does this say about the EOQ Formula? (Consider if you have to round EOQ, or if your forecast isn't exactly accurate, or if your other data is slightly wrong, etc...) Insert data for Question I here -----> Q 50 75 100 125 150 175 200 225 250 275 Annual Annual Holding Cost Ordering Cost Total Cost 300 325 350 375 400 425 450 475 500 525 550 575 600 625 650 675 700 725 750 775 800 825 850 875 900 l ordering policy. nual cost, $ EOQ Chart $12 $10 $8 $6 Annual Holding Cost Annual Ordering Cost Total Cost Place graph here.... $4 $2 $0 0 200 400 600 800 1000 Quantity per Order, Q de formulas for full credit -- do NOT simply type in answers. Add additional cells if necessary, but label each clearly! and the graph will be created automatically.) de formulas for full credit -- do NOT simply type in answers. Add additional cells if necessary, but label each clearly! de formulas for full credit -- do NOT simply type in answers. Add additional cells if necessary, but label each clearly! Week 3 Assignment -- PART TWO The following sample information was obtained by taking five doughnuts per hour for twelve hours from Fawcett Bakery Hour 1 2 3 4 5 6 7 8 9 10 11 12 a) Find the x-bar and R for each sample b) Find the x-bar-bar and R-bar for the twelve samples. x-bar = see above R= see above X-bar-bar = R-bar = Mean UCL = c) Find the 3-sigma UCL and LCL for the mean and range charts? Mean LCL = Range UCL = Range LCL = d) Does the process look to be in statistical control? Why or why not? e) Although you're not an expert on the doughnut making process, select 3 potential categories of process variation that should be evaluated in a Lean Sixsigma project -- and give a "doughnut making" example for each. 1st 105 98 97 106 108 125 115 95 113 106 95 110 1) 2) Weight (grams) 2nd 3rd 95 100 104 97 89 89 99 95 105 111 135 125 92 87 92 90 100 92 91 103 105 95 92 97 4th 102 87 95 93 109 132 89 96 82 118 82 86 Note: You must include formulas for full Assuming 3 standard deviations as contro 3) lve hours from Fawcett Bakery's doughnut process and weighing them. X-bar Average sample weight (g) 1.0 5th 97 106 91 101 107 137 94 94 102 93 107 94 x-bar R 0.8 0.6 X U LC 0.4 0.2 0.0 0 2 4 6 8 10 12 14 Sample # Place graph(s) here. Range Average sample weight (g) 1 0.8 0.6 R Column Column 0.4 0.2 0 0 2 4 6 8 10 12 14 Sample # u must include formulas for full credit -- do NOT simply type in answers. Add additional cells if necessary, but label each clearly! 3 standard deviations as control limits.... A2 = D4 = D3 = X-bar Range UCL 1 12 X-bar UCL LCL 12 14 R Column AA Column AB 12 14 t label each clearly! LCL 0.0 0.0 UCL 0.0 0.0 0.0 0.0 LCL 0 0.0