topic : production & inv. system

please solve using excel, provide clear steps

Problem 1: 5 pts A manufacturer capacity is equal to 60 products per work day. The annual demand reaches 11,520 units per year. The manufacturer operates 6 days per week and 48 weeks per year. The cost to switch the production line from one type of product to the other is $50,000. It costs $1,000 to store on product for one year. a. What is the economic lot size? b. What is the total annual cost? Problem 2: 5pts A company A buys products from company B. The company B proposed discounts: -$50 per product on orders of 1 to 99 products -$49 per product on orders of 100 or more products. The ordering cost is $64 per order. The annual holding cost is 20 percent of the per unit purchase price. The annual demand is 500 products. What is the best purchase quantity