Hello,

I am unsure as to how to go about completing this question. My prof mentioned attaching an excel spreadsheet as well as a brief summary of findings.

West\tCoast\tManufacturing West\tCoast\tManufacturing\tproduces\ta\tsingle\tproduct. The\tmanufacturing\tdata\trelating to\tthis\tproduct\tis\tas\tfollows: Opening\tWork\tin\tProcess Units\t-\t1,000 Costs\tin\tOpening\tWork\tin\tProcess o Materials\t-\t$1,423 o Conversion -\t$1,110 Percentage\tCompletion\t-\tMaterials\t100% Percentage\tCompletion\t-\tConversion\t50% Units\tStarted\tthis\tPeriod 10,150 Ending\tWork\tin\tProcess Units\t-\t1,900 Normal\tSpoilage o 2%\tof\tgood\tunits\tpassing\tinspection\twhich\toccurs\tat\tthe\tend\tof\tthe manufacturing\tprocess Spoiled\tUnits\tTotal\t-\t250 Costs\tAdded\tthis\tPeriod o Materials\t-\t$12,180 o Conversion -\t$27,750 Percentage\tCompletion\t-\tMaterials\t100% Percentage\tCompletion\t-\tConversion\t30% Required Prepare\ta\tFIFO\tprocess\tcosting\treport\tthat\tassigns\tcosts\tto\tending\twork\tin\tprocess, normal\tspoilage,\tabnormal\tspoilage,\tand\tunits\tcompleted\tand\ttransferred\tout