$($Click the icon to view the direct labor hour information.$)$

$($Click the icon to view the unit production information.$)$

Requirement

Prepare a direct labor budget for the upcoming year that shows the budgeted direct labor costs for each department and for the company as a whole.

Prepare the direct labor budget for the Cutting Department, then the Assembly Department, and finally the company as a whole.

Gable Industries

Direct Labor Budget

For the Upcoming Year

Cutting Department

Units to be produced

Multiply by: Direct labor hours per unit

Total cutting hours required

Multiply by: Direct labor cost per hour

Budgeted direct labor cost

Assembly Department

Units to be produced

Multiply by: Direct labor hours per unit

Total assembly hours required

Multiply by Direct labor cost per hour

Budgeted direct labor cost

Total budgeted direct labor cost

Data table

$\backslash$table$[[$Budgeted unit production for each of the products is as follows:$],[\{$fa$5356138-19$c$0-49$a$4-8$d$00-$dd$243949$d$08$b$\}$

$\backslash$table$[[$Number of units to$],[$be produced$]]],[$Product model$],[\backslash$table$[[$Flash$,$dots...,$540],[$Imperial$,$dots.,$770],[$Royal$,$dots...,$860]]]]$