Required Information

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

To complete this act$/$vity$,$ you will need to have Excel Installed on your computer. This act$/$vity requires you to work in Excel and answer questions in Connect. You will read a brief scenarlo and then download an Excel file that you will need to answer the required quest$/$ons$.$

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 laborhours. For Job costing purposes, it uses an average direct labor wage rate of $\backslash (\backslash$$ $20\backslash )$ per hour. The company has been struggling financlally; 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($Static$)$ Part $6$

Required:

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

Navigate to the "Job Profitability" tab of thls 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 $\backslash (\backslash$mathbf$\{6$ b$\}\backslash )$ and $\backslash (\backslash$mathbf$\{6$ c$\}\backslash )$ below.

Required $6$B

Required $6$C

What is the total cost of Jobs $3$ and $\backslash (12?\backslash )$