At Westonci.ca, we connect you with the best answers from a community of experienced and knowledgeable individuals. Join our Q&A platform and connect with professionals ready to provide precise answers to your questions in various areas. Our platform offers a seamless experience for finding reliable answers from a network of knowledgeable professionals.

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.