please answer all requirements and data tables (excel) are included in screenshots!!

The Mack Repair Shop repairs and services machine tools. A summary of its costs (by activity) for 2020 is as follows: (Click the icon to view data.) Read the requirements. GBED Requirement 1. Classify each cost as value-added, non-value-added, or in the gray area between a. Materials and labor for servicing machine tools b. Rework costs c. Expediting costs caused by work delays d. Materials-handling costs e. Materials-procurement and inspection costs f. Preventive maintenance of equipment g. Breakdown maintenance of equipment 1 Data table a. Materials and labor for servicing machine tools $ 880,000 b. Rework costs 175,000 C. Expediting costs caused by work delays 100,000 d. Materials-handling costs 50.000 e. Materials-procurement and inspection costs 110,000 f. Preventive maintenance of equipment 90,000 g. Breakdown maintenance of equipment 95,000 The Mack Repair Shop repairs and services machine tools. A summary of its costs (by activity) for 2020's as follows: Click the icon to view data) Read the requirements Requirement 1. Classify each cost as value-added, non-value-added, or in the gray area between 1. Materials and labor for servicing machine tools b. Rework costs c. Expediting costs caused by work delays d. Materials-handling costs e. Materiais procurement and inspection costs f. Preventive maintenance of equipment 9. Breakdown maintenance of equipment Requirements 1. Classity each cost as value added, non-value-added, or in the gray area between 2. For any cost classified in the gray area, assume 38% is value-added and 62% is non-value-added. How much of the total of all seven costs is value-added and how much is non-value-added? 3. Mack is considering the following changes: (a) introducing quality-improvement programs whose net effect will be to reduce rework and expediting costs by 80% and materials and tabor costs for servicing machine tools by 5% (D) working with suppliers to reduce materials procurement and inspection costs by 50% and materials-handing costs by 60% and (c) increasing preventive maintenance costs by 40% to reduce breakdown-maintenance costs by 20% Calculate the effect of programs a), b), and clon value-added costs, non value-added costs, and total costs. Comment briefly Print Done