***please check what i have si far and show excel calculations for all***

13 Analysis when embroidery is in Sri Lanka 15 Inputs 16 Anticipated demand 17 Standard deviation 18 Unit costs 19 Sales price 20 Disposal value 21 Inventory holding costs 22 23 24 Salvage value 25 Cost of understocking 26 Cost of overstocking 27 28 Outputs 29 Optimal cycle service level 30 Optimal production lot size 31 Expected profits 32 Expected overstock 33 34 IBM 4,000 2,000 $15 $50 $3 -849.07 17 AT&T 6,000 2,500 $15 $50 $3 HP 3,000 2,000 $15 $50 $3 Cisco 2,000 2,200 $15 $50 $3 Total

n .1. .... . , n.. AnyLogo supplies firms with apparel containing their logo to be used for promotional purposes. AnyLogo has four major customers - IBM, AT\&T, HP, and Cisco. During the holiday season, the logos are adomed with a Christmas motif. Demand from each firm for apparel with the Christmas motif is normally distributed, as shown in Table 13-7. AnyLogo currently produces all the apparel including the logo embroidery in Sri Lanka in advance of the holiday season. Each unit costs $15 and is sold by AnyLogo for $50. Any leftover inventory at the end of the holiday season is essentially worthless and cannot be repurposed for a different company. it is thus donated by AnyLogo to charity. Holding the apparel in inventory adds another $3 to the cost per unit donated to inventory. However, the donation allows AnyLogo to recover \$6 per unit in tax savings. What production quantities do you recommend for AnyLogo? What is the expected profit from the policy? On average, how much does AnyLogo expect to donate to charity each year