How Data is Provided on Excel: Job ID Customer ID 160 Region 1250 East Product Units Produced and Sold Cost per Foot of Leather JACKET 10 Feet of Leather per Unit Produced Direct Labor Cost per Hour Direct Labor Hours Per Unit Produced Sales Price per Unit 18.03 11.9 27.92 0.99 352.05 Description of Data: Job ID Customer ID Region Product Column Name Units Produced and Sold Cost per Foot of Leather Feet of Leather per Unit Produced Direct Labor Cost per Hour Direct Labor Hours Per Unit Produced Description A unique identification number for each job. This ID number cannot be repeated. A unique identification number for each customer. A customer can be associated with multiple jobs. Identifies the region of the corresponding job. Possible values are North, South, East, and West. The product produced and sold for the job. Possible values are shoes or jackets. The number of shoes or jackets produced and sold for the job. Note: An order for 2 shoes is for 2 pairs of shoes. The direct material cost per foot of leather. (e.g., the price of 1 foot of leather.) The number of feet of leather used per unit of output. (e.g. 12 feet of leather to produce 1 jacket). The hourly wage rate for manufacturing employees. (e.g., Employee is paid $31/hour). The number of direct labor hours used to produce 1 unit of output. (e.g., The employee uses 1.05 hours to produce 1 jacket.) The sales price per unit. (e.g., Each jacket is sold for $383.) Sales Price per Unit Question: The budgeted manufacturing overhead rate is 25% of direct material dollars. (Hint: A job that incurs $100 of direct materials will be allocated $25 of manufacturing overhead.) What is the total manufacturing OH applied (in dollars)? Check: The total manufacturing Over Head applied in the North region was $596,209
How Data is Provided on Excel: Job ID Customer ID 160 Region 1250 East Product Units Produced and Sold Cost per Foot of Leather JACKET 10 Feet of Leather per Unit Produced Direct Labor Cost per Hour Direct Labor Hours Per Unit Produced Sales Price per Unit 18.03 11.9 27.92 0.99 352.05 Description of Data: Job ID Customer ID Region Product Column Name Units Produced and Sold Cost per Foot of Leather Feet of Leather per Unit Produced Direct Labor Cost per Hour Direct Labor Hours Per Unit Produced Description A unique identification number for each job. This ID number cannot be repeated. A unique identification number for each customer. A customer can be associated with multiple jobs. Identifies the region of the corresponding job. Possible values are North, South, East, and West. The product produced and sold for the job. Possible values are shoes or jackets. The number of shoes or jackets produced and sold for the job. Note: An order for 2 shoes is for 2 pairs of shoes. The direct material cost per foot of leather. (e.g., the price of 1 foot of leather.) The number of feet of leather used per unit of output. (e.g. 12 feet of leather to produce 1 jacket). The hourly wage rate for manufacturing employees. (e.g., Employee is paid $31/hour). The number of direct labor hours used to produce 1 unit of output. (e.g., The employee uses 1.05 hours to produce 1 jacket.) The sales price per unit. (e.g., Each jacket is sold for $383.) Sales Price per Unit Question: The budgeted manufacturing overhead rate is 25% of direct material dollars. (Hint: A job that incurs $100 of direct materials will be allocated $25 of manufacturing overhead.) What is the total manufacturing OH applied (in dollars)? Check: The total manufacturing Over Head applied in the North region was $596,209
Principles of Cost Accounting
17th Edition
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Edward J. Vanderbeck, Maria R. Mitchell
Chapter4: Accounting For Factory Overhead
Section: Chapter Questions
Problem 4P: Using the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2....
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning