Kyler 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 Rocket, the Regal, and the Zip models EEE (Click the icon to view the direct labor hour information.) 3(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. Kyler Industries Direct Labor Budget For the Upcoming Year Rocket Regal Zip Total Cutting Department Units to be produced i Data Table The company is currently analyzing direct labor hour requirements for the upcoming year. Cutting Assembly Estimated hours per unit Rocket 2.9 2.6 2.2 15 Zip Direct labor hour rate 1.3 13 i Data Table Budgeted unit production for each of the products is as follows: Number of units to be produced Product model: Rocket . . Regal Zip 520 700 850 Prepare the direct labor budget for the Cutting Department, then the Assembly Department, and finally the company as a whole. Kyler Industries Direct Labor Budget For the Upcoming Year Zip Total Rocket Rega 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