Answer-2)-
| ABC COMPANY | |||||
| Direct Labor Budget | |||||
| Particulars | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | YEAR |
| Budgeted Production units (a) | 6500 | 7000 | 5800 | 9300 | 28600 |
| Direct labor hours per unit (b) | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 |
| Total direct labor hours (c=a*b) | 650 | 700 | 580 | 930 | 2860 |
| Wage per direct labor hour (d) | $25 | $25 | $25 | $25 | $25 |
| Total direct labor in $ (e=c*d) | 16250 | 17500 | 14500 | 23250 | 71500 |
3)-
| XYZ CO. | |||||
| Manufacturing Overhead Budget | |||||
| For the year | |||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Year | |
| Units to be produced (a) | 1600 | 1270 | 2900 | 1950 | 7720 |
| Time hour per unit (b) | .25 hours | .25 hours | .25 hours | .25 hours | .25 hours |
| Direct labor hours (c=a*b) | 400 | 317.5 | 725 | 487.5 | 1930 |
| Variable costs:- | |||||
| Variable overhead @ $7 per hour | 2800 | 2222.5 | 5075 | 3412.5 | 13510 |
| Total variable costs (d) $ | 2800 | 2222.5 | 5075 | 3412.5 | 13510 |
| Fixed costs:- | |||||
| Fixed overhead | 3650 | 3650 | 3650 | 3650 | 14600 |
| Total fixed costs (e) $ | 3650 | 3650 | 3650 | 3650 | 14600 |
| Total overhead (f=d+e) $ | 6450 | 5872.5 | 8725 | 7062.5 | 28110 |
2 Direct labor budet ABC Company plans to all within a limited size range identical. The...
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...
Answer in excel!
3. Manufacturing overhead budget The following is the direct labor budget for XYZ Co. Quarter Units to be produced 1.600 1.270 2.900 1,950 XYZ Co management estimated that the time required to manufacture one unit of finished goods is 25 direct labor hours. Variable overhead is based on direct labor hours at a rate of $7 per direct labor hour. Fixed overhead is $3.650 per quarter. Required: Prepare a manufacturing overhead budget for the four quarters and...
Completed using excel if possible
2. Direct labor budget: Draper Manufacturing Inc. plans to produce a number of units of product Z during the budget period. The units 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 unit is 0.65 hours per unit for the machine operator. The labor rate for machine operators is $31 per direct labor hour. Production for each quarter is...
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...
Addison Co. budgets production of 2,850 units during the second quartel. UUTUU Direct labor Variable overhead Fixed overhead Each finished unit requires 6 direct labor hours, at a cost of $9 per hour. Applied at the rate of $11 per direct labor hour. Budgeted at $640,000 per quarter. 0.5 points 1. Prepare a direct labor budget. 2. Prepare a factory overhead budget Complete this question by entering your answers in the tabs below. Print References Required 1 Required 2 Prepare...
Exercise 07-7 Manufacturing: Direct labor and factory overhead budgets LO P1 Addison Co. budgets production of 2,850 units during the second quarter. Other information is as follows: Direct labor Variable overhead Fixed overhead Each finished unit requires 6 direct labor hours, at a cost of $9 per hour. Applied at the rate of $11 per direct labor hour. Budgeted at $640,000 per quarter. 1. Prepare a direct labor budget. 2. Prepare a factory overhead budget. Complete this question by entering...
Exercise 07-7 Manufacturing: Direct labor and factory overhead budgets LO P1 Addison Co budgets production of 2.770 units during the second quarter. Other information is as follows: cost of $9 per hour. Direct labor Variable overhead Fixed overhead Each finished unit requires 4 direct labor hours at Applied at the rate of $11 per direct labor hour. Budgeted at $560,000 per quarter. 1. Prepare a direct labor budget. 2. Prepare a factory overhead budget Complete this question by entering your...
Lasser Company plans to produce 16,000 units next period at a denominator activity of 32,000 direct labor-hours. The direct labor wage rate is $12.00 per hour. The company's standards allow 2 yards of direct materials for each unit of product; the material costs $7.80 per yard. The company's budget includes variable manufacturing overhead cost of $2.30 per direct labor-hour and fixed manufacturing overhead of $156,800 per period. Required: 1. Using 32,000 direct labor-hours as the denominator activity, compute the predetermined...
Addison Co. budgets production of 2,400 units during the second quarter. Other information is as follows: Direct labor Variable overhead Fixed overhead Each finished unit requires 4 direct labor hours, at a cost of $20 per hour. Applied at the rate of $11 per direct labor hour. Budgeted at $450,000 per quarter. 1. Prepare a direct labor budget. 2. Prepare a factory overhead budget. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare...
The company plans for finished goods inventory of 220 units at
the end of June. In addition, each finished unit requires 5 pounds
of direct materials and the company wants to end each month with
direct materials inventory equal to 20% of next month’s production
needs. Beginning direct materials inventory for April was 540
pounds. Direct materials cost $2 per pound. Each finished unit
requires 0.60 hours of direct labor at the rate of $12 per hour.
The company budgets...