i figured out most of them. can you please help me fill in the rest. i need help.

Cost of quality report A quality control activity analysis indicated the following four activity costs of a hotel: Inspecting cleanliness of rooms $87,400 174,800 Processing lost customer reservations Rework incorrectly prepared room service meal 131,100 43,700 Employee training Total $437,000 Sales are $4,600,000. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. X Open spreadsheet Prepare a cost of quality report. Round the percents of total quality cost to the nearest whole number and the percents of total sales to one decimal place. Cost of Quality Report Quality Cost Classification. Quality Cost Percent of Total Quality Cost Percent of Total Sales 10 0.9 X 43,700 Prevention prace Quality Cost Classification Prevention Appraisal Internal failure External failure Total Cost of Quality Report Feedback * Hver and the percents of total sales to one de Percent of Total Sales 0.9 X 1.9 2.9 % 3.8 29 X Quality Cost 43,700 87,400 131,100 174,800 437,000 % % Check My Work Cinelfach selte alther inntinn annales Internal falli nutral failure that the stat Percent of Total Quality Cost 10 % 20 % 30 40 100 % % % % % Process Activity Analysis The Brite Beverage Company bottles, soft drinks into aluminum cans. The manufacturing process consists of three activities: 1. Mixing: water, sugar, and beverage concentrate are mixed. 2. Filling: mixed beverage is filled into 12-oz. cans. 3. Packaging: properly filled cans are boxed into cardboard "fridge packs." The activity costs associated with these activities for the period are as follows: Mixing $505,000 Filling 447,500 Packaging 97,500 Total $1,050,000 The activity costs do not include materials costs, which are ignored for this analysis. Each can is expected to contain 12 ounces of beverage. Thus, after being filled, each can is automatically weighed. If a can is too light, it is rejected, or "kicked." from the filling line prior to being packaged. The primary cause of kicks is heat expansion. With heat expansion, the beverage overflows during filling, resulting in underweight cans. This process begins by mixing and filling 7,800,000 cans during the period, of which only 7,500,000 cans are actually packaged. 300,000 cans are rejected due to underweight kicks. A process improvement team has determined that cooling the cans prior to filling them will reduce the amount of overflows due to expansion. After this improvement, the number of kicks is expected to decline from 300,000 cans to 75,000 cans, thus increasing the number of filled cans to 7,725,000 [7.500.000+ (300,000 - 75,000). a. Determine the total activity cost per packaged can under present operations. Round to the nearest cent. 0.14 per can enow.com/ilm/takeAssignment/takeAssignmentMain.do?invoker &takeAssignmentSessionLocator=&inprogress.... A Sign in eBook Print Item Packaging 97,500 Total $1,050,000 The activity costs do not include materials costs, which are ignored for this analysis. Each can is expected to contain 12 ounces of beverage. Thus, after being filled, each can is automatically weighed. If a can is too light, it is rejected, or "kicked," from the filling line prior to being packaged. The primary cause of kicks is heat expansion. With heat expansion, the beverage overflows during filling, resulting in underweight cans. This process begins by mixing and filling 7,800,000 cans during the period, of which only 7,500,000 cans are actually packaged. 300,000 cans are rejected due to underweight kicks. A process improvement team has determined that cooling the cans prior to filling them will reduce the amount of overflows due to expansion. After this improvement, the number of kicks is expected to decline from 300,000 cans to 75,000 cans, thus increasing the number of filled cans to 7,725,000 [7,500,000+ (300,000 - 75,000)], a. Determine the total activity cost per packaged can under present operations. Round to the nearest cent. 0.14 per can