HELP ASAP

1 x Data Table S 2,500 units 2,000 1,100 1,300 1.0 hours 10% Number of units manufactured and sold Selling price per unit... Variable manufacturing and selling costs per unit. Hours spent by engineers improving design... Testing and inspection hours per unit..... Percentage of units reworked in the plant after inspection Average variable rework costs per freezer.... Percentage of units repaired under warranty at customers' homes Average variable repair costs at customers' homes per freezer. Estimated lost sales due to quality.reputation........ Design engineer's labor rate (includes benefits and payroll taxes) Inspection costs per hour.. S 480 5% 520 550 units $90 per hour $60 per hour Requirement 1. Prepare a Cost of Quality (COQ) report. In addition to calculating the total costs of each category, calculate the percentage of COQ category of the total COQ. (Round the percentage to the one tenth of a percent, X.X%. If an input field is not used in the table, leave the input field empty; do not select a label or enter a zero.) Gambrell Cost of Quality Report Costs Total Costs of Percentage of Total Costs Incurred Quality of Quality (Rounded) Prevention Costs: Design engineering Total prevention costs Appraisal Costs: Testing and inspection Total appraisal costs Internal Failure Costs: Rework (external) Total internal failure costs % External Failure Costs: Rework (internal) Lost profits due to poor reputation Total external failure costs Total costs of quality