Refer to DCdesserts.com's activity-based flexible budget in Exhibit 11-11 Suppose that the company's activity in June is described as follows: Process hours Production runs New products tested Direct material handled (pounds) 9,000 8 4e , Required: 1. Determine the flexible budgeted cost for each item in the table below. 2-a. Compute the variance for setup cost during the month, assuming that the actual setup cost was $3,000. Use the activity-based flexible budget. 2-b. Compute the variance for setup cost during the month, assuming that the actual setup cost was $3,000. Use DCdesserts.com's conventional flexible budget (Exhibit 11-3), Complete this question by entering your answers in the tabs below. Req 1 Reg 2A Req 2B Req 1 Reg 2A Req 2B Determine the flexible budgeted cost for each item in the table below. a. Indirect material b. Utilities c. Inspection d. Test kitchen e. Material handling f. Total overhead cost Rey Req 2A > Reg 1 Reg 2A Reg 28 Compute the variance for setup cost during the month, assuming that the actual setup cost was $3,000. Use the activity- based flexible budget. (Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "0" for no effect (T.e., zero variance).) Variance Reg 1 Reg 2 Reg 28 Compute the variance for setup cost during the month, assuming that the actual setup cost was $3,000. Use DCdesserts.com's conventional flexible budget. (Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "O" for no effect (ie, zero variance).) Variance ( Req 2A Ron 20 DCDESSERTS.COM Monthly Flexible Overhead Budget Level of Activity Budgeted Cost 6,000 7.500 9,000 Cost Pool I (cost driver: process hours) Indirect material: +$12.000 $15.000 Nonstick cooking spray $18.000 Waxed paper 2.000 2.500 3.000 2.000 2.500 3,000 Other paper products Miscellaneous supplies 6,000 7.500 9.000 Indirect labor. maintenance 4.000 5.000 6.000 Utilities: Electricity 3.000 3.750 4.500 Natural gas 1.000 1.250 1.500 Total of cost pooli $30.000 $37.500 $45.000 Cost Pool II (cost driver: production runs) 8 12 16 Indirect labor Inspection $ 2.200 $ 3,300 $ 4,400 Setup 3.000 4.500 6.000 Total of cost pool II $ 5.200 $ 7.800 $10.400 Cost Pool III (cost driver: new products tested) 20 30 40 Test kitchen S 1.200 $ 1.800 S 2.400 Total of cost pool III S 1.200 S 1.800 S 2.400 Cost Pool IV (cost driver: pounds of material handled) 20,000 30,000 40.000 Material handling S 2.000 $ 3.000 $ 4.000 Total of cost pool IV $ 2.000 $ 3.000 $ 4,000 Cost Pool V (facility level costs) Indirect labor production supervisors $ 6,000 $ 6,000 $ 6,000 Depreciation: plant and equipment 500 Insurance and property taxes 500 100 100 100 $ 6,600 Total overhead cost S 6,600 S 6.600 $45,000 $56.700 S68,400 500 Total of cost pool V OB Diesel DATA REVIEW VIEW FORMULAS FLE PAGE LAYOUT HOME INSERT F29 E 1 X 1328 B C D DCDESSERTS.COM Monthly Flexible Overhead Budget 1 GN- Cost Process Hours 7,500 6,000 per Hour 9,000 $ 2.00 $ 0.33 0.33 1.00 0.67 12,000 $ 2,000 2.000 6,000 4,000 15,000 $18,000 2,500 3,000 2,500 3,000 7,500 9,000 5,000 6,000 0.50 0.17 4 5 Budgeted Overhead Costs 6 7 Variable overhead costs: 8 Indirect material: 9 Nonstick cooking spray 10 Waxed paper 11 Other paper products 12 Miscellaneous supplies 13 Indirect labor maintenance 14 Utilities 15 Electricity 16 Natural gas 17 Total variable overhead cost 18 19 Fixed overhead costs: 20 Indirect labor: 21 Inspection 22 Production supervisors 23 Setup specialists 24 Material handling 25 Depreciation: plant and equipment 26 Insurance and property taxes 27 Test kitchen 28 Total fixed overhead cost 29 Total overhead cost 3,000 1,000 $ 30,000 $ 3,750 4,500 1.250 1,500 37,500 $ 45,000 2,200 $ 6,000 3,000 2,000 500 100 1,200 15,000 $ 45,000 $ 2,200 $ 2.200 8,000 6,000 3,000 3,000 2,000 2,000 500 500 100 100 1,200 1,200 15,000 $15,000 52,500 $60,000 $ $ Fee Owed Budget RIAS Refer to DCdesserts.com's activity-based flexible budget in Exhibit 11-11 Suppose that the company's activity in June is described as follows: Process hours Production runs New products tested Direct material handled (pounds) 9,000 8 4e , Required: 1. Determine the flexible budgeted cost for each item in the table below. 2-a. Compute the variance for setup cost during the month, assuming that the actual setup cost was $3,000. Use the activity-based flexible budget. 2-b. Compute the variance for setup cost during the month, assuming that the actual setup cost was $3,000. Use DCdesserts.com's conventional flexible budget (Exhibit 11-3), Complete this question by entering your answers in the tabs below. Req 1 Reg 2A Req 2B Req 1 Reg 2A Req 2B Determine the flexible budgeted cost for each item in the table below. a. Indirect material b. Utilities c. Inspection d. Test kitchen e. Material handling f. Total overhead cost Rey Req 2A > Reg 1 Reg 2A Reg 28 Compute the variance for setup cost during the month, assuming that the actual setup cost was $3,000. Use the activity- based flexible budget. (Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "0" for no effect (T.e., zero variance).) Variance Reg 1 Reg 2 Reg 28 Compute the variance for setup cost during the month, assuming that the actual setup cost was $3,000. Use DCdesserts.com's conventional flexible budget. (Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "O" for no effect (ie, zero variance).) Variance ( Req 2A Ron 20 DCDESSERTS.COM Monthly Flexible Overhead Budget Level of Activity Budgeted Cost 6,000 7.500 9,000 Cost Pool I (cost driver: process hours) Indirect material: +$12.000 $15.000 Nonstick cooking spray $18.000 Waxed paper 2.000 2.500 3.000 2.000 2.500 3,000 Other paper products Miscellaneous supplies 6,000 7.500 9.000 Indirect labor. maintenance 4.000 5.000 6.000 Utilities: Electricity 3.000 3.750 4.500 Natural gas 1.000 1.250 1.500 Total of cost pooli $30.000 $37.500 $45.000 Cost Pool II (cost driver: production runs) 8 12 16 Indirect labor Inspection $ 2.200 $ 3,300 $ 4,400 Setup 3.000 4.500 6.000 Total of cost pool II $ 5.200 $ 7.800 $10.400 Cost Pool III (cost driver: new products tested) 20 30 40 Test kitchen S 1.200 $ 1.800 S 2.400 Total of cost pool III S 1.200 S 1.800 S 2.400 Cost Pool IV (cost driver: pounds of material handled) 20,000 30,000 40.000 Material handling S 2.000 $ 3.000 $ 4.000 Total of cost pool IV $ 2.000 $ 3.000 $ 4,000 Cost Pool V (facility level costs) Indirect labor production supervisors $ 6,000 $ 6,000 $ 6,000 Depreciation: plant and equipment 500 Insurance and property taxes 500 100 100 100 $ 6,600 Total overhead cost S 6,600 S 6.600 $45,000 $56.700 S68,400 500 Total of cost pool V OB Diesel DATA REVIEW VIEW FORMULAS FLE PAGE LAYOUT HOME INSERT F29 E 1 X 1328 B C D DCDESSERTS.COM Monthly Flexible Overhead Budget 1 GN- Cost Process Hours 7,500 6,000 per Hour 9,000 $ 2.00 $ 0.33 0.33 1.00 0.67 12,000 $ 2,000 2.000 6,000 4,000 15,000 $18,000 2,500 3,000 2,500 3,000 7,500 9,000 5,000 6,000 0.50 0.17 4 5 Budgeted Overhead Costs 6 7 Variable overhead costs: 8 Indirect material: 9 Nonstick cooking spray 10 Waxed paper 11 Other paper products 12 Miscellaneous supplies 13 Indirect labor maintenance 14 Utilities 15 Electricity 16 Natural gas 17 Total variable overhead cost 18 19 Fixed overhead costs: 20 Indirect labor: 21 Inspection 22 Production supervisors 23 Setup specialists 24 Material handling 25 Depreciation: plant and equipment 26 Insurance and property taxes 27 Test kitchen 28 Total fixed overhead cost 29 Total overhead cost 3,000 1,000 $ 30,000 $ 3,750 4,500 1.250 1,500 37,500 $ 45,000 2,200 $ 6,000 3,000 2,000 500 100 1,200 15,000 $ 45,000 $ 2,200 $ 2.200 8,000 6,000 3,000 3,000 2,000 2,000 500 500 100 100 1,200 1,200 15,000 $15,000 52,500 $60,000 $ $ Fee Owed Budget RIAS