Question

Lonsdale Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the...

  1. 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 $325,710 Machine hours
    Assembly 202,500 Direct labor hours
    Inspecting 33,150 Number of inspections
    Setup 36,480 Number of setups
    Materials handling 42,750 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,230 4,640 9,870
    Direct labor hours 4,500 6,750 11,250
    Number of inspections 1,680 530 2,210
    Number of setups 190 50 240
    Number of loads 750 200 950
    Units produced 10,400 5,200 15,600

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

    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 $ $
    Dining Room Lighting Fixtures $ $

Homework Answers

Answer #1
a. Activity rates for each activity [Refer working note 1]
Casting $33 per machine hour
Assembly $18 per direct labor hour
Inspecting $15 per inspection
Setup $152 per setup
Materials handling $45 per load
b. Total and per-unit activity costs    
Product Total Activity Cost

[Refer working note 2]
Activity Cost Per Unit

[Refer working note 3]
Entry Lighting Fixtures $341,420 $32.83
Dining Room Lighting Fixtures $299,170 $57.53

.

.

Working note 1 - Calculation of Activity rate
Activity Budgeted activity cost

(a)
Activity usage

(b)
Activity rate

(a / b)
Casting $325,710            9,870 machine hours $33 per machine hour
Assembly $202,500          11,250 direct labor hours $18 per direct labor hour
Inspecting $33,150            2,210 inspections $15 per inspection
Setup $36,480               240 setups $152 per setup
Materials handling $42,750               950 loads $45 per load

.

.

Working note 2 - Calculation of total activity costs associated with each product
Activity Activity Rate

[Refer working note 1]
Entry Lighting Fixtures Dining Room Lighting Fixtures
Activity usage Allocation of activity cost Activity usage Allocation of activity cost
(a) (b) (a x b) (c) (a x c)
Casting $33 per machine hour         5,230 machine hours $172,590        4,640 machine hours $153,120
Assembly $18 per direct labor hour         4,500 direct labor hours $81,000        6,750 direct labor hours $121,500
Inspecting $15 per setup         1,680 inspections $25,200           530 inspections $7,950
Setup $152 per inspection            190 setups $28,880             50 setups $7,600
Materials handling $45 per load            750 loads $33,750           200 loads $9,000
Total activity cost assigned $341,420 $299,170

.

.

Working note 3 - Computation of per-unit activity costs associated with each product
Entry Lighting Fixtures Dining Room Lighting Fixtures
Total activity cost allocated        [Refer working note 2]             (a) $341,420 $299,170
Production ( In units)                                                                     (b) 10,400 5,200
Overhead cost per unit                                                (a / b) $32.83 $57.53
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
BriteLite Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the...
BriteLite Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the fixtures. These activities and their associated activity costs and activity bases are as follows: Activity Activity Costs (Budgeted) Activity Base Casting $42,000 Machine hours Assembly 13,500 Direct labor hours Inspecting 5,800 Number of inspections Setup 16,800 Number of setups Materials handling 3,600 Number of loads Corporate records were obtained to estimate the amount of activity to be used by the two products. The estimated...
Lonsdale Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the...
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 $344,760 Machine hours Assembly 231,200 Direct labor hours Inspecting 38,080 Number of inspections Setup 33,360 Number of setups Materials handling 43,680 Number of loads Corporate records were obtained to estimate the amount of activity to be used by the two products. The...
Lonsdale Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the...
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 $250,900 Machine hours Assembly 154,000 Direct labor hours Inspecting 26,620 Number of inspections Setup 43,120 Number of setups Materials handling 45,120 Number of loads Corporate records were obtained to estimate the amount of activity to be used by the two products. The...
Lonsdale Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the...
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 $215,740 Machine hours Assembly 203,110 Direct labor hours Inspecting 35,520 Number of inspections Setup 49,830 Number of setups Materials handling 46,280 Number of loads Corporate records were obtained to estimate the amount of activity to be used by the two products. The...
Wings Co. budgeted $569,000 manufacturing direct wages, 2,500 direct labor hours, and had the following manufacturing...
Wings Co. budgeted $569,000 manufacturing direct wages, 2,500 direct labor hours, and had the following manufacturing overhead: Overhead Cost Pool Budgeted Overhead Cost Budgeted Level for Cost Driver Overhead Cost Driver Materials handling $ 184,000 4,600 pounds Weight of materials Machine setup 15,900 530 setups Number of setups Machine repair 1,200 30,000 machine hours Machine hours Inspections 21,000 300 inspections Number of inspections Requirements for Job #971 which manufactured 4 units of product: Direct labor 20 hours Direct materials 190...
Atlas Enterprises Inc. manufactures elliptical exercise machines and treadmills. The products are produced in its Fabrication...
Atlas Enterprises Inc. manufactures elliptical exercise machines and treadmills. The products are produced in its Fabrication and Assembly production departments. In addition to production activities, several other activities are required to produce the two products. These activities and their associated activity rates are as follows: Activity Activity Rate Fabrication $28 per machine hour Assembly $20 per direct labor hour Setup $75 per setup Inspecting $30 per inspection Production scheduling $12 per production order Purchasing $8 per purchase order The activity-base...
Atlas Enterprises Inc. manufactures elliptical exercise machines and treadmills. The products are produced in its Fabrication...
Atlas Enterprises Inc. manufactures elliptical exercise machines and treadmills. The products are produced in its Fabrication and Assembly production departments. In addition to production activities, several other activities are required to produce the two products. These activities and their associated activity rates are as follows: Activity Activity Rate Fabrication $33 per machine hour Assembly $18 per direct labor hour Setup $56 per setup Inspecting $20 per inspection Production scheduling $12 per production order Purchasing $8 per purchase order The activity-base...
Product costs using activity rates Hercules Inc. manufactures elliptical exercise machines and treadmills. The products are...
Product costs using activity rates Hercules Inc. manufactures elliptical exercise machines and treadmills. The products are produced in its Fabrication and Assembly production departments. In addition to production activities, several other activities are required to produce the two products. These activities and their associated activity rates are as follows: Activity Activity Rate Fabrication $25 per machine hour Assembly $32 per direct labor hour Setup $87 per setup Inspecting $15 per inspection Production scheduling $14 per production order Purchasing $5 per...
Atlas Enterprises Inc. manufactures elliptical exercise machines and treadmills. The products are produced in its Fabrication...
Atlas Enterprises Inc. manufactures elliptical exercise machines and treadmills. The products are produced in its Fabrication and Assembly production departments. In addition to production activities, several other activities are required to produce the two products. These activities and their associated activity rates are as follows: Activity Activity Rate Fabrication $30 per machine hour Assembly $15 per direct labor hour Setup $54 per setup Inspecting $32 per inspection Production scheduling $16 per production order Purchasing $13 per purchase order The activity-base...
Atlas Enterprises Inc. manufactures elliptical exercise machines and treadmills. The products are produced in its Fabrication...
Atlas Enterprises Inc. manufactures elliptical exercise machines and treadmills. The products are produced in its Fabrication and Assembly production departments. In addition to production activities, several other activities are required to produce the two products. These activities and their associated activity rates are as follows: Activity Activity Rate Fabrication $31 per machine hour Assembly $17 per direct labor hour Setup $46 per setup Inspecting $32 per inspection Production scheduling $18 per production order Purchasing $15 per purchase order The activity-base...