A-E create a LEDGER, b TRIAL BALANCE, c INVENTORY TRACKING, d INCOME STATEMENT, e RETAINED EARNINGS based on instruction page

Midnight Supplies buys a specialty commercial electrical component and resells it to contractors in their region. At the end of December 2021. They had the following balances in their accounts: Cash - 54.254,000 Accounts Receivable - $385,050 Inventory - 5562,500 17.500 units at $75 Each) Supplies - $8.000 Equipment - $100,000 Less Accumulated Depreciation - 530,000 Accounts Payable - 5187,000 (Need to pay by sa to calm discount) Common Stock - $1,000,000 Retained Earnings -54,092.550 Following we some relevant policies at Midnight They use a Perpetual FIFO system for recording inventory All wailable purchase discounts must be calmed 6 sales taxis collected on each sale Loring the first quarter 2022, Midnight had the following transaction: Jan 1 - Pay 516,000 in warehouse rent Jan 5-Beta pays in full for units purchased in December lan 10 - Purchase 22.500 units at $85 on account (Terms 2/15, w/30; FOB Destination Shipping $550) Jan 14 -Pay S28,436 in wages Jan 15-Pay 51785 in warehouse utilities an 17 - Pald Quarterly Insurance payment of $12459 Jan 28 - Sell 11,250 units at $150 per unit to ACME Construction for Cash (ACME picks up at Warehouse) San 28 -Pay 528,436 in Wages Jan 30 - Sell 3,750 units at $150 per unit to Beta Contractors on account (Terms 1/10, 1/30 FOB Destination. Shipping $195) Beta claims the discount Feb 1 Pay 516,000 in warehouse rent leb -Sell 1.500 units at $150 per unit to Charlie's Construction on account Terms 1/10, w/30708 Destination, Shipping S7) Charlie's pays on the due date Feb 10 - Purchase 54,000 units at 87 50 on account (Terms 2/15, 1/30 FOB Destination. Shipping $297) Feb 11 - Pay 528.436 in Wages Feb 15 - Pay 51674 in Warehouse utilities Feb 16-Sell 27,000 units at 5160 per unit to Devin's Designer Dwellings on account (Term 1/10, 1/30 FOB Destination. Shippine 523) Devin's claims the discount Feb 25- Pay 528.436 in Wages Feb 26 - Bought $7,000 in supplies feb 28 Sell 25,500 units at $100 per unit to ACME Construction for Cash (ACME picks up at warehouse) Mar 1-Pay 516,000 in warehouse rent Mar 5 - Purchase 45,000 units at $89.50 on account (Terms 2/15,6/30; FOB Destination. Shipping $273) Mar 11 - Pay $28,436 in wages Mar 13 - Pay 5245 for add in Contractors Quarterly Mar 14 Sell 30,000 units at $160 per unit to Charlie's Construction on account (Terms 1/10, 1/30) Charlie's pays on the due date. Mar 15- Pay S1598 in warehouse utilities Mar 25 - Purchase 7.500 units at $90 per unit on account (Terms 2/15, 1/301 Mar 25- Pay 528.436 in Wages Mar 30- Sell 26,250 units at $160 per unit to Ed's Electric on account (Terms 1/10,6/30) Ed's claims the discount. Shipping costs $263 Mar 30 - Paid Dividends of S600,000 At the end of the period, supplies on hand were $6,000 Accrued Wages were $11374.40 Deotec SI Total Debits Total Credits 5.309,550 5.309,550 Cash 4.254.000 4.254.000 4.254.000 Accounts Receivable 385,050 385.050 385 050 Inventory 562.500 562,500 562.500 Supplies 8,000 8.000 8.000 0 0 0 0 Account Balance Totals Beginning 1.Jan S.Jan 5-Jan 10-Jan 14.Jan 15-Jan 17.Jan 25 Jan 28.Jan 28-Jan 30-Jan 1.Feb S-Feb 9-Feb 10-Feb 11-Feb 15-Feb 16-Feb 25-Feb 25-Feb 26-Feb 26-Feb 28-Feb 1-Mar S-Mar 7-Mar 11.Mar 13-Mar 14-Mar 15-Mar 20. Mar 25.Mar 25-Mar 30-Mar 30-Mar 31 Mar 31. Mar 31-Mar 31-Mar 31-Mar 31. Mar 31-Mar Instructions Journal Ledger Trial Balances Inventory Tracking Income Statement Statemen Retained Equipment 100,000 100.000 100,000 Accumulated Depreciation 30,000 0 30,000 30,000 Accounts Payable 187.000 0 187.000 187,000 Common Stock 1.000.000 0 1.000.000 1.000.000 0 0 Instructions Journal Ledger Trial Balances Inventory Tracking Income Statement Statemen Rent Expense Wages Expense Utilities Expense Insurance Expense Retained Earnings 4,092.550 0 4,092 550 4,092.550 0 0 O 0 0 O Instructions Journal Ledger Trial Balances Inventory Tracking Income Statement Statemen Insurance Expense Sales Revenue Cost of Goods Sold Shipping Expense Adverti 0 0 0 0 0 0 0 0 Instructions Journal Ledger Trial Balances Inventory Tracking Income Statement Statemet Advertising Expense 1 Dividendes Supplies Expense Wages Payable Depreciation Expense 0 0 0 0 0 0 0 0 Depreciation Expense Income Summary 0 0 0 0 Closing Credits 4.082.0001 8.910.000 947.250 6,000 100,000 40,000 661,500 1,000,000 12.332,375.6 Cash AR Inventory Supplies Equipment Accumulated Depreciation Accounts Payable Common Stock Retained Earnings Rent Expense Wages Expense Utilities Expense Insurance Expense Sales Revenue Cost of Goods Sold Shipping Expense Advertising Expense Dividends Supplies Expense Wages Payable Depreciation Expense Pre-adjusted Adjusted Debits Credits Debits Credits Debits 4,082,000 4,082,000 8,910,000 8.910,000 947,2501 947,250 15,000 6,000 100,000 100,000 30.0001 40,000 661,500 661,500 1.000.000 1,000,000 4,092,550 4.092,550 48,000 48.000 170,616 181.990.4 5,057 5,057 12,459 12.459 19,736,175 19.736,175 10,728.450 10.728,450 1,148 1.148 245 245 500,000 500,000 9,000 11.374.4 10,000 11.374.4 Total 25,520,225 25,520,225 25,541.599.4 25,541,599.4 14.045,250 14.045.250 Instructions Journal Ledger Trial Balances Inventory Tracking Income Statement Statemer Purchases Unit Cost Total Cost Cost of Goods Sold Unit Cost Total Cost Date Inventory Unit Cost Total Cost Quantity Quantity Quanity | 10-Jan 28-Jan 30-Jan 5-Feb 10-Feb 16-Feb 28 Feb S. Mar 14. Mar 25-Mar 30. Mar Kod of Month Instructions Journal Ledger Trial Balances Inventory Tracking Income Statement Stateme Sales Revenue Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses Wages Expense Rent Expense Insurance Expense Depreciation Expense Supplies Expense Utilities Expense Shipping Expense Advertising Experise Net Income Instructions Journal Ledger Trial Balances Inventory Tracking Income Statement Statemen Beginning Retained Earnings Adjustments Plus: Net Income Less Dividends Total Change in Retained Earnings Ending Retained Earnings . 17000 1871 )+ss, 17 Jan Wouchou RATC 600 To coinbank MC 16000 bung waushawe were paid) 0 1000 To Canne (Bung account payetle pacat in full) Janio Ruunase me To Pay ad sa ARC 1890 (Being feeas purchased Jan 14 wages A 28436 ( | bark Mc 24436 (Bring wages paid) n 6 o'tan | Bark 1115 |bcura ) 1 1249 To Bank 149 (burg pasa) Jan 28 AME chaupes 0x 615 3100 14 sv) 1687500 (Euro Jan 28 wages All 28436 To Banxicain (Bung paid you wa 28436 Jan 30 BQ Comise MC To Som 56645 Being goods nela) 5690 14 OM 16000 Feb or warnause Rent To con Bank I being rent paid) fabot Chante consta dun MC To soles baire interna 25000 67 MC 22542 400 f fabot Fuso f) o . FARM Wages me fet is Nawrow Rent A To00 1600 To con Bank Ibung sent paid) 25000 Chalecos din Shapping MC 62 22.5067 To sos tu Bung soll moms) a MC 50kzo (sogo-w1) ll Ad c o 542(somo w1) To Beto Cambodia 562500 ( ), ou 4125000 12000 To th (6ing q ) 21434 28436 (Bing wage paia) 14 To lona com I Poin for Shipping thouges 4320513 TO SO (burg ) 43% 28436 (st u ) Bank MC DU 32000 To Dewin Designer ( ) 30 10 (@art ) Nostru ( fus 10 0 DA 4320000 523 fb2 Nages AR fab A fab 26 Goods MC To yotes 16000 reb 28 canale To SAMPLE ( ) Warunaue Rent 5. To cain me (burg Kva pas) , h (burq q ud) MOND to basit concen (Benig OLLUYU Ad) Oddam D E 462H00 2000 225000 13 24 | 16000 0 220000 4 241 n 24 Na Rut To con (up Kvi pia) A 270 E To Toyot (buri , ) Maybe Bon PC 22.000 to brasil Canelow.club (bu ) 13 blivit up lfoss cout) Mon 14 trgel Cavalli To Som I Bung geeds seed MOUS Woxen 54 To air MOA Nages 28436 To Cain besig white ) 20 To S04% Bung gende wed) No 1598 ) , 2 000 Shopping the 4 TO SOM Duratind Te alr ( ) t 600 000 MOM BA Depuri un MC o taxA. . ( ) Pau 10000 (Being dep written og No To of wages nic 1314-46 ( ) 6000 uro000 (Crow tr min + 85 ) 40000 To BANA MPC D To con 2508 X (fois a ) Nage bung wages pain) as Aut 24 To com 244 20 Nicoto 3 - To 50413 (Bing pead rela) Scupping en TO SAM Dusand (Burg dusi gand pain) To in oo two 000 10000 Mar 31 med tapes . l To fr ( ) Pau % ilm ne 10000 (Being dep written af Tools Wages nic 37 (Bring wage accrued) hi 6000 Dablu MC DHL uro000 (Crow t + 105 13 ) 4000 , Being balances au pure balance ines) - -1500 No 4021500 Beine wudite balans op * is assumed that while making the purchase of greats - . 4 % 350 boyf 4 AIJuy. itself