can use excel to solve

Question-3. Consider a simple manufacturing process as illustrated in the given figure. Assuming that demand is 3,000 units, what is the required input (I1) to meet demand? The defective rates are shown in the figure. Question-4 During three eight-hour shifts, 4200 non-defective parts are desired to produce. The standard time to complete the operation is 15 minutes, but the actual time to perform the operation takes longer and it is 25 minutes. Also it is known that 10% of the parts that begin production are scrapped. Suppose that each of the machines used for this operation will not be available for two hours of each shift, determine the number of machines required. Question-5. It takes 6 minutes to load and 4 minutes to unload a machine. Inspection, packing, and travel between machines totals 4 minutes. Machines run automatically for 30 minutes. Operators cost $20 per hour; machines cost $50 per hour. a. What is the maximum number of machines that can be assigned to an operator without creating machine idle time? b. What is the number of machines that minimizes the cost