M4.2. The fabrication department for an automobile component plant is scheduling its work for next month. The plant produces the
following four components: A1, B2, C3, and D4. Each component must go through three departments during the fabrication process. After fabrication, each valve is inspected by a human being, who spends 15 minutes per valve. There are 450 inspection hours available for the month. The time required (in hours) for each department to work on each component is shown in the following table. Also shown are the minimum number of components that must be produced for the month and the unit profit for each component. Formulate and solve the problem in Excel to determine the number of each product to manufacture that meets the requirements and maximizes profits. I need help finding the inspection values. My Optimal Solution should be 21,000.
