can someone put these answers into this table that is requested because I don't understand it and also add a comment please?

i would really appreciate it

I don't know how to do question 11-15. can someone help me with that.

I have to fill up this excel sheet but I don't know how

A B c D E F G 1 H 11. Using the plantwide overhead rate, what percentage of the total overhead cost is allocated to Product Y? What percentage is allocated to Product Z 12. Using the ABC system, what percentage of the Machining costs is assigned to Product Y? What percentage is assigned to Product Z? Are these percentages similar to those obtained in requirement 11? Why? 13. Using the ABC system, what percentage of Machine Setups cost is assigned to Product Y? What percentage is assigned to Product Z? Are these perontages similar to those obtained in requirement 11? Why? 14. Using the ABC system, what percentage of the Product Design cost is assigned to Product Y? What percentage is assigned to Product. Z? Are these percentages similar to those obtained in requirement 11? Why? 15. Using the ABC system, what percentage of the General Factory cost is assigned to product Y? What percentage is assigned to Product Z? Are these percentages similar to those obtained in requirement 11? Why? The percentages of overhead assigned using the plantwide and ABC approaches are computed as follows: Product Y (a) (a)+ (c) Amount % Product (b) (b)+(c) Amount % Total (c) Amount Plantwide Approach Manufacturing overhead (see 02) $684,000 Activity-Based Costing System Machining (see 09-10) Machine setups (see 09-10) Product design (see 09-10) General factory(see 09-10) Total cost assigned to products $200,000 100,000 84,000 300,000 $684,000 100% Are the percentages under the plantwide approach and under activity-based costing system similar? Comment: Inent Data Home Formulas Review View Page Layout 11 ab kar do A Percentage of the total overhead cost is allocated to Product and Product Z 6.9 Reg 11 Total 10.000 Direct Labor hours Multiplied by Plantwide CH Rate Manufacturing On Asiped Product 7,000 57.00 399,000 Product Z 3.000 57.00 171.000 570,000 65 66 67 66 69 70 71 Nape of allocation 70.00N 30 OON (399000/570000) (171000/570000) Percentage of the Machining costs is assigned to Product and Product Z Total 10,000 72 Reg 12 73 74 75 76 72 78 Machine Hours Multiply by machining activity rate Machining cost assigned Product Y 7,000 20.00 140.000 Product Z 3,000 20.00 60,000 200.000 Nape of allocation 70.00N (140000/200000) 30.00% (60000/200000) 80 Percentage of Machine Setups cost is assigned to Product Y and Productz 81 Reg 13 Total 200 Mahchine setups Multiply by machine setup activity rate Machine setup cost assigned Product 50 500 25,000 Product Z 150 500 75.000 100,000 89 84 BS 86 87 88 89 Sage of allocation 25.00 125000/100000) 75.00% (75000/100000) 90 Reg 14 Percentage of the Product Design cost is assigned to Product Y and Product Z Sheet1 Sheet2 Sheeta Ready ORT Daily AnswerSheetle - Microstice Home Insert Data Review View Page Layout Formula fab kar do 11 A D G 77 78 79 80 Nage of allocation 70.00% 30 OON (140000/200000 160000/200000) Percentage of Machine Setups cost is assigned to Product Yand Productz 81 Reg 15 82 83 Product Y 50 500 25,000 Total 200 Mahchine setups Multiply by machine setup activity rate Machine setup cost assigned Product Z 150 500 75.000 200,000 85 B6 87 BS 89 Sage of allocation 25.DON (25000/100000) 75.00N 175000/100000) Percentage of the Product Design cost is assigned to Product and Product Z Total 90 Reg 14 91 92 93 94 95 96 97 98 2 Product Y 1 42.000 42.000 No. of product Design Multiply by product design activity rate Product design cost assigned Product Z 1 42.000 42.000 84,000 Supe of allocation SODON (42000/84000) 50.00N (42000/84000) Percentage of the General Factory cost is assigned to Product and Product 99 Reg 15 100 101 Total 12.000 102 Product 8.000 25.00 200.000 Direct Labor hours Multiply by activity rate General factory OH assigned Product Z 4,000 25.00 100 000 300,000 103 104 105 106 Nage of allocation 66.67% (200000/300000) 33.33% (100000/300000) Sheet1 Sheet2 Sheeta H4 Ready H OP pter 7 Assignment Hickory Company manufactures two products-14,000 units of Product Y and 6,000 units of Product Z. The company uses a plantwide overhead rate based on direct labor hours. It is considering implementing an activity-based costing (ABC) system that allocates all 5684,000 of its manufacturing overhead to four cost pools. The following additional information is available for the company as a whole and for Products Y and Z: Activity Cost Pool Activity Measuro Machining Machino-hours Machine setups Number of setups Product design Number of products General factory Direct labor-hours Estimated Overhead Cost $200,000 $ 100,000 $84.000 $300,000 Expected Activity 10,000 MHS 200 setups 2 products 12,000 DLHS Page 341 Activity Measure Machino-hours Number of sotups Number of products Direct labor-hours Product Y 7,000 50 1 8,000 Product z 3,000 150 1 4,000 14 Required: Deily Answer Sheet.ee - Microsoft Excel Review View 684,000 12,000 Home ret Paor layout Formula Data 11 ab kar do 16 Final answer: OVERHEAD RATE = Estimated TOTAL Overhead 17 Reg1 cost/Total direct labor hours 18 19 Estimated TOTAL Overhead cost 20 Divided by total direct labor hours 21 22 Overhead 23 24 25 Reg 2 20 Labor Hour 27 Overhead rate Manufacturing OH Allocated (Labor hoverhead tate) 30 13 ACTIVITY RATE Estimated Overhead 32 cost/bxpected Activity 33 57.00 Product Y 8,000 57.00 450,000 Productz 4,000 57.00 228,000 Actvity Cost 14 35 Rega 36 Req 37 Regs 38 Rego 39 40 41 Req? Machining Machine setups Production Design General factory 200,000 100,000 14,000 300,000 Expected Activity 10,000 200 2 12,000 Activity RATE 20.00 200000/10000) 500,00 (100000/2001 42,000.00 (84000/2) 23.00 (300000/12000) Batch Level Machine Setups Sheet Sheet2 Sheet Enter 11 Q Home incent Page Layout Dat Rri View Formulas ab kar do C A 40 41 Reg 42 41 Reg Batch Level Machine Setups Product Level Product Design Activity Actvity A6 Reg 47 Machining Machine setups Production Design General factory Activity rate 20.00 500.00 42,000.00 25.00 product Y-Activity 7,000 50 2 8,000 Overehad assigned to product 140,000 (2097000 25,000 (500*50) 42,000 (420001) 200,000 (25*3000) 49 50 31 52 53 Total activity Cost 407.000 S4 Reg 10 Actvity 56 Overehad assigned to product Z-Activity productz 3,000 60,000 (20*3000) 150 73,000 (500*150) 1 42,000 (420001) 4,000 100,000 (2594000) Activity rate 20.00 500.00 42,000.00 25.00 Machining Machine setups Production Design General factory Total activity cost RODE & SEX 277,000 Percentage of the total overhead cost is allocated 69 Reg1 to Product Y and Product Sheet_Sheet2 Sheets Rey 0 B D 62 Percentage of the total overhead cost is allocated to Product and Product 63 11 65 156 Product Y 7.000 57.00 399.000 Total 10,000 Direct Labor hours Multiplied by Plantwide DH Rate Manufacturing OH Assigned Sage of allocation Product 2 3.000 57.00 171,000 570,000 68 30.00% 70 71 7000W (399000/5700001 1171000/570000) Percentage of the Machining costs is assigned to Product and Product 2 Product Z 72 Reg 12 75 74 75 76 77 7 79 30 Total 10,000 Product Y 7.000 20.00 140,000 Machine Hours Multiply by machining activity rate Machining cost assigned 3,000 20.00 60,000 200,000 Nate of allocation 70.OON (140000/200000 100000 30.000 0000) Percentage of Machine Setups cost is assigned to Product and Productz EI R13 Product Product z 150 Machine setups Multiply by machine setup activity rate Machine setup cost assigned Total 200 NA 50 500 25.000 500 85 6 75,000 100.000 ape of allocation 2500% (25000/100000) 75.00% 175000/100000) 89 30 Reg 14 Percentage of the Product Design cost is assigned to Product Y and Product Sheeti B D Sage of allocation 77 78 79 BO 70.00% (140000/200000) 30.00% (60000/2000001 Percentage of Machine Setups cost is assigned to Product Y and Product 31 Reg 13 82 80 34 Total 200 Mahchine setups Multiply by machine setup activity rate Machine setup cost assigned Product Y 50 500 25,000 Product Z 150 500 75,000 100,000 86 87 88 29 Sage of allocation 25.00% (25000/100000) 75.00% (75000/100000) Percentage of the Product Design cost is assigned to Product Y and Product z Total 2 90 Reg 14 91 92 93 94 95 95 97 98 No. of product Design Multiply by product design activity rate Product design cost assigned Product Y 1 42.000 42,000 Product Z 1 42.000 42,000 84,000 Shape of allocation 50.00N (42000/84000) 50.00N (42000/840001 Percentage of the General Factory cost is assigned to Product Y and Product z 99 Reg 15 100 101 102 103 104 105 106 Product Y 8,000 25.00 200,000 Total 12.000 Direct Labor hours Multiply by activity rate General factory OH assigned Product Z 4,000 25.00 100,000 300,000 Map of allocation 66.67% (200000/300000) 33.33% (100000/300000) Sheet1 Sheet2 Sheet3 Ready 3 Q o NE The percentages of overhead assigned using the plantwide and ABC approaches are computed as follows: Product Y (a)+(c) Amount % Product z (b) (b)+(c) Amount % Total (c) Amount Plantwide Approach Manufacturing overhead (see 02) $684,000 Activity-Based Costing System Machining (see 09-10) Machine setups (see 09-10) Product design (see 09-10) General factory(see 09-10) Total cost assigned to products $200,000 100,000 84,000 300,000 $684,000 100% Are the percentages under the plantwide approach and under activity-based costing system similar? Comment