AutoSave OFF Home Insert Draw Page Layout X Arial Paste BI U Ch02_student work(2)(1) Formulas Datal Review View Tell me v 10 A A A Wrap Text Merge & Center Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? F21 x fx A B C D Given Data PA2-07: 2 3 F G AMBERJACK COMPANY Most recent fiscal year data: 7 Estimated Value Actual Value Manufacturing overhead cost $ 594,000 $ 655,000 9 Direct labor cost $ 395,000 $450,000 10 Direct labor hours 16,500 11 Machine hours 7,500 18,000 8,500 12 13 14 15 16 17 18 19 20 21 22 23 24 26 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 46 46 47 48 H PA2-05 Given PA2-05 PA2-07 Given PA2-07 + Ready Share Comments General $%9 00 Conditional Format Cell Formatting as Table Styles Insert Delete Format Sort & v Filter Find & Select Analyze Data Yes No 1 J K L M N P R 8 V W Required: 1. Based on the company's cument alocation base (direct labor hours), compute the following: a. Predelenmined overhead rate. (Round your answer to 2 decimal places.) b. Applied manufacturing overhead. c. Over- or underapplied manufacturing overhead. 2. If the company had used direct labor dolars (instead of direct labor hours) as its alocation base, compute the folowing: a. Pradetamined overhaad rate b. Applied manufacturing overhead. e. Over- or underapplied manufacturing overhead. 3. If the company had used machine hours instead of direct labor hours) as its allocation base, compute the following: a. Predetermined overhead rate. (Round your answer to 2 decimal places.) b. Applied manufacturing overhead. c. Over- or underapplied manufacturing overhead. 4. Based on last year's data alone, which allocation base would have provided the most accurate measure for applying manufacturing overhead costs to production? 100%