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 $570,000   Machine hours Assembly 80,000   Direct labor hours Inspecting 42,000   Number of inspections Setup 38,000   Number of setups Materials handling 23,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:

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question

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 $570,000   Machine hours
Assembly 80,000   Direct labor hours
Inspecting 42,000   Number of inspections
Setup 38,000   Number of setups
Materials handling 23,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 6,000   13,000   19,000  
Direct labor hours 3,000   2,000   5,000  
Number of inspections 600   400   1,000  
Number of setups 300   200   500  
Number of loads 450   500   950  
Units produced 6,000   3,000   9,000  

 

a.  Determine the activity rate for each activity.

Activity Activity Rate  
Casting $fill in the blank 1 per machine hour
Assembly $fill in the blank 2 per direct labor hour
Inspecting $fill in the blank 3 per inspection
Setup $fill in the blank 4 per setup
Materials handling $fill in the blank 5 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 6 $fill in the blank 7
Dining Room Lighting Fixtures $fill in the blank 8 $fill in the blank 9
**Activity-Based Costing Exercise**

In this exercise, we're focusing on the activity-based costing method applied to production activities. Below is the data and associated tasks for determining the costs involved in manufacturing two types of products: Entry Lighting Fixtures and Dining Room Lighting Fixtures.

**Production Data:**

- **Machine Hours:**  
  - Entry Lighting Fixtures: 6,000 hours  
  - Dining Room Lighting Fixtures: 13,000 hours  
  - Total: 19,000 hours  

- **Direct Labor Hours:**  
  - Entry Lighting Fixtures: 3,000 hours  
  - Dining Room Lighting Fixtures: 2,000 hours  
  - Total: 5,000 hours  

- **Number of Inspections:**  
  - Entry Lighting Fixtures: 600 inspections  
  - Dining Room Lighting Fixtures: 400 inspections  
  - Total: 1,000 inspections  

- **Number of Setups:**  
  - Entry Lighting Fixtures: 300 setups  
  - Dining Room Lighting Fixtures: 200 setups  
  - Total: 500 setups  

- **Number of Loads:**  
  - Entry Lighting Fixtures: 450 loads  
  - Dining Room Lighting Fixtures: 500 loads  
  - Total: 950 loads  

- **Units Produced:**  
  - Entry Lighting Fixtures: 6,000 units  
  - Dining Room Lighting Fixtures: 3,000 units  
  - Total: 9,000 units  

**Tasks:**

a. **Determine the Activity Rate for Each Activity:**

- **Casting:** \(_\) per machine hour
- **Assembly:** \(_\) per direct labor hour
- **Inspecting:** \(_\) per inspection
- **Setup:** \(_\) per setup
- **Materials Handling:** \(_\) per load

b. **Calculate Total and Per-Unit Activity Costs:**

Use the activity rates from part (a) to determine the total and per-unit activity costs for each product. Round the per-unit amounts to the nearest cent.

- **Entry Lighting Fixtures:**
  - Total Activity Cost: \(_\)
  - Activity Cost Per Unit: \(_\)

- **Dining Room Lighting Fixtures:**
  - Total Activity Cost: \(_\)
  - Activity Cost Per Unit: \(_\)

This exercise is designed to enhance your understanding of activity-based costing by analyzing the production process and associated costs at a detailed level.
Transcribed Image Text:**Activity-Based Costing Exercise** In this exercise, we're focusing on the activity-based costing method applied to production activities. Below is the data and associated tasks for determining the costs involved in manufacturing two types of products: Entry Lighting Fixtures and Dining Room Lighting Fixtures. **Production Data:** - **Machine Hours:** - Entry Lighting Fixtures: 6,000 hours - Dining Room Lighting Fixtures: 13,000 hours - Total: 19,000 hours - **Direct Labor Hours:** - Entry Lighting Fixtures: 3,000 hours - Dining Room Lighting Fixtures: 2,000 hours - Total: 5,000 hours - **Number of Inspections:** - Entry Lighting Fixtures: 600 inspections - Dining Room Lighting Fixtures: 400 inspections - Total: 1,000 inspections - **Number of Setups:** - Entry Lighting Fixtures: 300 setups - Dining Room Lighting Fixtures: 200 setups - Total: 500 setups - **Number of Loads:** - Entry Lighting Fixtures: 450 loads - Dining Room Lighting Fixtures: 500 loads - Total: 950 loads - **Units Produced:** - Entry Lighting Fixtures: 6,000 units - Dining Room Lighting Fixtures: 3,000 units - Total: 9,000 units **Tasks:** a. **Determine the Activity Rate for Each Activity:** - **Casting:** \(_\) per machine hour - **Assembly:** \(_\) per direct labor hour - **Inspecting:** \(_\) per inspection - **Setup:** \(_\) per setup - **Materials Handling:** \(_\) per load b. **Calculate Total and Per-Unit Activity Costs:** Use the activity rates from part (a) to determine the total and per-unit activity costs for each product. Round the per-unit amounts to the nearest cent. - **Entry Lighting Fixtures:** - Total Activity Cost: \(_\) - Activity Cost Per Unit: \(_\) - **Dining Room Lighting Fixtures:** - Total Activity Cost: \(_\) - Activity Cost Per Unit: \(_\) This exercise is designed to enhance your understanding of activity-based costing by analyzing the production process and associated costs at a detailed level.
**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                | $570,000                  | Machine hours             |
| Assembly               | 80,000                    | Direct labor hours        |
| Inspecting             | 42,000                    | Number of inspections     |
| Setup                  | 38,000                    | Number of setups          |
| Materials handling     | 23,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         | 6,000     | 13,000     | 19,000    |
| Direct labor hours    | 3,000     | 2,000      | 5,000     |
| Number of inspections | 600       | 400        | 1,000     |
| Number of setups      | 300       | 200        | 500       |
| Number of loads       | 450       | 500        | 950       |
| Units produced        | 6,000     | 3,000      | 9,000     |

This data helps in determining the costs associated with each activity and how they contribute to producing entry and dining room fixtures. Activity-Based Costing (ABC) enables accurate cost calculation by associating costs with specific activities required to create a product.
Transcribed Image Text:**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 | $570,000 | Machine hours | | Assembly | 80,000 | Direct labor hours | | Inspecting | 42,000 | Number of inspections | | Setup | 38,000 | Number of setups | | Materials handling | 23,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 | 6,000 | 13,000 | 19,000 | | Direct labor hours | 3,000 | 2,000 | 5,000 | | Number of inspections | 600 | 400 | 1,000 | | Number of setups | 300 | 200 | 500 | | Number of loads | 450 | 500 | 950 | | Units produced | 6,000 | 3,000 | 9,000 | This data helps in determining the costs associated with each activity and how they contribute to producing entry and dining room fixtures. Activity-Based Costing (ABC) enables accurate cost calculation by associating costs with specific activities required to create a product.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Costing Systems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education