DATA for production report 5 BE SURE TO USE FORMULAS for math operations such as addition, 6 subtraction, multiplication, and division. E.G. Total units to be accounted for 7should be a formula. 8 TO 9 FROM 10 DATE 11 TOPIC 12 13 14 Assumptions: 5 All materials are added at the beginning of the process 16 Conversion costs are edded evenly throughout the protess 17 18 19 20 UNITS 21 Units to occount for Background Information: Crest Incorporated produces a liquid product called "Vanish" When the product is sprayed on an individual, he becomes invisible. There are two processes. Process #1 is the mixing process. Crest Ince. 1/31/17 Production Report for January 2017 Assumptions: All materials are added at the beginning of the process. Conversion costs are added evenly throughout the process Production Data for January 2017: Whole Units Direct Materials Conversion costs Quarts Beg. Bal. Work-in-Process Inventory Started in production Bal. Work-in-Process Inv. 13,000 8,000 5,000 23 Started in production 24 Tot Unvits to account for 25 26 Units occounted 27 Conm 28 End. Bal. Work-in-Protess Inv 29 Tot units accounted for 30 31 COSTS 32 Costs to account for 33 Beg. Bal, Work-in-Process Inv 34 Costs added in current period 35 Total costs to account for 36 Divided by equivalent unit leted and transferred to the next End. Bal. Work-in-Process Inventory (70% completed) and transferred Costs Beg, Bal. Work-in-Process Inventory Direct materials added in Direct labor added in January Manufacturing overhead Direct Materials Conversion costs Total Costs 538,000 32,000 40,000 per equivaient unit 39 Costs accounted for: 40 Completed and transferred out 41 End. Sal. Work-in-Process Inv. 42 Total costs accounted 4 Add lines and double lines as needed. 45 Be sure to use Excel cell references and Excel formulas