please help me work out the journal entries and fill out the amounts at the end of the period. these are the only instructions given. we first need to calculatue the job cost to date then fill out all the questions below using all the numbers in production we got from all 7 jobs. Thank you.

JOB ORDER COSTING PROBLEM Instructions - Determine the numeric Jonick Industries, Inc uses a job order costing system in manufacturing custom products, a Use formulas and/or functions to de b. Use vanablece reference rather The following table summarizes data related to production in June, the first month of operations c Do not use the per cells" Your formulas may only reference Determine the cost to date of each of the seven jobs below. cells where you have previously (only sold) (Questions #1-7) d Use the SUM and SUMIF functions Factory Machine Sales Job Cost e. Consider using the SUMIFS functio Job Materials Labor Hours Completed Price to Date Job 201 6,680 13,130 90 Answer #1 using a formula that mayb Job 202 16,380 10,930 70 yes 2 Copy the formula for #1 down in order Job 203 9,310 7,670 40 yes 32,950 3 9,500 Job 204 15,810 60 yes 4 5 Job 205 13,150 4,830 40 5,170 Job 206 13,300 30 yes 6 34,460 Job 207 7,410 6,830 25 yes 7 26,760 For general factory use 17,550 5,530 "The factory overhead rate per machine hour appears in cell L70 below 1 (Questions 118-16) Complete the following transactions for Jonick Industries by entering the amounts. VV Z AA AB AD Instructions - Determine the numerical answers to questions #1-22 a Use formulas and/or functions to determine each answer b Use vanables/cell references rather than typing numbers into the formulas c. Do not use "helper cells" Your formulas may only reference cells where data is given OR cells where you have previously entered in answers. d. Use the SUM and SUMIF functions at least twice each. e. Consider using the SUMIFS function, although it is not required Answer #1 using a formula that may be copied down to the six cells below it. Copy the formula for #1 down in order to answer #2 through #7 Complete the following transactions for Jonick Industries by entering the amounts. The transactions relate to one another. 8. Materials were purchased on account. $123,470 Date 8. Debit Credit Account Materials Accounts Payable 9. Materials were requisitioned (based on the information in the table above.) Debit Credit Date 9 Account Work in Process Factory Overhead Materials 10. Factory labor was used (based on the information in the table above.) Date Debit Credit 10. Account Work in Process Factory Overhead Wages Payable 11. Factory overhead costs were incurred on account $16,610 Date Debit Credit 11. Account Factory Overhead Accounts Payable 12. Depreciation of factory machinery and equipment $14,270 Date Debit Credit 12. Account Factory Overhead Accumulated Depreciation 13. The factory overhead rate, per machine hour Machine hours used appears in the table above. $60 Date 13 Debit Credit Account Work in Process Factory Overhead 14. Jobs were completed. Date 14. Debit Credit Account Finished Goods Work in Process 15. Jobs were shipped to customers and inventory was adjusted. Debit Credit Date 15. Account Cost of Goods Sold Finished Goods 16. Customers were billed on account for jobs sold. Date 16. Debit Credit Account Accounts Receivable Sales 7 8 9 DO 01 2 3 4 5 6 7 8 9 0 1 2 B Determine the following amounts at the end of the first accounting period based on the journal entries above. (Questions #17-21) 17 Ending balance in the Materials account 18. Cost so far of all uncompleted jobs 19. Cost of all jobs completed but not yet sold 20. Cost of all jobs that have been sold 21. Gross profit on all jobs that have been sold 4 19. Cost of all jobs completed but not yet sold 20. Cost of all jobs that have been sold 21. Gross profit on all jobs that have been sold (Question #22) Determined during the next accounting period: 22. Actual factory overhead for the previous period: $21,690 Debit Credit Date 22 Account Cost of Goods Sold Factory Overhead 1 6 7 8 9 0 1 2 3 14 35