Discover the answers you need at Westonci.ca, a dynamic Q&A platform where knowledge is shared freely by a community of experts. Get precise and detailed answers to your questions from a knowledgeable community of experts on our Q&A platform. Join our platform to connect with experts ready to provide precise answers to your questions in different areas.

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.