X 8FILEPasteClipboardC1641. Assign indirect costs to products or services using activity based costing.&14HOMECalibriAActivity Cost Pool5 Material Handling▶L=BIUINSERT⠀READYAttomatle) 3/26 Machine Set-Ups7 Engineering Support8 Power and Space9 Total overhead cost $1015 Activity Cost Pool16 Material Handling17 Machine Set-Ups18 Engineering Support19 Power and Space20 Total Overhead Cost2122DOFontSheet111PAGE LAYOUTBA AA.Overhead Cost$ 300,000$210,000fxx710,000+EEconomyFORMULASCAssigning indirect costs to products or services using activity based costing - ExcelDATAREVIEWVIEWWrap Text*Merge & Center -AlignmentDeluxeDOverhead Assigned Using Activity RatesActivity Cost Driver5,000 Material movesSet-upsEngineering hours $20,000 square feet.11 Use formulas to assign overhead to each product using both activity rates and activity proportions (%).12 Create if/then statements to verify that the two methods produce the same results.13ETotalCurrency$%,Activity RateNumberFper moveper set-up12.50 per hourper sq. ft.+.0 .00.00 ➜.0Conditional Format as CellFormatting Table StylesStylesEconomyGHActivityEconomy Model Proportion (%)2,0003002,000DeluxeHHInsert Delete FormatOverhead Assigned Using Activity Proportions (%)Total20%50%CellsIDeluxeModel3,000900|←|PJΣ > AutoSum+✔Fill-✓ClearProportion(%)B?KEditingAY HSort & Find &Filter SelectLSign InVerification: Create if/thenstatements to determine if the twomethods produce identical results byindicating "pass" or "fail"DeluxeEconomyTotal9►X+ 100%

Name: X 8FILEPasteClipboardC1641. Assign indirect costs to products or serv
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: X 8FILEPasteClipboardC1641. Assign indirect costs to products or services using activity based costing.&14HOMECalibriAActivity Cost Pool5 Material Handling▶L=BIUINSERT⠀READYAttomatle) 3/26 Machine Set-Ups7 Engineering Support8 Power and Space9 Total

Activity Rate=Overhead CostActivity Cost Driver

Business

Accounting

4 Activity Cost Pool 5 Material Handling 6 Machine Set-Ups 7 Engineering Support 8 Power and Space 9 Total overhead cost $ 710,000 10 14 15 Activity Cost Pool 16 Material Handling 17 Machine Set-Ups 18 Engineering Support 19 Power and Space 20 Total Overhead Cost B 21 22 Overhead Cost $ 300,000 $ 210,000 Shoot1 11 Use formulas to assign overhead to each product using both activity rates and activity proportions (%). 12 Create if/then statements to verify that the two methods produce the same results. 13 Economy D Overhead Assigned Using Activity Rates O Activity Cost Driver 5,000 Material moves Set-ups Engineering hours $ 20,000 square feet. Deluxe E Activity Rate Total - per move per set-up 12.50 per hour per sq. ft. G Economy H Activity Economy Model Proportion (%) 2,000 300 2,000 Deluxe Overhead Assigned Using Activity Proportions (%) 20% 50% Total - Deluxe Proportion Model (%) 3,000 900 K L Verification: Create if/then statements to determine if the two methods produce identical results by indicating "pass" or "fail" Economy Deluxe Total

4 Activity Cost Pool 5 Material Handling 6 Machine Set-Ups 7 Engineering Support 8 Power and Space 9 Total overhead cost $ 710,000 10 14 15 Activity Cost Pool 16 Material Handling 17 Machine Set-Ups 18 Engineering Support 19 Power and Space 20 Total Overhead Cost B 21 22 Overhead Cost $ 300,000 $ 210,000 Shoot1 11 Use formulas to assign overhead to each product using both activity rates and activity proportions (%). 12 Create if/then statements to verify that the two methods produce the same results. 13 Economy D Overhead Assigned Using Activity Rates O Activity Cost Driver 5,000 Material moves Set-ups Engineering hours $ 20,000 square feet. Deluxe E Activity Rate Total - per move per set-up 12.50 per hour per sq. ft. G Economy H Activity Economy Model Proportion (%) 2,000 300 2,000 Deluxe Overhead Assigned Using Activity Proportions (%) 20% 50% Total - Deluxe Proportion Model (%) 3,000 900 K L Verification: Create if/then statements to determine if the two methods produce identical results by indicating "pass" or "fail" Economy Deluxe Total

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

