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; accor
Required:
5. Go to the tab titled “Job Profitability.”:
a. Using formulas that refer to your answers from requirements 1-4, calculate the direct materials, direct labor, and applied overhead cost for each of the 12 jobs. (Hint: Use VLOOKUP to reference values from the pivot tables you created in requirements 1 and 2.)
b. What is the amount of applied overhead for Jobs 4 and 9?
Required:
6. Within the “Job Profitability”:
a. create formulas that compute the total job cost and gross margin for each of the 12 jobs.
b. What is the total cost of Jobs 3 and 12?
c. What is the gross margin Jobs 1 and 8?
Homework Answers
Request Answer!
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
Add Answer to:
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; accor
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...
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.50 per hour. During the year, the company started and completed only two jobs-Job Alpha, which used 68,200 direct labor-hours, and Job Omega. The job cost sheets for the these two jobs are show below: Job Alpha Direct materials Direct labor Manufacturing overhead applied Total job cost $1,674,000 Job Omega Direct materials Direct labor $...
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 Direct...
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 $13.50 per hour. During the year, the company started and completed only two jobs-Job Alpha, which used 68,700 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,722.000 Job Omega Direct materials Direct labor Manufacturing...
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 $13.50 per hour. During the year, the company started and completed only two jobs—Job Alpha, which used 68,700 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,722,000 Job Omega Direct materials Direct labor Manufacturing...
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 $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: points Job Alpha Direct materials Direct labor Manufacturing overhead applied Total job cost eBook $ 1,790,000 Hint Print References 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 $22.00 per hour. During the year, the company started and completed only two jobs—Job Alpha, which used 58,700 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 ? ? $ 2,590,000 ot ht ences...
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 $13.00 per hour. During the year, the company started and completed only two jobs—Job Alpha, which used 64,200 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,620,000 Job Omega Direct...
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 $19.50 per hour. During the year, the company started and completed only two jobs—Job Alpha, which used 55,900 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,230,000 Job Omega Direct...
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 $13.00 per hour. During the year, the company started and completed only two jobs—Job Alpha, which used 64,200 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,620,000 Job Omega Direct...
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.50 per hour. During the year, the company started and completed only two jobs-Job Alpha, which used 68,200 direct labor-hours, and Job Omega. The job cost sheets for the these two jobs are show below: Job Alpha Direct materials Direct labor Manufacturing overhead applied Total job cost $1,674,000 Job Omega Direct materials Direct labor $...
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 Direct...
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 $13.50 per hour. During the year, the company started and completed only two jobs-Job Alpha, which used 68,700 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,722.000 Job Omega Direct materials Direct labor Manufacturing...
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 $13.50 per hour. During the year, the company started and completed only two jobs—Job Alpha, which used 68,700 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,722,000 Job Omega Direct materials Direct labor Manufacturing...
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: points Job Alpha Direct materials Direct labor Manufacturing overhead applied Total job cost eBook $ 1,790,000 Hint Print References 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 $22.00 per hour. During the year, the company started and completed only two jobs—Job Alpha, which used 58,700 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 ? ? $ 2,590,000 ot ht ences...
Most questions answered within 3 hours.
-
3) What are the typical social structures in a global city?
asked 2 hours ago -
Luther Corporation
Consolidated Balance Sheet
December 31, 2019 and 2018 (in $ millions)
Assets
2019
2018...
asked 2 hours ago -
(Expected rate of return and risk) Carter Inc. is evaluating a
security. Calculate the investment’s expected...
asked 5 hours ago -
What specific indicators can point to lack of progress for
African Americans in American society?
asked 6 hours ago -
1-The Electrons in a beam are moving at 2.7×108 m/s in an
electric field of 15000...
asked 6 hours ago -
A gas tank is a vertical cylinder. It has a radius of 1m, a
height of...
asked 7 hours ago -
Accent Software faces the following conditions. All of these
support Accent’s use of a market-penetration pricing...
asked 8 hours ago -
A mathematically inclined friend emails you the following
instructions: "Meet me in the cafeteria the first...
asked 8 hours ago -
A monopoly sells in two countries . The demand curves in the two
countries are p1...
asked 9 hours ago -
A .15kg rubber ball is bounced off a wall. Before hitting the
wall, the ball moves...
asked 9 hours ago -
A manufacturing company preparing to build a new plant is
considering three potential locations for it....
asked 9 hours ago -
B. If compound Y has approximately the same values of solubility
in toluene as compound X,...
asked 10 hours ago