440.Sp13.Homework2.Data(1)

Co value value value value value lt 7 s ta nda rd

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: LUE! #VALUE! #VALUE! #VALUE! #VALUE! LT 7 S ta nda rd Dev 5 da ily dema nd #VALUE! rop(dlt) #VALUE! = rop with 1% #VALUE! EOQ #VALUE! #VALUE! #VALUE! TC #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! Ea ch employee ca n ma ke this ma ny ba tches Ea ch employee ca n this # of ba tches #VALUE! Qua rter 3 Qua rter 3 hours/ea ch employees # of ba tches Qua rter 3 hours/ea ch employees # of ba tches Qua rter 3 ga llons/ea ch employees # of ba tches #VALUE! Holding cost if cha nged to 6 50 2.9 25 2.9 25 Holding cost in compa rison to 1000 #VALUE! #VALUE! #VALUE! Name IDNumber AssignmentName Term SubmissionVersion Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Added name Michelle Higgins 399084 Homework 2 SP13 1 ### Wendy Keyes Michelle Higgins ### Wendy Keyes Michelle Higgins ### Wendy Keyes Michelle Higgins demand cost per holding lead time per week pair order cost rate (weeks) 1500 $50 $85 20% 1 EOQ 159.68719 ROP 10500 Cycle Time 0.7452069 Total Annual Cost $876.88 disk cost order cost annual usecost of capital $0.20 $15 60000 25% daily daily printing holding working days production demand setup cost 250 6000 3500 $300 $0.02 EPQ $2,786.80 Production runs $2.15 TC= $166,916.14 P= Demand/P 875000 0 Visitors Holding Cost Order Cost 18000 20% 30 Order Size 0 to 1500 to 3000 or more Discount Unit Cost Ch(i) EOQ(i) TC(eoq) TC(min) 1449 0% $2.50 $0.50 1469.6938 $1,102.85 #DIV/0! 2999 5% $2.20 $0.44 1566.699 $1,128.55 $690.00 10% $1.80 $0.36 1732.0508 $1,178.46 $720.00 Weekly Demand Cost 40 Order Cost $1 Order Size 0 to 500 to 1000 to 1800 to 2500 or more Holding Cost Rate $30 27% 499 999 1799 2499 Discount Unit Cost Ch(i) 0 1 0.06 1 0.1 1 0.12 1 0.15 1 0.27 0.27 0.27 0.27 0.27 EOQ(i) TC(eoq) TC(min) 94.2809 $60.40 94.2809 60.40158 $65.71 94.2809 60.40158 122.58 94.2809 60.40158 $214.43 94.2809 60.40158 $287.28 Selling Clearance Unit Cost Price Price $410 $750 $340 Cu Co Probability 234.246 $340 $70 83% m stddev 200 36 Weekly Stockout Demand Std Dev Risk 120 25 3% Daily Operating Profit per Loss per Cost Loaf Loaf Mu Std Dev $1,250 $0.25 $0.15 70000 5000 Cu Co $16,250.00 ($9,250.00) $0.64 71792.294 1250 cu co 0.0436508 53160.772 0.03 550 -12050 0.18 60000 4000 Holding Cost per Cost Per Weekly Demand Week Order LT 210 $0.01 $10 daily demand rop(dlt) rop with 1% 30 210 221.6317 EOQ 44.72136 TC $93.92 Standard Dev 7 5 Inventory Regular Holding Hours per Hours per Regular Overtime Cost per Beginning Employee Unit Labor Labor Quarter Inventory 550 27 $8 $12 $4.50 0 Holding cost in compariso n to 1000 Forecast Demand (per 1000 gallons) Quarter 1 2 3 4 Holding cost if changed to 650 2.925 400 700 850 650 Each employee can this # of batches 20.37037 Quarter 3 gallons/ea ch employee s # of batches 41.72727 0.0045 31.90909 Annual Interest Backorder Rate Unit Cost Cost 25% $800 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Demand 81 89 100 130 97 126 96 93 78 127 78 69...
View Full Document

This note was uploaded on 04/25/2013 for the course BUS 440 taught by Professor Rogers during the Spring '13 term at Berkeley.

Ask a homework question - tutors are online