Maple Inc. manufactures syrup that goes through threeprocessing stages prior to

Maple Inc. manufactures syrup that goes through threeprocessing stages prior to completion. Information on work in thefirst department Blending is given below for August:Production data:Pounds in process August 1; materials 100% complete; conversion70% complete 3000Pounds started into production during August 85000Pounds completed and transferred out ?Pounds in process August 31; materials 80% complete; conversion30% complete 6000Cost data:Work in process inventory August 1:Materials cost $900Conversion cost $5900Cost added during May:Materials cost $151000Conversion cost $161700The company uses the weighted-average method.Submit an Excel document which each tab labeled by item number ingood form that demonstrates the following:Compute the equivalent units of production.Compute the costs per equivalent unit for the month.Determine the cost of ending work in process inventory and of theunits transferred out to the next department.Prepare a cost reconciliation schedule for the month.