The image contains a table designed to allocate support costs among various departments. The goal is to distribute these costs to both support and production departments using specific allocation bases like hours worked and the number of employees. Allocated amounts are to be rounded to the nearest whole dollar, and zero should be entered if applicable.### Table Explanation**Support Departments:**1. **Maintenance** - Hours Worked: 11,000 - Number of Employees: 6 - Department Cost: $193,6002. **Administration** - Hours Worked: 9,720 - Number of Employees: 4 - Department Cost: $237,9003. **Log Yard** - Hours Worked: 8,160 - Number of Employees: 4 - Department Cost: $340,950**Production Departments:**1. **Milling** - Hours Worked: 25,920 - Number of Employees: 102. **Drying** - Hours Worked: 16,200 - Number of Employees: 123. **Packaging** - Hours Worked: 21,060 - Number of Employees: 8### Additional Data Fields:- Maintenance: - Final Department Costs: $259,600 (Input required)- Administration: - Field for input cost allocation (currently blank).The table implies the need for students to correctly allocate costs based on the outlined variables, providing a practical exercise in cost accounting practices and allocation methods used in business finance. **ForestLand Wood Products: Cost Allocation Case Study**ForestLand Wood Products manufactures lumber and wood components, with two main product lines: Hardwood and Softwood. Hardwoods are utilized for flooring, cabinetry, paneling, doors, and trimwork. Softwoods serve in walls, joists, planks, rafters, beams, posts, decking, subflooring, and concrete forms. Additionally, ForestLand sells wood shavings, a by-product, which are used for farm and industrial purposes and processed into pellets and fiberboard. Revenues from by-products offset costs, and the revenue is allocated based on the percentage of the product produced.**Three-Year Project with ForestLand**Your firm has been retained by ForestLand for three years to allocate support department costs accurately. The reciprocal services method will be used under your manager's instructions. You find that the Hardwood line produces 300 thousand board feet of product and Softwood produces 900 thousand board feet. The labor cost per thousand board feet is double for Hardwood compared to Softwood. Other production costs are consistent for both.**Support Departments**ForestLand has two support departments:1. **Maintenance**: Maintains equipment and janitorial duties. It is more heavily used in hardwood production. Cost driver: hours worked.2. **Administration**: Includes essential administrative roles. Cost driver: number of employees.**Cost Analysis Table**The following data represents the cost allocation across departments:| | Maintenance | Administration | Log Yard | Drying | Packaging ||---------------|-------------|----------------|----------|---------|-----------|| **Hours Worked** | 11,000 | 9,720 | 8,100 | 16,200 | 21,060 || **Number of Employees** | 6 | 4 | 5 | 12 | 8 || **Department Costs** | $193,600 | $237,900 | $340,950 | $476,450 | $245,400 |The goal is to determine proportional usage for each support department's cost driver among the rest of the departments.**Next Steps**Calculate the proportional allocation of the support department costs to the production departments using the provided tables and the reciprocal services method.

Cost allocation is a method of delivering assistance to the cost centres of a shared service organisation that supplies a product or service.Workings: Let, Total Maintenance Cost be X and the Total Administration Cost be Y. X=$193,600+0.15Y Y=$237,900+0.12X Now, X=$193,600+0.15×$237,900+0.12XX=$193,600+$35,685+0.018X0.982X=$229,285X=$233,488 And, Y=$237,900+0.12XY=$237,900+0.12×$233,488Y=$265,919Workings:Answer:

Business

Accounting

Use the following table to allocate the support cost departments. Round allocated amounts to the nearest whole dollar. If an amount is zero, enter "0". Production Departments Support Departments Log Yard Milling Drying Packaging Maintenance Administration 8,100 V 25,920 V 16,200 V 21,060 11,000V 9,720 Hours worked 10 12 6. Number of employees 246,400 340,950 521,400 476,450 24 193,600 237,900 Department cost Maintenançe 259,600 Administration Final department costs

Use the following table to allocate the support cost departments. Round allocated amounts to the nearest whole dollar. If an amount is zero, enter "0". Production Departments Support Departments Log Yard Milling Drying Packaging Maintenance Administration 8,100 V 25,920 V 16,200 V 21,060 11,000V 9,720 Hours worked 10 12 6. Number of employees 246,400 340,950 521,400 476,450 24 193,600 237,900 Department cost Maintenançe 259,600 Administration Final department costs

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

Hansaben
The following is a partially completed departmental expense allocation spreadsheet for Brickland. It reports the total amounts of direct and indirect expenses for its four departments. Purchasing department expenses are allocated to the operating departments on the basis of purchase orders. Maintenance department expenses are allocated based on square footage. Compute the amount of Maintenance department expense to be allocated to Fabrication. Operating costs No. of purchase orders Sq. ft. of space Multiple Choice O $6,400. $9,900. $8,100. $9,000. $25,600. Purchasing Maintenance Fabrication Assembly $32,000 $18,000 $96,000 16 3,300 $62,000 4 2,700
Assume a company provided the following information: Departmental costs Number of employees Square feet of space occupied Multiple Choice If the company (1) uses the direct method to allocate service department costs to operating departments, (2) allocates Cafeteria costs based on the number of employees, and (3) allocates Janitorial costs based on square feet of space of occupied, then the cost allocated from the Cafeteria Department to the Lab Department is closest to: C $58,338. $63,467. $76,800. Service Departments Operating Departments Cafeteria Janitorial Lab Tech $232,000 $950,000 32 68 $240,000 $140,000 20 2,000 11,000 9,000 $116,800. 10 3,000
Please help me with show all calculation thanku
Management and Allocation Assignm... i) Saved Caro Manufacturing has two production departments, Machining and Assembly, and two service departments, Maintenance and Cafeteria. Direct costs for each department and the proportion of service costs used by the various departments for the month of August follow: Proportion of Services Used by Direct Costs $120,000 76,000 54,000 37,000 Maintenance Machining Assembly Department Machining Assembly Maintenance Cafeteria Cafeteria 0.6 0.2 0.2 0.1 0.2 0.7 Required: Use the step method to allocate the service costs, using the following: a. The order of allocation starts with Maintenance. b. The allocations are made in the reverse order (starting with Cafeteria). Complete this question by entering your answers in the tabs below. Required A Required B The order of allocation starts with Maintenance. (Negative amounts should be indicated by a minus sign. Do not round Intermediate calculations.) To Cafeteria Machining Assembly From Maintenance…
Mr
Support department cost allocation-direct method Becker Tabletops has two support departments (Janitorial and Cafeteria) and two production departments (Cutting and Assembly). Relevant details for these departments are as follows: Support Department Janitorial Department Cafeteria Department Cost Driver Square footage to be serviced Number of employees Janitorial Department $300,000 Janitorial Department cost allocation Cafeteria Department cost allocation Cafeteria Department $170,000 4,700 2 44 8 Department costs Square feet Number of employees Allocate the support department costs to the production departments using the direct method. Cutting Department LA Cutting Department $1,500,000 2,400 21 $ Assembly Department SA Assembly Department $680,000 3,600 9 S < 11:15 PM 2/25/2024
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
Battery Small Motors Power 0.77 X 0.23 X General Factory 0.25 0.75 2. Allocate the support service costs to the operating divisions. Round all amounts to the nearest dollar. Use a minus sign to indicate a subtraction. For t boxes in which no entry is required, leave the box blank or enter zero ("0"). Direct costs Allocate: Support Departments Support Departments Operating Divisions Operating Divisions Power General Factory Battery Small Motors 220,000 ✔ 430,000 561,756 X $ 369,244 X Power 220,000 X General Factory 430,000 X Total 3. Assume divisional overhead rates are based on direct labor hours. Calculate the overhead rate for the Battery Division and for the Small Motors Division. Round yo answers to the nearest cent. Battery overhead rate Small Motors overhead rate 3.12 X 3.12 X
Conlon Enterprises reports the following information about resources. Cost Driver Rate Cost Driver Volume Resources used Setups $ 370 per run 425 runs Clerical 50 per page 2,500 pages typed Resources supplied Setups $ 160,450 Clerical 133,400 Sales revenue totaled $315,000. Required: a. Prepare a traditional income statement. b. Prepare an activity-based income statement.
Assume that Swifty has identified three activity cost pools.