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 $475,000 Machine hours
Assembly 128,000 Direct labor hours
Inspecting 33,250 Number of inspections
Setup 43,650 Number of setups
Materials handling 22,950 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,000 13,000 19,000
Direct labor hours 4,800 3,200 8,000
Number of inspections 200 750 950
Number of setups 270 180 450
Number of loads 640 210 850
Units produced 2,200 3,800 6,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
Determine the activity rate for each activity. If required, round the rate to the nearest dollar.
Activity Activity Rate
Casting $ per machine hour
Assembly $ per direct labor hour
Inspecting $ per inspection
Setup $ per setup
Materials handling $ 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 $ $
Dining Room Lighting Fixtures $ $

Respuesta :

The Activity rate for each activity are: Casting $25 per machine hour, Assembly $16 per direct labor hours, Inspecting $35 per inspection, Setup $97 per setup, Materials Handling $27 per load.

Activity rate for each activity

a. Activity rate for each activity

Casting:

Activity Rate = Budgeted Activity Cost / Budgeted Activity Base

Activity Rate = $475,000 / 19,000

Activity Rate = $25 per machine hour

Assembly:

Activity Rate = Budgeted Activity Cost / Budgeted Activity Base

Activity Rate = $128,000 / 8,000

Activity Rate = $16 per direct labor hours

Inspecting:

Activity Rate = Budgeted Activity Cost / Budgeted Activity Base

Activity Rate = $33,250 /950

Activity Rate = $35 per inspection

Setup:

Activity Rate = Budgeted Activity Cost / Budgeted Activity Base

Activity Rate = $43,650 / 450

Activity Rate = $97 per setup

Materials Handling:

Activity Rate = Budgeted Activity Cost / Budgeted Activity Base

Activity Rate = $22,950 /850

Activity Rate = $27 per load

b. Total and per-unit activity costs

Entry

Total Activity Cost = ($25.00×6,000) + ($16.00 × 4,800)+ ($35.00× 200) + ($97.00 ×270) + ($27.00 × 640)

Total Activity Cost =$150,000+$76,800+$7,000+$26,190+$17,280

Total Activity Cost = $277,270

Activity Cost per unit = Total Activity Cost / Units Produced

Activity Cost per unit = $ /2,200

Activity Cost per unit = $126.03

Dining:

Total Activity Cost =  ($25.00×13,000) + ($16.00 × 3,200)+ ($35.00× 750) + ($97.00 ×180) + ($27.00 × 210)

Total Activity Cost =$325,000+$51,200+$26,250+$17,460+$5,670

Total Activity Cost = $425,580

Activity Cost per unit = Total Activity Cost / Units Produced

Activity Cost per unit = $425,580/3,800

Activity Cost per unit = $111.99

Therefore the Activity rate for each activity are: Casting $25 per machine hour, Assembly $16 per direct labor hours, Inspecting $35 per inspection, Setup $97 per setup, Materials Handling $27 per load.

Learn more about Activity rate for each activity here:https://brainly.com/question/6654166

#SPJ1