WEEK 5Free Manufacturing Company (FMC) is based in San Diego, California. FMC wants to determine the cost of quality for the products it manufactures.Requirements:Categorize the costs into: Prevention

WEEK 5

Free Manufacturing Company (FMC) is based in San Diego, California. FMC wants to determine the cost of quality for the products it manufactures.

Requirements:

1. Categorize the costs into: Prevention, Appraisal, Internal Failure, and External Failure Costs
2. Compute the total costs for each category. Round answers to four decimal points.
3. Compute the percentage of revenue for each category. Round answers to four decimal points.
4. Compute the Total Costs of Quality. Round answers to four decimal points.

Follow the instructions on the Data tab of the worksheet linked in Module 5. Show all calculations within the cells of the Excel spreadsheet. This means that you must use formulas and links so that your thought process can be examined. You must also include a detailed explanation of each journal entry that you make or do not make on each date to convey your thought process. There should be no hard coding of solutions.

Review the grading rubric to understand how you will be graded on this assignment. Reach out to your instructor if you have questions about the assignment.

Submit your downloaded and completed Excel file (with your name added to the file name) to the CT Assignment dropbox for Module 5.