Problem 10-30 Please respond in copy able excel format NOT IN JPEG please. Kindly also show the calculation workings.

Thank you

Safe Travel produces car seats for children from newborn to 2 years...

Safe Travel produces car seats for children from newborn to 2 years old. The company is worried because one of its competitors has recently come under public scrutiny because of product failure. Historically, Safe Travel's only problem with its car seats was stitching in the straps. The problem can usually be detected and repaired during an internal inspection. The cost of the inspection is $5.00 per car seat, and the repair cost is $1.00 per car seat. All 200,000 car seats were inspected last year, and 5% were found to have problems with the stitching in the straps during the internal inspection. Another 1% of the 200,000 car seats had problems with the stitching, but the internal inspection did not discover them. Defective units that were sold and shipped to customers needed to be shipped back to Safe Travel and repaired. Shipping costs are $8.00 per car seat, and repair costs are $1.00 per car seat. However, the out-of-pocket costs (shipping and repair) are not the only costs of defects not discovered in the internal inspection. Negative publicity will result in a loss of future contribution margin of $100 for each external failure.

Required:

1. Calculate appraisal cost.
2. Calculate internal failure cost.
3. Calculate out-of-pocket external failure cost.
4. Determine the opportunity cost associated with the external failures.
5. What are the total costs of quality?
6. Safe Travel is concerned with the high up-front cost of inspecting all 200,000 units. It is considering an alternative internal inspection plan that will cost only $3.00 per car seat inspected. During the internal inspection, the alternative technique will detect only 3.5% of the 200,000 car seats that have stitching problems. The other 2.5% will be detected after the car seats are sold and shipped. What are the total costs of quality for the alternative technique?
7. What factors other than cost should Safe Travel consider before changing inspection technique