Assigning Traceable Fixed Expenses Selected data for Colony Company, which operates three departments, follow: Department A Department B Department C Inventory $100,000 $360,000 $140,000 Equipment (average cost) $900,000 $540,000 $360,000 Payroll $607,500 $540,000 $202,500 Square feet of floor space 27,000 13,500 4,500 During the year, the company's fixed expenses included the following: Depreciation on equipment $150,000 Real estate taxes 45,000 Personal property taxes (on inventory and equipment) Personnel department expenses 72,000 75,000 Assume that the property tax rate is the same for both inventory and equipment. Using the most causally related bases, prepare a schedule assigning the fixed expenses to the three departments. Hint: Not all fixed exp traceable to the three departments. One of these fixed costs should be considered a common cost and not traceable to the departments. Do not round until your final answer. Round final answer to the nearest whole number. Depreciation Real estate taxes Personal property taxes Personnel dept. expenses Department A Department B Department C 0 $ 0 $ 0 0 0 0 0 0 0 0

Assigning Traceable Fixed Expenses Selected data for Colony Company, which operates three departments, follow: Department A Department B Department C Inventory $100,000 $360,000 $140,000 Equipment (average cost) $900,000 $540,000 $360,000 Payroll $607,500 $540,000 $202,500 Square feet of floor space 27,000 13,500 4,500 During the year, the company's fixed expenses included the following: Depreciation on equipment $150,000 Real estate taxes 45,000 Personal property taxes (on inventory and equipment) Personnel department expenses 72,000 75,000 Assume that the property tax rate is the same for both inventory and equipment. Using the most causally related bases, prepare a schedule assigning the fixed expenses to the three departments. Hint: Not all fixed exp traceable to the three departments. One of these fixed costs should be considered a common cost and not traceable to the departments. Do not round until your final answer. Round final answer to the nearest whole number. Depreciation Real estate taxes Personal property taxes Personnel dept. expenses Department A Department B Department C 0 $ 0 $ 0 0 0 0 0 0 0 0

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter7: Allocating Costs Of Support Departments And Joint Products

Section: Chapter Questions

Problem 1CE: The expected costs for the Maintenance Department of Stazler, Inc., for the coming year include:...

See similar textbooks

Similar questions

