joseysemail is the excel file

need questions 1-6 asap and the pouring department form

can provide any clarification needed

\fJordan, Here is the relevant data that I've gathered for last quarter. Remember we use the FIFO method. All the materials are added at the beginning of the pouring process. The finishing department is different, though. Half the materials are added when conversion is 50% complete and half are added at the end. Below are the figures I've pulled from the accounting system. Because we are creating a variety of different size candles, we will create the costs using candle-inches. Then we can just figure out the cost of a particular size candle by multipying the per-inch cost by the height of the candle. Josey Beginning Inventory in Candle-Inches Units added during the month Ending WIP inventory in units Pouring 3,000 27,500 4,250 CC 85% Finishing 7,200 60% 5,050 CC 15% 80% Pouring Costs in Beginning Inventory Costs added during the month $ $ DM 1,750 $ 16,500 $ Finishing CC Transferred-In DM 500 $ 1,780 $ - $ 5,250 $ 2,474 $ CC 108 3,136 Finishing department (joseys email) PRODUCTION REPORT - FIFO METHOD Quantity Schedule and Equivalent Units Quantity Schedule Units to be accounted for: Work in process, beginning Started into production 7,200 23,750 Total units to be accounted for 30,950 Equivalent Units Tranferred -in Units accounted for as follows: Transferred out: From beginning inventory Started and completed this period Work in process, ending Materials 7,200 18,700 5,050 0 18,700 5,050 6,120 18,700 4,040 Total units accounted for 30,950 23,750 28,860 2,474 23,750 0.10 + 3,136 28,860 0.11 + Unit Costs Cost added by the department (a) Equivalent units (b) Unit cost, (a)/(b) 5,610 0.21 = conversion Cost Reconciliation Equivalent Units (EU) Costs Cost to be accounted for: Work in process, beginning Cost added by the department 1,780 6,800 Total cost to be accounted for 8,580 Cost accounted for as follows: Transferred out: From beginning inventory: Cost in beginning inventory Cost to complete these units: 0.10 for Materials per EU 0.11 for Labor per EU 1,888 0 665 Total cost Units started and completed 0.21 6,120 18,700 18700 Total costs transferred 0.10 2,553 3,980 0 Work in process, ending: for Materials per EU 6,533 526 5,050 18,700 0.11 for Labor per EU Total work in process, ending Total cost accounted for 439 965 7,498 4,040 ent Units (EU) Pouring Department (joseys email) PRODUCTION REPORT - FIFO METHOD Quantity Schedule and Equivalent Units Quantity Schedule Percentage Complete: Materials Beginning: 0 Units to be accounted for: Work in process, beginning Started into production 3,000 27,500 Total units to be accounted for 30,500 Ending: 4,250 Equivalent Units Units accounted for as follows: Transferred out: From beginning inventory Started and completed this period Work in process, ending 3,000 23,250 4,250 0 23,250 4,250 450 23,250 2,550 Total units accounted for 30,500 27,500 26,250 21,750 16,500 27,500 0.60 + 5,250 26,250 0.20 + Unit Costs Cost added by the department (a) Equivalent units (b) Unit cost, (a)/(b) Materials = conversion Cost Reconciliation Equivalent Units (EU) Costs Cost to be accounted for: Work in process, beginning Cost added by the department 2,250 21,750 Total cost to be accounted for 24,000 Cost accounted for as follows: Transferred out: From beginning inventory: Cost in beginning inventory Cost to complete these units: 0.60 for Materials per EU 0.20 conversion 2,250 0 90 2,340 0 0 23,250 Total cost Units started and completed 450 23,250 23,250 Total costs transferred Work in process, ending: 0.60 for Materials per EU 20,940 2,550 ### 15,700 4,250 5,240 0.20 conversion Total work in process, ending Total cost accounted for 510 0 3,060 24,000 2,550 Conversion 450 ent Units (EU) 2,550 2,550 Finishing department (Jordan's Table) PRODUCTION REPORT - FIFO METHOD Quantity Schedule and Equivalent Units Quantity Schedule Units to be accounted for: Work in process, beginning Started into production 5,050 31,900 Total units to be accounted for 36,950 Equivalent Units Tranferred -in Units accounted for as follows: Transferred out: From beginning inventory Started and completed this period Work in process, ending 5,050 31,600 300 0 31,600 300 6,120 31,600 120 Total units accounted for 36,950 31,900 37,840 3,000 31,900 0.09 + 3,800 37,840 0.10 + Unit Costs Cost added by the department (a) Equivalent units (b) Unit cost, (a)/(b) Materials 6,800 0.19 = conversion Cost Reconciliation Equivalent Units (EU) Costs Cost to be accounted for: Work in process, beginning Cost added by the department 1,780 6,800 Total cost to be accounted for 8,580 Cost accounted for as follows: Transferred out: From beginning inventory: Cost in beginning inventory Cost to complete these units: 0.09 for Materials per EU 0.10 conversion 965 0 615 Total cost Units started and completed 1,580 6,145 Total costs transferred 7,725 0 6,120 31,600 0.19 0.09 Work in process, ending: for Materials per EU 28 300 31,600 0.10 for Labor per EU Total work in process, ending Total cost accounted for 12 40 7,765 120 ent Units (EU) 31,600 120 Pouring Department (Jordan's Table) PRODUCTION REPORT - FIFO METHOD Quantity Schedule and Equivalent Units Quantity Schedule Units to be accounted for: Work in process, beginning Started into production 6,800 32,800 Total units to be accounted for 39,600 Equivalent Units Units accounted for as follows: Transferred out: From beginning inventory Started and completed this period Work in process, ending 6,800 25,100 7,700 0 25,100 7,700 0 25,100 6,930 Total units accounted for 39,600 32,800 32,030 #REF! 19,800 32,800 0.60 + 6,560 32,030 0.20 + Unit Costs Cost added by the department (a) Equivalent units (b) Unit cost, (a)/(b) Materials 0.81 = Labor Cost Reconciliation Equivalent Units (EU) Costs Cost to be accounted for: Work in process, beginning Cost added by the department 3,060 20,800 Total cost to be accounted for 23,860 Cost accounted for as follows: Transferred out: From beginning inventory: Cost in beginning inventory Cost to complete these units: 0.60 for Materials per EU 0.20 for Labor per EU 3,060 0 0 Total cost Units started and completed 3,060 20,293 Total costs transferred 23,353 0 25,100 0.81 0.60 Work in process, ending: for Materials per EU 4,648 7,700 25,100 0.20 0.00 for Labor per EU for Overhead per EU Total work in process, ending Total cost accounted for 1,419 0 6,067 29,420 6,930 ent Units (EU) 25,100 6,930 Finishing department (joseys email) PRODUCTION REPORT - FIFO METHOD Quantity Schedule and Equivalent Units Quantity Schedule Units to be accounted for: Work in process, beginning Started into production 7,200 23,750 Total units to be accounted for 30,950 Equivalent Units Tranferred -in Units accounted for as follows: Transferred out: From beginning inventory Started and completed this period Work in process, ending Materials 7,200 18,700 5,050 0 18,700 5,050 6,120 18,700 4,040 Total units accounted for 30,950 23,750 28,860 2,474 23,750 0.10 + 3,136 28,860 0.11 + Unit Costs Cost added by the department (a) Equivalent units (b) Unit cost, (a)/(b) 5,610 0.21 = conversion Cost Reconciliation Equivalent Units (EU) Costs Cost to be accounted for: Work in process, beginning Cost added by the department 1,780 6,800 Total cost to be accounted for 8,580 Cost accounted for as follows: Transferred out: From beginning inventory: Cost in beginning inventory Cost to complete these units: 0.10 for Materials per EU 0.11 for Labor per EU 1,888 0 665 Total cost Units started and completed 0.21 6,120 18,700 18700 Total costs transferred 0.10 2,553 3,980 0 Work in process, ending: for Materials per EU 6,533 526 5,050 18,700 0.11 for Labor per EU Total work in process, ending Total cost accounted for 439 965 7,498 4,040 ent Units (EU) Pouring Department (joseys email) PRODUCTION REPORT - FIFO METHOD Quantity Schedule and Equivalent Units Quantity Schedule Percentage Complete: Materials Beginning: 0 Units to be accounted for: Work in process, beginning Started into production 3,000 27,500 Total units to be accounted for 30,500 Ending: 4,250 Equivalent Units Units accounted for as follows: Transferred out: From beginning inventory Started and completed this period Work in process, ending 3,000 23,250 4,250 0 23,250 4,250 450 23,250 2,550 Total units accounted for 30,500 27,500 26,250 21,750 16,500 27,500 0.60 + 5,250 26,250 0.20 + Unit Costs Cost added by the department (a) Equivalent units (b) Unit cost, (a)/(b) Materials = conversion Cost Reconciliation Equivalent Units (EU) Costs Cost to be accounted for: Work in process, beginning Cost added by the department 2,250 21,750 Total cost to be accounted for 24,000 Cost accounted for as follows: Transferred out: From beginning inventory: Cost in beginning inventory Cost to complete these units: 0.60 for Materials per EU 0.20 conversion 2,250 0 90 2,340 0 0 23,250 Total cost Units started and completed 450 23,250 23,250 Total costs transferred Work in process, ending: 0.60 for Materials per EU 20,940 2,550 ### 15,700 4,250 5,240 0.20 conversion Total work in process, ending Total cost accounted for 510 0 3,060 24,000 2,550 Conversion 450 ent Units (EU) 2,550 2,550 Finishing department (Jordan's Table) PRODUCTION REPORT - FIFO METHOD Quantity Schedule and Equivalent Units Quantity Schedule Units to be accounted for: Work in process, beginning Started into production 5,050 31,900 Total units to be accounted for 36,950 Equivalent Units Tranferred -in Units accounted for as follows: Transferred out: From beginning inventory Started and completed this period Work in process, ending 5,050 31,600 300 0 31,600 300 6,120 31,600 120 Total units accounted for 36,950 31,900 37,840 3,000 31,900 0.09 + 3,800 37,840 0.10 + Unit Costs Cost added by the department (a) Equivalent units (b) Unit cost, (a)/(b) Materials 6,800 0.19 = conversion Cost Reconciliation Equivalent Units (EU) Costs Cost to be accounted for: Work in process, beginning Cost added by the department 1,780 6,800 Total cost to be accounted for 8,580 Cost accounted for as follows: Transferred out: From beginning inventory: Cost in beginning inventory Cost to complete these units: 0.09 for Materials per EU 0.10 conversion 965 0 615 Total cost Units started and completed 1,580 6,145 Total costs transferred 7,725 0 6,120 31,600 0.19 0.09 Work in process, ending: for Materials per EU 28 300 31,600 0.10 for Labor per EU Total work in process, ending Total cost accounted for 12 40 7,765 120 ent Units (EU) 31,600 120 Pouring Department (Jordan's Table) PRODUCTION REPORT - FIFO METHOD Quantity Schedule and Equivalent Units Quantity Schedule Units to be accounted for: Work in process, beginning Started into production 6,800 32,800 Total units to be accounted for 39,600 Equivalent Units Units accounted for as follows: Transferred out: From beginning inventory Started and completed this period Work in process, ending 6,800 25,100 7,700 0 25,100 7,700 0 25,100 6,930 Total units accounted for 39,600 32,800 32,030 #REF! 19,800 32,800 0.60 + 6,560 32,030 0.20 + Unit Costs Cost added by the department (a) Equivalent units (b) Unit cost, (a)/(b) Materials 0.81 = Labor Cost Reconciliation Equivalent Units (EU) Costs Cost to be accounted for: Work in process, beginning Cost added by the department 3,060 20,800 Total cost to be accounted for 23,860 Cost accounted for as follows: Transferred out: From beginning inventory: Cost in beginning inventory Cost to complete these units: 0.60 for Materials per EU 0.20 for Labor per EU 3,060 0 0 Total cost Units started and completed 3,060 20,293 Total costs transferred 23,353 0 25,100 0.81 0.60 Work in process, ending: for Materials per EU 4,648 7,700 25,100 0.20 0.00 for Labor per EU for Overhead per EU Total work in process, ending Total cost accounted for 1,419 0 6,067 29,420 6,930 ent Units (EU) 25,100 6,930