We have the following data: D = 5200, S = $200, and I[h] = 28%. Using Discount Table 12.2 and Equation (10), the EOQ for the price of $96 is equal to = 278 units. Because 278  

Solve in excel and show formulas

TABLE 12.2 A Quantity Discount Schedule PRICE RANGE QUANTITY ORDERED PRICE PER UNIT P 1-119 $100 Initial price Discount price 1 Discount price 2 $ 98 120-1,499 1,500 and over $ 96 A B D E F G G 1 Quantity Discount Models 2 Datas 3 D= 5200 200 28% 4 S= 5 I= 6 7 Discount 8 original price 9 First Discount 10 Second Discount 11 12 13 Calculate EOQ 14 EOQ (a) 15 EOQ(b) 16 EOQ (C) Qty minimum Qtx Max 1 120 1500 New Price 119 $100 1499 $98 5000 $96 EOQ I, Decision Total Cost 273 275 278