Figuring a predetermined overhead rate using direct materials as the allocation base. $130500 estimated manufacturing overhead cost and $87000 as allocation base. Then whats next in the formula
Please do not give solution in image format thanku
2 Applying Assignment ← Jackson Foundry uses a predetermined overhead allocation rate to allocate overhead to individual jobs, based View the costs. Read the requirements. Requirement 1. Compute Jackson Factory's predetermined overhead allocation rate. Predetermined overhea allocation rate per machine H Requirement 2. Prepare the journal entry to allocate manufacturing overhead. (Record debits first, then credit Accounts and Explanation pages $ Estimated overhead cost 880,000 Question 2, EM2-24 (similar to) Part 2 of 6 Date Dec. 31 Get more help. Estimated machine hours 80,000 $ 11 Debit Credit Costs At the beginning of 2025, the company expected to incur the following: $880,000 Manufacturing overhead costs Direct labor costs 1,440,000 Machine hours 80,000 hours At the end of 2025, the company had actually incurred: Direct labor costs Depreciation on manufacturing plant and equipment Property taxes on plant Sales salaries Delivery drivers' wages Plant janitor's wages Machine hours…
5. Match the following cost pools and activities with the most appropriate cost driver. Group of answer choices a. number of parts b. square feet c. direct labor hours d. number of tests required e. machine hours f. machine setups g. number of orders received 1. setup cost pool? 2. assembly cost pool? 3. supervising cost pool? 4. testing cost pool? 5. ordering cost pool? 6. fringe…
Custom's has three cost pools and an associated cost driver to allocate the costs to the product. The cost pools, cost driver, estimated overhead, and estimated activity for the cost pool are: Cost Pool Material Machining Inspection • Material cost pool . Material requisitions Machine hours Number of inspections • Machining cost pool Custom's data Cost Driver Inspection cost pool Estimated Activity per Driver 14,000 186,400 10,000 Estimated Overhead What is the predetermined overhead rate for each activity? Round to the nearest penny, two decimal places. $52,500 363,500 75,000
Eastern Chemical Company produces three products. The operating results of the current year are: Actual Price $382.00 271.60 326.00 Sales Product Quantity A B C 1,858 9,258 925 Target Price $ 301.00 313.60 218.50 Direct materials Direct labor Total prime cost The firm sets the target price of each product at 150% of the product's total manufacturing cost. It appears that the firm was able to sell Product Cat a much higher price than the target price of the product and lost money on Product B. Tom Watson, CEO, wants to promote Product C much more aggressively and phase out Product B. He believes that the information suggests that Product C has the greatest potential among the firm's three products because the actual selling price of Product C was almost 50% higher than the target price, while the firm was forced to sell Product B at a price below the target price. Both the budgeted and actual factory overhead for the current year are $847,300. The actual units sold for each product also…
Forner, Inc., manufactures and sells two products: Product Z1 and Product Z8. The company has an activity-based costing system with the following activity cost pools, activity measures, and expected activity Estimated Expected Activity Activity Overhead Activity Cost Pools Labor-related Measures Cost Product Z1 Product Z8 Total DLHS $112,190 40,440 609,770 600 2,000 Machine setups Оrder size 2,600 1,200 6, 200 setups 500 700 MHs 3,000 3,200 $762,400 The activity rate for the Machine Setups activity cost pool under activity-based costing is closest to: Multiple Cholce $203.26 per setup $190.55 per setup $122.97 per setup 92 F AQI 61 nere to search DELL
Please do not give solution in image format thanku
PR 18-4A Activity-Based Product Costing Obj. 4 Mello Manufacturing Company is a diversified manufacturer that manufactures three products (Alpha, Beta, and Omega) in a continuous production process. Senior management has asked the controller to conduct an activity-based costing study. The controller identified the amount of factory overhead required by the critical activities of the organization as follows: Activity Production Setup Materials handling Inspection Product engineering The activity bases identified for each activity are as follows: Activity Production Alpha Beta 3. Setup Materials handling Inspection Product engineering Total Omega Total Activity Base Machine hours Number of setups Number of parts The activity-base usage quantities and units produced for the three products were determined from corporate records and are as follows: Number of inspection hours Number of engineering hours Machine Hours 1,440 1,080 720 3,240 Number of Setups Activity Cost Pool $259,200 55,000…
DO NOT GIVE SOLUTION IN IMAGE
Lion Corporation uses an activity-based costing system to assign overhead costs to products. In the first stage, two overhead costs--equipment depreciation and supervisory expense-are allocated to three activity cost pools--Machining, Order Filling, and Other--based on resource consumption. Data to perform these allocations appear below: Overhead costs: Equipment depreciation Supervisory expense Equipment depreciation Distribution of Resource Consumption Across Activity Cost Pools: Product C9 $ 47,000 Product UO $ 6,000 Total Supervisory expense 0.60 Activity Cost Pools O $18.00 per MH O $5.30 per MH O $2.82 per MH O $3.18 per MH Mac 0.60 In the second stage, Machining costs are assigned to products using machine- hours (MHS) and Order Filling costs are assigned to products using the number of orders. The costs in the Other activity cost pool are not assigned to products. Activity data for the company's two products follow: 6,900 Order Filling 3,100 0.10 MHS (Machining) 10,000 b.20 200…
Please show your work.