Question:
The following data appeared in Ticonderoga Tile Company’s records on December 31 of last year:
Leake re SaleSievVemUee kis. a gue ake Pee alae oO ee ee eee 812,500(LO1,2,3)DirectmaterialuseddyedchristenBorbeeendecobeareensyasaxeAORAeeeee191,050Work−in−processinventory,December31...........0.c.e0se.en.eee12,300eXcelRaw−inateriallimventOnynbCCeniOcfaSilkaiga4siennatnacyhelaaeeeneaenneen42,500mhhe.com/hilton4eRaw−materialpurchasedduring′theyear....<...0.0......0.glo)...180,000RinisheG−GOodSinVentonyWeCemDeteederr−sreeete.heataeeit45,000NellelolelpereareaeReineCeesMeeneMenem|SedeenAnnyASoe−16,000DIIgeroullcloClneesentencetiaorArneEnoathnent,equaohceetraebopoedeme195,000PlantineatsliGhtamGlDOWCTrnckassaeteicegisaniaennanneweerOe22,600Buildingdepreciation(7/9isformanufacturing)......................40,500ACIMIMISHAIVE:SAIATIOSsame:Chomceti,selSereCena.heeheeneedeeerane24,900MiIScellaneOuUSifactonyiCOStsnmemcrceseereonereaaceea16,950SEITMONCOSES«tersaetee,etagetsaut:tetasRondegheorderReeaCEteener19,300MaintenanceeoniractonymachiNeScsmmeenteterreerin:teemarntear6,050INSUFATICSOMMACTOYCCUIONMEItswatesereenaeeaatacreootetnneee9,500PISTHMOUTOMCOSTSs.rsnctetacetclean.asadaceeeOeee800TaxesrOniMmanuUtactuninG|OrOWSIVcnsrieeaeaaneNtntenareeeneeeoer6,550LECSESCMCUSICIMAOOMOEMsoanasaveerdsaeccsepcannsooqsuue:4,100OnJanuary1,atthebeginningoflastyear,theFinished−GoodsInventoryaccounthadabalanceof40,000, and the Work-in-Process Inventory account had a balance of $12,950.
Required
a. Prepare a schedule of-cost of goods sold and an income statement.
b. BUILD YOUR OWNS PREADSHEET. Build an Excel spreadsheet to complete requirement (a).
•• Each of the following columns is independent and for a different company. Use the data given, which Unknown Account refer to one year for each example, to find the unknown account balances.
Balances (LO 1, 2,3) Company Account ! 2 3 Finished-goods inventory, January 1.................... $ 1,900
(d) 17,200Finished−goodsinventory,December31..................300 4,400 28,400 Work-in-process inventory, January 1 .................... 2,700 6,720 82,400 Work-in-process inventory, December 31 ................. 3,800 3,100 76,730 ake NMEIaMetveriitell IN MEINWOINY, JEINUETAY |. cc one enc onancueacsae
(a) 3,500 16,000 Raw-material inventory, December 31..:................. 3,600 2,900 14,100 UIC MESES) EMMIMEWEUTIENS Fico 556s ann nimes an en adanonee 16,100 12,000 64,200 Cost of goods manufactured during the year...............
(b) 27,220 313,770 MOVE N nMN IUNEXCWUTAMCCOSIS, os bees gh see ucndnadeenannacase 55,550 23,600 308, 100 COStOl.Goods Sold man tener aoe eee ee 56,050 27,200 302,570 (GOSS IMARGIA Gt «ca, exregtotatc ata ev aaa cee ae
(c) 16,400 641,280 DirectimatenalMUSec evans saris Creel ean tn ae area 15,300
(e) 66, 100 DIRSCH AION: wilecas8’. coc ree tags GRR eee en ee 26,450 3,800 124,700 Manttactunmoroverneachiy nia aaen tee tet eas 13,800 7,200 (g)
SAIS TEVENUG as Fidin 8 a-attone nant ene a On Ae 103,300
(f) 943,850