how do you complete this spread sheet

Tiru metnoa, assigning costs The assembly division of Quality Time Pieces, Inc. uses the FIFO method of process costing. Consider the following data for the month of May 2017: Physical Units (Watches) Direct Materials S459,888 Conversion Costs $142,570 100 510 450 $3.237,000 $1,916,000 Beginning work in process (May 1) Started in May 2017 Completed during May 2017 Ending work in process (May 31) Total costs added during May 2017 Degree of completion: Direct materials Conversion costs Degree of completion: Direct materials Conversion costs 8096 Conversion costs Equivalent Units Direct Conversion Materials Costs Flow of Production Completed and transferred out during current period From beginning work in process Started and completed Work in process, ending Equivalent units of work done in current period 350 350 128 498 479 the blue shaded areas on the ENTERANSWERS tab for inputs, ays use cell references and formulas where appropriate to receive full credit. If you copy/paste m the Instructions tab you will be marked wrone Total Production Cost Direct Materials Conversion Costs Work in process, beginning Costs added in current period Total costs to account for Costs added in current period Divide by, equivalent units of work done in current perio Cost per equivalent unit of work done in current period LLLL Assignment of costs: 3. Completed and transferred out: 4 Work in process, beginning s Costs added to beginning work in process in current period 16 Total from beginning inventory 7 Started and completed 78 Total costs of units completed and transferred out 19 Work in process, ending 20 Total costs accounted for INSTRUCTIONS ENTERI NSWERS Tutarch **