"Accessibility tab summary: General data is provided in rows $2$ to $6.$ Data table are presented in cells A$8$ to D$15$; A$17$ to C$22$; and A$24$ to C$29.$ A statement of requirement $1$ is presented in rows $31$ to $34.$ A table for student presentation is presented in cells A$36$ to E$42.$ A statement of requirement $2$ is presented in row $44.$ A table for student presentation is presented in cells A$46$ to E$50.$ A statement of requirement $3$ is presented in row $52.$ A table for student presentation is presented in cells A$54$ to G$58.$ A statement of requirement $4$ is presented in row $60.$ A table for student presentation is presented in cells A$62$ to G$67.$ A statement of requirement $5$ is presented in row $69.$ A table for student presentation is presented in cells A$71$ to C$74.$"Stelepad Industries manufactures custom steel frames for diesel engines. Below is some information regarding cost estimates and recorded costs for the last few jobs:The Milling Department is mostly automated and uses machine hours as its cost driver. The Assembly Department is more labor intensive and uses direct labor hours as its cost driver.Markup on job cost$70\mathrm{.}6\%$Estimated Factory CostsDepartmentMillingAssemblyMachine$-$hours$60,5243,325$ Direct labor$-$hours$8,75578,947$ Total fixed manufacturing overhead cost $ $320,274$ $ $521,941$ Variable manufacturing overhead per machine$-$hour $ $2\mathrm{.}02$ Variable manufacturing overhead per direct labor$-$hour $ $3\mathrm{.}58$ Cost summary for Cruiser Job $114$DepartmentMillingAssemblyMachine$-$hours$944\mathrm{.}6$ Direct labor$-$hours$5\mathrm{.}520\mathrm{.}3$ Direct materials $ $804$ $ $377$ Direct labor cost $ $89$ $ $303$ Cost summary for Tanker Job $851$DepartmentMillingAssemblyMachine$-$hours$459\mathrm{.}9$ Direct labor$-$hours$1\mathrm{.}86\mathrm{.}6$ Direct materials $ $822$ $ $403$ Direct labor cost $ $52$ $ $166$ Required:Follow the sequence below to determine the total cost of Cruiser Job $114$ and Tanker Job $851.$ Do not round any values.Step $1$: Calculate the estimated total manufacturing overhead cost for each departmentDepartmentMillingAssemblyVariable manufacturing overhead per machine$-$hour or direct labor$-$hour $$2\mathrm{.}02$ $$3\mathrm{.}58$ Total machine$-$hours or direct labor$-$hoursTotal variable manufacturing overheadTotal fixed manufacturing overhead costTotal manufacturing overheadStep $2$: Calculate the predetermined overhead rate in each departmentDepartmentMillingAssemblyTotal manufacturing overheadTotal machine$-$hours or direct labor$-$hoursPredetermined overhead rate per machine$-$hour or direct labor$-$hourStep $3$: Calculate the amount of overhead applied from both departmentsCruiser Job $114$Tanker Job $851$MillingAssemblyMillingAssemblyPredetermined overhead rate per machine$-$hour or direct labor$-$hourMachine$-$hours or direct labor$-$hours for the jobManufacturing overhead appliedStep $4$: Calculate the total job costCruiser Job $114$Tanker Job $851$MillingAssemblyTotalMillingAssemblyTotalDirect materialsDirect labor costManufacturing overhead appliedTotal costStep $5$: Calculate the selling priceCruiser Job $114$Tanker Job $851$Total costMarkupSelling price