Activity rates and product costs using activity$-$based cost

Idris 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 $$310,930$ Machine hours

Assembly $217,170$ Direct labor hours

Inspecting $35,520$ Number of inspections

Setup $51,680$ Number of setups

Materials handling $39,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,3204,71010,030$

Direct labor hours $4,5706,86011,430$

Number of inspections $1,6905302,220$

Number of setups $28060340$

Number of loads $7902101,000$

Units produced $10,6005,30015,900$

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

a$.$ 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

b$.$ Use the activity rates in $($a$)$ to determine the total and per$-$unit activity costs associated with each product. Round the per unit amounts 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$

Check My Work