Pls show your work in excel.

The following data are available for Lavender Department of the Purple Powder Company for the month of August: Product is transferred into the Lavender Department from the Red Department. No new material is added in the Lavender Department. Beginning WIP Inventory-August 9,100 units Percent Complete with respect to the Lavender 20% Department Transferred in Costs from Red Department $47,980 Conversion Cost in Beginning Inventory from the $12.654 Lavender Department Units Started in August 20,700 Costs Incurred in August Transferred in Costs from Red Department $115,920 Conversion Costs in Lavender Department $223,890 Ending WIP Inventory 4,100 Percent Complete with respect to the Lavender 6096 Department Percent Complete with respect to the Red Department 100% 1. Use weighted-average process costing to prepare a Production Cost Report. Upload the Spreadsheet in the Question 5 box. 2. What is the value of ending inventory in the Lavender Department