The following information appears in Columbus Cable Company’s records for last year:
SAlESMEVEMUC Meer erent Revere rnr ete EMI Mit ie eM Do, ckf ctsb anshee meokonaes $418,000 Manufacturing Company XO HRYT SMCN EMC SS Ses ei Sa AAR ake SP yt a 87,500 fer (LO I, 2)
Mantiactaring building depreciation... eee ca eb ce one ee o 54,000 oH (INCIMACIIMAIETENS ZINC SUONIES, vsoacsasnanomenavdanounuaduedaranes 12,600 on 4 Se OTIS SOG eer rn Ete ati ear ete ene i aara, eeplae Me tepese 29,000 fz, mhhe.com/hilton4e Raweanmatentall ImVeMtOnycamUary alle) wrea nen senescbieeeseyc reineyma s 36,800 Ceém-DM DCCtHIAWOR ants ean.) kiectncak ence ie, seR IB HOR ERE DEE: ENE ER Late 71,200 De Rawemateriallimvemtony DecembpenSilie. ss. sac. 0. e1sm0e7e1 suena 38,000 Pm Rmished=-qoodsinventony, Januaryieaina sl sele cocercs oat. Ginn Gieler 21,800 Finished=goodsiinventory, December Stam... os ng eis a Fe RaWwenmeatenialouirehases (0 hteet hae Serre Fee a A ates 20 ete 44600 dm Work-in-process inventory, December3 1 ................--s-sc0 t-e e 26,200 Wif Stieenuisonezanciingirectlabotuu, morc. aca e an anes eee eens a eRe 28,800 @H Brooenty taxes smanuiactunih@iplanta. 40444 2405. =s4unsoge janes aeoke 16,800 of Blantiutilities andlioowehn nn

a. .65 .:o iene dott memes cine 47,000 of} oem P78 Foo VOTE OlOCESS INVEMLONy, UAMUAnV ll teint. Aawiel ayy eeeet S-fep ra early erates SOjSOO CD 17 Coes a3 Doo Required OF + NCE / {300

a. Prepare an income statement with a supporting schedule of cost of goods sold.

b. BUILD YOUR OWN SPREADSHEET. Build an Excel spreadsheet to complete requirement (a).