Prodiem soiving and Preaictive Analytics in Excel Semiconductor ManufacturingThe Slicon Circuit Company produces semiconductor chips on sllicon wafers. Each wafer has 20 slots for chips. The firm wants to produce two new chip types, SCA and SCB, on the same wafers. The production process is subject to random disturbances, and new chips often fall quality testing. Each SCA chip passes its qualify test with probability 80%, and each SCB chip pases with probability 60%.Slicon Circuit manufactures SMM modules by combining two good SCA chips and one good SCB chip. The management is considering assigning between 10 to 15 slots on each wafer to SCA chips, and the remaining slots to SCB chips.The total cost of production per SMM module is 520 while the Silicon Circuit earns 590 per SMM module sold. The buiness analyt at the Silicon Circuit Company is using a spreadsheet simulation model to help with their decision.You have access to the Excel shell that the analyat has built. As the hired new employee, help the business analgst conclude the needed predictive analytics to:Choose the option which maximizes the mean total profit.Predict the chance that the number of SMM modules assembled from the chips on one wafer is greater than three.Predict the # of SMM modules on one wafer.Hints: IWT PUNCTION: Number). This function rounds a number down to the nearest integer. For example, NTT (8.2)=8, INT (8.9)=8, INTT (-5.4)=-6You thould use the INT function in assessing the number of SSM modules that can be assembled from the chips manufactured on one wafer, Since we cannot bring fractional SSM modules to the market, the produced SSM modvle must be an integer quartity.The Task: Develop the Excel model with the given data and inputs to determine the best course of action.Use a sample sise of 1000. Do two simulation runs. Verify the best action with two simulation ruins. Highlight the best choice clearly through sampling from the computer.