Please help me to solve this in excel only with the calculations and the process in order to get the result the image is for problem 1 thank you !Problem 1 # An assembly line requires two components: gadjits and widjits. Gadjits are produced by center 1 and widjits by center 2. Each unit of the end item, called a jit-together, requires three gadjits and two widjits, as shown in Figure 6.14. The daily production quota on the assembly line is 800 jit-togethers. Figure 6.14 Components for End Item J The container for gadjits holds 80 units. The policy variable for center 1 is set at 0.09. The average waiting time for a container of gadjits is 0.09 day, and 0.06 day is needed to produce a container. The container for widjits holds 50 units, and the policy variable for center 2 is 0.08. The average waiting time per container of widjits is 0.14 day, and the time required to process a container is 0.20 day. a. How many containers are needed for gadjits? b. How many containers are needed for widjits? Problem 2: Jill's Job Shop buys two parts (A & B) for use in their production system. The parts are needed throughout the entire 52-week year. Part A is used at a constant rate and are ordered whenever the quantity drops to a specific reorder point (continuous review). Part B is ordered from a supplier who visits every 3 weeks to assess stock and place orders (periodic review). Data for both A & B are shown below: Item Part A Part B Annual Demand12,0005,000 Holding Cost (% of item cost)15%10% Setup/Order Cost $100 $20 Lead time6 weeks2 weeks Safety stock60 units 10 units Item Cost $10.00 $3.00 a) What's the inventory control system (Reorder Qty & Reorder Point) for Part A? b) What's the inventory control system (Reorder Qty & Reorder Point) for Part B?