please follow instructions and use the formulas for each answer:)

JOB ORDER COSTING PROBLEM Jonick Industries, Inc. uses a job order costing system in manufacturing custom products. The following table summarizes data related to production in June, the first month of operations. Determine the cost to date of each of the seven jobs below. Factory overhead rate per machine hour: Complete the following transections for Jonick industries by entering the amounts. The transactions relate to one another. 8. Moterials were purchased on account. 9. Materials were requisitioned (based on the information in the table above.) 10. Factory labor was used (based on the information in the table above.) 11. Factory overhead costs were incurred on account 12. Depreciation of factory machinery and equipment: 13. The factory overhead rate, per machine hour: Machine hours used appears in the table above. 14. Jobs were completed. 15. Jobs were shipped to customers and imventory was adjusted. 16. Customers were billed on account for jobs sold. Instructions - Determine the numerical answers to questions #122. a. Use formulas and/or functions to determine each answer rather than typing in numerical answers. b. Use variables/cell references rather than typing numbers into the formulas. c. Do not use "helper cells". Your only entries should be in the yellow answer cells. Your formulas may only reference cells where data is given OR cells where you have previously entered in answers. d. Enter a formula for answer #1 and so that it can be copied down to answer #2 through #7. e. Use the SUM function when adding more than two contiguous cells. f. Use the SUMIFS function when adding values only when a condition is true. There are at least five answers where a SUMIFS function is appropriate. 9. Use the ABS function when a negative result is possible but the answer must show as a positive number. There is one answer where an ABS function is appropriate. IMPORTANT: Your formulas should work for different data sets, such as a. If the amounts given were different. b. If some or all of the five completed jobs were different ones than the five shown in your version. c. If some or all of the three jobs that were sold were different ones than the three shown in your version