Jon okbes costune pRonLEM Determine the cest to date of ewh of the seven jebts below. 6. Malerwis were Duchased co boumt 10. Tactory lator was used fosted on the ifomatod in the ube above? 1. Factory overhead cotit wote thourtod an accourt. sencos 12. Oepeciaten of tactiey inatherefy and watifmert. 11 I 13. The tactory deertieat rate. per machine heur Mrotire hours uled sppeas is the istle stove. 14. Jobs were completed. 15. Jobs were shipped to customers and inventory was adjusted. 16. Customers were billed on account for jobs sold. 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 (Quesbion 122 ) Determined during the noxt accounting period: 22. Actual factory overhead for the previous period: Instructions - Determine the numerical answers to questions \#1-22. 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 copled down to answer \#2 through #7. e. Use the SUM function when adding more than two contiguous cells. 1. 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. Q. 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. Jon OkDER COSTNG PROELEM Oetermine the cost be dite of tach of the seven jobe batise. Phothy depteief tite bet to wisitel 8. Maleiah were buchated oe accourit. 8. Nateriab were tequetiont (gased on the ifformatien in the tatse deeve) 0. Fackor laber was sied ibeted on the intampion in fhe weie above y 1. Facier evemead ceats were exewed on account. 2. Degreciasos of tackeny machinery act equipment 19.720 3. The faclory overhesd rate, per machine houc Mectire fougs ines appews in foe tetie abson Jon okbes costune pRonLEM Determine the cest to date of ewh of the seven jebts below. 6. Malerwis were Duchased co boumt 10. Tactory lator was used fosted on the ifomatod in the ube above? 1. Factory overhead cotit wote thourtod an accourt. sencos 12. Oepeciaten of tactiey inatherefy and watifmert. 11 I 13. The tactory deertieat rate. per machine heur Mrotire hours uled sppeas is the istle stove. 14. Jobs were completed. 15. Jobs were shipped to customers and inventory was adjusted. 16. Customers were billed on account for jobs sold. 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 (Quesbion 122 ) Determined during the noxt accounting period: 22. Actual factory overhead for the previous period: Instructions - Determine the numerical answers to questions \#1-22. 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 copled down to answer \#2 through #7. e. Use the SUM function when adding more than two contiguous cells. 1. 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. Q. 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. Jon OkDER COSTNG PROELEM Oetermine the cost be dite of tach of the seven jobe batise. Phothy depteief tite bet to wisitel 8. Maleiah were buchated oe accourit. 8. Nateriab were tequetiont (gased on the ifformatien in the tatse deeve) 0. Fackor laber was sied ibeted on the intampion in fhe weie above y 1. Facier evemead ceats were exewed on account. 2. Degreciasos of tackeny machinery act equipment 19.720 3. The faclory overhesd rate, per machine houc Mectire fougs ines appews in foe tetie abson