This is the project that I am working on. I have all the way up to #5 done. I need help with question #6. Please help me
AutoSave Ofn File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do HoutiProject1 Excel Irene HoutX Share Comments Calibri General Paste Conditional Format as Cell ormatting Table Styles Insert Delete Format B 1 u .-. . Merge & Center s-% , 48 Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing F25 Save the file oh you' name and project in the 'itle Example cav fonds, proie 1 Erer beginningbalances in the T-accourks from the Beginning Balance Sheer, al accourks have normalbalanoes. Common Stockha: 200,000 shares issued and oustanding. 2 Addkional information: Company uses apeipetualinventory system(discourks and fieight ane recorded n the inventory account), Suppliers offer a 2% dsoort company does not offer dsoorts to customers. No adjustment for inverkory is needed 3 Record the following smmaized August transactions using the general jounalprovided. Use a blank line between transactions. Ure the aoount titles as shown in the T-aocounts, do not add any a Purchased inventory on account, 335.000 b Paid $3,200 freight foos 10 Sold inventory on account, 325,000, cogs 412,500 Paid wages and Salaries.10,000, includes the amour de from previous month d 12 e. Received payments from customers on acoount,$35,000 13 Cashsales, 110,000, cogs $55,000 14 I g Padfor 6 months of business insurance, $6,000 s h Paid for 1yearsten, $12,000 16L Recovod cash advance paymenks from customors $6,000 Ii Paid oustandng scoounks payable within the dsoount period, 138,300 18k Complered $2.000 of work for customers tha paid in advance(use Sales Account) 4 Post tho transactions to the T-accounts usereforence numbers whenposting, calculato balance in each account after alposting is complete. See T-account page for addtional 5. Prepare a tial balance. Note: Alltrialbalances are located in the same tab 6 Journalize and post any necossary adusting entries continue using the journal to record the 0nstructions entries. Hirk: There ate 3eries. After adusting entries have been posted all accountsill beused and have normalbalances 27. Addkional adustingontry Wags earned but not paid totaled $1,000 8 Propare anadustad trial balanoo Propare amultipla-step hoome Statement, a Retained Earnings Statemont, and a Classitied Balance Sheet 10. Journalize and post your o lasing entries 2s 2T1Prepare apost-closing Trial Balance 212. lernember to include your name andproject in the name of the lile before submitting! 13. Your instructor is avalable to ansver GENERAL questions. The instructor wilNOT give you the accounk names for a transaction. 314 Check Figures Instructions Grading | Begin Bal | General Journal | T accounts | Trial Balances | Income Statement | Retained Earnings | BE : Select destination and presS ENTER or choose Paste +60% 8-54 PM Type here to search 4/9/2019
