Hello, I believe I got the first section correct. However I am struggling with the next highlighted section. I got the first section done with the help of a video and wanted to make sure I am doing this correctly and how I would work on the next highlighted section. I uploaded 2 pictures, Converse 1 which is the start of the problem and Converse 2 which is the second part of the problem where I am struggling. They loaded to where Converse 2 is on top, but that is the second part of the question. Please let me know if you need anymore information.

AutoSave (O Off) ACT500CTworksheetMod04Option01 (1) - Excel Search Warren W X File Home Insert Page Layout Formulas Data Review View Help Share Comments Calibri 11 - AA ap Wrap Text Custom Insert * Delete * AY O Paste CA BIU ~ E = Merge & Center * $ ~ % " 70 20 Conditional Format as Cell Format Sort & Find & Ideas Formatting Table Styles Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing Ideas F5 X V 19200 A B C D E F G H K - Converse Homes has two manufacturing departments-- Assembly and Production UI A W N Estimates at the beginning of the year Assembly Production Total Manufacturing Overhead Costs 480,000 $ 528,000 $ 1,008,000 Direct Labor-hours 12,000 7,200 19,200 Machine hours 4,800 24,000 28,800 LO 00 Job 142 Direct labor-hours 25 17 42 10 Machine hours 17 20 37 11 12 13 1. Calculate the amount of manufacturing overhead applied to Job 142. Converse uses a plantwide predetermined overhead rate based on direct labor hours. Data Sheet2 + Ready + 100% Type here to search O P N X W 9:58 PM 9/5/2020AutoSave (O Off) ACT500CTworksheetMod04Option01 (1) - Excel Search Warren W X File Home Insert Page Layout Formulas Data Review View Help Share Comments X 11 - AA ap Wrap Text Custom Insert * Calibri AY O BIU Merge & Center * $ ~ % " 70 20 Conditional Format as Cell Delete * Paste Formatting Table Styles Format Sort & Find & Ideas Filter ~ Select * Clipboard Font Alignment Number Styles Cells Editing Ideas X V 19200 A B C D E F G H K - 8 Job 142 9 Direct labor-hours 25 17 42 10 Machine hours 17 20 37 11 12 13 1. Calculate the amount of manufacturing overhead applied to Job 142. Converse uses a plantwide predetermined overhead rate based on direct labor hours. 14 Manufacturing Overhead Applied to Job 142: Assembly Production Total 15 Direct Labor Hours 25 17 42 16 Multiply by: Predetermined Plantwide Overhead Rate $52.50 $52.50 $52.50 17 Manufacturing Overhead $1,312.50 $892.50 $2,205.00 18 2. The CFO is considering changing the allocation base for Production to machine hours (instead of direct labor hours). The allocation base for Assembly would continue to be direct labor hours. 19 Exlain the results if this change is made: 20 Assembly Production Total 21 Manufacturing overhead allocated to Job 142: 22 23 24 25 26 27 Data Sheet2 + Ready + 100% Type here to search N X W 9:59 PM 9/5/2020