MOH
Ozuna Company uses a job-order costing system with a plantwide predetermined overhead rate based on direct labor-hours. For job costing purposes, it uses an average direct labor wage rate of $20 per hour. The company has been struggling financially; accordingly, it has asked you to conduct a job profitability study beginning with a thorough critique of its existing cost system. To keep the scope of your project manageable, you have chosen a subset of 12 jobs from the many jobs completed by the company during the year. Your goal is to complete the table shown below and comment on the insights that it provides:
| Job | Sales | Direct Materials | Direct Labor | Applied Overhead | Total Job Cost | Gross Margin | |
| 1 | $ | 2,400 | ? | ? | ? | ? | ? |
| 2 | $ | 5,400 | ? | ? | ? | ? | ? |
| 3 | $ | 9,000 | ? | ? | ? | ? | ? |
| 4 | $ | 1,450 | ? | ? | ? | ? | ? |
| 5 | $ | 2,200 | ? | ? | ? | ? | ? |
| 6 | $ | 7,000 | ? | ? | ? | ? | ? |
| 7 | $ | 1,700 | ? | ? | ? | ? | ? |
| 8 | $ | 1,600 | ? | ? | ? | ? | ? |
| 9 | $ | 8,000 | ? | ? | ? | ? | ? |
| 10 | $ | 4,100 | ? | ? | ? | ? | ? |
| 11 | $ | 3,200 | ? | ? | ? | ? | ? |
| 12 | $ | 2,800 | ? | ? | ? | ? | ? |
Click here to download the Excel template, which you will use to answer the questions that follow.
Click here for a brief tutorial on PivotTables in Excel.
Click here for a brief tutorial on VLOOKUP in Excel.
Excel Analytics 02-02 (Static) Part 4
Required:
4. Within the “Estimated MOH” tab,
a. Create a formula in cell E40 that calculates a plantwide predetermined overhead rate this year.
b. What is the plantwide predetermined overhead rate for this year?
Homework Answers
The question could be answered
based on students knowledge to
interpret water fall chart.
Please refer to the attached image for the answer.
Total Cost
Ozuna Company uses a job-order costing system with a plantwide predetermined overhead rate based on direct labor-hours. For job costing purposes, it uses an average direct labor wage rate of $20 per hour. The company has been struggling financially; accordingly, it has asked you to conduct a job profitability study beginning with a thorough critique of its existing cost system. To keep the scope of your project manageable, you have chosen a subset of 12 jobs from the many jobs...
pivot
Ozuna Company uses a job-order costing system with a plantwide predetermined overhead rate based on direct labor-hours. For job costing purposes, it uses an average direct labor wage rate of $20 per hour. The company has been struggling financially; accordingly, it has asked you to conduct a job profitability study beginning with a thorough critique of its existing cost system. To keep the scope of your project manageable, you have chosen a subset of 12 jobs from the many jobs...
Applied Overhead
Ozuna Company uses a job-order costing system with a plantwide predetermined overhead rate based on direct labor-hours. For job costing purposes, it uses an average direct labor wage rate of $20 per hour. The company has been struggling financially; accordingly, it has asked you to conduct a job profitability study beginning with a thorough critique of its existing cost system. To keep the scope of your project manageable, you have chosen a subset of 12 jobs from the many jobs...
Direct Labor
Ozuna Company uses a job-order costing system with a plantwide predetermined overhead rate based on direct labor-hours. For job costing purposes, it uses an average direct labor wage rate of $20 per hour. The company has been struggling financially; accordingly, it has asked you to conduct a job profitability study beginning with a thorough critique of its existing cost system. To keep the scope of your project manageable, you have chosen a subset of 12 jobs from the many jobs...
Costs
Ozuna Company uses a job-order costing system with a plantwide predetermined overhead rate based on direct labor-hours. For job costing purposes, it uses an average direct labor wage rate of $20 per hour. The company has been struggling financially; accordingly, it has asked you to conduct a job profitability study beginning with a thorough critique of its existing cost system. To keep the scope of your project manageable, you have chosen a subset of 12 jobs from the many jobs...
Gross Margin
Ozuna Company uses a job-order costing system with a plantwide predetermined overhead rate based on direct labor-hours. For job costing purposes, it uses an average direct labor wage rate of $20 per hour. The company has been struggling financially; accordingly, it has asked you to conduct a job profitability study beginning with a thorough critique of its existing cost system. To keep the scope of your project manageable, you have chosen a subset of 12 jobs from the many jobs...
Labor Percents
Ozuna Company uses a job-order costing system with a plantwide predetermined overhead rate based on direct labor-hours. For job costing purposes, it uses an average direct labor wage rate of $20 per hour. The company has been struggling financially; accordingly, it has asked you to conduct a job profitability study beginning with a thorough critique of its existing cost system. To keep the scope of your project manageable, you have chosen a subset of 12 jobs from the many jobs...
Hahn Company uses a job-order costing system. Its plantwide predetermined overhead rate uses direct labor-hours as...
Hahn Company uses a job-order costing system. Its plantwide predetermined overhead rate uses direct labor-hours as the allocation base. The company pays its direct laborers $21.00 per hour. During the year, the company started and completed only two jobs—Job Alpha, which used 69,500 direct labor-hours, and Job Omega. The job cost sheets for the these two jobs are shown below: Job Alpha Direct materials ? Direct labor ? Manufacturing overhead applied ? Total job cost $ 2,926,000 Job Omega Direct...
Exercise 2-7 Job-Order Costing; Working Backwards [LO2-1, LO2-2, LO2-3] Hahn Company uses a job-order costing system....
Exercise 2-7 Job-Order Costing; Working Backwards [LO2-1, LO2-2, LO2-3] Hahn Company uses a job-order costing system. Its plantwide predetermined overhead rate uses direct labor-hours as the allocation base. The company pays its direct laborers $15.50 per hour. During the year, the company started and completed only two jobs-Job Alpha, which used 64,400 direct labor-hours, and Job Omega. The job cost sheets for the these two jobs are shown below: Job Alpha Direct materials Direct labor Manufacturing overhead applied Total job...
Hahn Company uses a job-order costing system. Its plantwide predetermined overhead rate uses direct labor-hours as...
Hahn Company uses a job-order costing system. Its plantwide predetermined overhead rate uses direct labor-hours as the allocation base. The company pays its direct laborers $12.00 per hour. During the year, the company started and completed only two jobs—Job Alpha, which used 65,100 direct labor-hours, and Job Omega. The job cost sheets for the these two jobs are shown below: ? Job Alpha Direct materials Direct labor Manufacturing overhead applied Total job cost ? $ 1,632,000 Job Omega Direct materials...
Exercise 2-7 Job-Order Costing; Working Backwards [LO2-1, LO2-2, LO2-3] Hahn Company uses a job-order costing system. Its plantwide predetermined overhead rate uses direct labor-hours as the allocation base. The company pays its direct laborers $15.50 per hour. During the year, the company started and completed only two jobs-Job Alpha, which used 64,400 direct labor-hours, and Job Omega. The job cost sheets for the these two jobs are shown below: Job Alpha Direct materials Direct labor Manufacturing overhead applied Total job...
Hahn Company uses a job-order costing system. Its plantwide predetermined overhead rate uses direct labor-hours as the allocation base. The company pays its direct laborers $12.00 per hour. During the year, the company started and completed only two jobs—Job Alpha, which used 65,100 direct labor-hours, and Job Omega. The job cost sheets for the these two jobs are shown below: ? Job Alpha Direct materials Direct labor Manufacturing overhead applied Total job cost ? $ 1,632,000 Job Omega Direct materials...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago