Madison Park Co-op, a whole foods grocery and gift shop, has provided the following data to be used in its service department cost allocations: Departmental costs before allocations Employee-hours Space occupied-square feet Required: Service Departments Administration Janitorial $ 200,000 $ 60,000 470 800 340 1,100 Operating Departments Groceries Gifts $ 3,820,000 2,680 $ 350,000 180 9,400 600 Using the step-down method, allocate the costs of the service departments to the two operating departments. Allocate Administration first on the basis of employee-hours and then Janitorial on the basis of space occupied. (Please enter allocations from a department as negative and allocations to a department as positive. The line should add across to zero. Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.) Departmental costs before allocations Allocations $ Service Departments Administration Janitorial 200,000 $ 60,000 Operating Departments Groceries $3,820,000 $ Total Gifts 350,000 $4,430,000 Administration costs (200,000) Janitorial costs Total costs after allocations $ 0 $ 60,000 $3,820,000 $ 350,000 $4,230,000

Madison Park Co-op, a whole foods grocery and gift shop, has provided the following data to be used in its service department cost allocations: Departmental costs before allocations Employee-hours Space occupied-square feet Required: Service Departments Administration Janitorial $ 200,000 $ 60,000 470 800 340 1,100 Operating Departments Groceries Gifts $ 3,820,000 2,680 $ 350,000 180 9,400 600 Using the step-down method, allocate the costs of the service departments to the two operating departments. Allocate Administration first on the basis of employee-hours and then Janitorial on the basis of space occupied. (Please enter allocations from a department as negative and allocations to a department as positive. The line should add across to zero. Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.) Departmental costs before allocations Allocations $ Service Departments Administration Janitorial 200,000 $ 60,000 Operating Departments Groceries $3,820,000 $ Total Gifts 350,000 $4,430,000 Administration costs (200,000) Janitorial costs Total costs after allocations $ 0 $ 60,000 $3,820,000 $ 350,000 $4,230,000

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

QUESTION 2/15 2020033800068702: From the following information distribute cost of Time Keeping department among various other departments: Total cost of Time keeping department as per primary Distribution: Rs. 10000, Ratio of Stores Requisition: 4:3:2:1, Ratio of Machine Hours: 3:3:2:2, Ratio of No of Employee: 3:4:2:1 and Ratio of Floor area: 5:3:1:1 O Rs. 4000, Rs. 3000, Rs. 2000 and Rs. 1000 O Rs. 3000, Rs. 3000, Rs. 2000 and Rs. 2000 O Rs. 3000, Rs. 4000, Rs. 2000 and Rs. 1000 O Rs. 5000, Rs. 3000, Rs. 1000 and Rs. 1000
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…
Pepper Depanment store aliocates ns service department espenses to s various operating sales) departments The folowing dats is avaitable for ts service departments Expense Dasts for allecation ADunt Rent Square feet of flnor space $47,000 47,000 62, 00 Advertising Amount of dollar sales Adainistrative Number of enployees The following information s aveitable for mu three opeating tuale departments Number of Department Square Feet 5,400 8, 100 13,500 Dollar Seles $ 302,000 $ 453, 00 S 755, 000 enployees 15 Totals 27,000 $3,510,000 What as the total expense allocated to Deparnment B Mutiple Choice $32.000 $42065 O s400 $42500 $40.000
DATA ENVELOPMENT ANALYSIS OUTPUT INPUT STORE LOCATION SALES EBITDA STORE ARE(SQ.FT) #EMPLOYEES 1 A 47,682,116 7,459,291 35,523.00 62.0 2 B 42,612,114 3,880,099 39,493.00 75.00 3 C 44,187,228 4,215,221 39,731.00 79.00 4 D 30,487,610 4,201,924 35,833.00 77.00 5 E 41,535,542 5,182,632 36,552.00 75.00 6 F 24,497,561 3,079,086 37,328.00 61.00 7 G 43,749,818 6,485,312 38,709.00 79.00 8 H 24,081,113 1,820,738 37,827.00 66.00 9 K 44,711,757 6,310,682 35,631.00 66.00 10 L 32,138,829 125,696…
Account Activity and Relationships Each case is independent. Solve for missing data in alphabetical order. (Hint: Refer to Exhibit 18.6, p. 18-17 and the WIP table, p. 18-25.) Case A Case B Case C Case D Sales $425,000 Answer 550,000 Answer Direct materials 75,000 105,000 Answer 105,000 Direct labor 25,000 Answer 100,000 Answer Total direct costs Answer 160,000 Answer 150,000 Conversion cost Answer 130,000 Answer Answer Manufacturing overhead 40,000 Answer 50,000 Answer Current manufacturing costs Answer Answer 475,000 395,000 Work in process, beginning 35,000 50,000 Answer 105,000 Work in process, ending 25,000 Answer 105,000 Answer Cost of goods manufactured Answer 160,000 Answer 410,000 Finished goods inventory, beginning 45,000 40,000 35,000 60,000 Finished goods inventory, ending 30,000 Answer 40,000 Answer Cost of goods sold Answer 175,000 Answer 400,000 Gross profit…
MC Qu. 5-47 Baxter customer service department follows... Baxter customer service department follows up on customer complaints by telephone inquiry. During a recent period, the department initiated 12,800 calls and incurred costs of $377,600. Of these calls, 3,970 were for the company's wholesale operation; the remainder was for the retail division. Costs allocated to the retail division are: Multiple Choice $0. $377,600. $117,115. $260,485. $270,045
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) Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and P2). The distribution of each service department’s efforts (in percentages) to the other departments is: From To S1 S2 P1 P2 S1 — 10% 20% ?% S2 10% — ? 30 The direct operating costs of the departments (including both variable and fixed costs) are: S1 $ 180,000 S2 60,000 P1 50,000 P2 120,000 Required: 1. Determine the total cost of P1 and P2 using the direct method. 2. Determine the total cost of P1 and P2 using the step method. 3. Determine the total cost of P1 and P2 using the reciprocal method.
Problem 11-60 (Algo) Cost Allocation: Step and Reciprocal Methods (LO 11-1) Dunedin Bank has two operating departments (Retail and Commercial) and three service departments: Operations, Information Technology (IT), and Transactions. For the last period, the following costs and service department usage ratios were recorded: Supplying Department Transactions IT Operations Direct cost Using Department Transactions IT Operations Retail Commercial Ө Ө 70% 30% 10% Ө 20% 30% 40% 50% Ө Ө 10% 40% $ 390,000 $ 810,000 $ 1,650,000 $ 3,850,000 $ 2,400,000 Required: a. Allocate the service department costs to the two operating departments using the reciprocal method. From: Costs Operations Allocated to: Transactions Retail Commercial IT $ 810,000 $ 162,000 $ 81,000 $ 243,000 $ 324,000 Operations Transactions Total $ 243,000 $ 324,000
Problem 11-60 (Algo) Cost Allocation: Step and Reciprocal Methods (LO 11-1) Dunedin Bank has two operating departments (Retail and Commercial) and three service departments: Operations, Information Technology (IT), and Transactions. For the last period, the following costs and service department usage ratios were recorded: Supplying Department Transactions IT Operations Direct cost IT From: Operations Transactions Transactions Total 8 10% 70% $ 310,000 IT Using Department Operations Costs Operations S 250,000 $ 750,000 670,000 X 1,510,000 x 8 8 8 $ 730,000 Required: a. Allocate the service department costs to the two operating departments using the reciprocal method. Answer is complete but not entirely correct. Allocated to: Transactions $ 250,000 $ 2,233,333 x 8 30% 8 $ 1,570,000 $ Retail Retail 0X $ 0.x 0x 0 Commercial S $ 3,770,000 78% 30% 10% 833,333 X 0x 0x 833,333 Commercial 36% 38% 28% $ 2, 320, 000
Required information Skip to question [The following information applies to the questions displayed below.] The following information is departmental cost allocation with two service departments and two production departments. Percentage Service Provided to Department Cost S1 S2 P1 P2 Service 1 (S1) $ 47,000 0 % 20 % 40 % 40 % Service 2 (S2) 37,000 20 0 20 60 Production 1 (P1) 270,000 Production 2 (P2) 320,000 What is the amount of service department cost allocated to P1 and P2 using the direct method if the cost in P1 is changed from $270,000 to $290,000?
Required information Skip to question [The following information applies to the questions displayed below.] The following information is departmental cost allocation with two service departments and two production departments. Percentage Service Provided to Department Cost S1 S2 P1 P2 Service 1 (S1) $ 47,000 0 % 20 % 40 % 40 % Service 2 (S2) 37,000 20 0 20 60 Production 1 (P1) 270,000 Production 2 (P2) 320,000 What is the total cost in P1 and P2 and what is the amount of service department cost allocated to P1 and P2 using the step method with S1 going first?
PLease show work Not sure how to calulate properly IS Personnel Administration Residential Commercial Number of IS service tickets 90 120 75 1,410 940 Number of employees 35 40 27 138 162 Square footage occupied 3,900 8,000 3,800 16,100 69,500 The costs of the service departments and the allocation basis for each department follow. Department Direct Cost Allocation Base Information Systems (IS) $ 17,000 IS service tickets Personnel 24,000 Employees Administration 20,700 Square footage occupied Assume that the company allocates service department costs to production departments using the direct method. What amount of Information Systems (IS) Department costs will be allocated to the Commercial Department? Assume the same method of allocation as in requirement (a). What amount of personnel department costs is allocated to the residential department? I keep getting mixed up