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 $594,000 Machine hours Assembly 66,500 Direct labor hours Inspecting 41,400 Number of inspections Setup 49,200 Number of setups Materials handling 27,200 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,680 12,320 18,000 Direct labor hours 2,100 1,400 3,500 Number of inspections 320 580 900 Number of setups 360 240 600 Number of loads 280 520 800 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 $ 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 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 $ fill in the blank 7 $ fill in the blank 8 Dining Room Lighting Fixtures $ fill in the blank 9 $ fill in the blank 10
Process Costing
Process costing is a sort of operation costing which is employed to determine the value of a product at each process or stage of producing process, applicable where goods produced from a series of continuous operations or procedure.
Job Costing
Job costing is adhesive costs of each and every job involved in the production processes. It is an accounting measure. It is a method which determines the cost of specific jobs, which are performed according to the consumer’s specifications. Job costing is possible only in businesses where the production is done as per the customer’s requirement. For example, some customers order to manufacture furniture as per their needs.
ABC Costing
Cost Accounting is a form of managerial accounting that helps the company in assessing the total variable cost so as to compute the cost of production. Cost accounting is generally used by the management so as to ensure better decision-making. In comparison to financial accounting, cost accounting has to follow a set standard ad can be used flexibly by the management as per their needs. The types of Cost Accounting include – Lean Accounting, Standard Costing, Marginal Costing and Activity Based Costing.
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 | $594,000 | Machine hours | |
Assembly | 66,500 | Direct labor hours | |
Inspecting | 41,400 | Number of inspections | |
Setup | 49,200 | Number of setups | |
Materials handling | 27,200 | 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,680 | 12,320 | 18,000 | |||
Direct labor hours | 2,100 | 1,400 | 3,500 | |||
Number of inspections | 320 | 580 | 900 | |||
Number of setups | 360 | 240 | 600 | |||
Number of loads | 280 | 520 | 800 | |||
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.
-
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 -
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 $ fill in the blank 7 $ fill in the blank 8 Dining Room Lighting Fixtures $ fill in the blank 9 $ fill in the blank 10
![A
B
D
F
G
H
Activity rates and product costs using activity-based costing
2.
Lonsdale Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the fixtures. These activities and their associated
3 budgeted activity costs and activity bases are as follows:
4
6 Activity
Casting
DATA
Budgeted Activity Cost Activity Base
$594,000
Machine hours
Direct labor hours
Number of inspections
Number of setups
8
Assembly
66,500
9
Inspecting
41,400
10 Setup
11 Materials handling
49,200
27,200
Number of loads
12
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
13 produced follow:
14
15
DATA
16 Activity Base
Entry
Dining
Total
17 Machine hours
5,680
12,320
18,000
18 Direct labor hours
19 Number of inspections
20 Number of setups
21 Number of loads
22 Units produced
2,100
1,400
3,500
320
580
900
360
240
600
280
520
800
2,200
3,800
6,000
23
Using formulas and cell references, perform the required analysis, and input your answers into Activity Rate, Total Activity Cost, and Activity Cost Per Unit
24 columns. Transfer the numeric results for the green entry cells (C27:C31, C34:D35) into the appropriate fields in CNOWV2 for grading.
25
Activity Rate
26 la. Activity
Casting
Assembly
Inspecting
Setup
Materials handling
Formulas
27
Iper machine hour
per direct labor hour
28
29
per inspection
per setup
per load
30
31
32
33 b.
Total Activity Cost
Activity Cost Per Unit
Formulas
34
Entry Lighting Fixtures
Dining Room Lighting Fixtures
35
36
37
38
39
40
A1
A Data](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F39dba9ad-5c98-4774-bd6c-9e9576e4e946%2F783c38c9-4db2-4cd7-82e4-04ee41b4b319%2Fh9bd4ae_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)