i need alot of help to properly use excel formulas to submit this
Please be sure to submit your file as an Excel file. Any submissions in numbers format will receive a 0. AB D E F G Please be sure to submit your file as an Excelfie. Any submissions in number format will receive a 0 Cost Flow Journal Entries Student Name: Section Number: 5 6 7 8 9 10 11 12 For each of the transactions for the month below.journalize the necessary entry. The first entry has been completed for you. a. Materials purchased on account, $412,000. Description Debit Credit 33 14 15 16 17 18 b. Materials requisitioned for use in production, $398,000 $18,000 of this was for general factory use. Description Debit Credit 19 20 23 22 23 c. Factory labor 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 L 30 31 32 23 34 e. Depreciation of the office equipment, $15,000. Description Debit Credit 35 36 Sheet1 Calibri (Body) General [ 11 - ' ' CA- Wrap Text Merge Center Paste B S% 898 Conditional Format Formatting as Table Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? * Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates 071 fx D G 37 38 39 Factory prepaid rent that expired during the period, 56,000 Description Debit Credit 40 42 43 44 9. Office prepaid rent that expired during the period. $2,000 Description Debit Credit 46 47 h. Other costs incurred on account for factory overhead included $40,000 Description 40 Debit Credit 50 51 52 53 54 55 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 58 59 60 Close out the factory overhead balance to cost of goods sold Description Debit Credit 61 62 64 65 k Jobs completed during the period. 5900,000 Description Debit Credit 66 67 1 Cost of goods sold, $850,000. 69 70 Description Debit Credit 71 Sheet1 + Please be sure to submit your file as an Excel file. Any submissions in numbers format will receive a 0. AB D E F G Please be sure to submit your file as an Excelfie. Any submissions in number format will receive a 0 Cost Flow Journal Entries Student Name: Section Number: 5 6 7 8 9 10 11 12 For each of the transactions for the month below.journalize the necessary entry. The first entry has been completed for you. a. Materials purchased on account, $412,000. Description Debit Credit 33 14 15 16 17 18 b. Materials requisitioned for use in production, $398,000 $18,000 of this was for general factory use. Description Debit Credit 19 20 23 22 23 c. Factory labor 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 L 30 31 32 23 34 e. Depreciation of the office equipment, $15,000. Description Debit Credit 35 36 Sheet1 Calibri (Body) General [ 11 - ' ' CA- Wrap Text Merge Center Paste B S% 898 Conditional Format Formatting as Table Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? * Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates 071 fx D G 37 38 39 Factory prepaid rent that expired during the period, 56,000 Description Debit Credit 40 42 43 44 9. Office prepaid rent that expired during the period. $2,000 Description Debit Credit 46 47 h. Other costs incurred on account for factory overhead included $40,000 Description 40 Debit Credit 50 51 52 53 54 55 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 58 59 60 Close out the factory overhead balance to cost of goods sold Description Debit Credit 61 62 64 65 k Jobs completed during the period. 5900,000 Description Debit Credit 66 67 1 Cost of goods sold, $850,000. 69 70 Description Debit Credit 71 Sheet1 +
