please develop your answers using EXCEL

Problem-1) (Order Fill Rate and Service Level) Central Hospital Supply has a policy that a hospital can expect its orders to be filled directly from stock 92 percent of time. If any one item on an order is out of stock, the entire order will be held as a back order to avoid additional shipping costs. Order typically include up to ten items. A sampling of the orders over the last year shows that six combinations of products frequently appear on orders, as follows: Order Item Frequency of Order Combinations A,C,F,G,I 1 0.20 2 B,D,E 0.15 3 E,FI.J 0.05 4 A,B,C,D,F,H,J 0.15 5 0.30 D,F,G,H,I,J A,C,D,E,F 6 0.15 1.00 Inventory levels have been set so that products A, B, C, D, E, and F (i.e., Group 1) have a common service level of 0.95 each. The remaining products (i.e., Group 2) are set at 0.90 each. Q1) Is the firm meeting its inventory service target? Q2) If not, at what item service levels would these two groups of products have to be set to meet the 92 percent order fill rate? Tip) One possible way is to find out the values for two groups based on trial-and-error approach to satisfy the given target service level. The other way is to find out them using the Excel solver by assuming them as decision variables while the target service level could be the objective function with a target value