Input Data Number of suppliers = 8 Number of retail stores = 32 Demand per store from each supplier = 50000 Cost per large trailer = $1,000 Cost per small truck = $400 Large trailer capacity = 40,000 Small truck capacity = 10,000 Holding cost per unit per year = $1.00 Cost / large truck stop = $150 Cost / small truck stop = $50. Question 2: Compute the total cost (holding and trucking) of Illinois's current direct shipping network in cells E31 using small full truck loads when optimal lot sizes are shipped. Hint: To compute the optimal batch (lot) size shipped you will have to compute the EOQ amount to be shipped for meeting the annual demand. You will have to understand the setup cost (fixed cost) and holding cost from the data given in cells B2:B11. Once you do that follow the same sequential computations as you did for question 1