5. Answer with complete excel solutions please!

Question 5 1 pts Gible Company's quality cost report is based on the following data: Liability arising from defective products P 83,000 Lost sales due to poor quality 89,000 Supervision of testing and inspection activities 11,000 Downtime due to defects 83,000 Reliability testing 56,000 Test and inspection of in-process goods 39,000 Rework labor and overhead 72,000 Disposal of defective products 76,000 Re-entering data because of keying errors 18,000 Test and inspection of incoming materials 60,000 P would be the Total Appraisal Cost appearing on the quality cost report