could you explain through excel if possible? thank you

Bio Next Corporation is a biotech company that makes a cancer-treatment drug in a single processing department. Direct materials are added at the start of the process. Conversion costs are added evenly during the process. Bio Next uses the weighted-average method of process costing. The following information for July 2018 is available: (Click the icon to view the data.) (Click the icon to view the total costs.) Required Requirement 1. Calculate the cost per equivalent unit for direct materials and conversion costs. Enter the physical units first, and then calculate the equivalent units. (Round your answers to the nearest whole unit.) Physical Flow of Production Units Work in process, beginning Started during current period To account for Completed and transferred out during current period Work in process, ending Accounted for X X Data Total costs Equivalent Units Total Costs for July 2018 Physical Direct Conversion Work in process, beginning Units Materials Costs Direct materials $ 75,60 Work in process, July 1 12.600 2,600 8,820 Conversion costs 87, 100 5 162,700 Started during July 50, 100 Completed and transferred out during July 42,000 42,000 42,000 Direct materials added during July 320,000 Work in process, July 31" 20,700 20,700 7,245 Conversion costs added during July 463,750 Degree of completion: direct materials, 100%; conversion costs, 70% 946,450 "Degree of completion: direct materials, 100%; conversion costs, 35% Total costs to account for Print Done Print Done X Required 1. Calculate the cost per equivalent unit for direct materials and conversion costs. 2. Summarize total costs to account for, and assign total costs to units completed (and transferred out) and to units in ending work in process. Print Done