Question Sheetv11 - Microsoft Excel - O X X Home Insert Page Layout Formulas Data Review View Developer QuickBooks F54 fix =F46-SUM(F48:F52) D E F G H K L M N 0 P A B C 25 26 27 1) Calculation of product margin as per Traditional costing 28 Total Per Unit 29 B300 T500 B300 T500 30 No. of Units Sold 88,000 24,000 88,000 24,000 31 32 Sales: 5,280,000 2,160,000 60 90 33 34 Less: Cost of Goods Sold 35 Direct material 830,000 261,600 3.75 10.90 36 Direct labor 2,904,000 1,584,000 33.00 66.00 37 manufacturing overhead 579,732 316,218 6.59 13.18 38 39 Product Margin 1,466,268 1,818 16.66 0.08) 40 41 42 2 Total Per Unit 43 B300 T500 B300 T500 44 No. of Units Sold 88,000 24,000 88,000 24,000 45 46 Sales: 5,280,000 2,160,000 60 90 47 48 Less: Cost of Goods Sold 49 Direct material 330,000 261,600 3.75 10.90 50 Direct labor 2,904,000 1,584,000 33.00 66.00 51 manufacturing overhead 410,850 274,100 4.67 11.42 (See Note 1 Below) 52 Less: Advertising Expense 306,000 496,000 3.48 20.67 53 54 Product Margin 1,329,150 (455,700) 15.10 (18.99) 55 56 Note 1: Overhead allocation sheet 57 B300 T500 OH Cost OH Rate= Total Driver assigned=Activity Driver OH Cost assigned=Activity Activate Windows Total Cost 58 Activity Total OH Cost Driver OH/Total cost driver Incurred Rate * Driver incurred Incurred Rate * Driver incurred Go to PC settings to activate Windows Sheet2023 Sheet2024 Sheet2025 Sheet2026 Sheet2027 Sheet2028 Sheet2029 Sheet2030 Sheet2031 Sheet2032 Sheet2033 Sheet2034 Shl 80 80% + Ready 12:14 AM 03/04/21- O X Question Sheetv11 - Microsoft Excel X Home Insert Page Layout Formulas Data Review View Developer QuickBooks F54 fix =F46-SUM(F48:F52) C D E F G H K L M N 0 P A B 56 Note 1: Overhead allocation sheet 57 B300 T500 OH Cost Total Cost OH Rate= Total Driver assigned=Activity Driver OH Cost assigned=Activity Activity Total OH Cost Driver OH/Total cost driver Incurred Rate * Driver incurred Incurred Rate * Driver incurred 58 169,200 204,000 2.30 132,000 303,600 72,000 165,600 59 Machining 60 28,750 625.00 22 24 15.000 Setup 46 13,750 93,500 93,500 61 Product Sustaining 187,000 93500.00 62 274,100 63 Total 584,950 410.850 64 65 3 Quantitative Comparison of the traditional and activity based assignment. 66 67 ABC costing system Traditional costing system 68 B300 T500 B300 T500 %age=B30 Mage=1500 Amount/T %age=1500 "age=B300 otal Amount/To Total Amount/Total Amount/Total tal Amount amount 69 Amount Amount Amount Amount Total Amount Amount Amount Amount 70 Direct material 830,000 55.8% 261,600 44.2% 591,600 Direct cost: 64.7% 1,584,000 35.3% 4,488,000 Direct material 330,000 55.8% 261,600 44.2% 591,600 71 Direct labor 2,904,000 316,218 35.3% 895,950 Direct labor 2,904,000 64.7% 1,584,000 35.3% 4,488,000 72 manufacturing overhead 579,732 64.7% 306,000 38.2% 496,000 61.8% 802,000 73 Selling and Admin Exp 74 Total cost assigned to product 3,813,732 2,161,818 5,975,550 Indirect Cost: Machining 303,600 165,600 35.3% 75 Selling and administrative Expens 1,382,000 64.7% 469,200 13,750 47.8% 15,000 52.2% 28,750 76 Total Cost 7,357,550 Setup 93.500 50.0% 93,500 50.0% 187,000 77 Product Sustaining 3,950,850 2,615,700 6,566,550 78 Total cost assigned to produc 79 Cost Not assigned to product Selling and Admin Exp 580,000 (1382000-802000) 80 Other 211,000 81 Total Cost 7,357,550 82 83 Activate Windows 84 Go to PCsetting is to activate Windows OF 14 Sheet2023 Sheet2024 Sheet2025 Sheet2026 Sheet2027 Sheet2028 Sheet2029 Sheet2030 Sheet2031 Sheet2032 Sheet2033 Sheet2034 Shl #0 80% + Ready 12:14 AM 03/04/21
