AutoSave Ce Parry_bma05_4_20a_start - Read Only - Excel Dillan Parry CP File Home Insert Draw Page Layout Formulas Data Review View Help Search Share Comments AutoSum Calibri 12 ~ A A == 89 Wrap Text Currency 47 0 4 ME rill Peste X Out [Copy Format Painter Clipboard FH BIU w A Insert Delete format Idees Merge Center $ % -9 Clear Conditional format as Cell Formatting Table Styles Styles Sort & Tind Filter Sclect Eding Font Alignment Numer Cels dias E F H B L L N O P 0 F F S T U X Y Y Z AE B7 B C D 1 1. Compute the cost allocation rate for each activity. Always use cel references and formulas where appropriate to receive full credit. If you 2 copypaste from the instruction tab you will be marked wrong-1 3 + Full Company 5 Computation of Cost Allocation Rates Activity cost 5 Act Me Allocation Rate 7 Materiak handing per part B Machine setup per setup gretion of parts per part nishing per hur TI t . Compute the manufacturing overhead cost that should be assigned to lnb 420. Always use cel references and formulas where appropriate to receive full credit. If you 13 copy paste from the Instruction tab you will be marked wrong 14 6 Job 420 18 Manufacturinn overhead allocation 17 Act My MCH Sched Materials handing Machine setup 21 sertion of parts 21 Enishing 22 Total . 243. Compute the manufacturing overhead cost that should be assigned to Job 10. (Always use cel references and formulas where appropriate to receive full credit. If you 2 copy paste from the Interaction tab you will be marked wrong. 22 Job 510 29 Manufacturing overhead allocation 23 Activity MOH and 2. Material handing 31 Machine setup : Insertion of parts 39 Finishing 34 Total INSTRUCTIONS ENTERANSWERS IFI WI - Type here to search O E! ENG 11:14 AM 12/16/2020 AutoSave Ce Parry_bma05_4_20a_start - Read Only - Excel Dillan Parry CP File Home Insert Draw Page Layout Formulas Data Review View Help Search Share Comments AutoSum Calibri 12 ~ A A == 89 Wrap Text General . NI EX 27 O 4 Brill X Cut [Copy Peste * Format Painter Cipboard EE Insert Delete format Idees BIU. $ % -8 Merge & Center Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Eding Font Alignment Number Cels dias R4 > H 1 J L M N 0 T u U X Y Z z RE AD AE UF D E F G 2 Compute activity rates and apply to jobs 3 Faller Company uses ABC to Account for its champ wheel Manufacturing proces. Company managers have identfied four manufacturing activities that incur manufacturing overhead costs materials anding, machine setup, insertion of sorts and finishing. The budgeted activity costs for the upcoming year and their location + bases are as follows: 5 Tatal Budgeted Manufacturing G Activity Overhead Oost Allocation Base 7 Materials handling $12,000 Number of parts Machne setup 3,400 Number of setup 9 Insertion of parts 48,000 Number of part 10 Finishing 30.000 Finishing direct labor hours TOL $18.400 Roller Fuller Company expects to produce 1.000 chrome wheels during the year. The wheels TI are expected to use: Parts Finishing Hours Consumed 70 2,000 10 2,000 16 Finishing Parts Setups Hours 12 Hequired Consumed 18 Job 430 200 2 130 Job 310 425 4 250 21 21 use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If 22 you copy/paste from the Instruction tab you will be marked wrong. 24 Requirements 2 1 Compote the cost a location rate for cach activity 2 Compute the manufacturing overhead cast that should be assigned to ob 420 21 3 Compute the manufacturing overhead cost that should be assigned to lob S10. INSTRUCTIONS ENTERANSWERS - Type here to search O E! ENG 11:05 AM 12/16/2020 Braun 5c F4 20A vis_Instructions - Protected Vicw - Saved to this PC Dillan Parry DP File Home Insert Draw Design Layout References Mailings Review View Help Search Share Comments PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's sater to stay in Protected View Enable Editing Grader Instructions Accounting 2016 Project Braun 5e E4-20A V6 Project Description: bma05.04.20a LO 2 Steps to Perform: Step Instructions Points Possible 1 4 2 5 1. Compute the cost alocation rate for each activity. (Nways use cell references and formulas where appropriate to receive full credit. If you copripasto from the Instruction tab you will be marked wrong.) 2. Compute the manufactunng overhead cost that should be assigned to Job 420. (Always use cell references and formulas where appropriate to receive ful credit. If you copyinaste from the Instruction tab you will be marked wrong) 3. Compute the manufacturing overhead cost that should be assigned to Job 510 (Always use cell references and formulas where appropriate to receive ful credit. If you Coloaste from the Instruction tab you will be marked Wrona.) 3 5 Total Points 14 Page 1 of 1 132 word: Focus 100% Type here to search O ENC 11:05 AM 12/16/2020