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

4.1 Zeus Industries manufactures two types of electrical power units, custom and standard, which involve four factory overhead activities-production setup, procurement, quality control, and materials management. An activity analysis of the overhead revealed the following estimated activity costs and activity bases for these activities:
go.2
Rex Industries has identified three different activities as cost drivers: machine setups, machine hours, and inspections. The overhead and estimated usage are: Compute the overhead rate for each activity. Round your answers to two decimal places. Overhead Overhead Annual Rate per Activity per Activity Usage Activity Machine Setups $157,850 4,100 $ Machine Hours 324,622 14,114 2$ Inspections 119,000 3,400
Please do not give solution in image format thanku
ABC Company has an ABC system with three pools: Total cost in cost pool Activity Machine setups Customer service Maintenance $18,500 $5,000 Cost Driver $29,000 #setups O $9,000 #orders not enough information machine- hours $13,000 $6,000 $10,000 Compute total capacity costs allocated to product X. Activity volume (#cost driver units) Product X Product Y Total 45 15 25 20 5 25 65 20 50
TB MC Qu. 4-49 Boesenhofer, Inc., manufactures and sells... Boesenhofer, Inc., manufactures and sells two products: Product N6 and Product N7. 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 Measures Cost Product N6 Product N7 Labor-related DLHS Total $345,060 128,534 107,598 2,100 600 4,100 Machine setups 5,000 800 3,800 setups 7,100 Order size MHs 1,400 7,900 $581,192 The activity rate for the Machine Setups activity cost pool is closest to: Multiple Cholce $73.57 per setup $91.81 per setup Prev of 36 Next > 10:54 AM 66°F Mostly cloudy 目。 21 10/20/2021 pe here to search DELL Home End Delete PgUp PgDn F12 PrtScr Insert F10 F11 F8 F9 F7 F4 F5 F6 F3 Num Lock Backspace & %23 %24
7
Do not give answer in image
answer with full solution
Solve Required 1 Only
1
4.2 BriteLite Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the fixtures. These activities and their associated activity costs and activity bases are as follows: