Question: Detailed solution needed on Excel Please assist. CASE: Expenditures incurred in a manufacturing company are as follows: SUPPORTING DEPARTMENTS Cafeteria Heating TOTAL COSTS Direct Material

Detailed solution needed on Excel Please assist.

Detailed solution needed on Excel Please assist. CASE: Expenditures incurred in a

CASE: Expenditures incurred in a manufacturing company are as follows: SUPPORTING DEPARTMENTS Cafeteria Heating TOTAL COSTS Direct Material Direct Labor Indirect Material Indirect Labor Electricity Water PRODUCTION DEPARTMENTS Cutting Assembly 175.000,00 100,000.00 135.000,00 80.000,00 25.000,00 10.000,00 15.000,00 ? ? ? 20.000,00 30.000,00 ? ? 9.000,00 22.000,00 ? ? 2 275.000,00 215.000,00 64.000,00 79.000,00 156.000,00 23.000,00 12.000,00 Rent Insurance Tax Depreciation 40.000,00 24.000,00 12.000,00 ? 40.000,00 59.000,00 39.000,00 65.000,00 35.000,00 16.000,00 ? 6.000,00 ? 5.000,00 ? ALLOCATION BASES KW per hour Liter Square meters 14,00 196.00 303,00 32,00 152,00 615,00 96,00 87,00 1.615,00 58,00 65,00 2.462,00 200,00 500,00 5.000,00 INSTRUCTIONS Q1: Suppose that there is a counter to measure electricity usage in the Cutting Department, and a counter to measure water usage in the Assembly Department. Electricity usage in the Cutting Department is 72.800 $, while water usage in the Assembly Department is 4.730 S. Complete the table by allocating costs appropriately (First Allocation). (20 points) Q2: After completing the previous task, re-allocate the costs by considering the information below (Second Allocation). Cafeteria Heating Cutting Assembly SERVICES PROVIDED Cafeteria # of employees 10,00 20,00 500,00 400.00 930,00 Heatirg (Square meters) 308,00 615,00 1.615,00 2.462,00 5.000,00 a. Prepare a cost allocation table by using Direct Method. Journalize the ending balances of costs. (20 points) b. Prepare a cost allocation table by using Step-Down Method. Assume that Cafeteria ranks number 1. Journalize the ending balances of costs. (25 points) c. Prepare a cost allocation table by using Reciprocal Method. Journalize the ending balances of costs. (35 points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

CASE STUDY CASE: Expenditures incurred in a manufacturing company are as follows: SUPPORTING DEPARTMENTS Cafeteria Heating TOTAL COSTS Direct Material Direct Labor Indirect Material Indirect Labor...

Need help with this assignment. The docx contains the questions and the pdf is the assignment content Thanks in advance! Johnson Beverage Inc. (JBI) Due March 20, 2017 by 5pm via email or BlackBoard...

Question 1 goes like: You have been hired as a consultant to help Alex with the business. Please address the following questions in preparation for your discussions with him. Ignore any current...

Student name and surname: Student number: BUS 503 Advanced Accounting a) true b) false Take-Home Exam -2 The following costs are related to questions 15 - 18: A factory produces two products, A and...

Montonya Company has the following selected data for the current year: Sales (10,000 units) $90,000 Direct materials 30,000 Direct labor costs 10,000 Variable manufacturing overhead 3,500 Fixed...

The answer to question C is the most important (second point). CASE SCENARIO Company Background The Paper Products Factory (PPF) is a local manufacturer of a single product: paper party hats. They...

University of Bahrain College of Business Administration Department of Accounting First Semester 2021-2022 (ACC 221) Cost Accounting Case Study (15%) November 2021 CASE SCENARIO Company Background...

What is a top- down approach to evaluation of internal controls?

Explain why compound A readily decarboxylates (forming pyrrole) when heated with acid, but compounds B and C do not under the same conditions. CO.M COM -coH

With identified factors contributing to Audit Committee ineffectiveness and their implications thereof, it is of paramount importance that corrective actions be implemented to mitigate the issues....

! Required information [The following information applies to the questions displayed below.) Westerville Company reported the following results from last year's operations: Sales Variable expenses...