A company uses charging rates to allocate service department costs to the using departments. The accountant compiled the following information on one of the service departments: If Department K plans to use 1,350 hours of the service departments service in the coming year, how much of the service departments cost is allocated to Department K? a. 3,375 b. 27,300 c. 26,325 d. 23,950
Required information The Ferre Publishing Company has three service departments and two operating departments. Selected data from a recent period on the five departments follow: Costs Number of employees Square feet of space occupied Hours of press time Departmental costs before allocations Allocations: Service Departments Administration Janitorial Maintenance $ 144,200 $ 108,150 $ 49,440 140 20,000 Administration costs Janitorial costs Maintenance costs Total costs after allocations 60 15,000 Administration $ The company allocates service department costs by the step-down method in the following order: Administration (number of employees), Janitorial (space occupied), and Maintenance (hours of press time). Service Departments Janitorial $ 144,200 $ 108,150 $ 35 10,000 Required: Using the step-down method, allocate the service department costs to the operating departments. (Please enter allocations from a department as negative and allocations to a department as positive. The line…
To better match cost to revenues Lewisville Corporation distributes its service department overhead costs to producing departments. Information for April is presented here. Maintenance Utilities Overhead costs incurred $18,700 $9,000 Service provided to: Maintenance Dept. 10% Utilities Dept. 20% Producing Dept. A 40% 30% Producing Dept. B 40% 60% Using the step method, how much of Lewisville's Corporation’s Utilities Department cost is allocated between Departments A and B? (order of allocation begins with Maintenance) Group of answer choices $9,900 $10,800 $12,740 $27,700 In order to better match cost with revenues, Lewisville Corporation distributes its service department overhead costs to producing departments. Information for April is presented here. Maintenance Utilities Overhead costs incurred $18,700 $9,000 Service provided to: Maintenance Dept. 10% Utilities Dept. 20%…
The expected costs for the Maintenance Department of Stazler, Inc., for the coming year include: Fixed costs (salaries, tools): 64,900 per year Variable costs (supplies): 1.35 per maintenance hour Estimated usage by: Actual usage by: Required: 1. Calculate a single charging rate for the Maintenance Department. 2. Use this rate to assign the costs of the Maintenance Department to the user departments based on actual usage. Calculate the total amount charged for maintenance for the year. 3. What if the Assembly Department used 4,000 maintenance hours in the year? How much would have been charged out to the three departments?
Support department allocations The centralized computer technology department of Hardy Company has expenses of 320,000. The department has provided a total of 4,000 hours of service for the period. The Retail Division has used 2,750 hours of computer technology service during the period, and the Commercial Division has used 1,250 hours of computer technology service. How much should each division be allocated for computer technology department services?
Allocating Service Department Costs: Allocation Basis Alternatives Weld-Rite Fabricators has two producing departments, P1 and P2, and one service department, S1. Estimated directed overhead costs per month are as follows: P1 $450,000 P2 750,000 $1 273,000 Other data follow: Numbers of employees Production capacity (units) Space occupied (square feet) Five-year average of $1's service output used P1 P2 150 50 100,000 60,000 5,000 15,000 65% 35% For each of the following allocation bases, determine the total estimated overhead cost for P1 and P2 after allocating 51 cost to the producing departments. 1. Based on number of employees $ P1 P2 $ 2. Production capacity in units 3. Space occupied 4. Five-year average of $1 service used 627,450✔ 845,550✔ 5. Estimated direct overhead costs
Original costs Proportion of Administrative hours used Proportion of Information Systems hours used Proportion of Maintenance hours used (a) Total costs Administrative Institutional $77,000 0.20 Operating Segments 0.10 Support Departments Information Systems Maintenance $110,600 $62,000 0.10 Retail 0.10 0.10 0.10 Operating Segments Institutional Retail $649,000 $351,000 0.45 0.40 Determine the total costs that each operating segment would be accountable for if support costs are allocated using the direct method. (Round interme 0.30 0.35 0.30 0.50
Selected data for Miller Company, which operates three departments, follow: Department A Department B Department C Inventory $120,000 $432,000 $168,000 Equipment (average cost) $1,080,000 $648,000 $432,000 Payroll $810,000 $720,000 $270,000 Square feet of floor space 18,000 9,000 3,000 During the year, the company's fixed expenses included the following: Depreciation on equipment $120,000 Real estate taxes 36,000 Personal property taxes (on inventory and equipment) 57,600 Personnel department expenses 40,000 Assume that the property tax rate is the same for both inventory and equipment. Using the most causally related bases, prepare a schedule assigning the fixed expenses to the three departments. Hint: Not all fixed expenses are traceable to the three departments. One of these fixed costs should be considered a common cost and not traceable to the departments. Do not round until your final answer. Round final…
DJH Enterprises has 3 departments. Operating results for 2019 are as follows: Department 1 Department 2 Department 3 Sales $837,500 $402,500 $1,070,000 Variable Costs 556,250 358,750 752,500 Contribution Margin $281,250 $43,750 $317,500 Direct fixed expenses $150,000 $33,750 $203,750 Common fixed expenses 93,750 37,500 117,500 Total fixed expenses $243,750 $71,250 $321,250 Operating income (loss) $37,500 $(27,500) $(3,750) DJH is considering eliminating the departments that show losses. Assume that the direct fixed expenses could be avoided if the department is eliminated. What effect would elimination of Department 3 have on DJH’s total operating income? Select one: a. It would decrease total operating income by $113,750. b. It would decrease total operating income by $317,500. c. None of these options are correct. d. It would increase total operating income by $117,500. e. It would decrease total operating income by $3,750.
The information provided below was taken from the records of Chotoo Projects for the financialyear ended 31 May 2020.Extract of statement of comprehensive income for the year ended 31 May 2020RRevenue 480 000Direct costs 240 000Rent income 150 000Advertising 4 800Salaries and wages 90 000Rates and taxes 1 200Other operating expenses 80 000Additional information1. Revenue is calculated as direct cost plus 25%.2. Revenue is divided equally each month. Revenue is expected to increase by 18% for thefinancial year ending 31 May 2021.POSTGRADUATE DIPLOMA IN PROJECT MANAGEMENT – ACADEMIC AND ASSESSMENT CALENDARREGENT BUSINESS SCHOOL (RBS) January 2021 173. Fifty percent (50%) of the revenue is for cash and the balance is on credit. Debtorsnormally pay their accounts as follows:• 40% in the month of the invoice, and these debtors are entitled toa 5% discount;• 55% one month after the invoice;The balance is usually written off as bad debts.4. Purchases for June and July are expected to be 30…
DJH Enterprises has 3 departments. Operating results for 2019 are as follows: Department 1 Department 2 Department 3 Sales $938,000 $450,800 $1,198,400 Variable Costs 623,000 401,800 842,800 Contribution Margin $315,000 $49,000 $355,600 Direct fixed expenses $168,000 $37,800 $228,200 Common fixed expenses 105,000 42,000 131,600 Total fixed expenses $273,000 $79,800 $359,800 Operating income (loss) $42,000 $(30,800) $(4,200) DJH is considering eliminating the departments that show losses. Assume that the direct fixed expenses could be avoided if the department is eliminated.What effect would elimination of Department 2 have on DJH’s total operating income? Select one: a. It would increase total operating income by $42,000. b. It would decrease total operating income by $7,000. c. It would decrease total operating income by $49,000. d. It would increase total operating income by $30,800. e. It would decrease total operating income by $11,200.
Vernon transport company divides its operations into four divisions. A recent statement for its West Division folows Vernon Transport Comapny Wesy division Income Statement for year 3 Revenue $670,000 Salaries for drivers (520,000) Fuel expenses (67,000) Insurance (87,000) Division-level facility- sustaining costs (57,000) Companywide facility-sustaining costs (147,000) Net loss $208,000 Required a) By how much would cormpanywide income increase or decrease if West Division is estimated? Should West Division be eliminated? b) assume that West Division is able to increase its revenue to $760,000 by raising its prices. Determine the amount of the increase or decrease that would occur in companywide net income if the segemnt were eliminated. Should West Division be eliminated if revenue were $760,000? c) What is the mininum amount of revenue required to Jusify continuing the operation of West Divison? Complete this question by entering your answer in the table below. Income Would…