Excel File Edit View Insert Format Tools Data Window Help G 10 8 4 2 9 8 0 Sat Jul 12 4:42 PM AutoSave O n A P V . C ... *: Alt_Lab_5.1_Data (7) ~ Home Insert Draw Page Layout Formulas Data Review View Automate Comments Share Calibri (Body) v 11 ~ A A = ab Wrap Text General Insert v E Delete v Paste BIU V V vAv E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Format v Add-ins Analyze Formatting as Table Styles Filter Select Data F20 X V fx A C D E F G H K L M N 0 P 1 February '25 Manufacturing Overhead Router Costs Finishing Department Router A Router B Router C Router D SkillCut Total Labor 16,000 4 Machine Hours 175 175 175 175 170 870 Sanding supplies 600 5 Depreciation 5,000 $ 4,500 $ 5,000 $ ,500 $ 15,000 $ 35,000 Pain 5,500 6 Maintenance 2,500 $ 2,300 $ 2,050 $ 2,250 $ 4,650 $ 13,750 Poly 2,500 7 Total Router Costs 7,500 5 6,800 $ 8,050 5 6,750 5 9,650 $ 48,750 Total 24,600 8 9 Single-stage allocation 10 Total Overhead Costs 11 Total MH 12 Allocation Rate 13 14 Two-stage allocation 15 Total Overhead Costs 16 Basic Router Poo 17 Basic Router MH 18 Basic Router Rate 19 SkillCu 20 SkillCut Router MH 21 SkillCut Router Rate 22 23 24 25 1-Stage Shaker 1-Stage Scrollwork 2-Stage Shaker 2-Stage Scrollwork 26 Machine Hours 0.05 0.05 0.05 0.05 27 Direct Materials 15.00 $ 16.00 $ 15.00 $ 16.00 28 Direct Labor 2.00 S 2.00 $ 2.00 S 2.00 ocated Overhead 30 Total Cost 31 32 33 34 35 36 37 Sheet1 + Ready Accessibility: Good to go + 100 JUL TO 12 N