Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please provide an answer using excel formulas! thanks:) 5 7 AR c 11 Lirpa Inc. has the following data to be used in its service

please provide an answer using excel formulas!
thanks:)
image text in transcribed
image text in transcribed
5 7 AR c 11 Lirpa Inc. has the following data to be used in its service department cost location Service Departments Operating Departments Custodial Cafeteria Processing Packaging Departmental cost $ 150.000 $ 210.000 $875.000 5550 Space occupied in m2 500 2.000 10 JO WAKO Number of employees 5 12 135 . Total 5175 2050 317 165 Lirpa uses the step-down method for allocation. Costs are allocated from custodial based on space occupied to cafeteria then to the operating departments, Cafeteria costs are allocated to the operating departments based on number of employees Complete the service department allocations below. Note: not all blue cells must be filled in Department Allocation Basis as percentages: Custodial Administration Processing Bottling Custodial Administration 03 Custodia D S 150 10 SOKO 12 J3 15 16 Departmentales 5210 S75 S350 Space occupied in m2 2.000 10 Number of employees 20500 165 317 Lirpa uses the step-down method for allocation. Costs are allocated from custodial based on ce cupied to cafeteria then to the operating departments, Cafeteria costs are allocated to the operating departments based on number of employees Complete the service department allocations below. Note: not all blue cells must be filled in Daarment Allocation Basis as percentages: Custodial Administration Processing Bottling Custodial Administration Reallcoarion of Costs: Custodial Administration Processing Bottling Total Custodial Costs Reallocation Total Administration Costs Reallocation Total

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Local Union Financial Records A Guide For Local Union Trustees

Authors: John Lund

1st Edition

0875461948, 978-0875461946

More Books

Students also viewed these Accounting questions

Question

Are there any questions that you want to ask?

Answered: 1 week ago