1. Assign Overhead Costs to Activity Cost Pools国日First-Stage Allocation to Activity Cost Pools - ExcelSign InFILEHOMEINSERTPAGE LAYOUTFORMULASDATAREVIEWVIEWCalibri-A A10PasteBIU- A -Alignment NumberConditional Format asCellCellsFormatting - Table - Styles -ClipboardFontStylesA1fxACEFG1==2 Total costs and distribution of resource consumption across activity cost pools:34Activity Cost PoolsCustomerProductCustomerTotal CostOrdersDevelopmentRelationsOtherTotal6 Production Department:7Indirect factory wages$400,00050%30%15%5% 100%Factory equipment depreciationFactory utilities10 Factory property taxes and insurance8150,00055%30%0%15% 100%9120,00059%34%0%7%100%75,00057%33%0%10%100%1112 General Administrative Department:Administrative wages and salariesOffice equipment depreciation13275,00020%10%40%30% 100%1440,00032%16%15%37%100%15Administrative property taxes and insurance60,0000%0%0%100%100%1617 Marketing Department:18 Marketing wages and salariesSelling expenses150,00020%10%40%30% 100%19100,00032%16%15%37% 100%2021 Use the data to complete a First-Stage Allocation to Activity Cost Pools.22 When completing the table, copy formulas as appropriate.2324Activity Cost Pools25TotelSheet1READY100%Attempt(s)HintShow Me 1. Assign Overhead Costs to Activity Cost PoolsFirst-Stage Allocation to Activity Cost Pools - ExcelFILEHOMEINSERTPAGE LAYOUTFORMULASDATAREVIEWVIEWSign InCalibri10%PasteBIU-Alignment NumberConditional Format asCellCellsFormattingTable - Styles -ClipboardFontStylesA1fx==ABCDEFG19 Selling expenses100,00032%16%15%37% 100%2021 Use the data to complete a First-Stage Allocation to Activity Cost Pools.22 When completing the table, copy formulas as appropriate.2324Activity Cost Pools25Total26 Production Department:272829303132 General Administration Department:3334353637 Marketing Department:38394041 Total424344Sheet1READY100%Attempt(s)HintShow Me囲

Name: 1. Assign Overhead Costs to Activity Cost Pools国日First-Stage Allocati
Uploaded: 2024-03-20T06:32:49.000Z
Channel: Bartleby
Description: 1. Assign Overhead Costs to Activity Cost Pools国日First-Stage Allocation to Activity Cost Pools - ExcelSign InFILEHOMEINSERTPAGE LAYOUTFORMULASDATAREVIEWVIEWCalibri-A A10PasteBIU- A -Alignment NumberConditional Format asCellCellsFormatting - Table -

For allocating the cost pools we will multiply the percentage of Activity cost pools with the amount…

Business

Accounting

Activity Cost Pools Customer Product Customer Total Cost Orders Development Relations Other Total Production Department: Indirect factory wages Factory equipment depreciation Factory utilities Factory property taxes and insurance 2$ 400,000 50% 30% 15% 5% 100% 150,000 55% 30% 0% 15% 100% 120,000 59% 34% 0% 7% 100% 75,000 57% 33% 0% 10% 100% General Administrative Department: 275,000 Administrative wages and salaries Office equipment depreciation Administrative property taxes and insurance 20% 10% 40% 30% 100% 40,000 32% 16% 15% 37% 100% 60,000 0% 0% 0% 100% 100% Marketing Department: Marketing wages and salaries Selling expenses 150,000 20% 10% 40% 30% 100% 100,000 32% 16% 15% 37% 100% Use the data to complete a First-Stage Allocation to Activity Cost Pools. When completing the table, copy formulas as appropriate. A otivitu Coct Roole

