Joint cost allocation — weighted average method Gary’s Grooves Co. produces two types of carving knives, one with a handle made of a polymer that looks like walnut wood and another with a handle made with a polymer that looks like red oak. The knives are made through a joint production molding process that produces 380 knife blades for red oak handle knives and 240 knife blades for walnut handle knives at the split-off point. The polymer for the red oak handle knife blades requires twice as much cooling time as the polymer for the walnut handle knife blades, although all knives are removed from the joint molding process at the same time (i.e., once the cooling for the red oak handle knives is complete). The joint production process costs a total of $ 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 question below.     Open spreadsheet   Assuming the company allocates joint costs using the weighted average method based on the required cooling time of the two joint products, determine the amount of joint production costs allocated to each type of knife using the weighted average method. Round your answers to the nearest dollar. Joint Product Allocation Red oak handle carving knife $ fill in the blank 2 Walnut handle carving knife fill in the blank 3 Totals $ fill in the blank 4

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter16: Manufacturing Accounting (mfg)
Section: Chapter Questions
Problem 2R
icon
Related questions
icon
Concept explainers
Topic Video
Question

Joint cost allocation — weighted average method

Gary’s Grooves Co. produces two types of carving knives, one with a handle made of a polymer that looks like walnut wood and another with a handle made with a polymer that looks like red oak. The knives are made through a joint production molding process that produces 380 knife blades for red oak handle knives and 240 knife blades for walnut handle knives at the split-off point. The polymer for the red oak handle knife blades requires twice as much cooling time as the polymer for the walnut handle knife blades, although all knives are removed from the joint molding process at the same time (i.e., once the cooling for the red oak handle knives is complete). The joint production process costs a total of $ 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 question below.

 

 
Open spreadsheet

 

Assuming the company allocates joint costs using the weighted average method based on the required cooling time of the two joint products, determine the amount of joint production costs allocated to each type of knife using the weighted average method. Round your answers to the nearest dollar.

Joint Product Allocation
Red oak handle carving knife $ fill in the blank 2
Walnut handle carving knife fill in the blank 3
Totals $ fill in the blank 4
Excel
template - Saved v
O Search (Alt + Q)
File
Home
Insert
Draw
Page Layout
Formulas
Data
Review
View
Help
A Editing v
Arial
A v
Merge v
$4
Σ
B13
fx
A
В
C
E
F
1
Joint cost allocation - weighted average method
2
Gary's Grooves Co. produces two types of carving knives, one with a handle made of a polymer that looks like walnut wood and another with a handle made with a polymer that
looks like red oak. The knives are made through a joint production molding process that produces knife blades for red oak handle knives and knife blades for walnut handle knives
at the split-off point. The polymer for the red oak handle knife blades requires twice as much cooling time as the polymer for the walnut handle knife blades, although all knives are
removed from the joint molding process at the same time (i.e., once the cooling for the red oak handle knives is complete). The company allocates joint costs using the weighted
average method based on the required cooling time of the two joint products. The following data is provided:
3
4
5
DATA
6
Joint product
Knife Blades at Split-Off
Weight Factor
Joint Costs
Red oak handle carving knife
Walnut handle carving knife
7
380
2
$6,000
8
240
1
6,000
9.
Using formulas and cell references, perform the required analysis, and input your answers into the B, C, and D columns. Use the blue entry cells (B13:C14, B15) for intermediate
10 calculations. Transfer the numeric results for the green entry cells (D13:D15) into the appropriate fields in CNOWV2 for grading.
11
Weighted Blades of
Molding Time
Weighted Percent
of Molding Time
12 Joint product
13 Red oak handle carving knife
14 Walnut handle carving knife
Allocation
Formulas
15
Totals
16
17
18
Transcribed Image Text:Excel template - Saved v O Search (Alt + Q) File Home Insert Draw Page Layout Formulas Data Review View Help A Editing v Arial A v Merge v $4 Σ B13 fx A В C E F 1 Joint cost allocation - weighted average method 2 Gary's Grooves Co. produces two types of carving knives, one with a handle made of a polymer that looks like walnut wood and another with a handle made with a polymer that looks like red oak. The knives are made through a joint production molding process that produces knife blades for red oak handle knives and knife blades for walnut handle knives at the split-off point. The polymer for the red oak handle knife blades requires twice as much cooling time as the polymer for the walnut handle knife blades, although all knives are removed from the joint molding process at the same time (i.e., once the cooling for the red oak handle knives is complete). The company allocates joint costs using the weighted average method based on the required cooling time of the two joint products. The following data is provided: 3 4 5 DATA 6 Joint product Knife Blades at Split-Off Weight Factor Joint Costs Red oak handle carving knife Walnut handle carving knife 7 380 2 $6,000 8 240 1 6,000 9. Using formulas and cell references, perform the required analysis, and input your answers into the B, C, and D columns. Use the blue entry cells (B13:C14, B15) for intermediate 10 calculations. Transfer the numeric results for the green entry cells (D13:D15) into the appropriate fields in CNOWV2 for grading. 11 Weighted Blades of Molding Time Weighted Percent of Molding Time 12 Joint product 13 Red oak handle carving knife 14 Walnut handle carving knife Allocation Formulas 15 Totals 16 17 18
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning