Inser add Page Leonard Nimoy & Starfleet Associates Group manufactures components for alternative energy products (solar, wind, etc.) for multiple markets and makes many products and byproducts. The production cost report provided is for Department 1. The department does the initial component processing to allow it to be added to other circuitry boards and solar/wind electrical components. Once this step occurs, all production is transferred to the Department 2 for further development operations. ALL OF DEPARTMENT 2 OUTPUT IS SENT FOR FURTHER PROCESSING IN THE DEPARTMENT 3. Please note that all cost per unit values have been formatted to 3 decimals The following information is available for the current month, reflecting work in the Department 2 Costs of Beginning Work in Process: Material $31,423 Beginning Work in Process Units (31% complete 814 units conversion) I Conversion $29,975 Ending Work in Process Units Additional Production Costs: (74% complete 456 units Material $85,261 Conversion $61,174 conversion) Abnormal loss 6 Normal spollage Remaining unaccounted (continuous) for units Transferred out units 13,206 units (30% = finished byproduct. 70% transferred to Department 3 for further processing To create a new unit,92% of materials are added at the start of production. The remaining 8% is added at the very end of processing.just prior either selling the finished product or moving to another Department for final processing. Adding the final 8 generates a computerized process in the company's ERP Production System to move the products to a finished and transferred out status. This accounting process is easily accomplished since the company implemented NetSuite as a "cloud application of the product transferred out. 20% of the units generic product and costs are sold immediately with a 4o.cost mackup to customers with long term logistics contracts. These transactions are handled totally by their customer Relationship Management (CRM) and Supply Chain Management (SCM) ERP modules. Thermal 70% of transferred out.product is sent to Department for final processing 30 tv T Chart Text Shape Media Comment Table Insert Page The following information is available for the current month, reflecting work in the Department 3: Beginning Work in Process Units Costs of Beginning Work in Process: Material $22,816 197 units (47% complete conversion) Conversion $56,431 Ending Work in Process Units Additional Production Costs: Material $1,210,210 286 units $790,039 3 Conversion (90% complete- materials) (74% complete conversion) Abnormal loss Normal loss - defective chips Transferred out units (81% transferred to Department 4 and 19% transferred to Department 5 for further processing.) .003 units X Total Units accounted for ? units The following information is available for the current month, reflecting work in the Department 4: Costs of Beginning Work in Process: Beginning Work in Process Units (23% complete 402 units conversion Material $44,972 $56.882 Ending Work in Process Units Conversion Additional Production Costs: Material 112 units $2,397,562 2 71% complete- materials) (58% complete conversion Abnormal loss Normal loss Transferred ou units 100% complete and moved to finished goods inventory Conversion $4.273,936 14 units 7 units 30 stv Media Text Table Insert Shape Chart dd Page The following information is available for the current month, reflecting work in the Department 5 Beginning Work in Process Units (57% complete 137 units conversion) Costs of Beginning Work in Process: Material $97,552 Conversion $97,856 Ending Work in Process Units Additional Production Costs: 105 units Material $3,746,539 (39% complete- materials) (46% complete conversion) Abnormal loss 2. Conversion $5,312,808 12 units ? units Normal loss Transferred out units 100% complete and moved to finished goods inventory Complete departments 2,3,4,5 production cost reports for the month Generate all ournal entries necessary for the current month reflecting the activity for the company from the above Problem 5 - Production Cost Reports for Departments 2, 3, 4, and 5, in problem #5. Beginning WIP balances would have already been journalized. Show all transfer transactions. Complete the General Ledger Taccount for WIP in cach department. Please note that I have you repeating some for the transfer in to departments to help visualize the transactions and to assist in the computation of the final WIP T account balance. I know this is duplicative, but it Is intended to Your DOCESS. Home ality Mode Insert Draw Page Layout Formulas Data Review View Tell me Formula Bar Zoom 75% Split 100 Zoom to 100% Normal Page Break Page Custom Gridlines Headings Preview Layout Views E18 fx-SUM(C18:018) Zoom to Selection New Arrange Freeze Freeze Freeze First Window All Panes Top Row Column Hide Se Unhide Wind C Deputar Apr 2010 Phy Tout BU M Con H DA7010 Units to be around Ben WP Started into Production Total 125 13,135 25.091 RISMO 14.527 1200 12:00 30 Transferred Out Department 1 11 Norma Anomalo unding 120 29 12 121 12 13.0 11010 55 Co $5.834 S. Come cost 416 S. ton 1440 16.30 20 OM 20 To Cost Recon Condor 58 54,183 29 SH Ending wance 27 141 SHOP 514 SH 561 163 5:26.773 5 To WIP Cart Tot 3 Fished we Porcon complete Cover sheet Problem 4-Dept 1 Problem 4 - Dept 2,3,4,5 Problem 2 Problem 3 Problem Select destination and press ENTER or choose Paste 3 V PAC 20 Ruler Formula Bar Zoom 75% Ha U Split Hide Switch Unhide Window Gridines Headings 100 Zoom to 100% Zoom to Selection New Window Arrange Freeze Freeze Freeze First All Panes Top Row Column Normal Page Break Page Custom Preview Layout Views LS2 fx A De April 2010 1 2 Quotes Department Production Cost Baper 2010 Evet Units Tout Us Mre Conversion Costa W.DAT 65.849 WO 65,849 Units to be accounted for Begin WP Transferred in Department 1 Total Units 12.900 12:00 WIPE Dep WD PISMO 9 Un counted for 10 Transferred Out Department 11 Normal u Abnormal loss 1 Ending we 14 Total Units RO WP.DE MIN To Conosco Abnom WL $1641 565,149 SAN Cast u Begin WIP 14 Transferred in Darmst 1 10 Addion costs for production Total Cous 21 qut 22 Cost M 5864 18 C Tod Un M CAR SO so 10 24 Cost Recention schedule Costs Recounted for wame out. Det 27 Normales Abrommal on 2 Ending we 0 Materials Conversion Costa Total WP Costs To 34 Finished Transferred Out www.Perret complete 85 SO DU 50 100% And SOON ON ON Bong Finished Goods Fished Goods Mark Department Transfer 70.00 11 Decoupafore 44 Problem 4-Dept 2,3,4,5 Problema Problem 4 - Dept 1 A Cover sheet Problem 1 Problem 2 Select destination and press ENTER or choose Paste ce tv Split Normal Page Break Page Custom Preview Layout Views Gridlines Headings 100 Zoom to 100% Hide Zoom to Selection New Arrange Freeze Freeze Freeze First Window AN Panes Top Row Column SH L52 6 Quantes De Produto 100 Physka TURI Equivalent Units Mate Conco De Ar 1030 WP. Dapat we Uw to be fou o Ben a TransferredDet Tot 50 31 Udfor sa Transferred out. Department Normas Abnormou wong we Tous UNES ws Cast M Cornica To Segwe 50 se Toros Cou S. Collection Schedule Mar Tu OM CC 10 10 se Con Cou Tow Cost SO so Fichero w Porto N PEN PON 79 Det trends Dept tema D. Tried Cover sheet Problem Problem 2 Problem 3 Problem 4-Dept 2,3,4,5 Problem 4 . Depli Select destination and press ENTER or choose Paste 30 V I Normal Page Break Page Custom Preview Layout Views Gridines Headings Hide 100 Zoom to 100% Zoom to Selection New Window Arrange Freeze Freeze Freeze First All Panes Top Row Column SH UnhideWir LS2 23. Transferred out to Depts 19% 19 19% Quantities Department Production cost for Apr 2010 Physical Equivalent Units Equivalent Units Units M Convention Costs Dapar 2010 ourne WP 4 wp.pl WP. Detta Unies to be accounted for Wp so ferred in Department Total Units R Units accounted for 94 ferred Out. Department mul oss mallow ng WIP Totul Uns WP. DO PAMO hedo Mate Convention Conte Tot Departe 30 SO Tras OM M Coments Cost We ved. Departments 100 costs for production 104 10 101 100 Cost 09 V Reconhece code 110 Mened out Department 111 maless 111 malo 150 WP 114 115o Cost 116 Toto 111 Total Telul Endine so so 100N 100N SIN 10 - Porn complete BIN 122 fent Problems Problem 4 - Dept 2, 3, 4, 5 Problem 1 Cover sheet Problem 4 - Dept 1 Problem 2 Select destination and press ENTER or choose Paste tv 30 Ruler Formula Bar Zoom 75% Normal Page Break Page Custom Preview Layout Views Gridiines Headings 100 Zoom to 100% Zoom to Selection New Window Arrange Freeze Freeze Freeze First All Panes Top Row Column Split Hide Switch Unhide Windows LS2 fx G H 21 Department 3. Trwatered in BIN 81 BIS Des 2010 23 134 125 Quantities EN Unies to be accounted for 13 Begin WP 120 Transferred In - Department 130 Tots Units Dentro de Conta 100 Physical Equivalent Units Equivalent Units Mar Convention Costs wp.pt WP parents We Departments werments MO Un account for 130 Transferred Out Departments 134 Namatos Abormal loss 110 End LRT Total Units shed Goods Man Convece TO ATTI WP 50 10 WEB 10.000 Un Conversion Conte Total Ces 140 Ben W 141 Transferred in Departments 14 Addons for production 14 TC 144 quivalent Unte 14 Un Cost 248 143 Cout Reconciliation Schedule 140 Cost Accounted for 141 Transferred Out. Det 150 Normales 11 Alin Loss 15anongwe 10 M 154 Conversion Costs 155 Total WIP Costs 13 Total 157 whered on 10 WP Percent complete These OM Anom Traseu 0 0 so $ So endir Hapo $0 so $0 50 100 39 100N 46N 100 Dates 162 105 Cover sheet Problem 1 Problem 4 - Dept 2, 3, 4, 5 Problem 2 Problem 3 Problem 4 - Dept 1 Celect destination and press ENTER or choose Paste Inser add Page Leonard Nimoy & Starfleet Associates Group manufactures components for alternative energy products (solar, wind, etc.) for multiple markets and makes many products and byproducts. The production cost report provided is for Department 1. The department does the initial component processing to allow it to be added to other circuitry boards and solar/wind electrical components. Once this step occurs, all production is transferred to the Department 2 for further development operations. ALL OF DEPARTMENT 2 OUTPUT IS SENT FOR FURTHER PROCESSING IN THE DEPARTMENT 3. Please note that all cost per unit values have been formatted to 3 decimals The following information is available for the current month, reflecting work in the Department 2 Costs of Beginning Work in Process: Material $31,423 Beginning Work in Process Units (31% complete 814 units conversion) I Conversion $29,975 Ending Work in Process Units Additional Production Costs: (74% complete 456 units Material $85,261 Conversion $61,174 conversion) Abnormal loss 6 Normal spollage Remaining unaccounted (continuous) for units Transferred out units 13,206 units (30% = finished byproduct. 70% transferred to Department 3 for further processing To create a new unit,92% of materials are added at the start of production. The remaining 8% is added at the very end of processing.just prior either selling the finished product or moving to another Department for final processing. Adding the final 8 generates a computerized process in the company's ERP Production System to move the products to a finished and transferred out status. This accounting process is easily accomplished since the company implemented NetSuite as a "cloud application of the product transferred out. 20% of the units generic product and costs are sold immediately with a 4o.cost mackup to customers with long term logistics contracts. These transactions are handled totally by their customer Relationship Management (CRM) and Supply Chain Management (SCM) ERP modules. Thermal 70% of transferred out.product is sent to Department for final processing 30 tv T Chart Text Shape Media Comment Table Insert Page The following information is available for the current month, reflecting work in the Department 3: Beginning Work in Process Units Costs of Beginning Work in Process: Material $22,816 197 units (47% complete conversion) Conversion $56,431 Ending Work in Process Units Additional Production Costs: Material $1,210,210 286 units $790,039 3 Conversion (90% complete- materials) (74% complete conversion) Abnormal loss Normal loss - defective chips Transferred out units (81% transferred to Department 4 and 19% transferred to Department 5 for further processing.) .003 units X Total Units accounted for ? units The following information is available for the current month, reflecting work in the Department 4: Costs of Beginning Work in Process: Beginning Work in Process Units (23% complete 402 units conversion Material $44,972 $56.882 Ending Work in Process Units Conversion Additional Production Costs: Material 112 units $2,397,562 2 71% complete- materials) (58% complete conversion Abnormal loss Normal loss Transferred ou units 100% complete and moved to finished goods inventory Conversion $4.273,936 14 units 7 units 30 stv Media Text Table Insert Shape Chart dd Page The following information is available for the current month, reflecting work in the Department 5 Beginning Work in Process Units (57% complete 137 units conversion) Costs of Beginning Work in Process: Material $97,552 Conversion $97,856 Ending Work in Process Units Additional Production Costs: 105 units Material $3,746,539 (39% complete- materials) (46% complete conversion) Abnormal loss 2. Conversion $5,312,808 12 units ? units Normal loss Transferred out units 100% complete and moved to finished goods inventory Complete departments 2,3,4,5 production cost reports for the month Generate all ournal entries necessary for the current month reflecting the activity for the company from the above Problem 5 - Production Cost Reports for Departments 2, 3, 4, and 5, in problem #5. Beginning WIP balances would have already been journalized. Show all transfer transactions. Complete the General Ledger Taccount for WIP in cach department. Please note that I have you repeating some for the transfer in to departments to help visualize the transactions and to assist in the computation of the final WIP T account balance. I know this is duplicative, but it Is intended to Your DOCESS. Home ality Mode Insert Draw Page Layout Formulas Data Review View Tell me Formula Bar Zoom 75% Split 100 Zoom to 100% Normal Page Break Page Custom Gridlines Headings Preview Layout Views E18 fx-SUM(C18:018) Zoom to Selection New Arrange Freeze Freeze Freeze First Window All Panes Top Row Column Hide Se Unhide Wind C Deputar Apr 2010 Phy Tout BU M Con H DA7010 Units to be around Ben WP Started into Production Total 125 13,135 25.091 RISMO 14.527 1200 12:00 30 Transferred Out Department 1 11 Norma Anomalo unding 120 29 12 121 12 13.0 11010 55 Co $5.834 S. Come cost 416 S. ton 1440 16.30 20 OM 20 To Cost Recon Condor 58 54,183 29 SH Ending wance 27 141 SHOP 514 SH 561 163 5:26.773 5 To WIP Cart Tot 3 Fished we Porcon complete Cover sheet Problem 4-Dept 1 Problem 4 - Dept 2,3,4,5 Problem 2 Problem 3 Problem Select destination and press ENTER or choose Paste 3 V PAC 20 Ruler Formula Bar Zoom 75% Ha U Split Hide Switch Unhide Window Gridines Headings 100 Zoom to 100% Zoom to Selection New Window Arrange Freeze Freeze Freeze First All Panes Top Row Column Normal Page Break Page Custom Preview Layout Views LS2 fx A De April 2010 1 2 Quotes Department Production Cost Baper 2010 Evet Units Tout Us Mre Conversion Costa W.DAT 65.849 WO 65,849 Units to be accounted for Begin WP Transferred in Department 1 Total Units 12.900 12:00 WIPE Dep WD PISMO 9 Un counted for 10 Transferred Out Department 11 Normal u Abnormal loss 1 Ending we 14 Total Units RO WP.DE MIN To Conosco Abnom WL $1641 565,149 SAN Cast u Begin WIP 14 Transferred in Darmst 1 10 Addion costs for production Total Cous 21 qut 22 Cost M 5864 18 C Tod Un M CAR SO so 10 24 Cost Recention schedule Costs Recounted for wame out. Det 27 Normales Abrommal on 2 Ending we 0 Materials Conversion Costa Total WP Costs To 34 Finished Transferred Out www.Perret complete 85 SO DU 50 100% And SOON ON ON Bong Finished Goods Fished Goods Mark Department Transfer 70.00 11 Decoupafore 44 Problem 4-Dept 2,3,4,5 Problema Problem 4 - Dept 1 A Cover sheet Problem 1 Problem 2 Select destination and press ENTER or choose Paste ce tv Split Normal Page Break Page Custom Preview Layout Views Gridlines Headings 100 Zoom to 100% Hide Zoom to Selection New Arrange Freeze Freeze Freeze First Window AN Panes Top Row Column SH L52 6 Quantes De Produto 100 Physka TURI Equivalent Units Mate Conco De Ar 1030 WP. Dapat we Uw to be fou o Ben a TransferredDet Tot 50 31 Udfor sa Transferred out. Department Normas Abnormou wong we Tous UNES ws Cast M Cornica To Segwe 50 se Toros Cou S. Collection Schedule Mar Tu OM CC 10 10 se Con Cou Tow Cost SO so Fichero w Porto N PEN PON 79 Det trends Dept tema D. Tried Cover sheet Problem Problem 2 Problem 3 Problem 4-Dept 2,3,4,5 Problem 4 . Depli Select destination and press ENTER or choose Paste 30 V I Normal Page Break Page Custom Preview Layout Views Gridines Headings Hide 100 Zoom to 100% Zoom to Selection New Window Arrange Freeze Freeze Freeze First All Panes Top Row Column SH UnhideWir LS2 23. Transferred out to Depts 19% 19 19% Quantities Department Production cost for Apr 2010 Physical Equivalent Units Equivalent Units Units M Convention Costs Dapar 2010 ourne WP 4 wp.pl WP. Detta Unies to be accounted for Wp so ferred in Department Total Units R Units accounted for 94 ferred Out. Department mul oss mallow ng WIP Totul Uns WP. DO PAMO hedo Mate Convention Conte Tot Departe 30 SO Tras OM M Coments Cost We ved. Departments 100 costs for production 104 10 101 100 Cost 09 V Reconhece code 110 Mened out Department 111 maless 111 malo 150 WP 114 115o Cost 116 Toto 111 Total Telul Endine so so 100N 100N SIN 10 - Porn complete BIN 122 fent Problems Problem 4 - Dept 2, 3, 4, 5 Problem 1 Cover sheet Problem 4 - Dept 1 Problem 2 Select destination and press ENTER or choose Paste tv 30 Ruler Formula Bar Zoom 75% Normal Page Break Page Custom Preview Layout Views Gridiines Headings 100 Zoom to 100% Zoom to Selection New Window Arrange Freeze Freeze Freeze First All Panes Top Row Column Split Hide Switch Unhide Windows LS2 fx G H 21 Department 3. Trwatered in BIN 81 BIS Des 2010 23 134 125 Quantities EN Unies to be accounted for 13 Begin WP 120 Transferred In - Department 130 Tots Units Dentro de Conta 100 Physical Equivalent Units Equivalent Units Mar Convention Costs wp.pt WP parents We Departments werments MO Un account for 130 Transferred Out Departments 134 Namatos Abormal loss 110 End LRT Total Units shed Goods Man Convece TO ATTI WP 50 10 WEB 10.000 Un Conversion Conte Total Ces 140 Ben W 141 Transferred in Departments 14 Addons for production 14 TC 144 quivalent Unte 14 Un Cost 248 143 Cout Reconciliation Schedule 140 Cost Accounted for 141 Transferred Out. Det 150 Normales 11 Alin Loss 15anongwe 10 M 154 Conversion Costs 155 Total WIP Costs 13 Total 157 whered on 10 WP Percent complete These OM Anom Traseu 0 0 so $ So endir Hapo $0 so $0 50 100 39 100N 46N 100 Dates 162 105 Cover sheet Problem 1 Problem 4 - Dept 2, 3, 4, 5 Problem 2 Problem 3 Problem 4 - Dept 1 Celect destination and press ENTER or choose Paste