Activity Cost Pools Customer Product Customer Total Cost Orders Development Relations Other Total Production Department: Indirect factory wages Factory equipment depreciation Factory utilities Factory property taxes and insurance 2$ 400,000 50% 30% 15% 5% 100% 150,000 55% 30% 0% 15% 100% 120,000 59% 34% 0% 7% 100% 75,000 57% 33% 0% 10% 100% General Administrative Department: 275,000 Administrative wages and salaries Office equipment depreciation Administrative property taxes and insurance 20% 10% 40% 30% 100% 40,000 32% 16% 15% 37% 100% 60,000 0% 0% 0% 100% 100% Marketing Department: Marketing wages and salaries Selling expenses 150,000 20% 10% 40% 30% 100% 100,000 32% 16% 15% 37% 100% Use the data to complete a First-Stage Allocation to Activity Cost Pools. When completing the table, copy formulas as appropriate. A otivitu Coct Roole

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: Suzanne Corporation manufactures custom cabinets for kitchens. It uses a normal-costing system with…

A: Proration is the method of allocation of various overheads (i.e, manufacturing or works overhead,…

Q: Required: Using the step-down method, allocate the service department costs to the operating…

A: In step down method cost of service department is allocated to production department on step basis.…

Q: Solexx Corporation allocates its service department overhead costs to producing departments. This…

A: Lets understand the basics.Cost of service department can be allocated to production departments…

Q: Information from the records of Conundrum Company for September was as follows: Sales $307,500…

A: Product cost includes all the direct and indirect expenses directly concerned with the product like…

Q: Question 1 Fair Manufacturing Company is a factory in Hong Kong. It has two support departments-…

A: a. Direct Allocation: Support Department Operating Department Maintenance Accounting…

Q: Direct materials used is

A: Compute the total manufacturing cost.

Q: Determine the activity rate for each of the four activity cost pools. 3. Using the activity rates…

A: Solution Concept Under traditional costing the overhead is allocated using a single overhead…

Q: Garcon Company Pepper Company Finished goods inventory, beginning $ 12,500 $ 19,600 Work in process…

A: Cost of goods manufactured is the total cost of completed finished goods which is transferred from…

Q: Dolphin Company has two service departments, S1 and S2 and three production departments, P1, P2 and…

A: The direct method of cost allocation is a technique used to allocate costs directly to respective…

Q: A partial listing of costs incurred during March at ABC Corporation appears below: Direct…

A: PRODUCT COST Product Cost refers to the costs Incurred to Create a Product. Product Cost…

Q: Problem 1 The J. Page Furniture Company has the following information available regarding costs at…

A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…

Q: Activity Cost Pool Activity Measure Estimated Overhead Cost Machining Machine-hours %24 378,000 HR…

A: Activity-based costing is the method of allocation of overheads of the entity to the product for…

Q: Calculating Departmental Overhead Rates Using Post-Allocation Costs Valron Company has two support…

A: The direct method allocated costs of support departments directly to the operating or producing…

Q: Activity Cost Pool Labour related Material requisition orders Parts management Board etching General…

A: Overhead is the amount of money incurred on the making of the goods. It is a production cost. It…

Q: The following data from the just completed year are taken from the accounting records of Mason…

A: Cost of goods manufactured is the cost incurred on the making of the goods that are to be…

Q: Weldon Corporation has provided the following data from its activity-based costing accounting…

A: Given, Indirect factory wages = $340,000 Factory equipment depreciation =$240,00

Q: Problem 1: The following selected information is provided about a manufacturing company: Raw…

A: Cost of goods available for sale means the cost of opening inventory and cost of goods purchased…

Q: Direct materials $ 78,000 Direct labor $ 40,000 Manufacturing overhead $ 18,000…

A: Period cost is the cost incurred for the particular period. This cost can not be allocated to any…

Q: 6 Diamond Company uses an activity-based costing system with three activity cost pools. The company…

A: Step 1: Identify total manufacturing overhead.Step 2: Identify total selling and administrative…

Q: Department Hours Space Occupied Employees Hours Hours Personnel 17,000 12,600 30 Custodial Services…

A: Predetermined overhead rate - Printing is based on Total overhead cost after allocations divided by…

Q: Touch Of A Button produces screens for use in various smartphones. The company reports the following…

A: Manufacturing overhead, or the expenses incurred aside from those connected to the cost of raw…

Q: rish Corporation distributes its service department overhead cost directly tto producing…

A: Reciprocal method of cost allocation - The method that provides the most accurate results is the…

Q: Activity Cost Pools Total Cost Customer Orders Product Development Customer Relations Other…

A: The indirect costs are the costs that are not directly related to the production process. The costs…

Q: First-stage allocation of overhead costs to the activity cost pools: Overhead costs Installing…

A: The image outlines the allocation of overhead costs to activity cost pools, determination of…

Q: Ravelo Corporation has provided the following data from its activity-based costing system: Estimated…

A: Cost accounting is the one that is used by the management to implement an effective cost control…

Q: Estimated total machine-hours used Molding 2,500 Fabrication 1,500 Estimated total fixed…

A: The overhead is applied to the production on the basis of the pre-determined overhead rate. The…

Q: Sales $ 659,000 Direct labor cost $ 88,000 Raw material purchases $139,000 Selling expenses $…

A: SCHEDULE OF COST OF GOODS MANUFACTUREDSchedule Of Cost Of Goods Manufactured are those costs which…

Q: A manufacturer identified the following activities, costs, and activity drivers. Compute the…

A: ACTIVITY BASED COSTINGActivity Based Costing is a Powerful tool for measuring…

Q: Midiul acturing overneau 1,400,00 $1,000,000 $1,110,000 Direct labor costs $1,860,000 $1,550,000…

A: 3. **Direct Labor Costs**: This refers to the cost of labor directly involved in the manufacturing…

Concept explainers

Process Costing

Process costing is a sort of operation costing which is employed to determine the value of a product at each process or stage of producing process, applicable where goods produced from a series of continuous operations or procedure. 

Job Costing

Job costing is adhesive costs of each and every job involved in the production processes. It is an accounting measure. It is a method which determines the cost of specific jobs, which are performed according to the consumer’s specifications. Job costing is possible only in businesses where the production is done as per the customer’s requirement. For example, some customers order to manufacture furniture as per their needs.

ABC Costing

Cost Accounting is a form of managerial accounting that helps the company in assessing the total variable cost so as to compute the cost of production. Cost accounting is generally used by the management so as to ensure better decision-making. In comparison to financial accounting, cost accounting has to follow a set standard ad can be used flexibly by the management as per their needs. The types of Cost Accounting include – Lean Accounting, Standard Costing, Marginal Costing and Activity Based Costing.

Topic Video

Question

1. Assign Overhead Costs to Activity Cost Pools
国日
First-Stage Allocation to Activity Cost Pools - Excel
Sign In
FILE
HOME
INSERT
PAGE LAYOUT
FORMULAS
DATA
REVIEW
VIEW
Calibri
-A A
10
Paste
BIU
- A -
Alignment Number
Conditional Format as
Cell
Cells
Formatting - Table - Styles -
Clipboard
Font
Styles
A1
fx
A
C
E
F
G
1
==
2 Total costs and distribution of resource consumption across activity cost pools:
3
4
Activity Cost Pools
Customer
Product
Customer
Total Cost
Orders
Development
Relations
Other
Total
6 Production Department:
7
Indirect factory wages
$
400,000
50%
30%
15%
5% 100%
Factory equipment depreciation
Factory utilities
10 Factory property taxes and insurance
8
150,000
55%
30%
0%
15% 100%
9
120,000
59%
34%
0%
7%
100%
75,000
57%
33%
0%
10%
100%
11
12 General Administrative Department:
Administrative wages and salaries
Office equipment depreciation
13
275,000
20%
10%
40%
30% 100%
14
40,000
32%
16%
15%
37%
100%
15
Administrative property taxes and insurance
60,000
0%
0%
0%
100%
100%
16
17 Marketing Department:
18 Marketing wages and salaries
Selling expenses
150,000
20%
10%
40%
30% 100%
19
100,000
32%
16%
15%
37% 100%
20
21 Use the data to complete a First-Stage Allocation to Activity Cost Pools.
22 When completing the table, copy formulas as appropriate.
23
24
Activity Cost Pools
25
Totel
Sheet1
READY
100%
Attempt(s)
Hint
Show Me

1. Assign Overhead Costs to Activity Cost Pools
First-Stage Allocation to Activity Cost Pools - Excel
FILE
HOME
INSERT
PAGE LAYOUT
FORMULAS
DATA
REVIEW
VIEW
Sign In
Calibri
10
%
Paste
BIU-
Alignment Number
Conditional Format as
Cell
Cells
Formatting
Table - Styles -
Clipboard
Font
Styles
A1
fx
==
A
B
C
D
E
F
G
19 Selling expenses
100,000
32%
16%
15%
37% 100%
20
21 Use the data to complete a First-Stage Allocation to Activity Cost Pools.
22 When completing the table, copy formulas as appropriate.
23
24
Activity Cost Pools
25
Total
26 Production Department:
27
28
29
30
31
32 General Administration Department:
33
34
35
36
37 Marketing Department:
38
39
40
41 Total
42
43
44
Sheet1
READY
100%
Attempt(s)
Hint
Show Me
囲

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

None
Current Attempt in Progress Oriole Company has the following data: Direct labor Direct materials used Total manufacturing overhead Ending work in process inventory Beginning work in process inventory (a) Compute total manufacturing costs. Total manufacturing costs $ $83,600 92,400 71,500 33,000 49,500
rmn.2
IMAGE (A) Category Unit Batch Product Facility Total Pooled Cost Types of Costs $ 388,000 Indirect labor wages, supplies, factory utilities, machine maintenance 215,400 Materials handling, inventory storage, labor for setups, packaging, labeling and shipping, scheduling Research and development 112,600 307,000 Machine hours Cost Driver Number of production orders Time spent by research department Rent, general utilities, maintenance, facility depreciation, Square footage administrative salaries IMAGE (B) Direct materials cost Direct labor cost Number of labor hours Number of machine hours Number of production orders Research and development time Number of units Square footage Type of Product Total Cost Cost per Unit a Commercial a. Home a. Miniature Combined total $ 0 b. Commercial b. Home b. Miniature Combined total $ 0 Commercial $25.07 per unit $ 10.35 per hour 6,000 10,000 Home Miniature Total $15.07 per unit $ 8.35 per hour $12.07 per unit $9.35 per hour 12,000 2,000 45,000 25,000…
Equivalent Units of Production and Related Costs The charges to Work in Process—Assembly Department for a period, together with information concerning production, are as follows. All direct materials are placed in process at the beginning of production. Work in Process—Assembly Department Bal., 6,400 units, 40% completed 45,760 To Finished Goods, 119,400 units ? Direct materials, 116,000 units @ $6.25 725,000 Direct labor 145,160 Factory overhead 90,020 Bal. ? units, 25% completed ? Determine the following: a. The number of units in work in process inventory at the end of the period.fill in the blank 15ed53fd8f81023_1 units Feedback b. Equivalent units of production for direct materials and conversion. If an amount box does not require an entry, leave it blank. Work in Process-Assembly Department Equivalent Units of Production for Direct Materials and Conversion Costs WholeUnits EquivalentUnitsDirectMaterials…
Meginnis orporati elevant ange f ctivity s ,000 nits o ,000 nits. hen t roduces and sells 5,000 units, its average costs per unit are as follows: Average Cost per Unit Direct materials $ 5.20 Direct labor $ 3.75 Variable manufactu overhead $ 1.65 2.60 Fixed manufacturing overhead Fixed selling expense 0.50 Fixed administrative expense $ 0.40 $ 1.50 Sales commissions Variable administrative expense $ 0.50 If 6,000 units are produced, the total amount of direct manufacturing cost incurred is closest to: %24 %24
36 Arbon Company has three service departments and two operating departments. Selected data concerning the five departments are presented below: Costs Number of employees Square metres of space occupied Machine-hours Service Departments Equipment Administrative Janitorial Maintenance Prep Finishing Total $36,000 $256,100 $498,600 $950,500 $67,800 $92,000 80 60 240 600 300 1,280 300 1,200 1,000 2,000 7,000 11,500 26,000 54,000 80,000 The company allocates service department costs by the step-down method in the following order: Administrative (number of employees), Janitorial (space occupied), and Equipment Maintenance (machine-hours). Departmental costs before allocations Allocations: Required: Using the step-down method, allocate the service department costs to the operating departments. (Negative amounts should be indicated by a minus sign.) Administrative Janitorial Maintenance Total costs after allocation $ Operating Departments Service Departments Administrative Janitorial…
None
Under absorption costing, what is the cost of goods sold? (Round cost per unit to 2 decimal places, eg. 2.52 and final answer to 0 decimal place, e.g. 2,152.) Cost of goods sold $ eTextbook and Medi Save for Later Attempts: 0 of 3 used Submit Answer
Direct Materials Direct Labor Manufacturing overhead Total Manufacturing costs Work-in-process 1/1 Work-in-process 12/31 Cost of goods manufactured Sales Finished Goods 1/1 Cost of Goods Available Finished Goods 12/31 Cost of Goods Sold Gross Profit Operating Expenses Net Operating Income Case 1 $36,000 $12,000 $78,000 $12,000 $66,000 $180,000 $42,000 $78,000 $54,000 Case 2 $5,000 $6,000 $21,000 $2,000 $33,000 $50,000 $9,000 $7,000 $10,000 a Calculate the unknown amounts for both Case 1 and 2 b For Case 1, compute the total prime costs for the year. c For Case 1, compute the total conversion costs for the year. d For Case 1, compute the average price per unit if the company sold 15,000 uni e For Case 1, compute the operating income per unit if the company sold 15,000 units f For Case 1, compute the POHR assuming Manufacturing overhead is applied based on DL cost g For Case 1, review beginning and ending work in process. As an auditor or manager what one question might you possibly…
EstimatedFixedCost EstimatedVariableCost(perunitsold) Production costs: Direct materials $19 Direct labor 13 Factory overhead $261,300 10 Selling expenses: Sales salaries and commissions 54,300 4 Advertising 18,400 Travel 4,100 Miscellaneous selling expense 4,500 4 Administrative expenses: Office and officers' salaries 53,100 Supplies 6,500 2 Miscellaneous administrative expense 6,040 2 Total $408,240 $54 It is expected that 8,640 units will be sold at a price of $135 a unit. Maximum sales within the relevant range are 11,000 units. Required: Question Content Area 1. Prepare an estimated income statement for 20Y7. Belmain Co.Estimated Income StatementFor the Year Ended December 31, 20Y7 $- Select - Cost of goods sold: $- Select - - Select - - Select -…
EXERCISE 1 LP Corporation uses an activity-based costing system with the following three activity cost pools: Total Activity Activity Cost Pool Fabrication 80,000 machine-hours 400 orders Order processing Other Not applicable The Other activity cost pool is used to accumulate costs of idle capacity and facility-sustaining costs. The company has provided the following data concerning its costs: Wages and salaries Depreciation P460,000 180,000 200,000 P840,000 Occupancy Total The distribution of resource consumptions across activity cost pools is given below: Activity Cost Pools Order Fabrication Other Total Processing Wages and salaries 5% 80% 15% 100% Depreciation 15% 40% 45% 100% Occupancy 15% 50% 35% 100% Required: 1. Determine the activity rate for the Fabrication activity cost pool. 2. Determine the activity rate for the Order Processing activity cost pool. ersity