Ch. 17 P17-1B - Excel HW Assignment (2)
xlsx
keyboard_arrow_up
School
University of Nairobi *
*We aren’t endorsed by this school
Course
161
Subject
Finance
Date
Nov 24, 2024
Type
xlsx
Pages
8
Uploaded by anayaharry86
Your grade on this assignment will be evaluated as follows:
Use of formulas where appropriate 5% Formatting of Financial Stat
10%
Correct answers/accuracy
90%
Total
100% (out of a score of 10
Accuracy determination
Each cell = 1.5 points each
125
discussion question
5
Total possible points
130
00 points)
Instructions
(a) Under traditional product costing, compute the total unit cost of each product. Prepare
schedule of the individual costs by product (similar to Illustration 4-3 on page 5).
(b) Under ABC, prepare a schedule showing the computations of the activity-based overhe
(c) Prepare a schedule assigning each activity's overhead cost pool to each product based
(Include a computation of overhead cost per unit, rounding to the nearest cent.)
(d) Compute the total cost per unit for each product under ABC.
(e) Classify each of the activities as a value-added activity or a non-value-added activity.
(f) Comment on (1) the comparative overhead cost per unit for the two products under ABC
total costs per unit under traditional costing and ABC.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
NOTE: Enter a number in cells requesting a value; enter a formula in cells wit
Products
(a)
Manufacturing Costs
Home Model
Commercial Model
Direct materials
Value
Value
Direct labor Value
Value
Overhead
Value
Value
Total unit cost
?
?
Estimated
÷
Expected Use of
(b)
Activity Cost Pool
Overhead
Cost Drivers
Purchasing
Value
Value
Receiving
Value
Value
Assembling
Value
Value
Testing
Value
Value
Finishing
Value
Value
Packing and shipping
Value
Value
?
(c)
Home Model
Pounds
x
Activity-Based =
Activity Cost Pool
of Drivers
OH Rates
Purchasing
Value
Value
Receiving
Value
Value
Assembling
Value
Value
Testing
Value
Value
Finishing
Value
Value
Packing and shipping
Value
Value
Total cost assigned (a)
Units produced
OH cost per unit (a) +(b)
Home Commercial
(d)
ABC Manufacturing Costs
Model
Model
Direct materials
Value
Value
Direct labor
Value
Value
Overhead
Value
Value
Total cost per unit
?
?
(e )
Activity
Value- vs. Non-Value-Added
Purchasing
Receiving
Assembling
Testing
Finishing
Packing and shipping
(f)
Comment on (1) the comparative overhead cost per unit for the two products un
total costs per unit under traditional costing and ABC.
e a simple comparative
ead rates (per cost driver).
d on the use of cost drivers.
C, and (2) the comparative
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
th a "?" .
Expected Use of Drivers
= Activity-Based
OH Rate
Orders
?
Pounds
?
Number of parts
?
Number of tests
?
Units
?
Pounds
?
Commercial Model
Cost
Expected Use
x Activity-Based =
Cost
Assigned of Drivers
OH Rates
Assigned ?
Value
Value
?
?
Value
Value
?
?
Value
Value
?
?
Value
Value
?
?
Value
Value
?
?
Value
Value
?
?
?
Value
Value
?
?
nder ABC, and (2) the comparative
Related Documents
Related Questions
Compute the product margins for the B300 and T500 under the company’s traditional costing system.
2. Compute the product margins for B300 and T500 under the activity-based costing system.
3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.
arrow_forward
Info in images
Required:
1. Compute the product margins for the B300 and T500 under the company’s traditional costing system.
2. Compute the product margins for B300 and T500 under the activity-based costing system.
3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.
1. Compute the product margins for the B300 and T500 under the company’s traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.)
B300
T500
Total
Product margin
$0
2. Compute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.)
B300
T500
Total
Product margin
$0
3. Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2…
arrow_forward
Info in images
Required:
1. Compute the product margins for the B300 and T500 under the company’s traditional costing system.
2. Compute the product margins for B300 and T500 under the activity-based costing system.
3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.
1. Compute the product margins for the B300 and T500 under the company’s traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.)
B300
T500
Total
Product margin
$0
2. Compute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.)
B300
T500
Total
Product margin
$0
3. Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2…
arrow_forward
Hi-Tek Manufacturing, Incorporated, makes two types of industrial component parts-the B300 and the T500. An absorption costing
income statement for the most recent period is shown:
Hi-Tek Manufacturing Incorporated
Income Statement
Sales
Cost of goods sold
Gross margin
Selling and administrative expenses
$ 1,651,600
1,245,644
405,956
630,000
Net operating loss
$ (224,044)
Hi-Tek produced and sold 60,400 units of B300 at a price of $19 per unit and 12,600 units of T500 at a price of $40 per unit. The
company's traditional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor
dollars as the allocation base. Additional information relating to the company's two product lines is shown below:
Direct materials
Direct labor
Manufacturing overhead
Cost of goods sold
B300
$ 400,800
$ 120,300
T500
$ 162,400
$ 42,100
Total
$ 563,200
162,400
520,044
$ 1,245,644
The company has created an activity-based costing system to evaluate the profitability…
arrow_forward
hello, can u give correct answer
arrow_forward
How can I prepare a product cost report (with it's supporting calculations) for department 1. Round average cost per equivalent unit to two decimal places. Use rounded answers for subsequent calculations. Round other answers to the nearest whole number.
arrow_forward
please fill out this chart
arrow_forward
Need help with weighted aver. cont. margin and if you can list the formula as well.
arrow_forward
Please help me with correct answer thanku
arrow_forward
please fill out this chart
arrow_forward
Answer this cost accounting question
arrow_forward
Evaluating Selected Cost Driver Assume that a manufacturer of specialized machine parts developed the following total cost estimating equation for
manufacturing costs. Y = $14,400 + $1,250 (actual units) a. What is total estimated manufacturing costs if 180 units are produced? $Answer 0
arrow_forward
The management of Hartman Company is trying to determine the amount of each of two products to produce over the coming planning period. The following information concerns labor availability, labor utilization, and product profitability:
Labor-Hours Required(hours/unit)
Department
Product 1
Product 2
Hours Available
A
1.00
0.35
95
B
0.30
0.20
36
C
0.20
0.50
50
Profit contribution/unit
$30.00
$15.00
(a)
Develop a linear programming model of the Hartman Company problem. Solve the model to determine the optimal production quantities of products 1 and 2.
If required, round your answer to two decimal places.
Product 1
Product 2
Production
(b)
In computing the profit contribution per unit, management does not deduct labor costs because they are considered fixed for the upcoming planning period. However, suppose that overtime can be scheduled in some of the departments. Which departments would you recommend scheduling for…
arrow_forward
Max Machining incurs the following utilities costs at different levels of production:
0 units:
500 units:
1,000 units:
How would utility costs be properly classified?
Select one:
A. Stepped
B. Fixed
C. Mixed
D. Curvilinear
E. Variable
$120
$2,620
$5,120
arrow_forward
Please help with T500. Thank you :)
arrow_forward
Quick answer of this accounting questions
arrow_forward
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)
Exhibit 1: Assumptions (Both Products)
Product #1:
Launch-it
Sales price per unit
$ 10.00
Variable costs per unit:
$ 4.00
Monthly volume
240
Product #2:
Treat-time
Sales price per unit
$ 30.00
Variable costs per unit:
$ 14.00
Monthly volume
160
Total fixed costs per month
$ 1,500.00
Target profit per month
$ 8,000.00
Margin of Safety (in $)
Margin of Safety %
Degree of Operating Leverage
Expected % change in operating income (%)
arrow_forward
Need help with this general accounting question
arrow_forward
akeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
Up
eBook
Show Me How
Print Item
High-Low Method
Ziegler Inc. has decided to use the high-low method to estimate the total cost and the fixed and variable cost components of the total cost. The data for various levels of
production are as follows:
Units Produced
Total Costs
80,000
$25,100,000
92,000
27,206,000
120,000
32,120,000
a. Determine the variable cost per unit and the total fixed cost.
Variable cost (Round to two decimal places.)
%24
per unit
Total fixed cost
b. Based on part (a), estimate the total cost for 115,000 units of production.
Total cost for 115,000 units
Check My Work 4 more Check My Work uses remaining.
Previous
Next
arrow_forward
Please solve this one with calculation and explanation
arrow_forward
Benson Woodcraft Company manufactures "antique" wooden cabinets to house modern televisions. The Company began operations
in January of last year. Sidney Myrick, the owner, asks for your assistance. He believes that he needs to better understand the cost of
the cabinets for pricing purposes. You have collected the following data concerning actual production over the past year:
Number of
Cabinets
Total
Month
Produced
Cost
$21,400
32,900
29,600
18,700
28,900
27,200
25,500
31,900
32,400
31,700
32,100
9,800
January
840
February
3,610
1,970
March
April
Мay
640
1,590
June
1,320
July
August
September
1,140
1,760
2,340
2,970
3,340
October
November
December
310
Required
a. To understand the department's cost behavior, you decide to plot the points on graph paper and sketch a total cost line.
(1) Enter the number of units and their costs in increasing order.
b. Using the high-low method, compute the total cost equation for the preceding data.
(1) Compute the variable cost per unit.
(2) Compute…
arrow_forward
Required: Prepare a quantitative comparison of the traditional and activity-based cost assignments.
arrow_forward
Cost Accounting
Need Help with question 1.
Simplifying the ABC System: Equally Accurate Reduced ABC Systems
Selected activities and other information are provided for Patterson Company for its most recent year of operations.
Expected Consumption
Ratios
Activity
Driver
Quantity
Wafer A
Wafer B
7. Inserting dies
Number of dies
2,000,000
0.70
0.30
8. Purchasing materials
Number of purchase
orders
2,500
0.20
0.80
1. Developing test programs
Engineering hours
10,000
0.25
0.75
3. Testing products
Test hours
20,000
0.60
0.40
ABC assignments
$1,500,000
$1,500,000
Total overhead cost…
arrow_forward
25: 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
Setup
Materials handling
42,000 Number of inspections
Number of setups
38,000
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
arrow_forward
s
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning

Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub

Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,

Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Related Questions
- Compute the product margins for the B300 and T500 under the company’s traditional costing system. 2. Compute the product margins for B300 and T500 under the activity-based costing system. 3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.arrow_forwardInfo in images Required: 1. Compute the product margins for the B300 and T500 under the company’s traditional costing system. 2. Compute the product margins for B300 and T500 under the activity-based costing system. 3. Prepare a quantitative comparison of the traditional and activity-based cost assignments. 1. Compute the product margins for the B300 and T500 under the company’s traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.) B300 T500 Total Product margin $0 2. Compute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.) B300 T500 Total Product margin $0 3. Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2…arrow_forwardInfo in images Required: 1. Compute the product margins for the B300 and T500 under the company’s traditional costing system. 2. Compute the product margins for B300 and T500 under the activity-based costing system. 3. Prepare a quantitative comparison of the traditional and activity-based cost assignments. 1. Compute the product margins for the B300 and T500 under the company’s traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.) B300 T500 Total Product margin $0 2. Compute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.) B300 T500 Total Product margin $0 3. Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2…arrow_forward
- Hi-Tek Manufacturing, Incorporated, makes two types of industrial component parts-the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing Incorporated Income Statement Sales Cost of goods sold Gross margin Selling and administrative expenses $ 1,651,600 1,245,644 405,956 630,000 Net operating loss $ (224,044) Hi-Tek produced and sold 60,400 units of B300 at a price of $19 per unit and 12,600 units of T500 at a price of $40 per unit. The company's traditional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company's two product lines is shown below: Direct materials Direct labor Manufacturing overhead Cost of goods sold B300 $ 400,800 $ 120,300 T500 $ 162,400 $ 42,100 Total $ 563,200 162,400 520,044 $ 1,245,644 The company has created an activity-based costing system to evaluate the profitability…arrow_forwardhello, can u give correct answerarrow_forwardHow can I prepare a product cost report (with it's supporting calculations) for department 1. Round average cost per equivalent unit to two decimal places. Use rounded answers for subsequent calculations. Round other answers to the nearest whole number.arrow_forward
- please fill out this chartarrow_forwardAnswer this cost accounting questionarrow_forwardEvaluating Selected Cost Driver Assume that a manufacturer of specialized machine parts developed the following total cost estimating equation for manufacturing costs. Y = $14,400 + $1,250 (actual units) a. What is total estimated manufacturing costs if 180 units are produced? $Answer 0arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning

Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning

Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub

Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,

Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning