Requlred Information

Excel Analytics $02-02($Static$)$ Job$-$Order Costing; Plantwide Predetermined Overhead Rates $[$LO$2-1,$ LO$2-$

$2,$ LO$2-3]$

To complete this activity, you will need to have Excel installed on your computer. This activity requires you to work in Excel

and answer questions in Connect. You will read a brief scenario and then download an Excel file that you will need to

answer the required questions.

Some of the requirements will require you to view brief video tutorials. You will then use what you learned to work directly

in Excel to answer required questions.

$[$The following information applies to the questions displayed below.$]$

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:

Excel Analytics $02-02($Statlc$)$ Part $6$

Required:

Refer to the workbook titled "ExcelAnalytics$\_$JobOrderCosting$\_$PlantwidePredeterminedOverheadRates$\_$Template"

Navigate to the "Job Profitability" tab of this workbook.

a$.$ Within the "Job Profitability" tab, 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?$

Save your work in Excel, then enter your answer to requirements $6$b and $6$c below.

What is the gross margin Jobs $1$ and $8?$