complete using excel if possible

3. Manufacturing overhead budget The following is the direct labor budget for Cooper Co. Quarter 1 1.060 2 1,260 3 1,600 4 1,800 Year 5,720 Units to be produced Coopers' management estimates that it will take 2 direct labor hours to manufacture one unit of finished goods. Variable overhead is based on direct labor hours at a rate of $5 per direct labor hour. Fixed overhead is $1,850 per quarter. Required: Prepare a manufacturing overhead budget for the four quarters and the year