(Mod. 3) Using the Report Template on the attached EXCEL worksheet, Complete XYZ Company's 2016 Production Cost Report (appearing below) for the mixing department, assuming the facts that appear below.The company uses a process cost system (Weighted-Average Method) for tracking costs.

XYZ Manufacturing produces marine paint, which it sales in gallon containers. It uses a process costing system, an. There are two processing departments?Mixing, and Packaging. On January 1, 2016, the mixing department, had no beginning inventory. During the year, 30,000 gallons of paint were started in production. Of these, 25,000 gallons were completed and 5,000 gallons remained in process.Management estimates that the in-process units are approximately 80% complete.In the Mixing Department, all direct materials are added at the beginning of the production process.Labor and overhead costs are applied evenly through the process.During 2016, the Mixing Department incurred $45,000 in direct materials costs and $65,250 in labor costs, and $7,250 in overhead costs.

DEPARTMENTAL COSTS OF PRODUCTION REPORT Mont : Dept: UNITS: PHYSICAL UNITS To Account For Beg. wIP New Units lTransf. In! Total Units EQUIVALENT UNITS Dlrect Direct Labor Overhead Accounted For Transferred Out _w Total Units COSTS: Direct Materials Direct Labor Overhead Total Costs Beginning Inventory +Equivalent Units 5 - 5 - Current Period Costs TOTAL PERIOD COSTS 'U'J- I 1J1- I Cost Per Equivalent Unit Direct Materials Direct Labor Overhead Total Cools To Account For Beg. WIP Current Period Costs Total Costs Accounts For Units Completed 8: Transferred Out (Qty: Si Ending Inventory iEqU x 5] Total Costs