I need help specifically turning this in through excel using excel formulas.
JA AB C D E F G 8 9 10 For each of the transactions for the month below. Journalize the necessary entry. The first entry has been completed for you. 11 12 a. Materials purchased on account, $412,000. Description Debit Credit 13 14 15 16 17 b. Materials requisitioned for use in production, $398,000. $18,000 of this was for general factory use. Description Debit Credit 18 19 20 21 22 23 c. Factory tabor during the period was $550,000 $30,000 of this was indirect Description Debit Credit 24 25 26 27 28 29 d. Depreciation of the factory equipment, $26,000 Description Debit Credit 30 31 32 33 34 e. Depreciation of the office equipment, $15,000. Description Debit Credit 35 36 37 38 39 1. Factory prepaid rent that expired during the period, $6,000 Description Debit Credit 40 41 42 Sheet1 + Ready Calibri (Body) 11 ' AA 23 Wrap Text General Paste Ingers BTU Merge & Center $ % 9 *** Conditional Format Cell Formatting Table Sty Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Form Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates, P72 x x AB D 3 1. Factory prepaid rent that expired during the period. $6,000 3 Description Debit Credit F G H 1 2 3 4 9. Office prepaid rent that expired during the period, $2,000. Description Debit Credit 6 7 h. Other conts incurred on account for factory overhead included $40,000 Description 9 Debit Credit 0 1 2 Estimated factory overhead cost for the period was $120,000 and estimated direct labor hours for the period were 40,000 hours Assuming that overhead is applied based on direct labor hours and that the company used 42,000 direct labor hours during the period, apply factory overhead Description Debit Credit 6 7 Close out the factory overhead balance to cost of goods sold Description Debit Credit 1 Jobs completed during the period. 5000.000 Description Debit Credit I Goot of goods sold 5850,000. Debit Credit Dencription 1 Sheet1