NOTICE: HOVER OVER CELLS WITH RED INDICATOR SYMBOLS IN UPPER RIGHT CORNER TO READ IMPORTANT COMMENTS Production Costs Current Sales Year Projected Sales 0.07 Estm. Raw Raw Materials Materials Estm. Annual Raw -metals- Bicycle Materials Oursourc Compon types - Metals ed ents Selling Price Annual Sales- Sales- projecte Dec Jan Feb Mar Dec Jan Feb Mar this year d sales Shipping Costs Production Capacity per day Dec Parts Ordering Jan Feb Mar Warranty Liability Avg Use/day ROP FOR BRAKE PAD EOQ FOR BRAKE PADS 0 0 0 EXAMPLE FORMULA FOR ECONOMIC ORDER QUANTITY EOQ= /2(Annual usage in units)(Order cost) (Annual carrying cost per unit) Where Annual carrying cost = the Carrying costs % * unit cost Componen ts Sets Data EXAMPLE FORMULA FOR EPQ =SQRT(((2*10000*100))/(0.5*(1-60/80))) 0 0