1/3
Looks like no tags are added yet.
You will be given a list of financial items (collective in-class examples). First fill in the blank (last column) for each of the given DC data, assign to a carrying cost component (value of item, capital cost, storage space cost, inventory service cost, inventory risk cost, not included in ICC), each 0.5 point. Calculate the final ICC % (1 point). Interpret answer (2 pts) (i.e., what does final number mean; 25% rule of thumb); Evaluate answer (2 pts) (i.e., is it good/bad, how do you know, how to improve and why).
The total cost to hold this item as inventory or one year is (answer) of that item's value. The 25% rule of thumb is the typical benchmark. Here it’s above/below xyz points. This is bad/good because it is above/below 25%. To improve it, carry less inventory by better forecasting/shortening lead times, because every dollar not held avoids about xyz of annual cost and shrinks capital cost. Also reduce risk costs through better handling and use variable-cost storage so space cost scales with volume.
Practice Problem
Northcoast Outdoor sells a camping lantern. Use the data below.
Annual demand (D): 12,000 lanterns per year
Ordering cost (S): $50.00 per order
Unit cost: $20.00 per lantern
Annual inventory carrying cost: 20% of unit cost
Calculate: (a) EOQ, (b) annual ordering cost, (c) annual inventory cost, (d) total annual cost. Then (e) interpret the EOQ and (f) interpret the TAC. Round everything to 0.00 and include units. Then interpret EOQ + TAC, then suboptimization.
Step 0: Annual holding cost per unit
H = 20% × $20.00 = $4.00 per lantern per year
(a) EOQ
EOQ = √(2DS / H) = √(2 × 12,000 × $50.00 / $4.00) = √300,000 = 547.72 lanterns per order
(b) Annual ordering cost
(D / Q) × S = (12,000 / 547.72) × $50.00 = 21.91 orders × $50.00 = $1,095.45 per year
(c) Annual inventory (holding) cost
(Q / 2) × H = (547.72 / 2) × $4.00 = 273.86 × $4.00 = $1,095.45 per year
(d) Total annual cost (TAC)
TAC = ordering + inventory = $2,190.89 per year
The EOQ of 547.72 lanterns per order gives Northcoast the lowest combined cost of ordering and holding inventory. They should order about 548 lanterns (equilibrium point) at the EOQ, AOC ($1,095.45) equals AIC ($1,095.45), where the two curves cross and total cost is the lowest. Different amounts will unbalance it. They’re negatively correlated: order size rises = fewer orders → ordering cost falls. Average inventory rises = inventory cost goes up. Suboptimization: if bulk buying cuts ordering costs or warehousing cuts inventory costs by ordering small, each department’s own cost looks better, but total cost rises in both cases. The lowest cost comes from balancing costs than minimizing. Improving one cost in supply chain shifts cost elsewhere. Make choices based on total costs.
You will be given three separate sections to individually describe each of the three trade-offs between the number of DCs and related logistics costs (Transportation, Cost of Lost Sales, and ICC).
Supply-facing DCs consolidate supplier product so inbound full TLs get a low per-unit rate since fixed costs are spread out. Outbound loads are mixed to avoid costly LTL shipments. Strategically located DCs shorten delivery distances and lower outbound costs but split inbound volume. Shipments shrink and go from TL to LTL. Transportation cost hits a minimum, then rise once LTL penalties outweigh outbound savings. High substitutability = stockout sends the customer to competitors (sale’s lost), so DCs must be close. Low substitutability = customers wait, making distant DCs tolerable. DCs near key markets react faster to demand fluctuations and lower COLS (proxy for customer satisfaction) at a decreasing rate. Inventory positioning involves risk pooling. Aggregated demand is more stable since high demand offsets low demand. Centralized DCs need less safety stock than decentralized DCs. Total safety stock grows with the square root of the number of DCs (100 SD → split into 4 with 50 each, 200 total). When DCs are added, cycle inventory stays the same, safety stock falls but total safety stock rises. Optimal number of DCs balances transportation cost, COLS, and ICC.
-