Excel File Edit View Insert Format Tools Data Window Help L ) 61% 61% 1 Sun 11:12 PM Francesca Di Fabio Q AutoSave CF- Excel PR 18-3A In Home Insert Draw Page Layout Formulas Data Review View Share 0 Comments VA A Wrap Text w Insert v 4 LE V Delete Paste BIU = = A Merge & Center Find & Conditional Format Cell Formatting as Table Styles Sort Filter Ideas Format v Select C2 A C D F F H 1 K L N O P RS T V W X Y ZAA AR AC AD AF AH A AL AK AL A 1. Production deatment nater Cutting Department Finishing Department Factory overhead Drech labor hours Production department rate vih NH 2. Direct Labor Hours Production Department RADA Factory - Overhead 19 14 15 18 17 1L 19 20 21 22 23 24 25 26 27 28 29 30 ? 31 32 33 34 35 36 37 30 39 Icih ich Snowcards: Outling Department Finishing Department Total factory overhead Number of units Factory overhead per unit Icih ich Ska: Cutting Department Frish ng Dupartment Tatal factory overland Number of units Factory Overhead perurit 40 41 Achtbad 43 Production Control Materials Handling Cutting Department Finishing Department 47 Factory overhead Achyba Acilityrata dh proud ning Jamd nin MERA mave dlh ich 4. 49 50 51 52 53 54 55 56 57 Snowboards Activity Usage nirs Skis Activity Rate Activity Rate Activity Cost Activity Unage Activity Cost x s x inun - Imove - Activity Production Control Material Handling Quiling Department Fane Daisriman Pr. 1844)-3A moves dla moves All Irun imove Ich X + 100% Excel File Edit View Insert Format Tools Data Window Help L 61% 1 Sun 11:12 PM Francesca Di Fabio Q AutoSave CF- Excel PR 18-3A In Home Insert Draw Page Layout Formulas Data Review View Share 0 Comments v AA Wrap Text w Insert v 4 V Delete Paste LE 4 BIU des = = A Merge & Center Find & Conditional Format Cell Formatting as Table Styles Sort Filter Ideas Format v Select C2 A D E F H 1 1 N O P R V w Y ZAA AR AC AD AF AH A AL AK AL A Factory overhead perurit Icih vih 31 32 33 34 35 36 37 38 39 40 41 Skla: Cutting Department Finishing Department Total factory overhead Number of units Factory overhead per unit Acility-based rates 43 Production Control Materials Handling Cutting Department Finishing Department Factory overhead Aciba Acthy rate dlh prad ruina Jamo un mave ah dh ich 4. 46 46 47 ? 48 49 50 151 52 53 54 55 56 57 58 59 60 Activity Rate Skis Activity Rate Activity Cast Snowboards Activity Usage x nurs moves 1 dia Activity Coat irun imove - ich Activity Usage x ( ins moves Irun Imove x - Activity Production Control Contoh Material Handling Outling Department Finishing Department Total Number of units Activity cost per unit X ich - ch dlh x ich 62 [Kay Ay Answer here) 63 64 A5 GE 87 59 70 71 72 73 Pr. 1814)-3A + 100% C PR 18-3A Activity-based and department rate product costing and product cost distortions Obj. 3, 4 Black and Blue Sports Inc. manufactures two products: snowboards and skis. The factory overhead incurred is as follows: EXCEL TEMPLATE Indirect labor Cutting Department Finishing Department $507,000 156,000 192,000 $855,000 Total