Activity rates and product costs using activity based costing Lonsdale Inc manufactures entry and dining room lighting fixtures Five activities are used in manufacturing the fixtures These activities and their associated budgeted activity costs and activity bases are as follows Activity Budgeted Activity Cost Activity Base Casting $540,000 Machine hours Assembly 88,000 Direct labor hours Inspecting 42,000 Number of inspections Setup 40,000 Number of setups Materials handling 24,700 Number of loads Corporate records were obtained to estimate the amount of activity to be used by the two products The estimated activity base usage quantities and units produced follow Activity Base Entry Dining Total Machine hours 6,320 13,680 20,000 Direct labor hours 3,300 2,200 5,500 Number of inspections 270 780 1,050 Number of setups 240 160 400 Number of loads 490 460 950 Units produced 4,900 2,600 7,500 This information has been collected in the Microsoft Excel Online file Open the spreadsheet, perform the required analysis, and input your answers in the questions below Open spreadsheet Determine the activity rate for each activity If required, round the rate to the nearest dollar Activity Activity Rate Casting $ fill in the blank 2 per machine hour Assembly $ fill in the blank 3 per direct labor hour Inspecting $ fill in the blank 4 per inspection Setup $ fill in the blank 5 per setup Materials handling $ fill in the blank 6 per load Use the activity rates in (a) to determine the total and per unit activity costs associated with each product Round the per unit rates to the nearest cent Product Total Activity Cost Activity Cost Per Unit Entry Lighting Fixtures $ fill in the blank 7 $ fill in the blank 8 Dining Room Lighting Fixtures $ fill in the blank 9 $ fill in the blank 10 Activity rates and product costs using activity based costing Lonsdale Inc manufactures entry and dining room lighting fixtures Five activities are used in manufacturing the fixtures These activities and their associated budgeted activity costs and activity bases are as follows Budgeted Activity Activity Cost Activity Base Casting $540,000 Machine hours Assembly 88,000 Direct labor hours Inspecting 42,000 Number of inspections Setup 40,000 Number of setups Materials handling 24,700 Number of loads Corporate records were obtained to estimate the amount of activity to be used by the two products The estimated activity base usage quantities and units produced follow Activity Base Entry Dining Total Machine hours 6,320 13,680 20,000 3,300 5,500 Direct labor hours Number of inspections Number of setups 2,200 780 270 1,050 240 160 400 Number of loads 490 460 950 Units produced 4,900 2,600 7,500 This information has been collected in the Microsoft Excel Online file Open the spreadsheet, perform the required analysis, and input your answers in the questions below X Open spreadsheet Open spreadsheet a Determine the activity rate for each activity If required, round the rate to the nearest dollar Activity Activity Rate Casting x per machine hour $ $ Assembly per direct labor hour Inspecting per inspection Setup $ per setup Materials handling $ per load b Use the activity rates in (a) to determine the total and per unit activity costs associated with each product Round the per unit rates to the nearest cent Product Total Activity Cost Activity Cost Per Unit Entry Lighting Fixtures Dining Room Lighting Fixtures $

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 06, 2024

Activity rates and product costs using activity-based costing Lonsdale Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the fixtures.

Activity rates and product costs using activity-based costing

Lonsdale Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the fixtures. These activities and their associated budgeted activity costs and activity bases are as follows:

Activity	Budgeted Activity Cost	Activity Base
Casting	$540,000	Machine hours
Assembly	88,000	Direct labor hours
Inspecting	42,000	Number of inspections
Setup	40,000	Number of setups
Materials handling	24,700	Number of loads

Corporate records were obtained to estimate the amount of activity to be used by the two products. The estimated activity-base usage quantities and units produced follow:

Activity Base	Entry	Dining	Total
Machine hours	6,320	13,680	20,000
Direct labor hours	3,300	2,200	5,500
Number of inspections	270	780	1,050
Number of setups	240	160	400
Number of loads	490	460	950
Units produced	4,900	2,600	7,500

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.

Open spreadsheet

Determine the activity rate for each activity. If required, round the rate to the nearest dollar.

Activity	Activity Rate
Casting	$ fill in the blank 2	per machine hour
Assembly	$ fill in the blank 3	per direct labor hour
Inspecting	$ fill in the blank 4	per inspection
Setup	$ fill in the blank 5	per setup
Materials handling	$ fill in the blank 6	per load

Use the activity rates in (a) to determine the total and per-unit activity costs associated with each product. Round the per unit rates to the nearest cent.

Product	Total Activity Cost	Activity Cost Per Unit
Entry Lighting Fixtures	$ fill in the blank 7	$ fill in the blank 8
Dining Room Lighting Fixtures	$ fill in the blank 9	$ fill in the blank 10

Activity rates and product costs using activity-based costing Lonsdale Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the fixtures. These activities and their associated budgeted activity costs and activity bases are as follows: Budgeted Activity Activity Cost Activity Base Casting $540,000 Machine hours Assembly 88,000 Direct labor hours Inspecting 42,000 Number of inspections Setup 40,000 Number of setups Materials handling 24,700 Number of loads Corporate records were obtained to estimate the amount of activity to be used by the two products. The estimated activity-base usage quantities and units produced follow: Activity Base Entry Dining Total Machine hours 6,320 13,680 20,000 3,300 5,500 Direct labor hours Number of inspections Number of setups 2,200 780 270 1,050 240 160 400 Number of loads 490 460 950 Units produced 4,900 2,600 7,500 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X Open spreadsheet Open spreadsheet a. Determine the activity rate for each activity. If required, round the rate to the nearest dollar. Activity Activity Rate Casting x per machine hour $ $ Assembly per direct labor hour Inspecting per inspection Setup $ per setup Materials handling $ per load b. Use the activity rates in (a) to determine the total and per-unit activity costs associated with each product. Round the per unit rates to the nearest cent. Product Total Activity Cost Activity Cost Per Unit Entry Lighting Fixtures Dining Room Lighting Fixtures $