what is weighted average for that? using Excel to solve this question. thank you

cost accounting weighted average method

Table 2: Data for the Bottling Department for August 2017 Physical units (barrels) Direct materials Conversion costs Transferred-in 250 $0 $7,105 $100,000 100% 0% 70% 7 300 Work in process, August 1 Degree of completion of beginning work in process Transferred-in during August 2017 Completed during August 2017 Work in process, August 31 Degree of completion of ending work in process Total costs added during August 2017 Note: All monetary values are in US dollars 1,150 100% 0% 60% $14,025 ? $18,400