It is a case assignment. This case is SCM at beautiful bags. Could you please answers the questions with this case?

Answer the questions using the concepts, terminology and methodology covered in class, and all the facts presented in the case document. Make appropriate assumptions as necessary, similar to the ones shown in class. Use MS Excel to perform calculations and attach your Excel work file. Consult the instructor for guidance. Question: Analyze the following inventory management approaches for each of the three products (Exhibit 1), and calculate quarterly expected profits and determine which approach should be used for each product. a. Newsvendor model (single order from China). b. Two suppliers (as an extension of the Newsvendor), using the TJL facility for the quick response reactive capacity. Hint: Assume TJL provides flexible order timing and zero lead time. For simplicity, assume that TJL is equivalent to make-to-order. Hint: Assume any p (coefficient of correlation) value and "read period" duration. c. Use only the TJl facility as make-to-order. d. BONUS (25 points): Use only the Chinese supplier to implement a multi-period Periodic Review policy. Hint: Use T = 1 quarter, and make sure to calculate "quarterly" costs, including cost of the goods and holding cost of all associated inventory. Note that there are no "fixed costs of ordering" and freight cost is given as a variable/unit cost. Note: Instead of the holding cost rate of 10% given in the case, use the holding cost rates of 5%, 15% and 25% for the blue jeans, what's next, high fashion, respectively. Note: Since all demand information is given as "per quarter (1/4 of a year)", use "quarters" as your unit of time. Lead time from China is 120 days = 4/3 quarters. Note: Assume no backlogs are allowed (any unmet demand is lost forever)