please help me solve $,$Preston Industries manufactures three models of a product in a single plant with two departments: Cutting and Assembly. The company has estimated costs for each of the three product models, the Zoom, the Imperial, and the Rocket models.

$($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.

Preston 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

Data table

Data table

The company is currently analyzing direct labor hour requirements for the upcoming year.

$\backslash$table$[[,$Cutting,Assembly$],[$Estimated hours per unit:$],[$Zoom$,1\mathrm{.}7,2\mathrm{.}2],[$Imperial$,1\mathrm{.}8,2\mathrm{.}4],[$Rocket$,1\mathrm{.}0,2\mathrm{.}1],[$Direct labor hour rate..... $$,7,$$