The Bottling department of Soft Drink Company has the following production and manufacturing cost data for June 2022. All materials are added at the beginning of the process. Prepare a production cost report for The Bottling department for the month of June? Weighted average method.

The Bottling department of Soft Drink Company has the following production and manufacturing cost data for June 2022. All materials are added at the beginning of the process. Prepare a production cost report for The Bottling department for the month of June? (You can use Microsoft Excel when solving the above problem.)