Problem 4 (Textbook Reference: P34)- Prepare a production cost report A bottling company bottles soft drinks using a process cost system. Following are cost and production data for the mixing department for June: Units Materials Costs Inventory, June 1 Placed in Production in June Conversion Costs 16,240 41.720 56,000 $ 11,620 S 133,000 S 29,960 S Inventory, June 30 63,000 The June 30 inventory was 100% complete as to materials and 30% complete as to conversion. Required: Prepare a production cost report for the month ended June 30, using the average cost method. A production report template has been provided on the next page* Production Re port (Weigted Average Method) UNIT INFORMATION Unts in be Unts startedtransferred n Total units to account for the valent Units Materiak Convers ion Unts compketed& transferred out nts work in process invet Total units accounted for COST IN FORMATION Materials Conversion osts in be work in process iv osts incured the Total costs to account for Total costs to accourt for ded walent unts ost pere nt unit ted & transferred out osts remminng inendng work in process inmentory Total costs accounte d for