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.
Required:
3. Go to the tab titled “Estimated MOH.”:
a. For each of the seven variable manufacturing overhead expenses (highlighted in yellow), create a formula that calculates the estimated amount of the expense for this year. (Hint: Use last year’s actual amount of each expense and the actual total labor hours [cell B39] as the basis for this year’s estimates.)
3b. and 3c. What is the estimated indirect materials cost in the Molding Department (cell E17) and the estimated utilities cost in the Fabrication Department (cell E21)?
The question could be answered
based on students knowledge to
interpret water fall chart.
Please refer to the attached image for the answer.
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...
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...
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...
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...
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...
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...
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...
E3-21A (similar to) Question Help Lakeview Industries uses job costing to calculate the costs of its jobs with direct labor cost as its manufacturing overhead allocation base 1 (Click the loon to view additional information.) Read the requirements. More Info The company manufactures a variety of engines for use in farm equipment. At the beginning of the current year, Lakeview estimated that its overhead for the coming year would be $324,800. It also anticipated using 29,000 direct labor hours for...
Determining Manufacturing Costs Wagner Printing Inc. began printing operations on July 1. Jobs 7-01 and 7-02 were completed during the month, and all costs applicable to them were recorded on the related cost sheets. Jobs 7-03 and 7-04 are still in process at the end of the month, and all applicable costs except factory overhead have been recorded on the related cost sheets. In addition to the materials and labor charged directly to the jobs, $1,200 of indirect materials and...
An advertising agency is estimating costs for advertising a music festival. The job will require 200 direct labor hours at a cost of $50 per hour. Overhead costs are applied at a rate of $65 per direct labor hour. What is the total estimated cost for this job? JOB COST SHEET Hours Rate Estimated Cost Materials 0.00 Total estimated cost Prepare summary journal entries to record the following transactions for a company in its first month of operations. a. Raw...