CAN YOU HELP ME FIND C

Whispering Juice Company produces and distributes concentrated orange juice. It has been operating in two key customer segments for years, selling to institutional customers and retail customers. The production departments are supported by the following three services: Administrative, Information Systems, and Maintenance. To date, the accounting team has simply allocated the support costs evenly between the two operating segments in order to determine total costs. Realizing that there are more accurate ways of assigning these costs, the new controller has asked you to prepare support department cost allocations using three other (and arguably more accurate) methods. Financial information is as follows. (a) Determine the total costs that each operating segment would be accountable for if support costs are allocated using the direct method. (Round intermediate calculations to 4 decimal places, e.g. 15.2516 and final answers to 2 decimal places, e.g. 15.25.) (b) Determine the total costs that each operating segment would be accountable for if the step method is used to allocate support costs; assume support departments are ranked according to their original cost. (Round intermediate calculations to 4 decimal places, e.g. 15.2516 and final answers to 2 decimal places, e.g. 15.25.) Determine the total costs that each operating segment would be accountable for if support costs are allocated using the direct method. (Round intermediate calculations to 4 decimal places, e.g. 15.2516 and final answers to 2 decimal places, e.g. 15.25.) (b) Determine the total costs that each operating segment would be accountable for if the step method is used to allocate support costs; assume support departments are ranked according to their original cost. (Round intermediate calculations to 4 decimal places, e.g. 15.2516 and final answers to 2 decimal places, e.g. 15.25.) (c) Use Excel to determine the total costs that each operating segment would be accountable for if support costs are allocated using the reciprocal method. (Round answers to 2 decimal places, e.g. 15.25.)