I was told this question I posted

https://www.chegg.com/homework-help/questions-and-answers/frogs-inc-part-3-allocating-service-department-costs-goal-allocate-service-department-cost-q26462124

needed more information to be answered. I have provided that information needed here.

Home Insert Page Layout Formulas Data Review view Wrap Text General 14.1 Merge &Center, $, % , -.00 Condit Paste Formattin DEPARTMENT INFORMATION Totals EngineeringOwners 200 Concrete Castine Design 3 1,000 200 200 Projects per year 4 Direct Materials S DL costs 6 DL hours 7 Inspectian costs Total for the Year 982,000 447,200 208,C0D $1,362,400 1o 71,000 $ 10,000$ D,20D $ $ $208,499,2007,200 S 16,640 4,160 43,680 L 2 Plantvide MOH 10400 ,020 12,480 500 509,70$ 1.352,200 Is Engineerin Owners 2,5 00 :S 280,030 $ Cancrete Casting Design 1S 10 13 OH c 0.00 $15400 S 3,575.2 70.00 1,106 92 Concrele nesign Engireenre Ownes 13 14 Overhead Costs 15 Setup Costs 15 Utilities 17 Equi prme. 1B Permits 19 Travel to Jabsite 20 Total 21 1,000 1,000 5,020 2,000 5,000 50,000 $ 10,000 | $-15,000 | s 5,000- $ 0DC 100,000 5 5,00 1,000 S 500 $ -5,000 $ -20,000 $ 15,50D 30,00 $186,000 14,002 245,500 23 Design Engineerine wners 29 Concrete Casting Engineerine Estimated OH 15,5 S30, 186,000 s 30 driver 31 rate 12,180 16,640 48 24011.18 S 3.37 | Sheet1 Home Insert Page Layout Formulas Data Review view Wrap Text General 14.1 Merge &Center, $, % , -.00 Condit Paste Formattin DEPARTMENT INFORMATION Totals EngineeringOwners 200 Concrete Castine Design 3 1,000 200 200 Projects per year 4 Direct Materials S DL costs 6 DL hours 7 Inspectian costs Total for the Year 982,000 447,200 208,C0D $1,362,400 1o 71,000 $ 10,000$ D,20D $ $ $208,499,2007,200 S 16,640 4,160 43,680 L 2 Plantvide MOH 10400 ,020 12,480 500 509,70$ 1.352,200 Is Engineerin Owners 2,5 00 :S 280,030 $ Cancrete Casting Design 1S 10 13 OH c 0.00 $15400 S 3,575.2 70.00 1,106 92 Concrele nesign Engireenre Ownes 13 14 Overhead Costs 15 Setup Costs 15 Utilities 17 Equi prme. 1B Permits 19 Travel to Jabsite 20 Total 21 1,000 1,000 5,020 2,000 5,000 50,000 $ 10,000 | $-15,000 | s 5,000- $ 0DC 100,000 5 5,00 1,000 S 500 $ -5,000 $ -20,000 $ 15,50D 30,00 $186,000 14,002 245,500 23 Design Engineerine wners 29 Concrete Casting Engineerine Estimated OH 15,5 S30, 186,000 s 30 driver 31 rate 12,180 16,640 48 24011.18 S 3.37 | Sheet1