2. Change all of the numbers in the data area of your worksheet so that it looks like this: A 1 Chapter 3: Applying Excel 2 3 Data 4 Allocation base 5 Estimated manufacturing overhead cost Estimated total amount of the allocation base Actual manufacturing overhead cost 8 Actual total amount of the allocation base 6 7 Predetermined overhead rate Machine-hours $ B $ с 409,200 62,000 machine-hours 418,200 60,000 machine-hours If your formulas are correct, you should get the correct answers to the following questions. (a) What is the Predetermined overhead rate? (Round your answer to 2 decimal places.) per machine-hour

2. Change all of the numbers in the data area of your worksheet so that it looks like this: A 1 Chapter 3: Applying Excel 2 3 Data 4 Allocation base 5 Estimated manufacturing overhead cost Estimated total amount of the allocation base Actual manufacturing overhead cost 8 Actual total amount of the allocation base 6 7 Predetermined overhead rate Machine-hours $ B $ с 409,200 62,000 machine-hours 418,200 60,000 machine-hours If your formulas are correct, you should get the correct answers to the following questions. (a) What is the Predetermined overhead rate? (Round your answer to 2 decimal places.) per machine-hour

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Please do not give solution in image format thanku
Check my workCheck My Work button is now enabled Item 3 Logan Products has two production departments—assembly and finishing. These are supported by two service departments—sourcing (purchasing and handling of materials and human resources) and operations (work scheduling, supervision, and inspection). Logan has the following labor hours devoted by each of the service departments to the other departments. Total Labor Hours Used by Departments Sourcing Operations Assembly Finishing Sourcing - 20,000 40,000 60,000 Operations 10,000 - 60,000 50,000 The costs incurred in the plant are as follows: Departments Departmental Costs Sourcing $ 174,000 Operations 220,000 Assembly 416,000 Finishing 261,000 Total $ 1,071,000 Required: Use four decimal places (e.g., 33.3333%) in your calculation of percentages. 1. What are the costs allocated to the two production departments using (a) the direct method, (b) the step method, when…
Please don't give solutions in an image format thanku
I attached the data as well please do it Thanks
I need working for both the requirement a and b please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)
B NOWv2 | Online teachir X + ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSession Locator=&inprogress... Ⓒ Thomlin Company forecasts that total factory overhead for the current year will be $17,280,000 with 180,000 total machine hours. Year to date, the actual overhead is $8,220,000, and the actual machine hours are 82,200 hours. If Thomlin Company uses a predetermined factory overhead rate based on machine hours for applying overhead, as of this point in time (year to date), the overhead is a. $328,800 underapplied Ob. $391,200 overapplied Oc. $328,800 overapplied Od. $391,200 underapplied 8:15 A 5/2/202 H U a 1 C
ezto.mheducation.com Homework: Cost Management and Allocation Assignment Question 7- Homework: Cost Management and Allocation Assignment- Connect Homework: Cost Management and Allocation Assignm... i Saved Help Save & Exit Submit Check my work State Financial Corp. has three service departments (Administration, Communications, and Facilities), and two production departments (Deposits and Loans). A summary of costs and other data for each department prior to allocation of service department costs for the year ended December 31 follows. 4. points Administration Communications Facilities Deposits $8,320,000 $4,600,000 447, 000 Loans Direct costs $200,000 24,000 $290,000 31,000 $253,000 20,500 Employee hours Number of employees Square footage occupied Skipped 360,000 8. 14 6. 230 130 4,600 13,800 5,100 244, 100 203,300 The costs of the service departments are allocated on the following bases: Administration, employee-hours; Communications, number of employees; and Facilities, square…
help please answer in text form with proper working and explanation for each and every part and steps with concept and introduction no ai no copy paste remember answer must be in proper format with all working
How do I complete this table?