1. 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	$414,000		Machine hours
Assembly	112,000		Direct labor hours
Inspecting	31,500		Number of inspections
Setup	47,300		Number of setups
Materials handling	17,000		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	5,680		12,320		18,000
Direct labor hours	4,800		3,200		8,000
Number of inspections	390		510		900
Number of setups	330		220		550
Number of loads	310		540		850
Units produced	3,300		4,700		8,000

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

1. 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

2. 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