Answer in excel

2. Direct labor budget: ABC Company plans to produce a number of plastic pails during the budget period. The pails are all within a limited size range, so the amount of processing labor related to each one is nearly identical. The labor routing for each pail is 0.1 hours per pail for the machine operator. The labor rate for machine operators is $25 per direct labor hour. Production for each quarter is as follows: Quarter 1 6,500 Quarter 2 7,000 Quarter 3 5,800 Quarter 4 9,300 Product A (units) Required: Prepare a direct labor budget for the four quarters and the year. Units to be produced Direct labor hours per unit Total hours Direct labor rate Direct labor cost