Lightsquare 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	$114,114	Machine hours
Assembly	64,262	Direct labor hours
Inspecting	18,335	Number of inspections
Setup	29,380	Number of setups
Materials handling	26,424	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	2,173	1,285	3,458
Direct labor hours	855	2,066	2,921
Number of inspections	697	268	965
Number of setups	168	58	226
Number of loads	495	239	734
Units produced	5,541	2,411	7,952

Required:

Complete the Activity Table for entry lighting and dining room lighting fixtures.

A.

Determine the activity rate for each activity. Enter these rates in the Activity Rate columns.

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.

Complete the Activity Table for entry lighting fixtures.

A.	Determine the activity rate for each activity. Enter these rates in the Activity Rate column.
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.

Entry Lighting Fixtures

Activity

Activity-

Base

Activity

Activity

Usage

X

Rate

=

Cost

Casting

Assembly

Inspecting

Setup

Materials handling

Total activity cost

Number of units

Activity cost per unit

Complete the Activity Table for dining room lighting fixtures.

A.	Determine the activity rate for each activity. Enter these rates in the Activity Rate column.
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.

	Dining Room Lighting Fixtures
Activity	Activity-
	Base		Activity		Activity
	Usage	X	Rate	=	Cost
Casting
Assembly
Inspecting
Setup
Materials handling
Total activity cost
Number of units
Activity cost per unit