Hello, I am having a difficult part with the second question. I believe I got the first part right but I am struggling with the second half. It's two parts. It's asking for machine hours, so not a predetermined rate. Then it is asking the results if changes were made, so would I subtract the second part from the first part? I included two pictures, converse 1 and converse 2. They go in order as Converse 1 shows the first question and then Converse 2 is the questions I am struggling with. Thank you
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
