Anvils Works' requires, on average, 2,700 tons of aluminum each week, with a standard deviation of 1,100 tons. The lead time to receive its orders is 8 weeks. The holding cost for one ton of aluminum for one week is $9. It operates with a 0.99 in-stock probability.

a. On average, how many tons does it have on order?

b. On average, how many tons does it have on hand?

c. If its average inventory was 9,500 tons, what would be its average holding cost per week?

d. If its average inventory was 8,000 tons, what would be its average holding cost per ton of aluminum?

e. Suppose its on-hand inventory is 5,275 tons, on average. What in-stock probability does it offer to its customers? Hint: use the =NORM.S.DIST(z,1) Excel function.