The accounting manager is gathering data to form a cost allocation pool and cost allocation rate for materials handling costs at the Markleton Company, which makes outdoor furniture and signage from plastic resins. The manager is gathering data on the pounds of plastic resin processed in the month of January in each department. As a first step, the manager is cleaning the data that were downloaded from the company’s information system. An excerpt of those data is given in a screenshot here:

Questions1. What is one column that likely contains irrelevant data for this analysis?2. Which rows contain duplicate records?3. Which column needs to have its data standardized?4. What cell(s) contain missing data?5. In the Pounds processed column, which cell likely contains an outlier?

Transcribed Image Text:

A B Record Department 1 Locator 2 842ZE3 Outdoor furniture Plastic resin 3 23FA78 Signage 4 902L03 5 12YW21 Outdoor furniture Outdoor furniture Material Processed Additives Plastic resin PLASTIC RESIN 6 56XXC2 Outdoor furniture 7 92TL32 Outdoor furniture 8 33QC23 Signage 9 75RE33 Outdoor furniture Plstic rsn Signage Outdoor furniture Additives Plastic resin Plastic resin 10 49ZV84 11 7OLP34 12 43CZ76 13 56JWP9 Outdoor furniture 14 56JWP9 Outdoor furniture 15 08MQ64 Signage Plastic resin 16 19DFW2 Outdoor furniture Plastic resin Plastic resin PLASTIC RESIN Plastic Resin Plastic Resin Processing Date January 2 January 2 January 3 January 4 January 4 January 4 January 5 January 6 January 6 January 7 January 7 January 7 January 8 January 8 E Pounds Processed 2,429 1,154 1,731 2,384 1,002 1,905 25,381 1,363 1,948 2,488 1,235 1,902 1,902 1,541 1,134 F Received by bgw ost jwr ost ppq smt cds ppq ost smt jwr bgw bgw smt ost