7. Construct a trend analysis graph for the quality cost categories and the total. Quality cost data for a wheelbarrow manufacturer as a percent of net sales are as follows: Internal External Year Prevention Appraisal Failure Failure Total 1 0.2 2.6 3.7 4.7 11.2 2 0.6 2.5 3.3 3.6 10.0 3 1.2 2.8 4.0 1.8 9.8 4 1.2 1.7 3.4 1.2 7.5 1.0 1.3 1.8 0.9 5.0 8. For a homeowners' insurance organization, prepare graphs and analyze the internal failure costs for the past eight months using the labor index. Direct Labor Month Cost (Worker-hours) June $74,000 18,000 July $69,000 16,600 Aug. $71,000 17,300 Sept. $74,000 17,800 Oct $72,000 17,600 Nov. $74,000 17,500 Dec. $73,000 16,800 Jan $81,000 18,200 9. Prepare graphs and analyze the appraisal costs of a leading bank for the past eight months using the net sales index. Net Sales Month Cost (Thousands) Feb $45,000 $2,500 Mar. $43,500 $2,290 April $46, 100 $2,560 May $45,800 $2,540 June $47,000 $2,470 July $48,600 $2,550 Aug. $49,900 $2,500 Sept. $49,300 $2,580